Vendor Expense

(0) Share

Report

Posted on by Don01

Hi There,

We are trying to extract vendor expense entries out of nav into our data warehouse, we notice there is Vendor Ledger Entry table, however we don't see any field/column for GL/Ledger Number, as well as cost center.

Is this the right table for vendor expense, do we need other table to look up for GL number, and cost center.

Much appreciate it

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

You will have to look at the G/L Entry table for those kind of data.

The vendor ledger entries does only show accounts payable.

Was this reply helpful? Yes No
Don01 40 on at

Like (0)

Report

Thanks Inge!

but GL entry table doesn't have vendor number, I think, so I cannot get $ spent by vendor.

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,397 on at

Like (0)

Report

hi

in the g/l entry the vendor number can be found in the field

Source type:

if source type = Vendor then in the SOurce No. field you will have your "Vendor no."

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
Don01 40 on at

Like (0)

Report

Daniele,

Thanks so much! Yes, that would work!

Was this reply helpful? Yes No
Don01 40 on at

Like (0)

Report

one more follow up question on this, I notice that both GL entry and Vendor Ledger Entry table have "Document Type", with numeric value such as 0,1,2.3, 5,6), however I cannot find anywhere for its respective values, where does the value get defined, is it in different set up table?

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (1)

Report

hello the numeric values correspond to the options of the Document type.field property as in the image:
,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund,,,,Dishonored

the empty element corresponds to 0, payment corresponds to 1, invoice corresponds to 2 etc etc

DAniele

Was this reply helpful? Yes No
Don01 40 on at

Like (0)

Report

Hi DAniele,

Thank you so much for quick response! So is it like this (see below)? are they the same regardless the company which set up the navs?

0 - Empty

1 - Payment

2 - Invoice

3 - Credit Memo

4 - Finance Charge Memo

5 - Reminder

6 - Refund

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (0)

Report

Hi, This is the practice in BC, which may be easier to understand.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Don01 40 on at

Like (0)

Report

Thanks ZHU!

Very helpful, so this is built into the code, then it applies across the board, no wonder I cannot find anything in the database

Was this reply helpful? Yes No