can some one say me how to fetch inv supplier invoice no from purchase invoice not working :------------------------------ [#Form : Purchase Color] [#Line: DBTitle1] Fields : DSP VchDateTitle, DSP VchAcctTitle Add:Field:AfterSP VchAcctTitle:BILLCol23 [Field:BILLCol23] Set As : " Supplier Invoice Ref." Color : blue Width : 12 Align : left Style : Normal Bold border : thin right left [#Line: DSP VchDybkDetail] Add: Field :After SP VchAccount:Refnobb [Field:Refnobb] Use :UniDateField Set As : $invreferenceno ;;; $REFERENCE is working but $RefDate1 not working Width : 12 Align:Center Style : Normal
;;TDL ------------------supplier info no [#Form : Purchase Color] [#Line: DBTitle1] Fields : DSP VchDateTitle, DSP VchAcctTitle Add:Field:AfterSP VchAcctTitle:BILLCol23 [Field:BILLCol23] Set As : " Supplier Invoice Ref." Width : 12 Align : center Style : Normal Bold border : thin right left color: green6 [#Line: DSP VchDybkDetail] Add: Field :After SP VchAccount:Refnobb [Field:Refnobb] Use :Name Field Set As : $REFERENCE Width : 15 Align:Center color : blue Style : Normal bold Border: Thin Left right working but reference date not comming
Hi.. If you are referring to purchase bills then use these two methods $PARTYINVNO $PARTYINVDATE They are part of main voucher collection
Hi.. If you are referring to purchase bills then use these two methods $PARTYINVNO $PARTYINVDATE They are part of main voucher collection
Use this code.......... Code: [#Form : Purchase Color] [#Line: DBTitle1] ; Fields : DSP VchDateTitle, DSP VchAcctTitle Add : Field : After : DSP VchAcctTitle : BILLCol20 [Field:BILLCol20] Set As : "Supplier Invoice Reference" Width : 15 Align : center Style : Normal Bold border : thin right left Line : 0 [#Line: DSP VchDybkDetail] Add : Field : After : DSP VchAccount : Refnobb [Field:Refnobb] Use : Name Field Set As : $Reference + " / " + $$String:$ReferenceDate:ShortDate Width : 15 Align : Center color : blue Style : Normal bold Border : Thin Left right [#Collection: NRM Vouchers of Company] Fetch : Reference, ReferenceDate [#Collection : Vouchers of Ledger] Fetch : Reference, ReferenceDate
The Title Line ----DBTitle1 and DSP VchDybkDetail is common for all REGISTERS... hence you will get it in purchase/sales/journal etc....... If you want you can try CONDITION in the fields......try it......