Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Subledger Journal Entries

  • 1.  Subledger Journal Entries

    SILVER CONTRIBUTOR
    Posted 18 days ago

    Hello,
    For the first time in the 5+ years we've been using AX 2012 (R1, CU5) we've had a few subledger journal entries post on Purchase Orders.  We don't utilize this functionality so I'm not sure how they are being created and how to remove the vouchers that are hitting the GL (aside from a GL entry).  We have synchronous batching and we don't use encumbrance accounting, not sure what other areas to check?

    Postings are occurring as follows:
    Product Receipt Voucher is Debiting Expense and Crediting Accrued Purchases
    Subledger Journal Voucher is Debiting Expense and Crediting Accrued Purchases
    Invoice is Debiting Accrued Purchases and Crediting AP

    I'm getting double postings in the expense and accrued accounts.  Any advice on how this is now occurring and how to remove the SLJE would be very helpful.

    #AX2012​​
    #Finance

    ​​

    ------------------------------
    Courtney Blumling
    Sr. Manager, ERP Applications
    TMS International, LLC
    Glassport PA
    ------------------------------


  • 2.  RE: Subledger Journal Entries

    TOP CONTRIBUTOR
    Posted 18 days ago
    Hi,
    Can you share some screenhots of the postings made and you account setups in the inventory posting matrix under inventory/setup/posting/posting?
    Many thanks and best regards,
    Ludwig

    ------------------------------
    Ludwig Reinhard
    Sycor
    Veitshoechheim
    ------------------------------



  • 3.  RE: Subledger Journal Entries

    SILVER CONTRIBUTOR
    Posted 17 days ago
    Transaction Postings are below:
    Receipt Posting: 200500 Accrual and 505485 Expense


    Invoice: 200100 is AP

    These vouchers are fine, however the GL also has another sub-ledger entry RPFV (accrual account shown below):

    I checked the postings in the Inventory & WH Mgmt setup and everything for the PROFSERV group (for relevant item) is mapped properly.

    ------------------------------
    Courtney Blumling
    Sr. Manager, ERP Applications
    TMS International, LLC
    Glassport PA
    ------------------------------



  • 4.  RE: Subledger Journal Entries

    TOP CONTRIBUTOR
    Posted 16 days ago
    Hello Courtney,

    Microsoft did change some logic in AX2012 for posting PO vouchers compared to AX2009. You can read about it on the next page: Two voucher posting strategy for Purchase Distributions
    Microsoft remove preview
    Two voucher posting strategy for Purchase Distributions
    We have had questions recently regarding the two voucherposting strategy for purchase distributions. You may be seeing additionalpurchase order posting distributions as well as entries for the PO postingtypes Purchase expenditure, un-invoice and Purchase expenditure forproduct receipt. Microsoft Dynamics AX 2012 introduces the ability to havenon-stocked purchases.
    View this on Microsoft >
    Possibly, the person who did the setup was not aware of this or did not understand it correctly. Then it is possible to create a wrong item posting setup. I don't know how it has been setup and what account number represents what purpose in your chart of accounts. Can you elaborate on the Inventory posting setup? Please share some settings which accounts are mapped on what posting type and also explain what exact account name it is.

    In the past, I have seen multiple implementations where the posting was wrong due to wrong understanding of this two-voucher posting strategy.

    ------------------------------
    kind regards,

    André Arnaud de Calavon
    Solution Architect, Microsoft MVP - Microsoft Dynamics Business Solutions
    ------------------------------