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>

1 comment:

kousalya said...

interesting blog. It would be great if you can provide more details about it. Thanks you

Journal support