I have created a code for display profit column in the voucher , for instant shown us for per bill profit, so the problem is not getting the exact result I want, please correct my code and give me the right solution. what is the calculation formula ;;Reclaculate formula's [System: Formula] CalcedAmt: ($Rate * $BilledQty) - $StandardCost NrmlAmount: ($BilledQty * $Rate) - $StandardCost see this screenshot [System : UDF] TTEPurchaseRate : String : 2011 [#Line : EI ColumnOne] Add : Right Field : Before : VCH QtyTitle : TTEPROFIT [Field :TTEPROFIT] Use : Name Field Width : 16 Align : Center Setas : $$LocaleString:"PROFIT" Style : Normal Bold Set Always : Yes Border: Thin Left Right Skip : Yes ------------------------------------------------ [#Line : EI InvInfo] Add : Right Field : Before : VCHBilledQty : VCHPROFIT [Field : VCHPROFIT] Use : Name Field Align : Center Width : 16 Color : DEEP COBALT BLUE Set as : $StandardCost-$StandardRate Set Always : Yes Skip : Yes in this image i.e. Somnath premium agarbatti standard cost is 10 rs. and the standard selling price is 15, so I want to display profit of the item rs. 5 in this profit column, so how to get each of the items profits amount in this column
Use below methods for StandardCost & StandardRate StandardCost --> $StandardCost:StockItem:$StockItemName StandardRate --> $StandardRate:StockItem:$StockItemName
@murarikitan i know this , i think you have not understand my question , i want standard cost - ( Subtraction ) standard Rate difference means profit in my this column , i.e. Standard cost is ₹10/- and standard Selling price is ₹15/- , so difference is ₹5/- means profit ₹5/- displayed in this column.
[Field : VCHPROFIT] Use : Amount Rate Field Align : Center Width : 16 Color : DEEP COBALT BLUE Set As :$Rate-$StandardCost:StockItem:$StockItemName Set Always : Yes Skip : yes
@jaykumartailor sir, As per your solution it's perfectly working on sales voucher, thank you so much, perfectly working, but I want also a total of this column, please sir. SEE THIS SCREENSHOT
@JaykumarTailor sir please check this code for a total of this column, but not getting total, please give me the correct formula Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : TTE Total [Field: TTE Total] Use : TTE VCH PROFIT Border : Totals Set as : $$String@VCH PROFIT Total Skip : Yes Set always : Yes [System: Formula] TTE Total : $$Number:$VCHPROFIT VCHPROFITTotal : $$CollTTETotal:InventoryEntries@VCHPROFIT
Mr. Onkar This One Is Old Code Need Only For Change Set As. You Are Not Trying A Little Bit. No One Can Feed You For A Longer Time [#Line: EI ColumnOne] Option : TTE EI ColumnOne : @@IsSales [!Line: TTE EI ColumnOne] Add : Right Fields : At Beginning : TTE VCH NumPack Local : Field : Default : Align : Center Local : Field : TTE VCH NumPack : Info : "PROFIT" [#Line: EI InvDetails] Option : TTE EI InvDetails : @@IsSales [#Line: CI InvDetails] Option : TTE CI InvDetails : @@IsSales [#Line: EI InvInfo] Option : TTE EI InvInfo : @@IsSales [#Line: CI InvInfo] Option : TTE EI InvInfo : @@IsSales [!Line: TTE EI InvInfo] Add : Right Fields : At Beginning : TTE VCH NumPack Local : Field : TTE VCH NumPack : Storage : BasicNumPackages [Field: TTE VCH NumPack] Use : Name Field Align : Center Width : 16 Border : Thin Left Right Color : DEEP COBALT BLUE Set As :$Rate-$StandardCost:StockItem:$StockItemName ;;Set as :$StandardCost:StockItem:$StockItemName Set Always : Yes Skip : Yes Invisible : NOT ##VrVarC1 Skip on : $$IsEnd:$StockItemName ;; Inactive : $$IsEnd:$StockItemName [#Form: Export Invoice] Option : TTE Export Invoice NP : @@IsSales [!Form : TTE Export Invoice NP] Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : TTE Total NumPack [Field: TTE Total NumPack] Use : TTE VCH NumPack Border : Totals Set as : $$String@NumNumPackTotal Skip : Yes Set always : Yes [System: Formula] NumNumPack : $$Number:$BasicNumPackages NumNumPackTotal : $$CollNumTotal:InventoryEntries@NumNumPack
I know sir, but amit sir told me that this formula is not perfect for this code, its wrong calculation, so I want.
@jaykumartailor sir, thank you so much as per your solution, it's perfectly working on sales voucher, but Amit sir's calculation/solution this formula wrong as you know of my old post, so what ?? SEE THIS SCREENSHOT
Dear Onkar, Am a bit disappointed by your progress...... copy paste is okay...but one must learn from it also. Am expecting lot more from you. You try to make your code in a hurry...hurry....hurry......... slow down a bit...understand the code and then implement as per your needs. By this time I was expecting your knowledge and skills to grow a bit more..... still am glad you are learning and making progress and really doing things. But now onwards do things with a bit more understanding. Take your time and apply logic to problems. Experts are here always to help serious learners and coders. Keep it up.
@ASHOK sir, code is already on the forum, please scroll and see my first thread , then you will get this code