Variant Code

marialorenamarialorena 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.

Comments

  • jannestigjannestig Member Posts: 1,000
    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.
  • matttraxmatttrax Member Posts: 2,309
    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.
  • julkifli33julkifli33 Member Posts: 1,087
    what tables is affected if i change the length in table 5401 (Item variant) ?
    i change the length from 10 become 15
  • crisnicolascrisnicolas Member Posts: 177
    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.
  • SogSog Member Posts: 1,023
    or the tableinformer you can find in the download section
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • julkifli33julkifli33 Member Posts: 1,087
    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)
Sign In or Register to comment.