Smartlist - Vendor Card Purchases accounts with multiple defaults

(0) Share

Report

Posted on by WCoulby

Our vendor cards may have multiple purchases accounts set to populate as defaults. I can see how to run a smartlist that pulls the first default account, but is there a way to run a smartlist to see all the default purchases accounts?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

kmalone43 894 on at

Like (0)

Report
Copy link

Link copied!

You'll have to build a separate report or do some fancy SQL work to create the fields "Additional Account 1", "Additional Account 2", etc.

The table that you'll want to pull is PM00203.

If it were me, I'd create a separate report called "Vendor Additional Account Detail" & do something along the lines of....

Tables

PM00200 (vendor master)

PM00203 (additional account detail)

GL00105 (account number string)

Select * from pm00200 a inner join pm00203 b on a.vendorid = b.vendorid inner join gl00105 c on b.actindx = c.actindx

Let me know how this goes.

Thanks,

Kyle

Was this reply helpful? Yes No