I am new to Dynamic GP and need to know the tables got affect when orders (with Serialized items) got transfer to invoices.
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!...
Please execute the below query.
select ITEMNMBR,SERLNMBR,* from IV00200 order by dex_row_id desc
IV00200 - Item Serial Number Master
Hope this helps!
In reply to eeswar:
In reply to Simon Ng: