modify values in sales invoice header proplem

ahmedbaahmedba Member Posts: 424
I have sales invoice No i need to modify in sales invoice header and line
Ex
Sales Inoice No in sales invoice header table(No field)
inv-002
inv-003
inv-004
inv-005
I want to modify this values as following :

Sales Inoice No in sales invoice header table(No field)

inv-0012
inv-0013
inv-0014
inv-0015
but when it modify it will not effect in any values in database (meaning from inv-0012 to
inv-0015) not found in any place in database
How i do that by writing code if possible

Comments

  • AndwianAndwian Member Posts: 627
    Why do you want to do that? :-k
    Regards,
    Andwian
  • ahmedbaahmedba Member Posts: 424
    Because i make integration between two databases and I replaced this or i need to modify this no to not make duplicate or conflict in primary key when transferred.
    database A
    No customer
    inv-002 ahmed
    Database B
    No customer
    inv-002 ali
    when transferred done
    inv-002 ali will found in sales invoice header and
    inv-002 ahmed will be removed
    so that i change no by writing code are this possible by setrange
    thanks
Sign In or Register to comment.