BeyondERP.Newsletter
Menu

Setup page · Inventory management

Charges code

A setup page where you define charges codes, each with a description, an item sales tax group, the debit and credit posting for the charge and foreign trade settings.

Business process
Maintain inventory levels
Menu item
MarkupTable
Main table
MarkupTable
Data entity
InventoryChargeEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define charges codes, each with a description, an item sales tax group, the debit and credit posting for the charge and foreign trade settings.
What you do hereUse this page to set up the charges codes that track extra amounts, such as freight or insurance, in addition to the lines on an order, and to define how each charge is posted.
ExampleFor example, a freight or insurance charge paid on a purchase order can be set up to post to an expense account or to be added to the cost of the items.
Charges code 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

Business processMaintain inventory levels
Menu pathInventory management › Setup › Charges › Charges code
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 Charges code1 screen
  1. Screen 1

    Create a charges code

    Go to Inventory management > Setup > Charges > Charges code

    1. Select New
    2. Enter the charges code and description
    3. Under Posting, choose the debit type, posting type and account
    4. Choose the credit type, posting type and account
    5. Select Save
    1Charges codeBEAT-CHG
    2DescriptionHandling charge
    Debit typeLedger account
    Debit postingLedger journal
    Debit account610100
    Credit typeLedger account
    Credit postingLedger journal
    Credit account120100
    Create a charges code (zoomed on the outlined fields)
    Show the full screenCreate a charges code
    page title tab to open what to set or check

How to use it

  1. Go to Inventory management > Setup > Charges > Charges code.
  2. Select New to add a charges code.
  3. Enter the Charges code, Description and Item sales tax group.
  4. Under Posting, set the Type, Posting and Account for Debit and for Credit.
  5. Expand Foreign trade to review its settings.
  6. Select Save.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Charges codeThe code for the charge, such as freight or an invoice fee.Microsoft Learn HANDLINGMarkupCode
DescriptionHandling chargeTxt
Debit typeLedger accountCustType
Debit postingLedger journalCustPosting
Debit account610100CustomerLedgerDimension
Credit typeLedger accountVendType
Credit postingLedger journalVendPosting
Credit account120100VendorLedgerDimension

Test checklist

  1. Create a charges code FREIGHT with credit type Customer/Vendor and debit type Item.
  2. Add the charge to a purchase order header, then use Allocate charges to move it to the lines.
  3. Confirm the purchase order, post product receipt and invoice.
  4. Check the voucher: the vendor is credited for the charge and the item cost includes it.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Charges codeCustomer/Vendor on one side and Ledger account or Item on the other: for purchase charges, credit Customer/Vendor and debit Ledger account (expense) or Item (add to item cost)These are the posting patterns Learn gives: the vendor is credited, and the debit either expenses the charge or adds it to the cost of the items.Should a purchase charge such as freight be expensed or added to item cost?Entering a Maximum amount and expecting invoices to be checked: validation works only when Enable invoice matching validation is on in Accounts payable parameters and a charges policy rule exists for the vendor invoice policy.Test: Charge with debit type Item adds to item cost
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: You can edit a charges code at any time. Its posting setup applies to charges posted after the change. Microsoft Learn
Technical architect

6Technical

Menu itemMarkupTable Checked in Dynamics 365
FormMarkupTable Checked in Dynamics 365
TableMarkupTableShown as “Charges code” in Record infoChecked in Dynamics 365
Data entitiesInventoryChargeEntityInventory charge codes Microsoft data model PurchProcurementChargeEntityProcurement charge codes Microsoft data model SalesChargeEntitySales charge codes Microsoft data model SalesDeliveryChargeEntitySales delivery charge codes Microsoft data model
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerRetail service RetailServiceRental sales manager RentalSalesManagerRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentTo use itRetail store manager RetailStoreManagerProject manager ProjProjectManagerSales clerk TradeSalesClerkSales representative TradeSalesRepresentativeCustomer service representative TradeCustomerServiceRepresentativeGive people one of these roles. On this system, 19 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=MarkupTable
Integrate withInventoryChargeEntity data entity Microsoft data model
Data migrationInventoryChargeEntity (Inventory charge codes): loaded for each company, in Microsoft's default template 405 - Transportation management.PurchProcurementChargeEntity (Procurement charge codes): loaded for each company, in Microsoft's default template 120 - Accounts payable.SalesChargeEntity (Sales charge codes): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 405 - Transportation management loads Inventory charge codes at execution unit 1, level 30, sequence 10. 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 General ledger)Microsoft Learn
Table definitionMarkupTable columns and relations Microsoft data model
Everyone

8Sources