Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
rockwellmed
Posts: 42
Registered: 11-23-2009
0
Accepted Solution

Purchase Order reference number cross referencing

Looking to find out how I can take the PO reference number and trace it back to the receipt number then back to the original PO number?

When I drill down in inventory inquiry on an item, it takes me as far as the PO but only shows me the reference number. When I try to drill down to see the actual PO it will not pull it up.

 

Regular Contributor
dlevasseur
Posts: 182
Registered: 11-13-2008
0

Re: Purchase Order reference number cross referencing

What version of MAS?

 

Also, how long is your PO retention set for?  Once a PO is beyond that retention date it disappears forever (a big flaw I've had with MAS since day1)...

 

Right now in 4.4 in Item Inquiry->Transactions->Double click a PO Transaction, this will bring you to the receipt.  Then from there the PO number is in the top left corner.  You would then do a PO Inquiry.  Now again, if that PO is closed and beyond retention, it's gone forever.

-Dan
jcl
Sage MAS Partner
jcl
Posts: 48
Registered: 06-01-2009
0

Re: Purchase Order reference number cross referencing

You can also go to the Purchase Order/Inquiries menu and select Receipt History Inqiury.  At the PO Number field, do a lookup and pick the Receipt No field as your search field.  Then enter that reference number and search that way.  It should find the transaction containing that receipt number and you can see in the lookup, and/or pull up the record to see the PO Number it was tied to. 

 

This will work without regard to whether or not the PO has been purged from the Open PO files.  All PO's that have been received, provided you are keeping PO Receipt History, will have records in this file.  You won't be able to see the PO as it was created, but you can see all receipts done against it. 

 

If the reference number you pull up is related to a Receipt of Invoice, then this won't give you what you need.  It drives me, and everyone else who has ever done research in the PO module, absolutely crazy, but Sage chose to not include any of the line information for PO Receipt of Invoice transactions in the PO Invoice transaction history!.  You have to go to the AP module to lookup the inventory/PO line item information from the receipt.  I would think that at a minimum, it would be in both history files since it's very relevant in both places.  But if you had to leave it out of one of them, wouldn't you leave the inventory/PO detail information in the PO module???  Just one more step (and there are many) you have to follow each time you need to research a PO.