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

All responses (9)

Answers (2)

Don01 40 on at

Like (0)

Report

RE: Vendor Expense

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
Verified answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Expense

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

Hope this helps as well.

Thanks.

ZHU
Don01 40 on at

Like (0)

Report

RE: Vendor Expense

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
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (1)

Report

RE: Vendor Expense

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
Don01 40 on at

Like (0)

Report

RE: Vendor Expense

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?
Don01 40 on at

Like (0)

Report

RE: Vendor Expense

Daniele,

Thanks so much! Yes, that would work!
Verified answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: Vendor Expense

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
Don01 40 on at

Like (0)

Report

RE: Vendor Expense

Thanks Inge!

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

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Vendor Expense

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.