I have created TDL for Salesman field in invoice but it comes in 2 lines. I want in single line like : Salesman Name : ------ Comm% : -------- Amount : ------ and it has been credit in concern salesman account directly from invoice Please Help and guide. My code ;---------------add salesman details in invoice-------------; [#Part: EI BaseInfo] Option: EI Salesman1: $$IsSales:##SVVoucherType [!Part: EI Salesman1] Add: Line: EI lnSalesman1 , EI Comm1 [Line: EI lnSalesman1] Fields: Short Prompt,fldSalesman1 Local: Field: Short Prompt: Info: 'Salesman Name' Local : Field : fldSalesman1 : Preprinted: Yes [Line : EI Comm1] Add: Field: EI Comm1 Add: Field: EI Comm2 [Field : EI Comm1] Use : Short Prompt Info:"Comm %" Width :10 Preprinted: Yes [Field: fldSalesman1] Use: Short Name Field Storage: EI SalesmanName Width: 20 Table: MySalesmanCollection,endoflist ShowTable: Always [Field: EI Comm2] Use: Name Field Storage: EI commission1 Width: 10 Table: MycommCollection, endoflist ShowTable: Always [System: UDF] EI SalesmanName1: String: 1100 [System: UDF] EI commission1 : string: 1200 ;----------End salesman name-------
chaNge code line this: [#Part: EI BaseInfo] Option: EI Salesman1: $$IsSales:##SVVoucherType [!Part: EI Salesman1] Add: Line: EI lnSalesman1 [Line: EI lnSalesman1] Fields: Short Prompt,fldSalesman1 Field: EI Comm1,EI Comm2 Local: Field: Short Prompt: Info: 'Salesman Name' Local : Field : fldSalesman1 : Preprinted: Yes
Thank U Very very much. But how to credit same comm directly from invoice. Please Help. I have created 'salesman' group as indirect exp and the salesman account under the same group but invoice ledger entry for comm is not coming.
Dear Sir , I am adding Old balance and current bill in invoice and code are given below but in that 1 ) old balance amount is coming but colour in dr amount red and in cr amount green is not changing even though i insert condition . 2) In currunt invoice field g. total amount is not coming, I tried $$amount but that is net amount and not the g. total . Pl help in this problem Regards. [Field : Name Field1] Use : ShortPrompt Set As : "OLD BALANCE" PrePrinted : Yes Width : 25% Page Style : Normal Print FG : Blue Colour : Blue [Field : Name] Use : Amount Forex Field set as : $ClosingBalance:Ledger:$PartyLedgerName - $Amount Preprinted : Yes Width : 15% Page Style : NormalBold Print FG : Red Colour : IF $ClosingBalance Dr then Red else Green Format : "Symbol,DrCr" [Line: Billamt] Fields:Billamt1 Spce Top : 0.50 [Field: Billamt1] Field : Short Prompt, Amount Field Local : Field : Short Prompt : Info :$$LocaleString:"BILL AMOUNT" Local : Field : Short Prompt : Width : 21.5 Local : Field : Amount Field : Set as : #EXRPNVINVTotal Local : Field : Amount Field : Format : "Symbol,DrCr"