Dear experts, i want to add one field in pending bills table currently summplier bill no , bill date, bill amount is showing in table i want to add my that pending purchase voucher number after supplier ref no. so that easily one can pickup pending bill from file and attach with payment advice. i tried very much but at voucher level i failed to do this. for eg. i feed vch no 005, supplier bill no 12345 dt 12.10.13 rs. 15000 now in payment voucher it shows me only pending bill no 12345 dt 12.10.13 rs. 15000 i want to see pur_vch no 005, bill no 12345 date 12.10.13 amount 15000 is it possible? in coding i am not getting codes of that pending bills table. where is the code of this tables? regards mithari 9325509009
[#Collection: BankPymtAdvice BillDetailsLess] Source Collection: Default Fetch: Date Walk: All Ledger Entries, Bill Allocations Compute: BillName: $$Owner:$$Owner@BankingVchFirstPartyLedger;If $$Owner:$$Owner@BankingVchFirstPartyLedger = $$Owner:$LedgerName Then If $$IsEmpty:$Name Then "321" Else "987" Else "123";If $$Owner:$$Owner@BankingVchFirstPartyLedger = $$Owner:$LedgerName Then If $$IsEmpty:$Name Then "On Account" Else $Name Else "" Compute: BillAmount: If $$Owner:$$Owner@BankingVchFirstPartyLedger = $$Owner:$LedgerName Then $Amount Else "" Compute : BillDate : If $$Owner:$$Owner@BankingVchFirstPartyLedger = $$Owner:$LedgerName Then $BillDate Else "" Compute : BillDueDate : If $$Owner:$$Owner@BankingVchFirstPartyLedger = $$Owner:$LedgerName Then $BillCreditPeriod Else "" Compute: IsBillAlloc: Yes Compute: VchNo: $$Owner:$$Owner@BankingVchFirstPartyLedger;$$Owner:$$Owner:$VoucherNumber;If $$Owner:$$Owner@BankingVchFirstPartyLedger = $$Owner:$LedgerName Then "10" Else "9"; Filter: IsEmptyBillName Client Only: Yes ;;24378060 ;633934 [#Line: BankPymtAdvice BillDetails Title] Use: BankPymtAdvice BillDetails Local: Field: Default: Type: String Local: Field: Default: Style: Normal Bold Local: Field: Default: Align: Centre Local: Field: BankPymtAdvice BillDetails Name: Set as: $$LocaleString:"Bill Ref." Local: Field: BankPymtAdvice BillDetails Date: Set as: $$LocaleString:"Bill Date" Local: Field: BankPymtAdvice BillDetails VchNo: Set as: $$LocaleString:"Voucher Number" Local: Field: BankPymtAdvice BillDetails DueDate: Set as: $$LocaleString:"Due Date" Local: Field: BankPymtAdvice BillDetails Amount: Set as: $$LocaleString:"Amount" Border: Thin Top Bottom [#Line: BankPymtAdvice BillDetails] Field: BankPymtAdvice BillDetails Name, BankPymtAdvice BillDetails Date,BankPymtAdvice BillDetails VchNo, BankPymtAdvice BillDetails DueDate Right Field: BankPymtAdvice BillDetails Amount;, BankPymtAdviceAmtInv Local: Field: Default: Style: Normal Local: Field: BankPymtAdvice BillDetails DueDate: Invisible: NOT ##BankPymtAdvicePrintDueDate Local: Field: BankPymtAdvice BillDetails Date: Cells: If ##BankPymtAdvicePrintDueDate Then 1 Else 2 [Field : BankPymtAdvice BillDetails VchNo] Use: Name Field Set as: $VchNo;VoucherNumber;Vouchertypename Border: Thin Box