SubContract Variance Account - Adjust Item Cost Entry

sowmyasridhar
Member Posts: 19
We are having an issue with the SubContract Variance account. We are hitting the $ values in this account. The dollars hitting are the dollars that have been received and not paid to the supplier (uninvoiced received).
Here are the steps they follow
1. They create the Production Order. The Production order has SubContract work center.
2. They create the Purchase order through Sub Contract WorkSheets. so the Prod Order No is linked to the Purchase Order.
3. They receive the items.
4. After they receive the items, they create pick and close the Production Order (Change the Status to finished).
5. By process they run Adjust-Item Cost Entries report everyday after hours. Because the production order is closed, this report hits the Sub Contract Variance G/L Account.
6. Most of the times they don't invoice in the same accounting period. So the numbers are growing in this G/L Side to the large unfavourable side.
I think Adjust-Item Cost Entries won't hit this G/L account if we close the Production Order after we invoice the PO.
My question is :
When do we have to close the Production Order (is it after we invoice the PO or before we invoice the PO) ? What is the solution for this problem. Please advise.
Here are the steps they follow
1. They create the Production Order. The Production order has SubContract work center.
2. They create the Purchase order through Sub Contract WorkSheets. so the Prod Order No is linked to the Purchase Order.
3. They receive the items.
4. After they receive the items, they create pick and close the Production Order (Change the Status to finished).
5. By process they run Adjust-Item Cost Entries report everyday after hours. Because the production order is closed, this report hits the Sub Contract Variance G/L Account.
6. Most of the times they don't invoice in the same accounting period. So the numbers are growing in this G/L Side to the large unfavourable side.
I think Adjust-Item Cost Entries won't hit this G/L account if we close the Production Order after we invoice the PO.
My question is :
When do we have to close the Production Order (is it after we invoice the PO or before we invoice the PO) ? What is the solution for this problem. Please advise.
0
Comments
-
This is a problem in NAV I think it occurs from version 5.0SP1.
The problem is in my opinion that there is no function for expect cost posting when you post the subcontracting operation and when you finish the production order the WIP is "cleared" so you get a variance for the entire subcontracting amount as you describe, and of course this is problem when receiving and invoicing is in separate periods.
The solution? well if you wait to change status to finished you'll might get other problems instead but you won't get any variances for subcontracting costs. But the best way might be to find a way to track the prod.orders when receiving and invoicing is in different periods if it's a minor number of prod.orders you might be able to do this manually.
The problem is known by Microsoft hopefully they'll change this in next version._____________________
NAV Freelance Consultant0 -
Thank you very much. This helped me a lot.0
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
- 1.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