Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
The cost of ram material is not getting added to the FG
anil.kankanala
Member Posts: 2
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.
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.
k.Anil
0