Dear Sir, I am not getting PO Number in Purchase Register and I am getting only Purchase voucher type I have created Purchase excise voucher type which I am not getting. [#Menu:Gatewayoftally] Add:Itemurchase Registerisplay:Vikram_Voucher Register [Report:Vikram_Voucher Register] Use:Voucher Register Set : VoucherTypeName : $$VchTypePurchase Set : ColumnarDayBook : Yes [#Line : DSP ColVchTitle] Add : Fields : Before : DSPVCHNumber : OrderVchType Local : Field : Default : Style : Small Italic Local : Field : Order Number : Set As : "PO No" [#Line : DSP ColVchDetail] Add : Field : Before : DSPVCHNumber: OrderVchnumber [Field : Order Number] Use : Name Field SetAs : $OrderVchnumber Width : 10% Page Border : Thin Left Style : Small [#Collection: Columnar Vouchers of Ledgers] Fetch : OrderVchnumber
Dr Mr. Vikram the rectification is as follows :- [#Menu:Gatewayoftally] Add:Itemurchase Registerisplay:Vikram_Voucher Register [Report:Vikram_Voucher Register] Use:Voucher Register Set : VoucherTypeName : $$VchTypePurchase Set : ColumnarDayBook : Yes [#Line : DSP ColVchTitle] Add : Fields : After : DBC VchNo : Order Number Local : Field : Default : Style : Small Italic Local : Field : Order Number : Set As : "PO No" [#Line : DSP ColVchDetail] Add : Fields : After : DBC VchNo : Order Number [#Line : DSP ColVchTotal] Add : Fields : After : DBC VchNo : Order Number Local : Field : Order Number : Set As : "PO No" [Field : Order Number] Use : Name Field Set As : $Reference Width : 10% Page Border : Thin Left Style : Small [#Collection: Columnar Vouchers of Ledgers] Fetch : Reference, VoucherNumber [#Collection : Columnar Filtered Vouchers of Company] Fetch : Reference, VoucherNumber [#Collection: Columnar Vouchers of Ledgers] Fetch : Reference, VoucherNumber [#Collection: Columnar Daybook Vouchers of Company] Fetch : Reference, VoucherNumber [#Collection: Ledger Vouchers Coll] Fetch : Reference, VoucherNumber [#Collection: Daybook Vouchers of Company] Fetch : Reference, VoucherNumber
And if you want Purchase Voucher Type by default then add below code in the above tdl :- [#Field: COLREGWithVchType] Set As : "Yes"
dear vikram, please see my code attached it shows po no, po date, grn no, grn dt, account head where the inv cost is debited it works okey but only two errors are there 1- the account head ( either common ledger set yes or no) takes from grn, if user updates it in pur vch entry then updated ledger not showing 2- if voucher feed as voucher and not as invoice then last ledger is taking if possible help to correct this and your requirment is already fulfilled in this code. regards mithari 9325509009