MRP DETAILS IN BATCH WISE STOCK ITEM

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..

 

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

 

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.

 

[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..

 

Am working since last three days but not getting the result. I need help.. I completely forgot the "Collection"...

 

Taufeeq, check out this, Thanks

 

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...

 

I will revert 2morrow

 

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.

 

Please upload your final codes it will help to learn more about batch collection, Thanks in advance