Microsoft Dynamics AX (Archived)

the best table to get invoices

(0) Share

Report

Posted on by agus

1,162

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

All responses (9)

Answers (1)

agus 1,162 on at

Like (0)

Report

RE: the best table to get invoices

ok satish, great
Suggested answer

Satish Panwar 14,645 on at

Like (1)

Report

RE: the best table to get invoices

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
agus 1,162 on at

Like (0)

Report

RE: the best table to get invoices

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

Satish Panwar 14,645 on at

Like (0)

Report

RE: the best table to get invoices

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.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: the best table to get invoices

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
agus 1,162 on at

Like (0)

Report

RE: the best table to get invoices

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

Satish Panwar 14,645 on at

Like (0)

Report

RE: the best table to get invoices

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?
agus 1,162 on at

Like (0)

Report

RE: the best table to get invoices

hi satish,

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

Satish Panwar 14,645 on at

Like (0)

Report

RE: the best table to get invoices

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