Vendor to ledger reconciliation report logic

Finance and Operations/AX Developer Forum
1

Hi,

I am working 2012 R3 ,Can anybody help to find the logic I mean where exactly the Leger balance and Vendor balance fields got populated in the Tmp table.

I have debugged the class VendLedger_reconciliation but could not find where exactly thos two fields got inserted into Tmp table.

Please suggest

2

Please provide the screenshot of ur fields if possible… For reports u can check ur DP class’s Process report() method…

3

Pleae check it \Classes\VendLedgerReconciliationDP\processReport

4

Here is the answer…

\Classes\VendReport_LedgerReconciliation\insertLedgerTransactions

\Classes\VendReport_LedgerReconciliation\insertVendorTransactions

5

Hi Gopinath,

Thanks for your reply

below is the screen shot.

pastedimage1548312981822v1.png
pastedimage1548312981822v1.png819×460 2.29 KB

Can you please tell where exactly these fields are populating and inserting into Tmp table

6

see the above reply

7

Hi Gopi

When I debugged below two methods

\Classes\VendReport_LedgerReconciliation\insertLedgerTransactions

\Classes\VendReport_LedgerReconciliation\insertVendorTransactions

I am getting null values for ledger balance and vendor balance.

Can please suggest any other way

Thanks

8

see they are inserting records using insert_recordset

9

Please explain your issue ?

10

\Classes\VendReport_LedgerReconciliation\populateVendTrans

11

Hi Gopi,

I want to find code exactly l where Ledger Balance(LedgerAmountMST = XXX) and vendor Balance (vendAmountMST=XXX).

But while I debugging all the above methods LedgerAmoutMST and VendorAmountMST is not showing any value even though the report is showing the balances.

pastedimage1548318165654v1.png
pastedimage1548318165654v1.png983×168 5.04 KB

can you please suggest?

12

You are storing in a temp table… It wont show the values… Before inserting into temp table , just write the same code to display the values and check?

VendorAmountMST balcnce comes from the vendtranstable