Skip to content

Contact Us    Now Hiring

@meritweb on TwitterMerit Solutions on LinkedInMerit Solutions YouTube Video SeriesMerit Solutions on FacebookSubscribe to Merit Matters Blog

   

How to Work with Miscellaneous Charges in Foreign Currency in Microsoft Dynamics AX

To work with miscellaneous charges, you must create miscellaneous charges codes. You create these miscellaneous charges codes in Accounts Payable and in Accounts Receivable in Microsoft Dynamics AX as follows:

  • To create the miscellaneous charges codes in Accounts Payable, click Accounts Payable, expand Setup, expand Misc. Charges, and then click Misc. charges codes.
  • To create the miscellaneous charges codes in Accounts Receivable, click Accounts Receivable, expand Setup, expand Misc. Charges, and then click Misc. charges codes.
The following are the codes that you can use when you configure miscellaneous charges codes.

In Accounts Payable

  • The Item - Vendor charge code is used in purchase orders.
  • The Ledger Account- Vendor (Expense - Vendor) charge code is used in purchase orders.
  • The Ledger Account - Ledger Account (Expense - Ap Accrual) charge code is used in purchase orders.
  • The Item - Ledger Account (Item - Ap Accrual) charge code is used in purchase orders and in purchase invoices.

    To use these charge codes in a purchase order, click Accounts Payable, click Purchase order, click Setup, and then click Misc. charges

To use the Item - Ledger Account (Item - Ap Accrual) charge code in a purchase invoice, click Accounts Payable, expand Inquiries, expand Journals, click Invoice, click Misc. charges, and then click Adjustment.

In Accounts Receivable

  • The Customer - Ledger Account (Customer - Income/revenue) charge code is used in sales orders and in free text invoices.
  • The Ledger Account - Ledger Account (Expense - Ap Accrual) charge code is used in sales orders and in free text invoices. To use these charge codes, click Accounts Receivable, click Sales order, click Setup, and then click Misc. charges.

NOTE: You cannot select the Item option when you configure miscellaneous charges in Accounts Receivable.

Charge codes for foreign currency

When you use foreign currency in miscellaneous charges, you must consider the configuration of the miscellaneous charges code that is used in the transaction to achieve the expected result.

In Accounts Payable

  • Use the Item - Vendor charge code when the currency that is used by the miscellaneous charges code is the same currency that is used in the purchase order. The exchange rate is taken from the purchase invoice posting date. The exchange rate cannot be changed.
  • Use the Ledger Account - Vendor (Expense - Vendor) charge code when the currency that is used by the miscellaneous charges code is the same currency that is used in the purchase order. The exchange rate is taken from the purchase invoice posting date. The exchange rate cannot be changed.
  • Use the Item - Ledger Account (Item - Ap Accrual) charge code when the currency that is used by the miscellaneous charges code may differ from the currency that is used in the purchase order. The exchange rate is taken from one of the following:
    • The exchange rate is taken from the purchase invoice posting date. You cannot change the exchange rate.
    • The exchange rate is taken from the invoice adjustment after you specify the currency and the exchange rate date.
  • Use the Ledger Account - Ledger Account (Expense - Ap Accrual) charge code when the currency that is used by the miscellaneous charges code may differ from the currency that is used in the purchase order. The exchange rate is taken from the purchase invoice posting date. You cannot change this date even though the currencies in the purchase order and in the miscellaneous charges are different.

In Accounts Receivable

  • Use the Customer- Ledger Account (Customer - Income/revenue) charge code when the currency that is used by the miscellaneous charges code is the same currency that is used in the sales order or in the free-text invoice. The exchange rate is taken from the sales invoice posting date. The exchange rate cannot be changed.
  • Use the Ledger Account - Ledger Account (Expense - Ap Accrual) charge code when the currency that is used by the miscellaneous charges code may differ from the currency that is used in the sales order or in the free-text invoice.

The exchange rate is taken from the posting date of the sales invoice or from the posting date of the free-text invoice. The exchange rate cannot be changed in the currencies in the sales order.