May 20, 2011

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

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

This article describes how to work with miscellaneous charges in foreign
currency in Microsoft Dynamics AX.

More Information


Setup


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.


Miscellaneous 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:

o The exchange rate is taken from the purchase invoice posting date. You
cannot change the exchange rate.

o 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.

----------------------------------------------------------------------------
----------------------------------------------------------------------------
---------------------------------------------

Faiqa Usman, Support Manager,

May 16, 2011

Support Alert....!!!! Microsoft Dynamics AX - Production Picking Journal with Two Decimal Spaces CRM:0027802

Microsoft Dynamics AX - Production Picking Journal with Two Decimal Spaces

The BOM (Bill of Materials) quantity fields in the base data and in the
production module (BOM and ProdBOM tables) contain four decimal places in
the standard AX setup. However the Production picking journal only has two
decimal spaces.

In the BOM Lines form, and also within a Production Order in the BOM form,
the Quantity fields are displayed using 4 decimal places, and you can enter
values using up to 4 decimals, for example 1.2345. However, when you want to
record the quantities of Raw Materials used in a Production Order, in a Pick
list Journal, you can only enter those Quantities using 2 decimals.

The reason why you can see and use 4 decimals in the BOM Lines, but only use
2 decimals in Pick Lists is explained below. Note that you can customize
Microsoft Dynamics AX to allow Quantities displayed and entered in such
places as the Pick List to use 4 or more decimals, however this is not
generally recommended unless it is essential for a Customer to do that.

Microsoft Dynamics AX allows you to enter 4 decimals for the Quantity field
in BOM Lines to give you flexibility in how you define the quantity to use
in a BOM.

Below are two examples:

1. For example, if you use 1 kg of salt in a BOM to make a large cake
mix of 1000 kgs, then:

o you may define the BOM Line to use "1.0000" kg of item Salt and with
the field "Per Series" set to 1000.00
Or

o you may prefer to define the BOM Line to say use "0.0010" kg of salt
and with the field "Per Series" set to 1.00

o those two alternatives above will both give the same end result, when
you create a Production Order to make some cake mix..

o then, when you create a Production Order to make 2,000 kg of "Cake
Mix", the BOM Lines are copied into the ProdBom Lines, and it will display
as an expected usage of 2.0000 kg of Salt (as we need 1 kg per 1000 kg of
cake mix. However, when you enter the actual Quantity used in the Pick List,
you would enter it as 2.00.

2. Some customers want to define BOM Line Quantities as percentages,
and all using "Per Series" of 100

o When they do that, raw materials' Quantities may need to be entered
using 4 decimals, to ensure the total quantity of all materials used equals
100.

----------------------------------------------------------------------------
----------------------------------------------------------------------------
---------------------------------------------

Faiqa Usman, Support Manager,

Email: faiqaq@m-consultants.com <mailto:affan.naeem@m-consultants.com>