F4229 populated with F42119

AnnaTal

AnnaTal

Active Member
Is it possible to populate F4229 with F42119?
We've used PO 14 of Sales Update then we've bypassed updating of F4229. Is there something to do now?
 
Have a look at P42996 for purging your records G42312/18

Guy Robert
Syntax.Net
 
If I understand your question, you want to go back and recreate the F4229 for past sales.

I don't know of any JDE built way to do this. You can certainly do it with a custom job. There are many different ways to do this, but I will briefly outline one possibility.

I would start by looking at the key fields on the F4229 and create a database query that groups the F42119 on those keys except for FY (fiscal year). Create a copy of each of your new records for each FY you need to rebuild and add the FY value to your record. Load these records into F4229. Now all you need to do is create a UBE that reads the F42119 and updates the appropriate monthly buckets and totals buckets. You may have records that have all zeros when you are done, but you can delete those.

This is a rough, very quick outline of one approach. There are other ways to do it.

Good Luck,


Jer
 
Back
Top