BeyondERP.Newsletter
Menu

Setup step on the Charges code page · Accounts payable

Set up Charges code

Set up the codes for the charges, such as freight or fees, that are used on purchase orders.

Used by
Accounts payable manager, Rental coordinator agent, Rental manager and 4 more roles
Business process
Perform invoice matching in Dynamics 365 Finance
Menu item
MarkupTable_Vend
Main table
MarkupTable
Data entity
InventoryChargeEntity
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 for charges codes, which track purchase amounts in addition to line items.
What you do hereUse this page to define each charge, its optional maximum amount for invoice validation, and how it is debited and credited when posted.
ExampleYou pay freight and insurance on a purchase order and want these amounts itemized separately on the order.
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

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

Set up the codes for the charges, such as freight or fees, that are used on purchase orders.

  1. Screen 1

    Create the freight charges code

    Go to Accounts payable > Charges setup > Charges code, Posting section

    1. Select New and enter the charges code and description
    2. In the Posting section, set the debit and credit types
    3. Turn on Compare purchase order and invoice values
    1Charges codeBEAT-FRT
    DescriptionFreight
    Maximum amount0.00
    Debit TypeLedger account
    Debit PostingPurchase, charge
    Debit Account610100
    Credit TypeCustomer/Vendor
    Compare purchase order and invoice valuesYes
    Create the freight charges code (zoomed on the outlined fields)
    Show the full screenCreate the freight charges code
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Accounts payable > Charges setup > Charges code.
  2. Select New.
  3. In the Charges code field, enter a code for the charge, and add a description.
  4. Optionally, select an Item sales tax group and enter a Maximum amount for the charge.
  5. On the Posting FastTab, set how the charge is debited and credited, including the posting types and main accounts for ledger postings.
  6. To compare the charge on invoices with the purchase order, turn on Compare purchase order and invoice values.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Maximum amountThe highest amount allowed for this charge, used when vendor invoice charges are validated.Microsoft Learn 0.00MaxAmount
Compare purchase order and invoice valuesWhen on, the charge on an invoice is compared with the same charge on the purchase order.Microsoft Learn Yes
Debit postingFor ledger postings, the posting type used on the debit side, together with the debit main account.Microsoft Learn CustPosting
Charges codeThe code for the charge, such as freight or an invoice fee.Microsoft Learn FREIGHTMarkupCode
DescriptionA short description of the charges code.Microsoft Learn FreightTxt
Debit TypeThe type of account the debit side of the charge posts to, such as Ledger account or Item.Microsoft Learn Ledger accountCustType
Debit AccountThe main account the debit side of the charge posts to.Microsoft Learn 610100CustomerLedgerDimension
Credit TypeCustomer/VendorVendType

Test checklist

  1. Create a Freight code with Debit Ledger account (expense) and Credit Customer/Vendor.
  2. Add the charge to a purchase order and post the invoice.
  3. Check the voucher debits the expense account and increases the vendor balance.
  4. Set a Maximum amount, turn on invoice matching validation and a charges policy rule, then check an invoice above it is flagged.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Charges codeFor a vendor charge recorded as expense: Credit Type Customer/Vendor and Debit Type Ledger account with the expense main accountLearn's example adds the charge to the vendor's account on the credit side and posts the cost to an expense account on the debit side.Entering a Maximum amount and expecting it to be enforced: validation needs Enable invoice matching validation and a charges-based policy rule type in the vendor invoice policy.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Posting setup is used when the charge posts, so a change affects charges posted afterwards.
Technical architect

6Technical

Menu itemMarkupTable_Vend Checked in Dynamics 365
FormMarkupTable Checked in Dynamics 365
TableMarkupTableShown as “Charges code” in Record infoKey field: MarkupCodeChecked 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
Who can open itPrivilegesMaintain charges in the purchase process MarkupAutoSetup_VendMaintainView charges in the purchase process MarkupAutoSetup_VendViewDutiesInquire into product sales prices and discount master PriceDiscProdSalesPriceDiscMasterInquirEnable purchase order to invoice process PurchOrderToInvoiceProcessEnableEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnable
8 security roles MCRTestUserRoleRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental sales manager RentalSalesManagerPurchasing manager TradePurchasingManagerSales clerk TradeSalesClerkSales manager TradeSalesManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable manager VendInvoiceAccountsPayableManagerRental manager RentalManagerPurchasing manager TradePurchasingManagerRental coordinator agent RentalCoordinatorAgentRental sales manager RentalSalesManagerTo use itSales manager TradeSalesManagerSales clerk TradeSalesClerkGive people one of these roles. On this system, 7 roles can open this page.Checked in Dynamics 365
Actions on the pageButtons: Translations, External codesChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=MarkupTable_Vend
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