Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table containing PO line information - CD @ work

Status
Not open for further replies.

hvns

Technical User
Oct 2, 2007
25
US
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
 
Well after a while of lookign around I have found it.

POM_RecptHistoryLine

I would still appreciate the feedback on classes...
 
If you are going to do the BOI then you should start with the Data Files classes and then the BOI classes and then VI.
 
Note that the Business Objects Interface is only available for the Framework modules. PO is not a framework module yet. (Not until 2009 at least.)

Dawn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top