Variant Code

marialorena
Member Posts: 62
I created and posted a sales invoice for item xxx. This was supposed to be posted with variant code. How to correct?
Thanks.
Thanks.
0
Comments
-
Issue a Credit Note with stock to the same customer then invoice again.
If you mean you created an order then shipped and invoiced in one step you will have to create a new order to ship and invoice with the correct variant.
IF just an invoice with no shippment then a new invoice should do.0 -
Just take it one step at a time.
You need to reverse a posted invoice? That's what a credit memo is for.
You need to reissue the order? Do a copy document on the original, but change the variant code on the line. Then post.0 -
what tables is affected if i change the length in table 5401 (Item variant) ?
i change the length from 10 become 150 -
julkifli33 wrote:what tables is affected if i change the length in table 5401 (Item variant) ?
i change the length from 10 become 15
There are several tables involved... use the developer toolkit to find them out.0 -
or the tableinformer you can find in the download section0
-
Sog wrote:or the tableinformer you can find in the download section
i already using table informer that you told me
but it didn't tell us every field that not have relation
like table Item Variant (5401) ... it only inform us that Item No. has relation with No. (from table 27)
all i want to know is like field "Code" from (5401) is affecting "Variant Code" in table sales line (37)0
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
- 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
- 320 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