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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
GL Inconsistency error in Transfer Order
vishalkumarjain
Member Posts: 8
We r using NAV 2009 R2 IN version, when we r posting (Ship) Transfer Order of more than 150 lines without any structure, getting GL inconsistency error. I have used tips and tricks I found difference of only 0.01 amount. Please let me know how can I solve this problem of difference amount 0.01
Also, When we r posting transfer order without adjust cost batch job then it is successfully posted. After posting TO, when we run adjust cost batch job, it is throwing me same error (GL inconsistency).
e.g.
Transfer order is made with appox. 400 diff. items. We have taken one Item called ABC with 36 Qty and at the time of shipment, internally system picked these qty (for transfer purpose) from diff. Item Ledger entry i.e.
Inventory Reduced (Main Store) : ABC -36 Pcs @ Value 277.55 (Cost per Unit taken by system is 7.70972)
Inventory Added (In-Transit) : ABC +8 Pcs Value 61.32 (Cost Per Unit taken by system is 7.665)
ABC +3 Pcs Value 22.99 (Cost Per Unit taken by system is 7.66333)
ABC +25 Pcs Value 193.23 (Cost Per Unit taken by system is 7.7292)
Now, in above condition, you can see that actually system picked three diff. ILE entries to transfer the required qty but only single ILE generated for outbound entry purpose. And there is a diff. of 0.01 in Amount. It is happening in many items in the same Transfer Order (and other Transfer Orders as well)
Please suggest any solution for above situation because it’s occured many times when working with warehouse having huge inventory related movements and item having small values.
Also, When we r posting transfer order without adjust cost batch job then it is successfully posted. After posting TO, when we run adjust cost batch job, it is throwing me same error (GL inconsistency).
e.g.
Transfer order is made with appox. 400 diff. items. We have taken one Item called ABC with 36 Qty and at the time of shipment, internally system picked these qty (for transfer purpose) from diff. Item Ledger entry i.e.
Inventory Reduced (Main Store) : ABC -36 Pcs @ Value 277.55 (Cost per Unit taken by system is 7.70972)
Inventory Added (In-Transit) : ABC +8 Pcs Value 61.32 (Cost Per Unit taken by system is 7.665)
ABC +3 Pcs Value 22.99 (Cost Per Unit taken by system is 7.66333)
ABC +25 Pcs Value 193.23 (Cost Per Unit taken by system is 7.7292)
Now, in above condition, you can see that actually system picked three diff. ILE entries to transfer the required qty but only single ILE generated for outbound entry purpose. And there is a diff. of 0.01 in Amount. It is happening in many items in the same Transfer Order (and other Transfer Orders as well)
Please suggest any solution for above situation because it’s occured many times when working with warehouse having huge inventory related movements and item having small values.
0