You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!