Dynamic GP Transfer Orders (with Serial number) affect what tables

I am new to Dynamic GP and need to know the tables got affect when orders (with Serialized items) got transfer to invoices.

Thanks,

Simon

  • Hi,

    For example :

     

    I just put a sales order in GP and saved it. The sales order header is stored in SOP10100 table and the line detail is stored in SOP10200 table.

     

     

    After I transfer the sales order into invoice it display look like this.

     

    The Sales order is now transfer to invoice. You can see the table field called "ORIGNUMB" , Where the 

    invoice came from.

    Hope this helps!...

  • Hi,

    Please execute the below query.

    select ITEMNMBR,SERLNMBR,* from IV00200 order by dex_row_id desc

    IV00200 -  Item Serial Number Master

     

    Hope this helps!

    Thanks

    eeswar

  • In reply to eeswar:

    Great thanks.

  • In reply to Simon Ng:

    You're welcome.

    Thanks

    eeswar

Related
Recommended