Hi,
I need to build a report in Excel where I can get all my Production Orders related to its sales order.
Here an exemple.
I currently use Jet reports for that, and I try to link "Sales header" with "Reservation Entry" and "Prod. Order Line" however, I don't have any success.
Any suggestion?
Thank you
Hi Earl W,
Unfortunately, I need more fields from Prod. Order Line table.
In addition, I need to use Reservation Entry table because I am not an expert in Jet, and I don't know if it exists another way to associate the Prod. Order with the sales orders.
Any suggestions are more than welcome. :)
Thanks!
DR
do all sales lines already have reservations? If so, you can pull data from reservation entries table:
Reservation Status | Item No. | Location Code | Quantity (Base) | Reserved For | Reserved From | Entry No. | Transferred from Entry No. |
---|---|---|---|---|---|---|---|
Reservation | FG1654 | YELLOW | -1 | Sales Order 1035 | Prod. Order Line Firm Planned 101007 | 115 | 0 |
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156