Carol,
We created a new table to store the open order amounts. We store them on
the 1st of every month (the records are tagged with the prior month and
year). Then, we have a report that has the following columns:
Column 1: Item No.
Column 2: Beginning Balance (from new table)
Column 3: Order Additions (F4211 and F42119)
Column 4: Order Changes (calculated - see note below)
Column 5: Orders Invoiced (F42119)
Column 6: Ending Balance (F4211)
Order Changes: Start with the Ending Balance, add Orders Invoiced, subtract
Orders Added, subtract Beginning Balance. (Column 6 + Column 5 - Column 3 -
Column 2 = Column 4)
I hope this gives you some ideas.
Michelle Dulay
ERP Coordinator
BFGoodrich Aerospace
Chandler Evans Control Systems
email:
[email protected]
OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
Oracle
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)