Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged for

(0) Share

Report

Posted on by Flo Griffin

*This post is locked for comments

All responses (6)

Answers (0)

Flo Griffin 65 on at

Like (0)

Report

Re: Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged

Thank you Leslie. It ran perfectly!
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged

The vendor ID is stored as the Originating Master ID in the Financials SmartList. You will need to add this column. The vendor's document number also comes through to the general ledger files.

Kind regards,

leslie
Flo Griffin 65 on at

Like (0)

Report

Re: Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged

I tried going through Financials and Purchasing. What I need to do is link the 2. If you run it in Purcashing, the query returns the account numbers linked to the Vendor Master, not the individual transaction. If you go through Financials, it doesn't give the option of choosing a Vendor. I'm trying to get the Financial information linked to the Purchasing transaction. Thanks.
Dan Liebl 7,320 on at

Like (0)

Report

Re: Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged

You would have to go through the Transaction smartlists. Payables trx and Receiving Trx. If the info is not there, you may have to go throught Account Trx under Financial.

Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
Flo Griffin 65 on at

Like (0)

Report

Re: Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged

I am trying to create the inquiy using the Smart List Application built in to Microsoft Dynamics GP 10.0. Thanks.
L Vail 65,271 on at

Like (0)

Report

Re: Purchasing Smart Link inquiries return the accounts payable and purchasing account numbers that are linked to the vendor master file. I want to run a Purchasing report that will return the actual accounts payable and purchasing account number charged

Do you have SmartList Builder?