Tuesday, November 1, 2011

As OF - Did you know?


 



  • The As Of Posted Code (PC) in the cardex tells you the progress of a transaction in the cardex   
  • If the As Of Posted Code is = 'S', then the transaction has not been recorded in the General Ledger 
  •  If the As Of Posted Code is = to ‘ ‘, then the transaction has been recorded in the general ledger, but has not been processed to As Of
  • If the As Of Posted Code is = 'X', then the transaction is not a reconciling item and will not get processed to As Of 
  • If the As Of Posted Code is = to 'Y', then the transaction has been processed to As Of
Reconciling the general ledger directly to the cardex and/or on hand can be challenging, because not all transactions post to the general ledger immediately.  They do, however, update on hand and cardex immediately.  So if you try to reconcile these tables without knowing this information, you will have variances due to timing that are not true variances.  The standard JD Edwards methodology for reconciling inventory is to use the as of process which takes these timing differences into account as illustrated above.  So the key to a much smoother reconciliation is to incorporate the as of process.  We will discuss this process and the standard approach to JD Edwards inventory reconciliation in future posts.  Stay tuned!
Visit us on the web at:  http://www.cjinv.com/  or email me directly at jjensen@cjinv.com.





2 comments:

  1. Hi. I'm having some differences between cardex and gl because variances are not being reflected on cardex. For example: There is an exchange rate difference between the receipt (OV) and the voucher (PV). JDE calculates it correctly, the general ledger line is created, but not in cardex. We are using the 01 cost method (not 07). Do you know where could be the problem? It is Enterprise One 9.02

    ReplyDelete
  2. Hi.

    I believe the reason the variances are not writing to the cardex is because you are valuing your inventory at the last in cost (01 cost method.

    The 01 cost method is not impacted by voucher match. It is only impacted by the receipt itself. So the exchange rate variance probably will not revalue inventory. If it doesn't, the variance will not be written to the cardex.

    You can test this by reviewing the 01 cost in the f4105 before and after the exchange rate vareiance occurs at voucher match. If it remains the same, the variance record should not be written to the cardex. If it changes, the variance record should be written to the cardex.

    This then leaves the question as to how to handle the journal entry. In my opinion, if the variance is not revaluing inventory at the time it occurs, then the journal entry should not be hitting an inventory account in the GL.

    I also know that there are some specific procesing options and AAI's related to how the exchange rate variance is calculated and what accounts it should hit.

    I hope this helps!

    ReplyDelete