0 Replies Latest reply: Jan 28, 2014 1:21 PM by 1835194 RSS

    Scheduling COGS Programs for R12

    1835194

      Hi Everyone

       

      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.