top of page
365 Finance Architec

Automated Accounting Part 1 - Inventory Posting Profiles, Purchase Orders

Updated: Aug 29, 2023

So, what are posting profiles? They are the Dynamics 365 configuration of automatic transaction journal entries. These setups are the heartbeat of the system and a majority of the setup lives in the Inventory Management Module under Setup > Posting > Posting. The topic can get quite involved with complex designs, so we will start with the basics.


Today we will cover Posting Profile setup for Purchase Order Receipt and Invoice related to the purchase of Raw Materials.


Say we want D365 to automatically process the following business process:

Today we will cover Posting Profile setup for Purchase Order Receipt and Invoice related to the purchase of Raw Materials.


1. Chart of Accounts

Create the following Main Accounts in General Ledger and create an Item Group named RAW, Raw Materials in Inventory Management.



2. Purchase Order Receipt

When the Purchase Order Receipt is posted it will use the following setups.


Inventory management > Setup > Posting > Posting > Purchase order (tab)

The "Cost of purchased materials received" posting type will debit Accrued Inventory.


Inventory management > Setup > Posting > Posting > Purchase order (tab)

The "Purchase, accrual" posting type will credit Accrued Liabilities.


3. Sales Order Invoice

When the Purchase Order Invoice is posted it will reverse the accruals posting for the Sales Order Shipment, and then record the following final (financial) postings.


Inventory management > Setup > Posting > Posting > Purchase order (tab)

The "Cost of purchased materials, invoiced" posting type will Debit Financial Inventory.


Accounts payable > Setup > Vendor posting profiles

The "Vendor" posting type is setup in the Accounts Payable module.

The "Vendor" posting type will Credit Financial Liability (Accounts Payable).


4. Purchase Expenditures

These accounts are used when posting the Purchase Order, thus need to be setup.

Their values on journal vouchers will usually 'net' to zero.


Note: Values that do not net to zero will manifest when doing gain/loss Purchase Order Returns when a return is for a different Standard Cost value than the original purchase order's Standard Cost.


Inventory management > Setup > Posting > Posting > Purchase order (tab)

The "Purchase expenditure un-invoiced" and "Purchase expenditure for product" posting types are coded to expense accounts so the Trial Balance resets to zero when the year end General Ledger process is run.

---

Subsequent blogs will cover Posting Profiles for Production and Sales Orders.

555 views1 comment

1 Comment


Prashant Dhurandhar
Prashant Dhurandhar
Mar 06, 2023

Who are you? You are god in my point of view. I have tried by asking many people, I watched many videos, buy I did wasted my time only. After reading this article I got what I was searching for. I didn't understand what accounts to be used at what place. You made it very easy to understand. God bless you and thank you so much! 🙂

Like
bottom of page