How to fetch picked_from_subinventory for a receivables invoice?
Summary:
How to fetch picked_from_subinventory for a receivables invoice?
Content (required):
We have a requirement to display all invoices shipped to a country for tax purposes. Invoice Number, Invoice Line Number, Accounted Amount and tax_rate_code has to be displayed along with Warehouse and Sub-Inventory. Query works fine for regular deliveries. But in case of split deliveries, wsh_delivery_details table returns multiple rows and Accounted Amount from ra_cust_trx_line_gl_dist_all is being doubled since there is no direct join between ra_cust_trx_line_gl_dist_all and wsh_delivery_details tables. Is there any solution to this issue?
0