The cost of ram material is not getting added to the FG

anil.kankanala

In 4.0 version, for the below mentioned scenarion, the cost of ram material is not getting added to the finished product , if we are using assembly bill of material.

Take the Finished product item code as FG. Raw material one item code as RM 1. Raw material two item code as RM2.

Define these raw materials in the assembly bill of material for item FG, Give the quanytity as 1 for both these items.

Think that item RM1 is having inventory balance of 1, and RM2 is a new item for which there is no inventory balance.

Now in the BOM Journal create the work order for item FG, the posting date of the work order is 07-12-2006.If you try posting this worker order now, system gives the error, that you cannot post the work order as there is no inventory balance for item RM2 as on that date . This control is there in the base system.

Now the user has created the PO for item RM2 on 12-12-2006 for quantity 1 and he has posted the receipt for this PO on 12-12-2006.

Now he has gone back to the work order which is created on 07-12-2006, without changing the posting date he has posted the work order. It has posted successfully.

Now he has posted the invoice for PO of RM2 item on 15-12-2006 with cost as Rs. 2000.

Now if we see the FG Item cost , the cost of RM2 is not getting loaded into the finished product cost, due to this the gross profit of Finished product is showing wrong figure when it is sold.

We have run both the costing batch jobs but the cost of RM2 is not getting added to the FG.

Usually thea bove flow may happen in the real time scenario, but the problem here is the raw material cost is not getting added into the finished product, I think this is a bug in the product.

NOTE:
1. Same thing is happening even if the work order is posted after posting the receipt for item RM2 but before posting the invoice for item RM2.

2. The raw material cost is getting added only if the work order posting date is after the posting dates of both receipt and invoice i,e work order is posted after invoicing RM2. But practically we cannot say thet every time the flow of material should be like this.

Please go thru this and if any body encounterted the same problem and if it is rectified, please let me know. Please verify whether this has been rectified in the Navision 4 version hotfixes which have been released so far.

Thanking you.