Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Linking Purchase Order...

Linking Purchase Orders to Receipt numbers

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am new to using GP and struggling to pull out the information I require. I have the task of trying to update the capex list but to do it manually (run a Smartlist on the Capex GL account and then go into 'Purchase Order Processing Document Enquiry' search the receipt number and then take the PO information and add it to my capex list) is taking me forever.

There must be a easier way right? I have been trying to link tables all day to create a Smartlist without much luck. I can't seem to work out a way to link PO's to Receipts. I was thinking if I could link those two I could at least have a pivot working of the data to bring the PO line items for the each Receipt.

To be honest I haven't had any training so struggling to work out where to start on the running and creating Smartlists. So if anyone could recommend a book or a good internet guide for beginners it would be appreciated.

Thanks,

Dean

*This post is locked for comments

All responses (3)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Linking Purchase Orders to Receipt numbers

Thanks for the suggestions Leslie & Mahmoud. I plan to spend some time tomorrow looking at this.

I will let you know how I get on.

Thanks,

Dean
Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

RE: Linking Purchase Orders to Receipt numbers

I have previously developed a report for purchase order and associated receiving and invoices details.

Let us know if you need any further assistance,
Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: Linking Purchase Orders to Receipt numbers

Hi,

Both the PO Number and the Receipt number are in the POP30310 table for history and the POP10310 for POs that are not in history.

Kind regards,

Leslie