- Product receipt posted
- Vendor invoice posted
This article is my practice to analyze how system booking G/L for the purchasing process
Ledger Account Related
Step 1: Setup Vendor Posting profile
Vendor posting group Summary Account = 200100 Account Payable
Setup for account payable parameter.Enable Post product receipt in Ledger
Choose the Posing profile from the previous Vendor posting profile
Make sure the example Vendor is assigned the same group as the previous posting profile
Step2: Setup purchase order Inventory posting profile
You can define an Inventory posting account on Inventory Management > Posting
Or Setup for Specific Item Group under Inventory Managment>Setup> Inventory >Item Group
Purchase Accrual for Vendor balance account for purchase receipt posting process
Make sure the Example productize assigned to the same Item Group
Make sure the Item Model group is enabled for Post Physical Inventory, Post Financial Inventory, and Accurate liability on product receipt
Step3: Create Purchase Order and analyst Voucher transaction (Stock Item)
Create and confirm purchase order
Product quantity: 1 pcs
Unit price: 1,000 THB
TAX: none
Post product receipt
check product received voucher transaction, Accrual Purchas,e and Physical Inventory was created
Post Vendor Invoice
- Input Invoice Number
- Update match Status: Passed
- Post
Check the Invoiced voucher transaction
As you can see the Accrued Purchase and Physical Inventory were reversed from the product receipt
Account payable and Financial Inventory account was created instead
The reason why purchase expenditure is zero is that this account is offset itself, you can track it on the Subledger journal
Step4: Create Purchase Order and analyst Voucher transaction (Non-Stock Item)
Item Model Group> Enable Accrue Liability on product receipt
Purchase order Inventory Posting profile
Released Product
Create and confirm purchase order
Product quantity: 1 pcs
Unit price: 1,000 THB
TAX: none
Product receipt Voucher Transaction
Different from Stock Items, System book Purchase expenditure accounts rather than Physical inventory because the product is non-stock
Vendor Invoice Voucher Transaction
The Purchase expense 600140 was booked as a debit side for a non-stock item purchase
Already done posting profiles on the purchasing process. next episode I will try to explore posting profiles on Sales Order processing. Thank you for visiting.
Credit
https://exploredynamics365.home.blog/2020/05/09/inventory-transactions-posting-profile-setup-part-1-in-dynamics-365-finance-and-operations/
https://www.linkedin.com/pulse/physical-vs-financial-inventory-transactions-ax-2012-chandu-naresh/
https://gopalthorve.com/procurement-inventory-accounting-microsoft-dynamics-365-for-finops/