Transfer order issue in NAV SG 5.0 SP1
phani_kaushik
Member Posts: 8
Hi,
The Singapore version of NAV 5.1 seems to post wrong inventory entries into G/L upon posting a transfer order.
Even in Cronus, this is the case:
24-01-08 109001 2110 Resale Items Direct Cost on 24-01-08 2,308.50 -2,308.50 G/L Account No 2871 0
24-01-08 109001 7170 Inventory Adjmt., Retail Direct Cost on 24-01-08 2,308.50 2,308.50 G/L Account No 2872 0
24-01-08 109001 2110 Resale Items Direct Cost on 24-01-08 2,308.50 2,308.50 G/L Account No 2873 0
24-01-08 109001 7170 Inventory Adjmt., Retail Direct Cost on 24-01-08 2,308.50 -2,308.50 G/L Account No 2874 0
The 1st two entries are actually correct whereas the other two are just nullifying the 1st two, which is wrong.
Can someone help me out whether there are any hotfixes or any other way to solve this?
The Singapore version of NAV 5.1 seems to post wrong inventory entries into G/L upon posting a transfer order.
Even in Cronus, this is the case:
24-01-08 109001 2110 Resale Items Direct Cost on 24-01-08 2,308.50 -2,308.50 G/L Account No 2871 0
24-01-08 109001 7170 Inventory Adjmt., Retail Direct Cost on 24-01-08 2,308.50 2,308.50 G/L Account No 2872 0
24-01-08 109001 2110 Resale Items Direct Cost on 24-01-08 2,308.50 2,308.50 G/L Account No 2873 0
24-01-08 109001 7170 Inventory Adjmt., Retail Direct Cost on 24-01-08 2,308.50 -2,308.50 G/L Account No 2874 0
The 1st two entries are actually correct whereas the other two are just nullifying the 1st two, which is wrong.
Can someone help me out whether there are any hotfixes or any other way to solve this?
0
Comments
-
What is wrong ? U shipped it ,
Cr Inventory A/c
Dr Inventory Adjustment From Transfer from Code
NAV automatically received it in "In Transit"
Dr Inventory A/c
Cr Inventory Adjustment.
After posting the receipt at Transfer to
Cr Inventory A/c
Dr Inventory Adjustment From In Transit
AND
Dr Inventory A/c
Cr Inventory Adjustment. at Transfer to Code.Kapil Khanna0 -
A transfer order by definition cancels itself out...you ship something, then you receive it back in at a different location.0
-
It is also possible for each location to have it's own inventory account in the inventory posting setup. That is not used in the Cronus database, but is recommendable, especially if each location is regarded as a seperate profit center.
If you set it up that way your first and third entry will touch different accounts.Kai Kowalewski0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 327 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

