dear experts I want little help, see this image, discount amount total not coming in column total, I added this but not getting total of this column, see this image and code Local: Field: KA Discount Amt: Set as:$$CollAmtTotal:InventoryEntries:$Discount
@Amit Kamdar sir I added this Local: Field: KA Discount Amt:Set as:$$Total: KA Discount Amt i also added this - Local: Field: KA Discount Amt:Set as:$$CollAmtTotal:InventoryEntries:$$Total:KA Discount Amt but after loading this tally quit and showing Bad Formula
if it is an attribute of the InventoryEntries(Collection) then use like this: Code: $$CollAmtTotal:InventoryEntries:$KADiscountAmt else you have to add this one to the part where InventoryEntries are repeated Total :KADiscountAmt and in the field where you want to set setas :$$Total:KADiscountAmt
@teja varma Bhai and @Amit Kamdar sir I have added customized discount tdl in tally, in tally default discount is % basis but I want amount wise so I added a tdl, I think the problem comes from this tdl , see this tdl , cash discount [#Line: EI ColumnOne] Add: Option: Disc EI ColumnOne: @@IsSales [!Line: Disc EI ColumnOne] Local: Field: VCH DiscTitle: Set as: "Disc Amt" [#Line: VCHBATCH ColumnOne] Add: Option: Disc EI ColumnName: @@IsSales [!Line: Disc EI ColumnName] Local: Field: VCH DiscTitle: Info: "Disc Amt" [#Field: MPSDiscountTitle] Set as: "Discount Amt" [System: Formula] CalculatedAmt: ($Rate * $BilledQty) - $BatchDiscount NormalAmount: ($BilledQty * $Rate) - $BatchDiscount [#Field: VCH Discount] Delete: Format Add: Format: "Nopercent,NoZero" [#Field: VCHBATCH Discount] Delete: Format Add: Format: "Nopercent,NoZero" [#Field: VCH Value] Resetval: if (@@NoBaseUnits OR $$IsEmpty:BilledQty) then $$Value else (($Rate * $BilledQty) - $Discount)