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
- 304 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
Issue with Copy and Pasting Rows in Sales Invoice
engsiong75
Member Posts: 143
Hi
I have a user who regularly copies and paste sales invoice line in Navision. He is only copying rows with description column and then pasting the rows with description to a different row.
Eg.
From this
Type No. Description Quantity Unit Price Line Discount Amount
Item A Test Item 5 1.00 0.00
XXXX
YYYYY
Item B Testing 5 1.00 0.00
To this
Item A Test Item 5 1.00 0.00
XXXX
YYYYY
Item B Testing 5 1.00 0.00
XXXX
YYYYY
In NAV 2013 R2, this is not an issue as the user can use the Copy Rows and Paste Rows function. This is no problem if the user copies rows within the same sales invoice. Eg. The user selects all the rows and then click the Copy Rows function. Then go to a new line and then Paste rows.
However, if the user copies the rows and then paste it in Excel. Then recopy the exact rows and columns back into Sales Invoice, the program starts to behave differently. At that point, I will get error message that the "Quantity must have a value in the Sales Line: Document Type = Invoice, Document No.= XXXX, Line No.=0. It cannot be zero or empty."
Once I troubleshoot the code, I found that the issue is that the Invoice Discount Amount field is being Activated. This causes the "TestField(Quantity);" code to be trigger which results in the error.
Query:
Why is it that when I copy and paste from the same page, I do not encounter any error but as soon as I have to copy and paste it to Excel, copy the same unchanged data, using the same column and row, I get an error message?
Please don't suggest hiding the field Line Discount Amount as the user needs to see the field for the lines with Type Item.
Thank you,
Tan Eng Siong
I have a user who regularly copies and paste sales invoice line in Navision. He is only copying rows with description column and then pasting the rows with description to a different row.
Eg.
From this
Type No. Description Quantity Unit Price Line Discount Amount
Item A Test Item 5 1.00 0.00
XXXX
YYYYY
Item B Testing 5 1.00 0.00
To this
Item A Test Item 5 1.00 0.00
XXXX
YYYYY
Item B Testing 5 1.00 0.00
XXXX
YYYYY
In NAV 2013 R2, this is not an issue as the user can use the Copy Rows and Paste Rows function. This is no problem if the user copies rows within the same sales invoice. Eg. The user selects all the rows and then click the Copy Rows function. Then go to a new line and then Paste rows.
However, if the user copies the rows and then paste it in Excel. Then recopy the exact rows and columns back into Sales Invoice, the program starts to behave differently. At that point, I will get error message that the "Quantity must have a value in the Sales Line: Document Type = Invoice, Document No.= XXXX, Line No.=0. It cannot be zero or empty."
Once I troubleshoot the code, I found that the issue is that the Invoice Discount Amount field is being Activated. This causes the "TestField(Quantity);" code to be trigger which results in the error.
Query:
Why is it that when I copy and paste from the same page, I do not encounter any error but as soon as I have to copy and paste it to Excel, copy the same unchanged data, using the same column and row, I get an error message?
Please don't suggest hiding the field Line Discount Amount as the user needs to see the field for the lines with Type Item.
Thank you,
Tan Eng Siong
0
Comments
Good question. Maybe a bug.
But how much does this occur? Users don't need to copy and paste it to Excel each time I assume.
Perhaps the error does not occur when you refresh just before the last copy?
Tino Ruijs
Microsoft Dynamics NAV specialist
The issue is that there are time when the user can recycle the description by copying rows from the top to rows at the bottom. At other times, the user has to go copy the data to Excel and then run some macro\formula so that the data in the Description column changes according to some logic.
I have tried refreshing before copying and before pasting. There is no difference to the outcome.
Thank you,