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
- 296 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
Copy Document - Wrong Exchange Rate
PPP
Member Posts: 159
Hi,
I have come across a situation in Navision. I am using the copy document functionality while creating the invoice. Basically copy from S.Order/Blanket Order. The procedure follows by the users are mentioned below.
1. Create new invoice by pressing F3 so invoice number and Posting Date is generated. Posting date is the work date ( default)
2. Copy document - copy from blanket Order.
3. enter rest of the information to complete the invoice.
What i observed here is ,when we copy the header information the Exchange rate also get copied to the invoice ( which is very exchange based on the posting date in the Sales Order). But in the invoice the posting date is current/different from the order - posting date and accordingly the exchange rate is different. But Navision takes the old exchange rate and post the invoice which is wrong. It will validate only if you change the posting date manually. But copy functionality works after creating the invoice record , by then invoice number and the Invoice posting date is already updated and user need not to change the posting date.
Is this is a Bug in navision ? or procedure we are doing is somthing wrong ?
Any way i have lot of data gone in with wrong exchange rate>>> :x :x :x ](*,)
Can anybody through some light on it
Thanks in advance
PpP
I have come across a situation in Navision. I am using the copy document functionality while creating the invoice. Basically copy from S.Order/Blanket Order. The procedure follows by the users are mentioned below.
1. Create new invoice by pressing F3 so invoice number and Posting Date is generated. Posting date is the work date ( default)
2. Copy document - copy from blanket Order.
3. enter rest of the information to complete the invoice.
What i observed here is ,when we copy the header information the Exchange rate also get copied to the invoice ( which is very exchange based on the posting date in the Sales Order). But in the invoice the posting date is current/different from the order - posting date and accordingly the exchange rate is different. But Navision takes the old exchange rate and post the invoice which is wrong. It will validate only if you change the posting date manually. But copy functionality works after creating the invoice record , by then invoice number and the Invoice posting date is already updated and user need not to change the posting date.
Is this is a Bug in navision ? or procedure we are doing is somthing wrong ?
Any way i have lot of data gone in with wrong exchange rate>>> :x :x :x ](*,)
Can anybody through some light on it
Thanks in advance
PpP
0
Comments
I'm not sure that I clear understanding or not.
Have u try this ?
In the Copy Document -:
- Include Header = Yes
- Posting Date <-- Here, put your current/working date
- Replace Posting Date = Yes
- Replace Document Date = Yes.
I'm using NAV4, and it works fine.
Wish this can help.
I am using 5.0
Include Header - check box
Recalculate Lines - check box
I couldnt find any ' replacing posting date...., document' date etc
I am using 5.0
Include Header - check box
Recalculate Lines - check box
system validates only if you change the posting date.
Copy document functionalty works after you create the INvoice record ( by pressing f3.) . System gives the new invoice number and the posting date ( by default work date). So user need not to change the posting date.