Hi,

I need a report that print all kinds of requirement because of a sales order line (tdsls041). The item at the sls order line can be both a standard item and a customized item, and it can also be a phantom.
The report shall print:
1) Inventory on hand/ economic stock for the sls order line item and planned production orders for the item(all production orders where the status is Planned - Active). If (economic stock is <0 and it is a manufactured item) or the item is a phantom, go to step 2,
2) Go to the next level in the BOM for the sls order line item, print Inventory on Hand and econ. stock for all items at this level, if there is Planned Inventory Transactions for these items and the item is a manufactured item, print the planned production orders (positve transactions, from e.q. tdinv150 and/or corresponding pcs table).
3) Make a new "loop" , go to the next level in the BOM for the manufactured items printed at step 2, print Inventory on Hand and econ. stock for all items at this level, if there is Planned Inventory Transactions for this items and the item is a manufactured item, print the planned production orders (positive transactions, from e.q. tdinv150 and/or corresponding pcs table).
4) New loop, aso.

The total number of levels in the BOM is maximum 8.

The intention of the report is to make sure that a sales order line is ready to be delivered, and if not, where is the constraints.

If anyone have made something like this or have ideas about how to make the report, I would be pleased:D to get some help.

Best regards

Sturla

We had a requirement for something which I think is along the same lines as yours - view inventory,view delivery & invoice details and view (some) variant options which we feel would have been too slow to try to select in real time.
The compromise is that it is up to 24 hours out of date.

What we did was to create a custom table and a session which displayed the contents of that table per customer.
The table is populated each night by another customer session with details from the following tables:
tdsls040
tdsls041
tdsls045
tipcf520
tiitm001
tipcs021
tccom010
and a custom table extending customer details
tipcs020
tcmcs018

Although the exact requirement is not the same as yours, it may be that for performance you may need to consider something similar. Using a custom table also allowed us to have custom indexes (example, reverse order date).