Hello all,
First question and new with MAS90 so will try to be specific. I do not have the Tech CD with me (@work) and I am trying to find the table that has the Purchase Order Line infotmation... I am wanting to find all line information for present and past purchse orders.
I have foudn the following:
PO4_PurchaseOrderReacp - shows me all Purchase order
PO2_PurchaseOrderEntryLine - Only shows current PO's not past ones.
I am wanting to make a simple query that will give me the number of line items per PO... Then will expand on this to do quartley / yearly / also lines received during a period.
First thank you in advance for the help and wanted to say the infomration I have been reading on the posts after find this forum 2 days ago has been very interesting... ALready asking to purchase the VI and BOI parts for future work that I want to do from what I have been seeing.
Also it seems that the classes offered are pretty good so I am starting to look for some - feedback appreacited on any good ones or the best to start with.
Thank you,
John
First question and new with MAS90 so will try to be specific. I do not have the Tech CD with me (@work) and I am trying to find the table that has the Purchase Order Line infotmation... I am wanting to find all line information for present and past purchse orders.
I have foudn the following:
PO4_PurchaseOrderReacp - shows me all Purchase order
PO2_PurchaseOrderEntryLine - Only shows current PO's not past ones.
I am wanting to make a simple query that will give me the number of line items per PO... Then will expand on this to do quartley / yearly / also lines received during a period.
First thank you in advance for the help and wanted to say the infomration I have been reading on the posts after find this forum 2 days ago has been very interesting... ALready asking to purchase the VI and BOI parts for future work that I want to do from what I have been seeing.
Also it seems that the classes offered are pretty good so I am starting to look for some - feedback appreacited on any good ones or the best to start with.
Thank you,
John