Microsoft Dynamics AX (Archived)

the best table to get invoices

(0) Share

Report

Posted on by agus

1,174

hi expert,

what is the best table to me to get all invoice vendor or customer ?

currently i get custinvoicejour & vendinvoicejour, but not invoice capture in there.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Agus,

Tables that you mentioned are correct. Corresponding details are in CustInvoiceTrans and VendInvoiceTrans. If you can't find something here, search in CustTrans / VendTrans.

If you can let us know what's missing, we may be able to add something to my response. Without knowing what's missing, won't be able to help further.

Thanks,

Satish Panwar

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

hi satish,

so i must combine CustTrans / VendTrans & custinvoicejour/vendinvoicejour ?

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Everything should be there in CustInvoiceJour. As you mentioned that something is missing, so I advised to check CustTrans. Reason is...all transactions type finally lands in CustTrans.

What I asked above is what's missing from CustInvoiceJour table?

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

if i take example data, all of transtype = project, not in custinvoicejour table. why ?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good Morning Agus,

Is the main problem identifying the vendor / customer invoice data or the captures that you miss?

When you say captures do you mean document attachments or somethings else?

What do you try to achieve here?

Would be great if you could clarify.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Agus,

Project related invoices are in ProjInvoiceJour table and have corresponding entry in CustTrans which is what you see below. If you take the voucher from custTrans and search in ProjectInvoiceJour.LedgerVoucher field, you will be able to find the relationship. other fields to join are AccountNum and TransDate.

Thanks,

Satish Panwar

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

Hi ludwig & satish,

thanks for response.

i thought i can get all of invoices related to vendor/customer without using several tables. can be represented in one table, i was hoping like that. :)

in case using several table, i need further analyze my design first.

anyway thanks for your input.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

Hi Agus,

I would suggest that you start from CustTrans and then get all associated invoices from different tables. if you are just looking for invoice, transaction date, amount etc, how much is remaining, all these can be retrieved from CustTrans table itself.

Thanks,

Satish Panwar

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

ok satish, great

Was this reply helpful? Yes No