After a long time am once again back. I am trying to make a tdl for MRP details to be mentioned in Batch for Stock Item. So that while selling the Stock items party can apply the rate as per their percentage of MRP rates. Please help me to resolve my errors in the TDL. File attached herewith..
[Field: TMRP] Use : Rate Price Field Set As : $$CollectionField:$TFMRPRATE:1:BatchAllocations Skip : Yes Storage : TMRP ;;Border : Thin Right
Thank you so much Admin Sir for your instant and co-operative reply. I think i will have to do lots of revision. Please guide me to get the MRP rate to be displayed in batch collection table. Still not getting the result. [#Collection: Batches VchSrc] FETCH : TFMRP, HASMRP, TFMRPRATE, VCHBATCHTFMRP [#Collection: Active Batches VchExtract] SubTitle : $$LocaleString:"Name", @@ExpirySubTitle, $$LocaleString:"MRP", $$LocaleString:"Balance" FETCH : TFMRP, HASMRP, TFMRPRATE, VCHBATCHTFMRP FORMAT : $TFMRPRATE, 4
Do not understand your LOGIC ??? MRP is something you are entering in the BatchAllocations sub-form........... and the Batch selection table comes before that .... so how do you expect to get the "Future" value??
If you want it to appear in the Table, then arrange to enter the MRP in the StockItem's master and not the Voucher level.
I want to allocate it in the Purchase Voucher later it will be helpful in Sales Voucher from that storage. It is just for reference purpose so that at the time of making invoice we can specify the rate as per the schemes of MRP. I had already done at Stock Item master level now i need to add it in Entry Level so that different MRP's of each batch can be seen at the time of sale invoice.
Make a new collection of Purchase Vouchers......... extract the MRP from that..... Filter it.....equal to StockitemName to VchStockItem and same for Batch....... .......then use CollectionField function to display it in Sales voucher only. In purchases it won't show, as data is not yet fed in.
[Field: VCHBATCH TFMRP] Use : Rate Price Field Width : @@VCHRateWidth Style : Small Bold Align : Right Storage : TFMRP Rate Set always : Yes ;; Skip On : $$Line > 1 OR $$IsEmpty:$BilledQty OR (NOT @@DoEditAll AND $$IsValidPriceLevel:$PriceLevel AND @@StdVchFldSkipCond) Option: TFMRP SALE: @@IsSales [!Field: TFMRP SALE] Use : Rate Price Field Width : @@VCHRateWidth Style : Small Bold Align : Right Storage : STFMRP Rate Set always : Yes Set As : $$CollectionField:$StockItemName:$BatchAllocations:$ActiveBatchesVchExtract:$TFMRPRATE Skip : Yes WHAT IF I CAN ADD AN OPTIONAL FIELD FOR SALES VOUCHER ?? PLEASE GUIDE ME..
Judging from you code am not sure what exactly you want ??? You want MRP to be shown in the BATCH Table, then what purpose adding a field will do ?? You have made a MRP Field in purchase voucher .........and input the MRP ......... and now you want the MRP to be shown in TABLE/Collection.... so focus on this. Study --- Field : VCHBatch Name ... in there there are further options.......... the optional field for Purchase and Sales are different ...... Find the appropriate one......... then work on it.
Am working since last three days but not getting the result. I need help.. I completely forgot the "Collection"...
Hmm...hope someone smarter and knowledgeable helps you..... I also do not have much idea in cross collection data retrieval.
Thanks Johar but it shows as Expired... Also i am upgrading my tdl to TallyPrime Version so it does not support in Prime Developer as well. Not Working...
Can anyone help me from this code. It is already made for Purchase Voucher Number in Pending Bills Collection. I want it same for Batch Wise Collection. [#Collection: Pending Bills] Title : $$LocaleString:"Pending Bills" Sub Title : $$LocaleString:"Name", $$LocaleString:"Date", $$LocaleString:"Balance" ,$$LocaleString:"PV No" Source Collection : Pending Bills SRC Fetch : Name, BillDate, BillCreditPeriod, BaseClosing, FinalBalance ,billid,LedgerEntries.*,VoucherNumber,billvchnumber Fetch: Ledger Bills.* Unique : $$Name Format : $$Name, 10 Format : $BillDate, 8 : Universal Date Format : $BaseClosing,-30 : "AllSymbols, DrCr" Client Only : Yes Keep Source : ... ;; Keep the source at Bill allocations subform Level Format : $LedgerEntries.VoucherNumber,10 [#Collection : Pending Bills SRC] Fetch: VoucherNumber,billvchnumber Format : $LedgerEntries.VoucherNumber,10 ;;xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [#Collection: Active Batches VchExtract] SubTitle : $$LocaleString:"Name", @@ExpirySubTitle, $$LocaleString:"Balance", $$LocaleString:"MRP" Fetch : Batch Allocations.* Fetch : Name, Parent, ExpiryPeriod, ClosingBalance, GodownName, MfdOn, ClosingAsOnDate, TFMRPRATE, InventoryEntries.*, LedgerEntries.*, Format : $InventoryEntries.TFMRPRATE, 8 ;;: "Symbol,Forex" [#Collection: Batches VchSrc] FETCH : TFMRPRATE FORMAT : $InventoryEntries.TFMRPRATE, 8 : "Symbol,Forex" ;;xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Everyone, Finally i succeeded in upgrading my tdl to tally prime version with advancements in it. Spent full 4 Days to recover and revise all the codings... Admin Sir i would like to share that i opted for basic method instead of advanced method and it worked literally great. Thanks..
I am struggling on similar requirement. [System: UDF] BatchMRP : Number:11008 ;; Adding optional lines in Batch Allocatiomn Sub Form in Stock Item Master [#Line: STKALLOC Column] ;; Column Title Line Add: Option: BMRP STKALLOC Column : Yes [#Line: STKALLOC MainLine] ;; Data Input Line Add: Option: BatchMRP MainLine : Yes ; [#Line: STKALLOC ExpiryDateLine] ;; Expiry Info Line Add: Option: BMRP STKALLOC ExpiryDateLine : Yes [#Line: STKALLOC Total] ;Total Line Add: Option: BMRP STKALLOC Total :Yes [!Line: BMRP STKALLOC Column] Add: Right Fields: At Beginning : BatchMRP Title ;; Adding UDF Field Title [Field: BatchMRP Title] Use : Rate Title Field Style : Small Bold Info : $$LocaleString:"MRP" Width : 6 Invisible : $$IsSysName:$BaseUnits [!Line: BatchMRP MainLine] Add: Right Fields: At Beginning: Batch MRP ;; Adding UDF Field for Input [Field: Batch MRP] Use: Number Field Width : @@RateWidth Max : @@MaxNumberWidth Style : Small Bold Storage : BatchMRP ;; UDF to Store Batch MRP Data Set Always : Yes Invisible : $$IsSysName:$BaseUnits Inactive : $$IsSysName:$BaseUnits Align : Right Format : "Symbol,Forex" ;; Following Lines are for Field Alignments [!Line:BMRP STKALLOC ExpiryDateLine] Add: Right Fields: At Beginning: BatchMRP Title Local: Field: BatchMRP Title : info: "" Local: Field: BatchMRP Title : Set Always: Yes [!Line: BMRP STKALLOC Total] Add: Right Fields: At Beginning: BatchMRP Title Local: Field: BatchMRP Title : info: "" Local: Field: BatchMRP Title : Set Always : Yes Why BatchMRP values are not fetched in "List of Active Batches" while entering Sales Voucher ? [#Collection: Active Batches VchExtract] SubTitle : $$LocaleString:"Name", @@ExpirySubTitle, $$LocaleString:"Balance", $$LocaleString:"MRP" Add : Fetch : Batch Allocations.* Add : Fetch : BatchMRP Format : $BatchMRP, 10 [#Collection: Batches VchSrc] Add : Fetch : Batch Allocations.* Add : Fetch : BatchMRPs.* FORMAT : $BatchMRP, 10
B. Patil Sir It is very easy.... Learn a Function Named Collection Field by Key Or Add MRP in Batch Allocation Object... There are many ways to Achieve this... But You just have to focus more
Thanks. Seems there is a long way to go for me. Can you suggest Reading/Learning resources elaborating "Collections"
For Integration -- Software Codecs( YT Channel) For Reports -- This is a skill...you will learn it through experience only. I prefer you to create at least 10 simple reports then You will get confidence on Collection.