Lot Specific Costing

dayakar

Hi all,
Nav allows the item to be batch(Lot) tracked. Is there a solution to have batch costing(Lot Specific Costing) as well? Currently now the system uses either FIFO or average costing. Prospect wants the correct batch cost to be reflected against the sales invoice when the respective batch is selected.

I know its possible by using serial items, is there any way or work arround to achieve by only lots.

Any help or insight will be highly appreciated.

chengalasettyvsrao

what is your problem , system is doing what u need exactly.

Create a New item called = LOt
Costing method = FIFO
Item tracking code = Lot All and assign the Number series (Onely Lot number there is no serial number)

Create the Porder , Receipt and Invoice

Posting date = 01/01/01
Item code = LOt
Qty = 1
Item cost = 1000
Lot No = Abc 001


Create the another Purchase order , receipt and Invoice

Posting date = 02/02/02
item code = Lot
Qty = 1
Item cost = 2000
Lot no = ABC 002.

Now create the sales order and Ship and Invoice

Posting date = 03/0303
Item code = Lot
qty = 1
Item Price = 3000
Lot No = ABC 002 ( that means system has to take the item cost = 2000 /-)

Now run the AICE batch Job check the tha Item ledger entries and Values entries for the field cost amount (acutal) for Entry type = Sale.

you will get what need.

dayakar

Thank for your reply,

but in the case of transfers and consumptions nav will not apply the same way.
We need to get the same unit cost as per lot through out the Transfers and mfg also.

May be am missing some thing.

chengalasettyvsrao

No, it will do the same way what i explained above .

even Transfers and Mfg also it works based lot cost .

U can test your self.

Dont forget to run the AICE batch job( othere wise u dont know)

dayakar

Thanks for the quick reply,

When a transfer is created the system will automatically determine the price according to the item's unit cost. However, the user can select any available lot, but can we make transfer price specific to lot selected.

chengalasettyvsrao

dayakar wrote:

Thanks for the quick reply,

When a transfer is created the system will automatically determine the price according to the item's unit cost. However, the user can select any available lot, but can we make transfer price specific to lot selected.

follow this example do in u r system

Create the Porder , Receipt and Invoice

Posting date = 04/04/04
Item code = LOt
Qty = 1
Item cost = 4000
Lot No = Abc 004
Location = Blue


Create the another Purchase order , receipt and Invoice

Posting date = 05/05/05
item code = Lot
Qty = 1
Item cost = 5000
Lot no = ABC 005
Location = Blue

Now create the transfer order on 06/06/06 from Blue - Green.

Posting date = 07/07/07

Item = Lot
qty = 1

Transfer price = System automatically take the unit cost from Item card ( dont think about this one)

Lot No = ABC 005 .

Now run the AICE and check the item ledger & value entries for entry ty pe = Transfer .
system will take the cost amouont (actual) = 5000 for that LOT.

I can tell system is doing what u need .

dayakar

Thanks for the reply,

Testing results are quite ok but in the customer DB i can see variation in the cost amount (actuals), i found that in the item tracking code card they didnt checked the Lot Specific Tracking.

ACIE batch is running always.

Is there any way to correct these type of entries?

dayakar

Well it was a setup issue at the customers DB.
While check mark in the Lot Specific Tracking nav is working as expected.
This resolves my basic issue.

dayakar

Thanks chengalasettyvsrao