Nug Column need without decimal 00 and show total of nug under with total quantity, and also calculated nug show in party ledger. How much nugs recived this party show in party ledger report. please help me. thanks [#LINE: EI COLUMNONE] OPTION : KC EI COLUMNONE : @@ISSALES [!LINE : KC EI COLUMNONE] ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS LOCAL : FIELD : KC MTS : INFO : "Nug" [#LINE: EXPINV COLUMN1] OPTION : KC EXPINV COLUMN1 : @@ISSALES [!LINE : KC EXPINV COLUMN1] ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS LOCAL : FIELD : KC MTS : INFO : "Nug" LOCAL : FIELD : KC MTS : DELETE: STORAGE LOCAL : FIELD : KC MTS : TYPE : STRING [#LINE : EI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [!LINE : KC EI INVINFO] ADD: RIGHT FIELDS: Before : VCH Value : KC MTS [FIELD : KC MTS] USE : Amount FIELD ;; TYPE : NUMBER STORAGE : KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [#LINE: EXPINV INVDETAILS] OPTION : KC EXPINV INVDETAILS : @@ISSALES [!LINE : KC EXPINV INVDETAILS] ADD : LEFT FIELDS : AFTER : EXPINV DESC : KC MTSPRINT [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [SYSTEM : UDF] KC MTS : Amount : 505 [SYSTEM : FORMULA] TRSFormula : ( $KCMTS ) IsSales0 : $$IsSales:##SVVoucherType
Dear Sir Amit, you mean add this line in code file or other else. and please also guide me about nug total
Dear Manuz, Please tell me the write location or row , where I put this code. thanks / I tried but not get correct answer
need to add format in the field level as mentioned below: [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black Format : " NoDecimal"
Thanks Damodaran Sir for reply. Please see the attached file. One more thing how get the total of Nug left side of total amount
Thank you very much Arun Prasath Sir. Please give me one more favor . I attached file. Total of Nug also show in parties ledger. Advance Thanks
Please try this...... Code: [#LINE: EI COLUMNONE] OPTION : KC EI COLUMNONE : @@ISSALES [!LINE : KC EI COLUMNONE] ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS Title LOCAL : FIELD : KC MTS Title : INFO : "Nug" [#LINE: EXPINV COLUMN1] OPTION : KC EXPINV COLUMN1 : @@ISSALES [!LINE : KC EXPINV COLUMN1] ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS Title [FIELD : KC MTS Title] USE : Name FIELD Set as : "Nug" SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black Skip : Yes [#LINE : EI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [#LINE : CI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [!LINE : KC EI INVINFO] ADD: RIGHT FIELDS: Before : VCH Value : KC MTS [FIELD : KC MTS] USE : Number FIELD STORAGE : KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [#Part: EI InvInfo] Add : Total : KCMTS [#LINE: EXPINV INVDETAILS] OPTION : KC EXPINV INVDETAILS : @@ISSALES [!LINE : KC EXPINV INVDETAILS] ADD : LEFT FIELDS : AFTER : EXPINV DESC : KC MTSPRINT [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [SYSTEM : UDF] KC MTS : Number : 505 [SYSTEM : FORMULA] TRSFormula : ( $KCMTS ) IsSales0 : $$IsSales:##SVVoucherType [#Part : VCH Narration] Option : Nug Totals : @@IsSales [!Part : Nug Totals] Add : Line : At Beginning : KC MTS Total [Line : KC MTS Total] Field : Medium Prompt, EI Nug Total Local : Field : Medium Prompt : Info : "Total Nugs" [Field : EI Nug Total] Use : Number Field Set as : $$Total:KCMTS Set Always : Yes Width : @@NumberWidth
Sir Sanjeev S, Is it possible to take print out with same information in print mode ? Last request ( how to get total's of nug in party ledger report )
[#LINE: EI COLUMNONE] OPTION : KC EI COLUMNONE : @@ISSALES [!LINE : KC EI COLUMNONE] ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS Title LOCAL : FIELD : KC MTS Title : INFO : "Nug" [#LINE: EXPINV COLUMN1] OPTION : KC EXPINV COLUMN1 : @@ISSALES [!LINE : KC EXPINV COLUMN1] ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS Title [FIELD : KC MTS Title] USE : Name FIELD Set as : "Nug" SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black Skip : Yes [#LINE : EI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [#LINE : CI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [!LINE : KC EI INVINFO] ADD: RIGHT FIELDS: Before : VCH Value : KC MTS [FIELD : KC MTS] USE : Number FIELD STORAGE : KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [#Part: EI InvInfo] Add : Total : KCMTS [#LINE: EXPINV INVDETAILS] OPTION : KC EXPINV INVDETAILS : @@ISSALES [!LINE : KC EXPINV INVDETAILS] ADD : LEFT FIELDS : after : EXPINV DESC : KC MTSPRINT [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [SYSTEM : UDF] KC MTS : Number : 505 [SYSTEM : FORMULA] TRSFormula : ( $KCMTS ) IsSales0 : $$IsSales:##SVVoucherType [#Part : VCH Narration] Option : Nug Totals : @@IsSales [!Part : Nug Totals] Add : Line : At Beginning : KC MTS Total [Line : KC MTS Total] Field : Medium Prompt, EI Nug Total Local : Field : Medium Prompt : Info : "Total Nugs" [Field : EI Nug Total] Use : Number Field Set as : $$Total:KCMTS Set Always : Yes Width : @@NumberWidth [#Line: DSP VchAccTitles] Add: Right Field: Before: DSP VchRefTitleFld : DSP KC MTS Title [Field: DSP KC MTS Title] Use: name field Set as: "Nug" Width: 4 Align: Center Border: Thin Left Style: Normal Bold [#Line: DSP VchDetail] Add: Right Field: Before: DSP VchRefNumberFld : DSP KC MTS Total [Field: DSP KC MTS Total] Use: number field Set as: $$Total:KCMTS Width:4 Align: Center Border: Thin Left Style: Normal Bold
Amit Kamdar Sir, Arun Prasath Sir, Sanjeev S Sir, I need your attention. Please guide me for correction of this TDL file. Thanks
Please make some efforts in solving your queries. This is a platform where TDL learning and knowledge is shared. We can help with technicalities..........if there are any hiccups.
[#LINE: EI COLUMNONE] OPTION : KC EI COLUMNONE : @@ISSALES [!LINE : KC EI COLUMNONE] ADD : RIGHT FIELDS : Before : VCH AmtTitle : KC MTS Title LOCAL : FIELD : KC MTS Title : INFO : "Nug" [#LINE: EXPINV COLUMN1] OPTION : KC EXPINV COLUMN1 : @@ISSALES [!LINE : KC EXPINV COLUMN1] ADD : LEFT FIELDS : After: EXPINV DESCTITLE : KC MTS Title [FIELD : KC MTS Title] USE : Name FIELD Set as : "Nug" SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black Skip : Yes [#LINE : EI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [#LINE : CI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [!LINE : KC EI INVINFO] ADD: RIGHT FIELDS: Before : VCH Value : KC MTS [FIELD : KC MTS] USE : Number FIELD STORAGE : KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [#Part: EI InvInfo] Add : Total : KCMTS [#LINE: EXPINV INVDETAILS] OPTION : KC EXPINV INVDETAILS : @@ISSALES [!LINE : KC EXPINV INVDETAILS] ADD : LEFT FIELDS : after : EXPINV DESC : KC MTSPRINT [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 4 ALIGN : CENTER Print Fg :Black [SYSTEM : UDF] KC MTS : Number : 505 [SYSTEM : FORMULA] TRSFormula : ( $KCMTS ) IsSales0 : $$IsSales:##SVVoucherType [#Part : VCH Narration] Option : Nug Totals : @@IsSales [!Part : Nug Totals] Add : Line : At Beginning : KC MTS Total [Line : KC MTS Total] Field : Medium Prompt, EI Nug Total Local : Field : Medium Prompt : Info : "Total Nugs" [Field : EI Nug Total] Use : Number Field Set as : $$Total:KCMTS Set Always : Yes Width : @@NumberWidth Align : Center Color : Black Style : Normal Bold [#Line: DSP VchAccTitles] Add :Right Field :Before SP VchRefTitleFld : DSP KCMTS [Field: DSP KCMTS] Use : Name Field Set as :"Nug" Width :5 Style :Normal Bold Border :Thin left Align :Center [#Line: DSP VchDetail] Add :Right Field :Before SP VchRefNumberFld : DSP EI Nug Total [Field: DSP EI Nug Total] Use : Number Field Set As :$$Total:KCMTS Width :5 Color :Red Style :Normal Border :Thin left Align :Center