BeyondERP.Newsletter
Menu

Setup step on the Posting page · Inventory management

Set up Posting

Use this page to choose the main account for each posting type, with a tab for each subledger such as sales orders and purchase orders.

Used by
Auditor, Chief financial officer, Inventory accountant and 9 more roles
Business process
Maintain inventory levels
Menu item
InventPosting
Main table
InventPosting
Data entity
InventInventoryLedgerPostingDefinitionEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you set up inventory posting profiles, which control how inventory subledger transactions post to the general ledger.
What you do hereUse this page to choose the main account for each posting type, with a tab for each subledger such as sales orders and purchase orders.
ExampleFor example, to set the account for purchase expenses for one item group, you open the Purchase order tab, select the Purchase expenditure for expense posting type and set the Item code to Group.
Posting page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Posting1 screen

Use this page to choose the main account for each posting type, with a tab for each subledger such as sales orders and purchase orders.

  1. Screen 1

    Set up inventory posting

    Go to Inventory management > Setup > Posting > Posting

    1. Select a tab for the subledger, for example Sales order
    2. Under Select, choose the posting type, for example Cost of units, delivered
    3. Select New
    4. Set the item code (Table, Group or All) and the item relation, and the account code (Table, Group or All) and the account relation
    5. Select the main account
    6. Select Save
    1SelectCost of units, delivered
    2Item relationBEAT
    Item codeGroup
    Account codeAll
    Main account130100
    Set up inventory posting (zoomed on the outlined fields)
    Show the full screenSet up inventory posting
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Inventory management > Setup > Posting > Posting.
  2. Select the tab for the type of transaction, such as Purchase order.
  3. Select the posting type.
  4. Select New.
  5. In the Item code field, select Table, Group, All or Category, and then set the Item relation or Category relation.
  6. In the Account code field, select Table, Group or All, and then set the Account relation.
  7. Optionally, select a Sales tax group.
  8. In the Main account field, enter the account to post to.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item codeWhether the line applies to one item, an item group, all items or a category.Microsoft Learn GroupItemCode
Item relationThe item or item group that the line applies to.Microsoft Learn RAWMATItemRelation
Category relationThe category that the line applies to when Item code is Category.Microsoft Learn CategoryRelation
Account codeWhether the line applies to one customer or vendor, a group or all.Microsoft Learn AllCustVendCode
Sales tax groupLimits the line to one sales tax group; if blank, it applies to all tax groups.Microsoft Learn
Main accountThe ledger account that the posting type posts to.Microsoft Learn 130100
SelectCost of units, delivered

Test checklist

  1. On the Purchase order tab, select a posting type and add a row with Item code Group and Account code All
  2. Post a product receipt and invoice for an item in that group
  3. Open Inventory management > Inquiries and reports > Transactions for the line
  4. Open the physical and financial vouchers and check the main accounts

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up PostingFor each posting type, rows with Item code = Group (one per item group) and Account code = All, with a main account on eachLearn's setup procedure uses Item code Group to post by item group and Account code All to apply the row to all vendors or customers; Table and Category rows are there for exceptions.At what level do we define inventory posting rows: per item, per item group, per category or for all items?Leaving posting types blank, for example the standard cost variance or moving average accounts. Learn lists these accounts as prerequisites for standard cost and moving average items.Test: Purchase order posts to the item group's posting profile accounts
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Main accounts can be changed at any time. Postings made afterwards use the new account; vouchers already posted are not changed.
Technical architect

6Technical

Menu itemInventPosting Checked in Dynamics 365
FormInventPosting Checked in Dynamics 365
TableInventPostingShown as “Item, ledger posting” in Record infoKey field: InventAccountTypeChecked in Dynamics 365
Data entitiesInventInventoryLedgerPostingDefinitionEntityLedger posting definition for inventory Microsoft data model InventProcurementLedgerPostingDefinitionEntityLedger posting definition for procurement Microsoft data model InventProductionLedgerPostingDefinitionEntityLedger posting definition for production Microsoft data model InventSalesLedgerPostingDefinitionEntityLedger posting definition for sales Microsoft data model InventStandardCostVarianceLedgerPostingDefinitionEntityLedger posting definition for standard cost variance Microsoft data model
Who can open itPrivilegesMaintain item posting InventPostingMaintainView item posting InventPostingViewDutiesInquire into general ledger policies LedgerGeneralLedgerPoliciesInquireEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger policies RentalLedgerGeneralLedgerPolicieInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
12 security rolesAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental sales manager RentalSalesManagerRental manager RentalManagerAccounting manager LedgerAccountingManagerRental purchasing manager RentalPurchasingManagerAccounting supervisor LedgerAccountingSupervisorTo use itInventory accountant clerk InventCostCostClerkInventory accountant InventCostAccountantRental coordinator agent RentalCoordinatorAgentAuditor AuditPolicyManagerFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventPosting
Integrate withInventInventoryLedgerPostingDefinitionEntity data entity Microsoft data model
Data migrationInventInventoryLedgerPostingDefinitionEntity (Ledger posting definition for inventory): loaded for each company, in Microsoft's default template 300 - Inventory.InventProcurementLedgerPostingDefinitionEntity (Ledger posting definition for procurement): loaded for each company, in Microsoft's default template 300 - Inventory.InventProductionLedgerPostingDefinitionEntity (Ledger posting definition for production): loaded for each company, in Microsoft's default template 300 - Inventory.Load order: Microsoft's default template 300 - Inventory loads Ledger posting definition for inventory at execution unit 1, level 310, sequence 100. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Inventory management)Microsoft Learn
Table definitionInventPosting columns and relations Microsoft data model
Everyone

8Sources

To cite this step: IM-SETUP-370, Set up Posting. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/IM-SETUP-370