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!

Accessing Distribution for PO 2

Status
Not open for further replies.

jrobinson6274

IS-IT--Management
Mar 13, 2006
5
US
I'm creating a report that shows the distribution for AP Invoices. I can pull the distribution from APDIST for the invoice but I was asked to aslo include the distribution for the associated PO. Which table show the Invno and PO number? And where can I find the distribution for the PO?

Thanks in advance.
 
POmast XX -> APmastXX (hist APymstXX) Once you Invoice PO.

APdistXX -> Distribution details for APmastxx.

PO details -> POTRANxx


Edgar
Integrated Bar Code Systems, INC.
 
Thank you Edgar,

What is the join for POMAST and APMAST?

THanks
 
In addition is there a table that matchs PO to AP Invoice#'s or are there fields that I can use to create the relationship.
 
There is not a direct link between APDIST/APMAST and POTRAN/POMAST. I mean, there is not a field in APDIST or APMAST that gives you the PO# related.

This is one modification you need to work on, addding the field PURNO in APMAST/APDIST in order to get a complete report easier.

Once you added this field, you need to fill it up when receiving Unbill POs in AP.

Now, I understand that your current situation is you have not this information in apdist, try seeking the PO# in the APMAST file, maybe it was entered by accounting people as a reference in the field APMAST->REF.

If you have not a APMAST->REF field helping you, you will need to get the file ICTRAN involved. ICTRAN has the details about what you are invoicing in AP. This file also stores the vendor# in the field ORGNO and the PO# in the field DOCNO.

So try to do your best to get your report.

My final suggestion is to add the field PURNO in the APMAST and update it when an unbill PO is save.

Hope it helps you.






 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top