Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.
Based on the customer or vendor that you're working with or the item that you're selling, you might want to apply specific additional charges. The charges feature in Microsoft Dynamics 365 Supply Chain Management helps you automatically apply charges to purchase orders or sales orders.
Automatic charges (auto charges) are automatically applied when you create a sales order or a purchase order. You can define auto charges for specific vendors, customers, groups of vendors, groups of customers, items, or groups of items. You can also define auto charges that apply to all vendors, customers, or items.
Set up parameters
The Procurement and sourcing parameters page has a few settings that are especially relevant when you want to apply charges automatically in the purchase order. To complete this setup, follow these steps.
Go to Procurement and sourcing > Setup > Procurement and sourcing parameters.
On the Prices tab, on the Prices FastTab, set the following fields:
- Find auto charges for header – Set this option to Yes if charges should automatically be applied to purchase order headers.
- Find auto charges for line – Set this option to Yes if charges should automatically be applied to purchase order lines.
The Accounts receivable parameters page also has a few settings that are especially relevant when you want to apply charges automatically in the sales order. To complete this setup, follow these steps.
Go to Accounts receivable > Setup > Accounts receivable parameters.
On the Prices tab, on the Prices FastTab, set the following fields:
- Find auto charges for header – Set this option to Yes if charges should automatically be applied to sales quotation and sales order headers.
- Find auto charges for line – Set this option to Yes if charges should automatically be applied to sales quotation and sales order lines.
Set up charges codes
To apply charges, you must first define charges codes.
Follow one of these steps:
- For purchase orders: Go to Procurement and sourcing > Setup > Charges > Charges code.
- For sales orders: Go to Accounts receivable > Setup > Charges > Charges code.
On the Action Pane, select New to create a charges code.
In the header of the new record, set the following fields:
Charges code – Enter a code for the charges.
Description – Enter a description of the charges.
Item sales tax group – Select an item sales tax group, if applicable.
Prorate – Set this option to Yes if you want to prorate your charges. This option is available only for sales orders.
Maximum amount – Enter the maximum amount that's allowed for the charges code. This field is used to validate charges for vendor invoices. It's available only for purchase orders.
Note
To turn on the functionality for validating charges for purchase orders, go to Accounts payable > Setup > Accounts payable parameters. On the Invoice validation FastTab, in the Invoice validation section, set the Enable invoice matching validation option to Yes.
The Posting FastTab includes Debit and Credit sections. Set the following fields, depending on the ledger that you want to post the charges to:
- Type – Select the type of account that you're posting to (Ledger, Customer, or Item). If you select Ledger account as the debit type or credit type, specify a posting type in the Posting field, and specify the main account in the Account field.
- Posting – Select the type of postings to create (such as Broker fee or Customer settlement).
- Account – Select the account to post the charge for.
On the Action Pane, select Save.
Create charge groups
Charge groups automatically apply specific charges to a group of customers or vendors. The following subsections describe how to create and assign these charge groups.
Charge groups for purchase orders
To create charge groups for purchase orders, follow these steps.
Go to Procurement and sourcing > Setup > Charges > Vendor charges group.
On the Action Pane, select New to add a row to the grid, and then set the following fields:
- Charges group – Enter the name of the charge group.
- Description – Enter a description of the charge group.
On the Action Pane, select Save.
Go to Procurement and sourcing > Vendors > All vendors, and either open an existing vendor or create a new vendor.
On the Purchase order defaults FastTab, in the Purchase order section, set the Charges group field to the charge group that you created.
Charge groups for sales orders
To create charge groups for sales orders, follow these steps.
Go to Accounts receivable > Setup > Charges > Customer charge groups.
On the Action Pane, select New to add a row to the grid, and then set the following fields:
- Charges group – Enter the name of the charge group.
- Description – Enter a description of the charge group.
On the Action Pane, select Save.
Go to Accounts receivable > Customers > All customers, and either open an existing customer or create a new customer.
On the Sales order defaults FastTab, in the Sales order section, set the Charges group field to the charge group that you created.
Define auto charges
After you set up your charge codes, follow these steps to define the auto charges.
Follow one of these steps:
- For purchase orders: Go to Procurement and sourcing > Setup > Charges > Automatic charges.
- For sales orders: Go to Accounts receivable > Setup > Charges setup > Auto charges.
In the list pane, in the Level field, select the level where your auto charge applies:
- Header – Apply charges to the order header.
- Line – Apply charges to the order lines.
Select an existing auto charge to edit it, or select New to define a new auto charge.
In the Account code list, select one of the following values to specify the scope of accounts that the auto charge affects:
- Table – Assign charges to a specific customer or vendor.
- Group – Assign charges to a miscellaneous charges group.
- All – Assign charges to all customers or vendors.
In the Customer relation or Vendor relation field, select a specific customer or vendor if you set the Account code field to Table. If you set the Account code field to Group, select a customer or vendor charges group.
In the Item code field, select one of the following values to specify the scope of items that the auto charge affects. You can select an item code only when you define auto charges at the line level.
- Table – Assign charges to a specific item.
- Group – Assign charges to an item charges group.
- All – Assign charges to all items.
In the Item relation field, select a specific item if you set the Item code field to Table. If you set the Item code field to Group, select an item charges group.
For sales orders only: In the Mode of delivery code field, select one of the following values to specify the scope of delivery modes that the auto charge affects:
- Table – Assign charges to a specific mode of delivery.
- Group – Assign charges to a mode of delivery group.
- All – Assign charges to all modes of delivery.
For sales orders only: In the Mode of delivery relation field, select a specific mode of delivery if you set the Mode of delivery code field to Table. If you set the Mode of delivery code field to Group, select a mode of delivery group.
On the Lines FastTab, define the charges and the charge rates that the current auto charge uses. You can use the toolbar on this FastTab to add as many lines as you require. For each line, set the following fields:
Currency – Select the currency that you want to use to calculate the charge. This field applies to the Header and Line levels for sales quotation and sales order charges.
Charges code – Select the code for the charge.
Category – Select one of the following values:
- Fixed – Enter the charge as a fixed amount on the line. You can use fixed charges on charges both in the order header and on the order lines.
- Pcs – Base the charge on unit with no unit of measure conversion. Pcs in this case represents any unit of measure and not the specific Pcs unit of measure. You can use these charges only on order lines. They appear when you calculate the order total.
- Percent – Enter the charge as a percentage on the line. You can use percentage charges on charges both in the order header and on the order lines.
- Intercompany percent – Enter the charge as a percentage on the line for intercompany orders. You can use intercompany percentage charges only on order lines.
- External – A third-party service that's associated with one or more shipping carriers calculates the charge.
- Specific unit – Express the charge value in the unit of measure on the charge line. Unit of measure conversion is used to apply it proportionally to the unit of measure on the sales line. This category applies only to the Line level.
- Specific unit match – Express the charge value in the unit of measure on the charge line. The unit of measure on the sales line must match this unit of measure for the charge line to be applied. No unit of measure conversion is applied. This category applies only to the Line level.
Unit – Enter the unit that applies when the Category field is set to Specific unit or Specific unit match.
Charges value – Enter the charge value, based on the category that you selected.
Charges currency code – Specify a currency for the charge if you want to use a currency other than the currency that you specified in the Currency field. You can use a different currency only if the Debit type or Credit type field is set to either Ledger account or Item for the selected charges code.
From amount – Specify a starting amount to apply the auto charge to. In this context, the amount refers to the order total.
To amount – Specify the ending amount to apply the auto charge to. In this context, the amount refers to the order total.
Sales tax group – Specify a sales tax group.
Site and Warehouse – Specify a site and warehouse if charges should be applied only for a specific site and warehouse.
Keep – Select this checkbox to keep the charges transactions after invoicing is completed, so that the charge is applied every time that you create a new invoice for the selected customer account.
For sales orders only: If you want to calculate tiered charges, see Tiered charges on sales orders for information.
Supply Chain Management provides the following optional functionality for calculating auto charges. You might need to enable and configure these features before you can use them. For more information, follow the links.
Tip
When configuring auto charges for accounts payable in Dynamics 365 Finance, you might see duplicate charge calculations if you set up auto charges for both specific vendors (Table) and all vendors (All). This situation occurs because the system applies all relevant auto charge configurations, regardless of hierarchy, whenever you create a new purchase order. For example, if you set up a charge code with account code All, the system applies that charge code to every purchase order, even if you also set up other specific vendor or group configurations.
Allocate charges from the header to a line
The following procedure shows how to allocate header-level charges to a line. Before you start this procedure, you should already have a header-level charge of the fixed amount type and an order where you apply that charge. Additionally, the order should already include at least one line item.
Open the purchase order or charge order.
On the Action Pane, follow one of these steps:
- For purchase orders: On the Purchase tab, in the Charges group, select Allocate charges.
- For sales orders: On the Sell tab, in the Charges group, select Allocate charges.
In the Allocate charges to order lines dialog box, set the following fields:
Charges allocation – Select one of the following values to specify how the charges should be allocated:
- Net amount – Allocate charges according to each line amount relative to the total net amount.
- Quantity – Allocate charges according to the number of units for each line relative to the total number of units.
- Per line – Allocate charges equally among the total number of lines.
Allocate charges to lines – Select a value to specify whether charges should be allocated to all lines, to positive lines only, or to negative lines only.
Allocate all – Select this checkbox to allocate charges to order lines even if the charges code has a debit type other than Item.
Received – Select this checkbox to allocate charges only to received order lines.
Stocked – Select this checkbox to allocate charges to only inventoried order lines.
Show selections and clear specific lines – Select this checkbox to exclude specific lines from this allocation. When you select this checkbox, the Choose lines to exclude from allocation grid opens. This grid includes only lines that match the criteria that are defined by the Allocate charges to lines and Stocked settings. For example, if you set the Allocate charges to lines field to Positive lines and select the Stocked checkbox, the grid shows only lines that are both positive and inventoried. In addition, the grid automatically filters out any lines that the full quantity is already received for. While the grid is open, clear the Include checkbox for each line that you want to exclude from allocation.
Important
When you work with the Choose lines to exclude from allocation grid, be sure to leave the grid open until you select Allocate. If you close the grid before you select Allocate, your settings in the grid are lost. Therefore, charges are allocated based on the criteria that you previously defined.
Select Allocate to apply your settings and close the dialog box.
Reapply header auto charges
In some cases, the system reapplies header auto charges by deleting and inserting them after you update a header field.
You can set up auto charges to consider vendor charge groups or modes of delivery. Therefore, when you update the Charges group or Mode of delivery on a purchase order header, the charge might change based on the auto charge setup. When the charge needs to be recalculated, the system deletes the existing auto charge and inserts a new auto charge. The recalculation doesn't affect charges you add manually to the purchase order.
After the system allocates an auto charge from the header to a line, it doesn't track its origin (there's no reference from the line to the auto charge setup), so the charge becomes a line charge. If you then update the Charges group or Mode of delivery on a purchase order header, the system reapplies the new, recalculated header charge, but it doesn't affect the line charges. This pattern applies to both purchase order headers and sales order headers.
The following examples show how to update header-level charges and select a new Mode of delivery on the purchase order header. Each example assumes that you already have a header-level charge of type fixed amount and an order where that charge is applied. The order must already include at least one line item.
Example 1: Header auto charge value resets after changing the mode of delivery
This example shows that if you customize the value of a header auto charge and then update the mode of delivery for the purchase order, the system resets the header auto charge to its original value.
Go to Procurement and sourcing > Purchase orders > All purchase orders and open a purchase order that includes a header auto charge of type fixed amount.
On the Action Pane, open the Purchase tab and, in the Charges group, select Maintain charges.
For the existing header auto charge, enter a new value in the Charges value field.
On the Action Pane, select the Back button to return to the purchase order.
Open the Header tab of the purchase order.
Expand the Delivery FastTab and select a new value for the Mode of delivery field.
On the Action Pane, select Save.
On the Action Pane, open the Purchase tab and, in the Charges group, select Maintain charges.
Note that the Charges value is now reset to its original auto charge value.
Example 2: Header auto charge is reapplied after allocating it to a line and then changing the mode of delivery
This example shows that if you allocate a header auto charge to a line and then update the mode of delivery for the order, the system reapplies the original header auto charge while leaving the allocated charge applied to the line.
Go to Procurement and sourcing > Purchase orders > All purchase orders and open a purchase order that includes a header auto charge of type fixed amount.
On the Action Pane, open the Purchase tab and, in the Charges group, select Maintain charges.
Note the header auto charges listed here.
On the Action Pane, select the Back button to return to the purchase order.
On the Action Pane, open the Purchase tab and, in the Charges group, select Allocate charges.
On the Allocate charges to order lines dialog, select the Allocate all check box. Then select Allocate to allocate the header auto charge to the order lines.
On the Action Pane, open the Purchase tab and, in the Charges group, select Maintain charges.
Note that the header auto charges are no longer listed because you allocated them to the line level.
On the Action Pane, select the Back button to return to the purchase order.
On the Purchase order lines FastTab, select a purchase order line.
On the Purchase order lines FastTab toolbar, select Financials > Maintain charges.
Note that the previous header auto charge is now shown here, at the line level.
On the Action Pane, select the Back button to return to the purchase order.
Open the Header tab of the purchase order.
Expand the Delivery FastTab and select a new value for the Mode of delivery field.
On the Action Pane, select Save.
On the Action Pane, open the Purchase tab and, in the Charges group, select Maintain charges.
Note that the original header auto charge is now reapplied to the order, even though the charge is also listed at the line level.