Cust/Vendor fors on application between LCY and FX missing
jannestig
Member Posts: 1,000
Hi all,
I have searched through the forums and not found an exact fit for my issues here.
Currently the following scenario happen in a 4.02 environment.
The client has EUR as LCY, they have a purchase invoice in CHF swiss franc then a payment is applied in LCY from payment journal with the currency column set to blank as it is LCY.
The exchange rate columns have the following relationship CHF to USD as the US is the headquaters so the issue is partly to do with this relational currency setup.
When the LCY line is applied either in a payment journal or from the vend ledger entries the following happens. The payment is set to applying entry the Currency fields in the top of form 233 and the balancing lines are set to blank. In this scenario the APPl Remain amount is then based off a CHF to USD exchange rate. It would seem the code cannot handle the blank currency field and recognize it as LCY. I have shown this by manually inserting a EUR into detailed and vendor lendor entry for the application this works to resolve the issue but is a manual action on the line. Even if i add EUR to a payment journal line during posting the EUR is set to blank as it is LCY.
I have shown this is a failing in CRONUS as well as our environment,
My thoughts were to make the application code recognize the Blank and insert the EUR (LCY) into the application,
I was after others experiance or suggestions
I have searched through the forums and not found an exact fit for my issues here.
Currently the following scenario happen in a 4.02 environment.
The client has EUR as LCY, they have a purchase invoice in CHF swiss franc then a payment is applied in LCY from payment journal with the currency column set to blank as it is LCY.
The exchange rate columns have the following relationship CHF to USD as the US is the headquaters so the issue is partly to do with this relational currency setup.
When the LCY line is applied either in a payment journal or from the vend ledger entries the following happens. The payment is set to applying entry the Currency fields in the top of form 233 and the balancing lines are set to blank. In this scenario the APPl Remain amount is then based off a CHF to USD exchange rate. It would seem the code cannot handle the blank currency field and recognize it as LCY. I have shown this by manually inserting a EUR into detailed and vendor lendor entry for the application this works to resolve the issue but is a manual action on the line. Even if i add EUR to a payment journal line during posting the EUR is set to blank as it is LCY.
I have shown this is a failing in CRONUS as well as our environment,
My thoughts were to make the application code recognize the Blank and insert the EUR (LCY) into the application,
I was after others experiance or suggestions
0
Comments
-
Hi,
do one thing in Purhcase & Payable setup set Appln. between currencies filed to All.
Pranav
Intech Systems
Pranav Joshi
MS Dynamics NAV Consultant
SBS Group Desert Mountain (Formerly Silverware Inc.)0
Categories
- All Categories
- 75 General
- 75 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions