If I understand the poster correctly, he has a similar requirement as myself.
Sales Order Bookings would be IMO considered to be all Sales Orders entered in Jan. for instance... this would include Outstanding Orders (which your solution would include), shipped orders (not a sales order anymore so not included) and invoiced orders (also not included).
If a user wanted to see Booked orders, they'd have to reference something like:
Sales Header/line tables for Outstanding Orders
Sales Shipment receipt Header/line tables for all other orders (shipped/invoiced)
Problem with above is that some orders in the shipment receipt tables might have been booked in Dec or previous and shipped in Jan. You wouldn't want to include these, so you'd probably have to archive the Sales Orders first (only work on information going forward obviously), and then cross reference items in the sales shipment receipt tables with this archive information to ensure you only had entries that belonged in January's bookings.
Working on resolving this problem now... Parent Company wants to see all orders booked in a specific Month. (In other words: all outstanding orders / shipped orders / invoiced orders that had a document date of when the order was created (or more accurately should probably use when the order was released if NAV captures this as some orders may stay open and not considered booked. ???)
One must understand that this information once reported each month may change as customers could cancel orders / change orders / may not be shipped till next month etc..., so it will definitely not match sales reports.
Anyways... I believe the term booked orders means orders "taken" that month regardless of their status after.
Any ideas about the following would be greatly appreciated.
I'll most likely just test the best scenario first with excel via odbc sql data, so any reference to the best tables to get this information from would be helpful.
I thought Item Ledger Entry Table at first, but it doesn't record prices and you'd have to cross-reference it with value postings? I think.
Shipment receipt line records unit price and item charge base amount (which is the extended price including discounts), so you could get all relevant information from there and sum the items with the same Order No_ (sales order no)
that's where I'm at right now with it. Biggest problem with this report is items booked in Dec shipped in Jan. :(
dave
