Hello.
I'm working on a project where I need to extract the purchase history from the company's Sage Sql database.
According to the documentation located at https://sageaom.kcsvar.com/AOM60/POHSTL.xml the TRANSTYPE of 2 is a Purchase Order.
I know there are PO's in the system because tables POPORH1,2 and POPORL have plenty of data in them.
However the Purchase Order History Lines table, POHSTL, doesn't have a single occurrence of a type 2 in it.
How is this possible? Can someone explain this to me?
Thanks in advance,
Mike