Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Intercompany Currency Bug
tricknot
Member Posts: 5
Hi,
We're investigating intercompany functionality on Nav 5. We've found a bug when distributing invoice lines to another company, which we'd like to know if anyone has found/ had resolved?
(btw, we're only using the Cronos demo for this investigation, and have completed all the relevant I/C setup)
We raised a Purchase Invoice in company A (GBP) for 400 USD total.
In the Invoice Lines, we allocated 200USD to a GL Acct (Postage) in company A and 200USD to company B (which is DKK, but irrelevant for this)
Posting the invoice in Co A gave us the following GL Entries:
DR Co. A Postage 223.02 (400USD converted to GBP @1.79- ok)
CR Co. A Creditors (223.02) (400USD converted to GBP @1.79- ok)
DR Co. A I/C Customer 62.17 Wrong
DR Co. A Postage (62.17) Wrong
What it should have done is Credit Co A Postage 111.51 (200USD converted to GBP). Instead it seems to have taken the already converted 111.51 GBP, treat it as USD and then apply the 1.79 conversion rate again (to give 62.17).
In Co A outbox (and Co B Inbox) it shows incorrectly as 111.51 USD (not GBP).
If anyone else has come across this and can provide fix info, or simply can agree that the above looks wrong, I'd be most grateful!!
Thanks
tricknot
We're investigating intercompany functionality on Nav 5. We've found a bug when distributing invoice lines to another company, which we'd like to know if anyone has found/ had resolved?
(btw, we're only using the Cronos demo for this investigation, and have completed all the relevant I/C setup)
We raised a Purchase Invoice in company A (GBP) for 400 USD total.
In the Invoice Lines, we allocated 200USD to a GL Acct (Postage) in company A and 200USD to company B (which is DKK, but irrelevant for this)
Posting the invoice in Co A gave us the following GL Entries:
DR Co. A Postage 223.02 (400USD converted to GBP @1.79- ok)
CR Co. A Creditors (223.02) (400USD converted to GBP @1.79- ok)
DR Co. A I/C Customer 62.17 Wrong
DR Co. A Postage (62.17) Wrong
What it should have done is Credit Co A Postage 111.51 (200USD converted to GBP). Instead it seems to have taken the already converted 111.51 GBP, treat it as USD and then apply the 1.79 conversion rate again (to give 62.17).
In Co A outbox (and Co B Inbox) it shows incorrectly as 111.51 USD (not GBP).
If anyone else has come across this and can provide fix info, or simply can agree that the above looks wrong, I'd be most grateful!!
Thanks
tricknot
0