top of page
365 Finance Architec

Automated Accounting Part 2 - Inventory Posting Profiles, Sales Orders

Updated: Aug 29, 2023

Today we will be reviewing automation of accounting for Sales Orders.


We want D365 to automatically code the following journals:


I this scenario we are are posting the Sales Order Invoice every night via a batch job, thus are not accruing Revenue upon Sales Order Shipment, as the Revenue for the day will be recorded each evening when the Sales Order Invoice is posted.


Our focus continues to be on the configuration that enables: synchronized, balanced Inventory sub ledger vs. balanced Trial Balance general ledger, auto coded transactions.


We will configure selling Finished Goods on our Sales Order. In next blog we will cover Production Order Posting Profiles, bridging the gap between

Part 1, Inventory Posting Profiles, Purchase Orders, and

Part 2, Inventory Posting Profiles, Sales Orders.


  1. Chart of Accounts

Create the following Main Accounts in General Ledger and create an Item Group named FG, Finished Goods in Inventory Management.




2. Prerequisite setup, Inventory Model Group

Inventory management > Setup > Inventory model groups

Turn on Post physical inventory.

This setup enables the Sales Order Shipment (packing slip) to post a journal in the Trial Balance.


3. Prerequisite setup, Accounts Receivable Parameters

Accounts receivable > Setup > Accounts receivable parameters > Updates [tab]

In addition to step 2 (above), this setup enables the Sales Order Shipment (packing slip) to post a journal in the Trial Balance.



4. Sales Order Issue (packing slip)

Posting of the sales order issue is dependent on prerequisite setup in the Inventory Model Group (step 2) and Accounts Receivable Parameters (step 3), and the following setups.


When the Sales Order Issue (packing slip) is posted it will use the following setups to assign a Main Account in the journal.


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

The "Cost of units, delivered" posting type will credit Accrued Inventory for the shipped Finished Goods.


This inventory account is to recognize that the inventory is no longer on hand, because it has been shipped (pack slip posted).



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

The "Cost of goods, delivered" posting type will debit Shipped Not Invoiced.

It is not important to itemize the debit side of the journal related the corresponding Item Group (Finished Goods), thus this setup uses the "All" item code, so that all Item Groups use the same account (150950).

Note: re. Matching Accounting Principle

We are coding the COGS (conceptually 'Deferred COGS'), upon shipment, to the Balance Sheet (150950).


Reasoning:

We are using a Balance Sheet account, and want to avoid posting Cost of Goods Sold (COGS) to a Profit Loss account:

because we are not posting, accruing, nor deferring any "Revenue" upon shipment.


WARNING: DO NOT use the "Deferred Cost of Goods Sold" radio button, as that is used in conjunction with a separate D365FO feature: Revenue Recognition, that is used when Revenue is deferred.



5. Sales Order Invoice

When a Sales Order is invoiced, the prior journal, Sales Order Shipment (packing slip) is reversed using the same posting profile accounts assigned in step 4.


Additional invoice specific accounts for the invoicing will be assigned as follows:


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

The "Cost of units, invoiced" posting type will credit Financial Inventory for the sold Finished Goods.


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

The "Cost of goods sold, invoiced" posting type will debit the P&L COGS account.


Now that the Inventory and COS accounts related to Sales Order Invoice are setup, we will focus on the Revenue and Receivable setups.


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

The "Revenue" posting type will credit the P&L Revenue account.


Accounts receivable > Setup > Customer posting profiles will establish the Main Account used for the "Customer" posting type. When the Sales Order Invoice is posted, the Customer account will be debited for the invoice total.


---

Subsequent blogs will cover Posting Profiles for Production Orders.




Comments


bottom of page