Relation between Retail Tables and LedgerJournalTrans

Finance and Operations/AX Technical Forum
1

Hi,

I want to find Ledger Voucher no with respect to Retail transactions. Tables are - RetailTransactionTable, RetailTransactionPaymentTrans, GeneralJournalEntry, GeneralJournalAccountEntry, LedgerJournalTrans, through query.

Please help…

2

I have salesorderid in RetailTransactionTable and find out Ledger voucher no against respective sales order no.

3

Tell me table names exactly…From reatail and ledger

4

Hi Suvarna,

LedgerJournalTrans->CustBankAccount
retailsalestable->Salestable

Both the fiels refers same edt->RefRecId

5

Sales Order no from RetailTransactionTable with status, same record present in RetailTransactionPaymentTrans, GeneralJournalEntry, GeneralJournalAccountEntry, LedgerJournalTrans

6

Hi suvarna,

Try with Invoiceid…

7

Hi,
Invoice in LedgerJournalTrans and InvoiceId in RetailTransaction Table…

8

Ok

9

What type of transactions it is? If it is invoice, you can use invoiceId and get voucher from CustInvoiceJour.

10

Sales Order no present in Retail Transaction table and retail payment transaction table with status = Voided / Posted. Same present in GeneralJournalEntry and GeneralJournalAccountEntry. Same voucher present in LedgerJournalTrans. I want to link all this tables.

11

What you are trying to get, by linking all those table?

12

Hi ,
Refer this link…
irfanaxapta.blogspot.in/2014_01_01_archive.html