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