BeyondERP.Newsletter
Menu

Setup step on the Charges code page · Accounts receivable

Set up Charges code

Set up the codes for charges such as invoice fees, freight and insurance that are used on sales orders.

Used by
Accounts receivable clerk, Accounts receivable manager, Credit management clerk and 16 more roles
Business process
Define freight and other charges for orders in Dynamics 365 Supply Chain Management
Menu item
MarkupTable_Cust
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 used on sales orders and purchase orders.
What you do hereUse it to set up codes for charges such as invoice fees, freight and insurance.
ExampleFor example, when the customer pays an invoice charge, you set up the code to add the charge to the sales order totals and the customer's account.
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 charges such as invoice fees, freight and insurance that are used on sales orders.

  1. Screen 1

    Create the freight charges code

    Go to Accounts receivable > Charges setup > Charges code

    1. Select New and enter the charges code and a description
    2. On the Posting FastTab, set the debit type
    3. Set the credit type, posting and account
    1Charges codeBEAT-FRT
    Debit typeCustomer/Vendor
    Credit typeLedger account
    Credit postingSales order revenue
    Credit account410100
    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 receivable > Charges setup > Charges code.
  2. Select New.
  3. In the Charges code field, enter a code for the charge.
  4. In the Description field, enter a description.
  5. Optionally, in the Item sales tax group field, select a sales tax group.
  6. On the Posting FastTab, set how the charge is debited and credited.
  7. If the debit or credit type is Ledger account, enter the posting type and the main account.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Charges codeThe code for the charge, such as freight or an invoice fee.Microsoft Learn FREIGHTMarkupCode
Item sales tax groupThe sales tax group for the charge, if any.Microsoft Learn TaxItemGroup
ProrateSet to Yes to prorate the charge; available only for sales orders.Microsoft Learn MCRProRate
TypeThe type of account the charge posts to on the debit or credit side, such as Ledger account, Customer/Vendor or Item.Microsoft Learn
PostingThe posting type used when the type is Ledger account.Microsoft Learn CustPosting
AccountThe main account the charge posts to.Microsoft Learn
Debit typeCustomer/VendorCustType
Credit typeLedger accountVendType
Credit postingSales order revenueVendPosting
Credit account410100VendorLedgerDimension

Test checklist

  1. Create a charges code FREIGHT with Debit Type Customer/Vendor and Credit Type Ledger account with a revenue main account.
  2. Add the code to a sales order with a fixed amount.
  3. Invoice the order and check the customer is debited and the revenue account is credited for the charge.
  4. Add a translation and print the invoice for a customer in that language to check the charge text.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Charges codeFor charges the customer pays (for example invoice fees or freight): Debit Type Customer/Vendor and Credit Type Ledger account with the revenue main account for that charge.Debit to the customer adds the charge to the sales order totals, and the ledger credit records the charge income on its own revenue account.Expecting a charge in a different currency from the order when neither the debit nor credit type is Ledger account or Item; a separate charge currency is only allowed for those types.
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 on a charges code is used when charges are posted, so changes apply to charges posted afterwards; posted vouchers aren't changed.
Technical architect

6Technical

Menu itemMarkupTable_Cust 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 sale process MarkupAutoSetup_CustMaintainView charges in the sales process MarkupAutoSetup_CustViewDutiesEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableInquire into sales order progress SalesOrderProgressInquireEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnable
20 security rolesCredit management clerk CredManClerkAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManager MCRTestUserRoleAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkProject manager ProjProjectManagerRental clerk RentalClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental representative RentalRepresentativeRental sales manager RentalSalesManagerProduction planner ReqProductionPlannerRetail service RetailServiceRetail store manager RetailStoreManagerCustomer service representative TradeCustomerServiceRepresentativeSales clerk TradeSalesClerkSales manager TradeSalesManagerSales representative TradeSalesRepresentative
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental coordinator agent RentalCoordinatorAgentSales manager TradeSalesManagerRetail service RetailServiceTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkSales representative TradeSalesRepresentativeRental representative RentalRepresentativeGive people one of these roles. On this system, 19 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_Cust
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