Purchase Order Product Receipt and Vendor Invoice Posting in Microsoft Dynamics AX 2012 R3

-

Purchase Order Product Receipt and Vendor Invoice Posting in Microsoft Dynamics AX 2012 R3


In Microsoft Dynamics AX 2012, when a purchase order is product receipt and vendor invoice updated for stocked items, there are two accounting processes and resulting entries which occur:
The accrued liability is updated (new feature in AX 2012)
The inventory cost is updated (available in AX 2009)

To enable these accounting processes, two new posting types are available and a main account must be specified for each:
Purchase expenditure, un-invoiced: This posting type is used to accrue the liability and product receipt amounts when a purchase order is product receipt updated.
Purchase expenditure for product: This posting type is used to offset the liability and inventory amounts when a purchase order invoice is updated.

The accounts for these posting types can be specified in the Posting form (Inventory and Warehouse management> Setup>Posting>Posting) and on the Purchase order tab on the Item groups form (Inventory management>Inventory>Item groups).

AX 2012 R3

In AX 2012 R3, both accounting processes referenced above will create subledger journal and voucher entries. For posting type Purchase expenditure, un-invoiced, accounting entries which net to 0 will not be transferred to the general journal as in AX 2012 R2. The Purchase expenditure, un-invoiced postings are not displayed in the Voucher transactions form but in the Subledger journal form. The Subledger journal form will display all generated subledger accounting entries, including those not transferred to the general ledger.

Product Receipt Voucher transactions and Subledger journal:
Product Receipt Voucher transactions and Subledger journal
For posting type Purchase expenditure for product, accounting entries that net to 0 will no longer display both a line for the credit and debit entries in the Voucher transactions form as in AX 2012 R2 but will be displayed in the Subledger journal and transferred to the general ledger in a single zero-amount accounting entry.

Vendor Invoice Voucher transactions and Subledger journal:
Vendor Invoice Voucher transactions and Subledger journal:

Instances exist for both posting types Purchase expenditure for product and Purchase expenditure, un-invoiced where there will be a balance for stocked items such as from currency translation or a stocked item which is returned with a variance between the unit price and average cost.

This blog post references the Microsoft Dynamics AX 2012 R3 White Paper ‘Accounting for stocked items on product receipts and vendor invoices’

Comments

Post a Comment

Popular posts from this blog

D365: Request for quotations (RFQ). Process RFQ overview

-
Image
D365: Request for quotations (RFQ). Process RFQ overview In this blog post I am going to review one type of procurement solicitation that is available within Microsoft dynamics 365 for Finance and Operations – Requests for quotations (RFQ). In general, RFQ is used when the company wants to receive competitive offers from several vendors for the goods they might purchase. As the result, company invite suppliers into a bidding process to bid on specific products or services, it is some kind of putting out goods to tender or requesting for proposal. And now it’s time to step up to the plate and follow the process presented below: I would like to bring to the table details on creating an RFQ, sending it to vendors, and evaluating bids returned by vendors. The first step in the RFQ process is to set up prerequisites. The following prerequisites are required for this functionality. Let’s break each setting down… Procurement and sourcing parameters for requests for ...
Read more

MSDyn365FO: Inventory blocking

-
Image
MSDyn365FO: Inventory blocking In this blog post we are going to review the different approaches of the inventory blocking and their effect on the master planning: Manual inventory blocking Inventory blocking through Quality order Inventory blocking through Inventory status Inventory blocking through Quality order and batch disposition codes Manual Inventory blocking With this approach you manually block items or rather its inventory from being issued/consumed.  Nothing else than items that are available on-hand can be blocked. This can be done through inventory blocking form. Navigate to  Inventory management > Periodic tasks > Inventory blocking. In this case, Inventory blocking type will be set to Manual. While you are manually blocking the existing inventory, you have an ability to decide whether the blocked inventory should be considered by master planning or not. If you set Expected receipt flag, then blocked quantity will be included in th...
Read more

Inventory Revaluation in D365FO: Scenario with Costs

-
Image
Inventory Revaluation in D365FO: Scenario with Costs  Posted on: March 27, 2019 |   By: Jarrod Kraemer |    Microsoft Dynamics AX/365 Authored by: Dave Occhionero Inventory revaluation  is a process in AX/D365 that is commonly misunderstood.  There are many scenarios and processes within D365 that impact the results of what the inventory revaluation calculates and displays.  In this blog post, I wanted to document a scenario that is focused on a very specific costing scenario, with the hope that some of the fundamentals outlined below can apply to your costing setup. The first scenario shows the revaluation impact when costing is tracked at the Batch # level. Let’s first assume that a purchase order is created with the following costs. The total cost of the Purchase order is $625 of which Material = $600 PO Charge= $25 Let’s assume that Purchase Order Registered/Received & Invoiced @ $625. This registered transaction ...
Read more