web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AX 2012 PO Posting to Ledger: Explanation of Accounts

(0) ShareShare
ReportReport
Posted on by 815

AX 2012 PO Posting to Ledger: Explanation of Accounts on the Inventory Posting Setup.  It seems that during receipt of goods and Invoice posting, there are a lot of extra accounts being used that were not used in prior releases.   Does anyone have an explanation of these postings?  I could not find anything in the on-line help or manuals.  Besides the item model group, is there another setup that affects what accounts are used?

Example:  Upon receipt of a Stock item, I would expect to hit Inventory & an accrual account (Goods received, not invoiced).  What I am seeing is 4 entries instead of 2, but 2 of the entries to "Purchase expenditure, un-invoiced"  net each other out, so I am not sure why they are needed.

Can I shut off posting to "Purchase expenditure, un-invoiced"

DEBIT

CREDIT

     Purchase expenditure, un-invoiced

Actual cost of inventory received on PO.  (Inventory received not invoiced)

Purchase Accrual: actual cost of inventory

(Accrual account)

      Product receipt:  Inventory value received not invoiced. (Inventory account)

Purchase expenditure, un-invoiced

Actual cost of inventory received on PO.  (Inventory received not invoiced)

 

 

*This post is locked for comments

I have the same question (0)
  • 640579632b5c4e6780a624c4771b6f93 Profile Picture
    4,730 on at
    Re: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Is the posting defination turn on or configure it to meet your requirement

  • Karen Hanley Profile Picture
    815 on at
    Re: AX 2012 PO Posting to Ledger: Explanation of Accounts

    I have not set up anything in the posting definition; I will have to read up on that.  But I am not sure why receiving an inventory item would be posting to "Purchase expenditure, un-invoiced"; is there some other setup controlling that or do I have to setup posting definitions?

  • Verified answer
    Karen Hanley Profile Picture
    815 on at
    Re: AX 2012 PO Posting to Ledger: Explanation of Accounts

    MS has indicated that the posting has changed in AX2012.  Here is the explanation provided:

    When a product receipt is recorded for a stocked item, two accounting processes take place:

    ï‚· One accounting process creates an accounting entry for the accrued liability. The accounting entry amount is for the received quantity of the stocked item, multiplied by the currency amount per unit for the purchase order. This process uses the new accounting framework that was added in Microsoft Dynamics AX 2012. In the following example, XX denotes the currency amount of the accounting entry.

    Debit Purchase expenditure, un-invoiced XX

    Credit Purchase, accrual XX

    ï‚· Another accounting process accounts for the cost in inventory for the received quantity of the stocked item by crediting the expenditure ledger account and capitalizing the cost in an inventory asset ledger account.

    Debit Product receipt XX

    Credit Purchase expenditure, un-invoiced XX

    When a vendor invoice is recorded for a stocked item and accounting entries are created, two accounting processes take place:

    ï‚· First, the accounting entries on the product receipt for accrued liability are reversed. The amount that is reversed is based on the quantity of stocked item on the vendor invoice that is matched to the product receipt. Then, the accounting entry is created to record the liability for the vendor invoice. Both entries are created by the new accounting framework that was added in Microsoft Dynamics AX 2012.

    Credit Purchase expenditure, un-invoiced XX

    Debit Purchase, accrual XX

    Debit Purchase expenditure for product XX

    Credit Vendor balance (Accounts payable) XX

    ï‚· Second, the accounting entry on the product receipt that records the inventory cost is reversed. The amount that is reversed is based on the quantity of the stocked item on the vendor invoice that is matched to the product receipt. Additional account entries are created to record the inventory cost under a new inventory ledger account classification.

    Credit Product receipt XX

    Debit Purchase expenditure, un-invoiced XX

    Debit Purchase, product receipt XX

    Credit Purchase expenditure for product XX

    Conceptually, if you net the vouchers together, the effect remains the same as the accounting entry that is generated in Microsoft Dynamics AX 2009. Because two separate accounting

    processes are used that do not interact with each other, it is not possible to summarize the vouchers together in Microsoft Dynamics AX 2012.

  • ewills Profile Picture
    5,990 on at
    Re: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Hello, do you know why, this new accounting framework is created? why would we require the purchase-expenditure - uninvoiced? what is the business logic

  • Suggested answer
    Community Member Profile Picture
    on at
    Re: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Ewills,

    Its been added to accrue the liability. Plus, if you notice in the second accounting event at the time of product receipt, AX is actually capitalising the incurred expense (DR: Product receipt and CR: un-invoiced product expenditure).

    Also, you can disable purchase expenditure, un-invoiced posting only if you disable the physical posting in the model group or AP parameters.

    Also, purchase expenditure, un-invoiced is not something new that Microsoft has added in AX 2012, it was there is AX 2009 also but with a different name of - packing slip, offset account. Microsoft has added only purchase accrual at the time of product receipt posting at the time of PO posting.

     

    Huzaifa,

    Posting definition setup is not required for the PO posting unless you are enabling the "commitment accounting" (encumbrances and pre-encumbrances). 

     

  • community Profile Picture
    141 on at
    RE: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Hi Bilal,

    can we do the accrual posting at the month end , one time & reverse it at moth end ,I need a periodic action or batch which can trigger the received PO/consider partial received and post accruals at the month end as below & reverse the encumbrance

    End month

    Dr . Expense XX

    Dr.  Reserve for encumbrance  XX

                                                       Cr.purchase Accrual XX

                                                       Cr .encumbrance    XX

    Reverse this entry beginning of the month

  • Community Member Profile Picture
    on at
    RE: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Hi Marian,

    In standard AX this is not possible. It actually accrue the liability at the time of product receipt posting and clears it once it get invoice updated. I didn't find any parameter to accrue it periodically at month end.

  • Community Member Profile Picture
    on at
    RE: AX 2012 PO Posting to Ledger: Explanation of Accounts

    This is now fixed in AX 2012 R3.

    --- here are details from What's new page of Dynamics AX 2012 R3

    The results of the accounting entries for stocked items on product receipts and vendor invoices are combined into one subledger journal entry and voucher.

    Accounting entries for Purchase expenditure, un-invoiced are not transferred to the general ledger if the amount for both the accounting currency and the reporting currency adds up to 0 (zero) per voucher, currency code, and ledger dimension.

    Accounting entries for Purchase expenditure for product are transferred in summary form to the general ledger per voucher, currency code, and ledger dimension.

    -----

  • Community Member Profile Picture
    on at
    RE: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Hi,

    In my case at the time of invoicing purchase accrual and purchase expenditure, un-invoiced account not reversed.

    Is there some setup missing as I have check and find no gap in setup.

    Transaction while packing slip

    Voucher Date Ledger account Ledger Name Currency Amount
    APPRV/17-18/05058 02-05-2018 116101 Purchase, accrual INR -6375
    APPRV/17-18/05058 02-05-2018 264601 Purchase expenditure, un-invoiced INR 6375
    SEPL-00031543 02-05-2018 264601 Purchase expenditure, un-invoiced INR -6376
    SEPL-00031543 02-05-2018 264506 Product receipt INR 6376

    Transaction while Invoice

    Voucher Date Ledger account Ledger Name Currency Amount
    RABPV/1718G/00437 02-05-2018 282703 IGST Recoverable INR 1785
    RABPV/1718G/00437 02-05-2018 115101 Vendor balance INR -8160
    RABPV/1718G/00437 02-05-2018 264602 Purchase expenditure for product INR 6375
    SEPL/29050 02-05-2018 264106 Purchase, inventory receipt INR 6375
    SEPL/29050 02-05-2018 264506 Product receipt INR -6376
    SEPL/29050 02-05-2018 264601 Purchase expenditure, un-invoiced INR 6376
    SEPL/29050 02-05-2018 264602 Purchase expenditure for product INR -6375
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: AX 2012 PO Posting to Ledger: Explanation of Accounts

    Hi Divanshu,

    Do you mind creating a new thread and provide some details on what you posted when and where?

    Many thanks

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans