You’re offline. This is a read only version of the page.
5
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.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (