Hi,
Can someone help me to find the relation between Link between VendTrans and LedgerJournalTrans table?
I am trying to find the invoice settlement made for a specific journal number in LedgerJournalTable.
Thanks in advance.
Regards,
Selva
Hi,
Can someone help me to find the relation between Link between VendTrans and LedgerJournalTrans table?
I am trying to find the invoice settlement made for a specific journal number in LedgerJournalTable.
Thanks in advance.
Regards,
Selva
Thanks a lot Chaitanya
Hi,
Please try the following code. I am able to get data with it. If its returning null, take a transaction of type Payment in VendTrans and check once if any data is missing.
static void AXC_VendTransVoucher(Args _args) { LedgerJournalTrans ledgerJournalTrans; LedgerJournalTable ledgerJournalTable; VendTrans vendTrans; VendTable vendtable; VendInvoiceJour vendInvoiceJour; while select vendTrans where vendTrans.TransType == LedgerTransType::Payment join vendtable where vendtable.AccountNum == vendTrans.AccountNum //&& vendtable.AccountNum == "V123" // Specify AccountNum here outer join ledgerJournalTrans where vendTrans.Voucher == ledgerJournalTrans.Voucher //&& ledgerJournalTrans.TransactionType == LedgerTransType::Vend join ledgerJournalTable where ledgerJournalTable.JournalNum == ledgerJournalTrans.JournalNum { info(strFmt("Account:%1, TransType: %2, JournalNum: %3, Type: %4", vendtable.AccountNum, vendTrans.TransType, ledgerJournalTable.JournalNum, ledgerJournalTable.JournalType)); } }
Hi,
It is vendor payment transaction
Regards,
Selva
Hi,
Yeah is it vendor Invoice (or) vendor payment transaction.
Hi,
Vendor transaction type
Regards,
Selva
Hi,
Ok. What is the transaction type you are looking for specifically?
Hi Chaitanya ,
Same issue still I am getting JournalNum as empty in vendtrans.
In vendtrans table the JournalNum field is empty for all records.
kindly note that i am trying to do this before posting.
Regards,
Selva
Hi,
Please use following code which is based on voucher.
static void AXC_VendTransVoucher(Args _args) { LedgerJournalTrans ledgerJournalTrans; LedgerJournalTable ledgerJournalTable; VendTrans vendTrans; VendTable vendtable; while select ledgerJournalTable join ledgerJournalTrans //where ledgerJournalTrans.TransactionType == LedgerTransType::Vend && ledgerJournalTable.JournalNum == ledgerJournalTrans.JournalNum join vendTrans where vendTrans.Voucher == ledgerJournalTrans.Voucher // && ledgerJournalTrans.JournalNum == "XYZ" // Specify JournalNum here join vendtable where vendtable.AccountNum == vendTrans.AccountNum //&& vendtable.AccountNum == "V123" // Specify AccountNum here { info(strFmt("Account:%1, JournalNum: %2", vendtable.AccountNum, ledgerJournalTable.JournalNum)); } }
Hi Chaitanya ,
I have tried that..no luck
still I am getting JournalNum as empty in vendtrans.
Regards,
Selva
Hi Sukrut,
Relating VendInvoiceJour from the VendTrans is fine based on your explaination.
but how to relate with LedgerJournaltable ?? since vendtransid = 0 in LedgerJournalTrans
Thanks,
Selva
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,263 Super User 2024 Season 2
Martin Dráb 228,112 Most Valuable Professional
nmaenpaa 101,148