Dear @Amit Kamdar Sir and Admin, I need information / Help, When we buy some of the products in a Mall, then we get a bill of POS, in it written in the bill end part says that you have saved ₹ 250/- on MRP like this, so now is it possible like this in customized invoice tdl , how to get this ??
When we give a discount to the customer like ₹ 2 on MRP, then this print in this format like you have to save ₹ 2 on MRP, so how to get this sir if xyz product MRP is ₹ 32 /- and we give a discount to the customer like ₹ 2 then the total of all products discount value print in this format like you have to save ₹ XYZ on MRP, how ??
Make a new Line/Field at position you want...... then in Field... Set As : "You have to save " + $DiscountAmt + "on MRP"
@Amit Kamdar sir see this image no. 1 and 2 and 3 image no. 1 discount is % basis [ by default tally ] image no. 2 discount is Amount Basis [ i have developed amount base discount tdl ] in this image 1 tally by default discount is % basis, so I want in amount wise, so now I have developed a tdl and it perfectly works in amount basis see image no. 2, now this column print in my customized invoice tdl but as per your solution sir, I have added this in line but not getting the result, I have added like this, but not getting the result, showing the only like this You have to save on MRP see this invoice screenshot [Line: KA Note] Field: Simple Prompt,Simple Field Local: Field: Simple Prompt: Set as: " सूचना : - " Local: Field: Simple Prompt: Style: P9 Local: Field: Simple Field: Set As : "You have to save " + $DiscountAmt + "on MRP" Local: Field: Simple Field: Line: 0 Local: Field: Simple Field: Full Width : Yes Local: Field: Simple Field: Style: P9 Local: Field: Simple Field:Align : Center Space Top: 0.5 Local: Field: Simple Field:Width : 6
Then make a compute in your collection.......... where you calculate........ Qty * Rate minus TotalAmt = Discount Amount.
ok, @Amit Kamdar sir, tell me one more thing, see this image again, I want display discount column total, and this discount column total amount display in this format like "You have to save RS. 8 on MRP"
Just like total of 467/- .... same way define total for discount in your part level and in the bottom total line compute the total, and then same total you refer to in the Note-line.
Add a new column for Discounted Amount & Compute their total at the bottom & Show that amount in your Discount Line.
Dear Omkar, Ideally take one additional field in Inventory entry where MRP * Qty is calculated acccumulate the total and compare it with Invoice Amount if same no saving else difference is saving. It might look something like this .....
@Sanjeev S sir mi hya padhatine ek navin pos bilacha format tayar kela aahe , khali screenshot dila aahe , pan ek problem yet aahe , roundoff chi amount print madhye yet nahi , krupaya hyavar margdarshan karave . dhanywad [Line: KA ROUND OFF] Field: Simple Prompt,Simple Field Local: Field: Simple Prompt: Set as:"ROUND OFF" Local: Field: Simple Field:set as@RoundAmount Local: Field: Simple Field: Align:Right Local: Field: Simple Prompt: Border:Thin Bottom Right Local: Field: Simple Prompt:Full Width: Yes Local: Field: Simple Field: Space Left : 0.2 inch Local: Field: Simple Field: Border:Full Thin Bottom Local: Field: Simple Field: Full Width: Yes Local: Field: Simple Field: Style: Large Bold Local: Field: Simple Field: Line:0 Local: Field: Simple Field:Set Always : Yes
Dear Omkar, Only issue seems to be in line 3 right syntax is .... Local: Field: Simple Field:set as: $$String@RoundAmount
@Sanjeev S sir mala solution milale , khalilpramane aahe , [Line: KA ROUND OFF] Field: Simple Prompt,Simple Field Local: Field: Simple Prompt: Set as:"ROUND OFF" Local: Field: Simple Prompt: Style:Normal Bold Local: Field: Simple Field:set as:$$COLLAMTTOTAL:INVENTORYENTRIES:$Amount-$Amount Local: Field: Simple Field: Align:Right Local: Field: Simple Prompt: Border:Thin Bottom Right Local: Field: Simple Prompt:Full Width: Yes Local: Field: Simple Field: Space Left : 0.2 inch Local: Field: Simple Field: Border:Full Thin Bottom Local: Field: Simple Field: Full Width: Yes Local: Field: Simple Field: Style: Large Bold Local: Field: Simple Field: Line:0 Local: Field: Simple Field:Set Always : Yes pan ek problem aahe , roundoff amount barobar aahe , pan tyacha symbol barobar yet nahi jya thikani roundoff minus pahije tyathikani minus cha symbol pahije aani jya thikani roundoff plus kele aahe tya thikani plus che symbol yayala pahije , please solve this problem. example : - khali mi screenshot dila aahe , tyamadhe mi demo sathi kande sale kele aahet , tyachi kimmat hi Rs.15.69/- aahe tar mag mi roundoff plust karun customer kadun Rs.16/- ghetali aahe , mag khali roundoff chya column madhye plus roundoff che symbol yayala pahije , je ki screenshot madhye tumhi baghat aahat minus che symbol aale aahe , je ki chukiche aahe.