How to Fetch total invoice value,taxable value,cgst amt,sgstamt,igstamt

Remove if:$PartyLedgername="Gst Payable" ;in line level

 

What u want please clarify in details.
Are you want to remove those vouchers which have class entry or remove those which have not class entry?

 

Sattam Sir,
I want to remove those vouchers which have class entry.

 

Try This

Code:

[System: Formulae]
myfilter:$$IsEmpty:$ClassName

 

Sattamji,
That already suggested by Amit Sir did not work. U also suggested function did not help. I posted my collection also in that this formula is there. If u can modify.
Thanks

 

Dear rony have you tried my recent code?
earlier I suggest myfilter: $$IsEmpty:##SVClass
now I suggest
myfilter:$$IsEmpty:$ClassName

Both are not same

 

Dear Experts,
I am very much thankful to all specially Amitsir and Sattamji. Both function works, but for Amitsir surprisingly same TDL makes diff result for diff company, where both company configuration R same .In one company Omit Class entry in other don't. Checking why it react diff. Sattamji works for both. Any way I much thankful and highly appreciate your help Thanks again.THANKS, THANKS

 

Dear Experts,

My Sales Voucher Consist of Both Inventories and Service for Example:
----------------------------------------------------------------------------------
Particulars Qty Rate Amount
-----------------------------------------------------------------------------------
8" Hollow Block (Stock Item) 1000 0.500 500

Transportation Charge (Ledger) 50
-----------------------------------------------------------------------------------
Total 550
-----------------------------------------------------------------------------------

I was trying to call the inventories and ledger details: I mean, I need the StockItemName for the inventories and the LedgerName for the Accounting Entreies in the Same field. Is there any way to construct like that?

At present my coding is as below: The inventory details are coming correctly, but no details of Income ledger involved in the sales. Can any one help me?

Line vTfmt DebitDetlsLne

Repeat : PvTfmt DebitDetlsLne : My Repeat Coll
[Field : PvTfmt ParticularFld]

Use : Name Field
Set as : $valStockItemName
Set Always : Yes
FullWidth : Yes
Style : Small

[Collection : My Src Coll]
Type : Vouchers : Voucher Type
Child of : $$VchTypeSales
belongs to : yes

[Collection : My Repeat Coll]
Source Collection : My Src Coll
Filter: LedFil
Walk : Inventory Entries
By : ValMasterID: $MasterID
By : valStockItemName : $StockItemName

Aggr Compute : ValBilledQty : Sum : $BilledQty
AggrCompute : ValAmount : Sum : $Amount

Fetch: date,VoucherNumber,PartyLedgerName


[System: Formulas]
LedFil: $PartyLedgerName = ##LedgerName

 

Yes. I am getting the inventories details correctly. But the Income Ledger is not coming in the UDF

 

Use : Name Field
Set as : $valStockItemName
Set Always : Yes
FullWidth : Yes
Style : Small

Is it correct? I think it can only fetch the inventory item name (Stcok Item Name). To get the income ledger name and value I think I have to refer something else

 

Thank You Sir,

 

Create a Collection Which Will Hold Income Ledger Name

Walk Through The Function and Set your required value in variable and return the same variable in field

Example:

[Field: MyField]
Set as $$MyNewFunc

[Function: MyNewFunc]
Variable: AllStockItemString: String
000: Walk Collection: Inventory Entries
010: Set: AllStockItemString:##AllStockItemString +$$String:$StockItemName
020: End walk
030: Return: ##AllStockItemString

 

Amit Sir....I think We can achieve this By Using the above method which I post.... Please check if It is wrong..

 

Sir,

I have applied this given function, but now the fields are showing blank.

 

Sir That is a example Not Solution Plus Please post your applied code So, I can check the mistake in that

 

[Collection : RCP Main Coll]

Type : Vouchers : Ledger
Child Of : #LedgerName

[Function: RCPVoucherwalkFunc]
Variable: AllStockItemString: String
000: Walk Collection: RCP Main Coll
010: Set: AllStockItemString:##AllStockItemString +$$String:$StockItemName
020: End walk
030: Return: ##AllStockItemString

[Field : RCP ParticularFld]

Use : Name Field
Set as : $$RCPVoucherwalkFunc
Set Always : Yes
FullWidth : Yes
Style : Small

Sir, Now I have modified that code like above. Asif now the stock names are coming, but the Inocme Ledgers are not coming.

My purpose is to make a customer statement as attached:

 

This "tdlexpert.com" is really helpful sir. Thank you so much for promoting this kind of free education. Really appreciate the people behind this. If you don,t mind, I would like give a small donation for the purpose this free education.

 

Sir You want to Create a String of Income Ledgers then Create a Collection of Income Ledger and walk Through the Collection And Create that String

[Collection:SunDebColl]
Type: Ledgers
Child of:"Sundry Debtors"
Belong To: Yes


[Field: MyField]
Set as $$MyNewFunc

[Function: MyNewFunc]
Variable: AllLedgerString: String
000: Walk Collection: SunDebColl
010: Set: AllLedgerString: ##AllLedgerString + $$String:$Name
020: End walk
030: Return: ##AllLedgerString

 

This is again a Example So, Please Modify it According and Try to understand the Function