Microsoft Dynamics AX (Archived)

Get Invoice Reference Number

(0) Share

Report

Posted on by benjamin84

2,075

Dear All,

I need advice,

at Form voucher transaction, for example data : journal number GJT-XXXXX, Voucher IJVXXXX, Ledger Account for cost of material

i want get invoice reference number,

from where table I could get the invoice reference number ?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Benjamin,

Is it a purchase or sales invoice? I assume you need the Invoice number? It can be found in the CustTrans or VendTrans table. For both tables you need to filter on the voucher number and the transaction/posting date to get a unique record.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

You can refere method 'findFromTaxTrans' of vendInvoiceJour table.By using that you will get vendor invoice id.

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

danke andre,

i'll check first.

:)

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

You can check field invoiceId of either table custInvoiceJour(for customer transactions)
(or) table vendInvoiceJour(for vendor transactions) with the help of voucherid and invoice date.

Please use the following job to get the invoice reference number for the given journal number and voucher id

static void InvoiceTrans(Args _args)
{
GeneralJournalEntry generalJournalEntry;
GeneralJournalAccountEntry journalAccountEntry;
SubledgerVoucherGeneralJournalEntry subledgerVoucherGeneralJournalEntry;
CustInvoiceJour custInvoiceJour;
VendInvoiceJour vendInvoiceJour;
DataAreaId company;

company = curext();

// Customer invoice reference number for the given journal number and voucherId
select journalAccountEntry
join generalJournalEntry
where ((generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry)
&& (generalJournalEntry.SubledgerVoucherDataAreaId == company) // Current company
&& (generalJournalEntry.JournalNumber == "Jour1") // Specify journal number here
&& (generalJournalEntry.SubledgerVoucher == "vouc1")) // Specify voucher here
join Voucher, AccountingDate from subledgerVoucherGeneralJournalEntry
where (subledgerVoucherGeneralJournalEntry.GeneralJournalEntry == generalJournalEntry.RecId)
join custInvoiceJour
where custInvoiceJour.InvoiceDate == subledgerVoucherGeneralJournalEntry.AccountingDate
&& custInvoiceJour.LedgerVoucher == subledgerVoucherGeneralJournalEntry.Voucher;
info(strFmt("Customer Invoice reference number %1", custInvoiceJour.InvoiceId));

// Vendor invoice reference number for the given journal number and voucherId
select journalAccountEntry
join generalJournalEntry
where ((generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry)
&& (generalJournalEntry.SubledgerVoucherDataAreaId == company) //Current company
&& (generalJournalEntry.JournalNumber == "Jour2") // Specify journal number here
&& (generalJournalEntry.SubledgerVoucher == "vouch2")) // Specify voucher here
join Voucher, AccountingDate from subledgerVoucherGeneralJournalEntry
where (subledgerVoucherGeneralJournalEntry.GeneralJournalEntry == generalJournalEntry.RecId)
join vendInvoiceJour
where vendInvoiceJour.InvoiceDate == subledgerVoucherGeneralJournalEntry.AccountingDate
&& vendInvoiceJour.LedgerVoucher == subledgerVoucherGeneralJournalEntry.Voucher;
info(strFmt("Vendor Invoice reference number %1", vendInvoiceJour.InvoiceId));
}

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No