Need Help in Adjusting rceipts against Invoices in FIFO basis

I am very much beginner in TDL

I want in below format


I tried creating Different collection for receipts and sales but unable to repeat in single report
So used main collection which includes all vouchers output is

 

Basically you need to first make the Collection for all Debit entries and then knock it off with credit entries on FIFO basis
we had done the same for those customers who had not done bill wise

do not advertise. You can conduct your business elsewhere after sharing your contact details. But no direct.......thanks. -- ADMIN

 

Sorry there was no intention for advertisement.. no any intention to sell anything on this forum...
it was that this module can be done...
As there was not option to attached tcp so i had to give the Google drive option
anyway you can check there is no business done here.

 

100% right amit... and even if he wants i will not sell but wanted to give him the idea with the above logic i mentioned .. it can be done and the readiness to check the output
its ok i understand and appreciate all developer efforts...and yes no hard feelings. Its all in to learn

 

I am not adjusting against bills (Bill allocations)
I am adjusting receipts with sales invoices irrespective of BillAlloc
I tried
2 separate Collections for Receipts and sales
and tried repeating over parts but First part is overriding the second one

Code:

[Collection : ISPL_VChcollection]   
    Type        : Vouchers     : Ledger
    Child of    : ##LedgerName
    Fetch        : Date, VoucherNumber, VoucherTypeName, Narration
   
    Compute        : LedgerName    :    $LedgerName
   
   
[Collection : ISPL_SalesVChcollection]
    Use        : ISPL_VChcollection
    Add: Filter    : ISPL_Sales_filter
   
[Collection : ISPL_ReceiptVChcollection]
    Use        : ISPL_VChcollection
    Add: Filter    : ISPL_Receipt_filter
    ;Compute        : Amount        :    $$FilterAmtTotal:AllLedgerEntries:MIFiltIntLedger:$Amount

[System    : Formulae]
    ISPL_Sales_filter :    $VoucherTypeName ="Sales"
    ISPL_Receipt_filter :    $VoucherTypeName ="Receipt Bank"

 

Yeah I want in the same way
any pointing's how to achieve this?

 

(A) 1.Create the Ledger collection with the filter as Ledger having the Bill wise enable
Use the default collection “Ledger Outstandings”

(B) 1. Create the function and make walk collection with the above said collection
2. Create the collection as Ledger vouchers using the parameter from the above said collection (1) and make the walk collection . Like below

For Example :

[Collection: Vouchers of Ledger]

Type : Vouchers : Ledger

Child Of : ##pLedgerName


(C) 1. Inside the walk collection (3) make as New Object : Voucher : MasterId
2. Then need to use Walk Collection : Ledger Entries
3. Compare the Ledger Name in the Ledger Entries is equal to the selected Ledger in the collection (1).
If : $LedgerName = ##pLedgerName

(D) 1. If the above condition is satisfied then if $$NumItems:BillAllocations > 0 then need to delete the existing billallocations and need to make the “Insert Collection Object : Bill Allocations”


(E) 1. Then make the voucher Type condition as $$IsPayment:##VoucherTypeName then update the bill allocations using the Set Value . The above said approach can do through User Defined Function.

 

ok just to give an idea how you can achieve it
as mentioned in my earlier post
A) first Create the list of All debit entries
B) then create the list of credit entries
C) Select 1st debit entry lets say amount is 10000.00 make a function and knock it off till the amount is zero with credit amount then take second amont and so on till the credit amount is not cleared the balance of debit is pending amount

if you dont understand the above logic got o EXCEL and do the same exercise you should get the answer



D)

 

pls send tdl on shaikhkd9@gmail.com