Hey all,
Finding whether a sales document invoiced is easy enough in GP.
My question is - what is the simplest way to find out whether a document invoiced using SQL?
Currently I'm using multiple SQL statements to figure it out. One to get the document (from a search), and another to lookup ORIGNUMB with SOPTYPE=3 to see if it invoiced.
Looking around at the database, I think it might be possible to use the TRXSORCE field (blank not invoiced - TRANSFER invoiced?).
I'm hoping to get it down to only one sql statement.
Finding whether a sales document invoiced is easy enough in GP.
My question is - what is the simplest way to find out whether a document invoiced using SQL?
Currently I'm using multiple SQL statements to figure it out. One to get the document (from a search), and another to lookup ORIGNUMB with SOPTYPE=3 to see if it invoiced.
Looking around at the database, I think it might be possible to use the TRXSORCE field (blank not invoiced - TRANSFER invoiced?).
I'm hoping to get it down to only one sql statement.