Which table contain Vendor id

(0) Share

Report

Posted on by Community Member

Hi,

How to get vendor id anyone give some idea

Thanks.

I have the same question (0)

All responses (8)

Answers (0)

WillWU 22,361 on at

Like (0)

Report

Hi Ashokkumar,

Please check the AccountNum field in the Table VendTable.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Vendor information, including vendor id, is in VendTable table. The field name is AccountNum.

But also many other tables contain vendor id - for example purchase orders (because purchase order is always related to a vendor).

How to get it depends what you are doing. Please tell us more about your situation.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Now, I need to add vendor id field in product receipt report,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Will

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I would assume that Product receipt report already has Vendor id.

But anyway vendor id is in the product receipt table: VendPackingSlipJour.OrderAccount.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi Nikolos,

I try to add orderaccount field in report but couldn't get particular vendorid(i don't know how to get order number) , so i just give some number instead orderaccount for testing purpose,

but showing like this error "

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Have you deployed your report?

By the way, next time post a new question / thread if you want help with a new thing.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

ok thanks

Was this reply helpful? Yes No