As a business requirement we invoice all Shipped order on the same day.
Hence there is no delay in waiting for realizing amount AR after Shipping.
When we are running the Collect Revenue Information or COGS Recognition Event daily it is not realizing the whole amount.
Initially we thought it was a scheduling issue and restructured our schedule of Jobs:
00:00:00 GMT Autoinvoice Master Program CNY
00:00:00 GMT Autoinvoice Master Program USD
00:00:00 GMT Autoinvoice Master Program EUR
45 Mins is the average maximum time we have noticed.
We are unable to create a request set for these so as to tie it together.
Hence Manually scheduling based on average maximum run times.
01:00:00 GMT Collect Revenue Recognition Information CNY Ledger
01:05:00 GMT Generate COGS Recognition Events CNY Ledger
01:10:00 GMT Collect Revenue Recognition Information EUR Ledger
01:15:00 GMT Generate COGS Recognition Events EUR Ledger
01:20:00 GMT Collect Revenue Recognition Information USD Ledger
01:25:00 GMT Generate COGS Recognition Events USD Ledger
02:00:00 GMT Create Accounting - Cost Management at the same time for all relevant Inventory Orgs.
The DCOGS account balance incrementally building up where as we want to see it as Zero.
We run the collect revenue information with date parameters from Sysdate-2 to sysdate -1.
At the end of each day we would want all the amount in DCOGS to be posted to respective product groups which happens after Create Accounting is run.
Please suggest on better way to approach this.