• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Monthly Order Dollars

cschwobe

Active Member
We are looking for a way on daily basis to keep track of our order dollars. I know how to get new order dollars and cancelled dollars, but is there any way to track a changed order value.

Any help is greatly appreciated.

Carol Schwobe
One World XE
AS 400
 

Mike Dupaix

VIP Member
Carol,

The easiest would be to use F42199, the Sales Order Ledger file. This file tracks all changes to order lines in the ledger file if it is activated in the Order Activity Rules. Your report(s) would need to look for duplicate keys and build logic to report on the changes to the dollars or other items you want to track.

Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 

brown

Member
We are on World, but we have the F4211 Journaled and capture the journals
daily. Then check the journals for changes to orders to see the dollars
involved.

I will let you know it took two consultants to set this up and for a long
time there were multiple problems. If you can journal in One-World, give it
a try and let the LIST know how you do.
 

Michelle D.

Active Member
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: mdulay@chandlerevans.bfg.com

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)
 
Top