Can someone help me outline what is the Syntax to be used for MRP Like whats the function name that I have to use so that it fetches MRP for that field.
So I tried This for getting GST and MRP in list of Stock Items i get only 0 I have tried using MRPRate or MRPValue but it keeps returning only 0 Can someone correct it ;;======TO SHOW IGST RATE & MRP IN SALES & PURCHASE VOUCHER ONLY FOR DISPLAY====== [#Line : EI ColumnOne] Option : Global EI ColumnOne [!Line: Global EI ColumnOne] Add : Right Fields : At Beginning : IAMRPT, IAMVAT [Field : IAMRPT] Info : "MRP" Align : Centre Width : @@NumberWidth Style : Small bold [Field : IAMVAT] Info : "IGST%" Align : Centre Width : @@NumberWidth Style : Small bold [#Line : EI ColumnTwo] Option : Global EI ColumnTwo [!Line: Global EI ColumnTwo] Add : Right Fields : At Beginning : IAMRPT, IAMVAT Local : Field : IAMRPT : Info : " " Local : Field : IAMVAT : Info : " " [#Line : EI InvInfo] Option : Global EI InvInfo [#Line : CI InvInfo] Option : Global EI InvInfo [!Line: Global EI InvInfo] Add : Right Fields : At Beginning : IAMRP, IAMVA [Field : IAMRP] Use : Number Field Set As : $MRP:StockItem:$StockItemName Align : Centre Border : Thin Left Right Skip : YES [Field : IAMVA] Use : Number Field Set As : $GSTIGSTRate:StockItem:$StockItemName Format : "NoZero, Percentage" Align : Centre Border : Thin Left Right Skip : YES ;;=====HSN-SAC CODE IN VOUCHER ENTRY [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes ;;Unique : $StockItemName Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate Add :Format :$MRP Fetch:MRP ;;TO SHOW GST DETAILS IN STOCK SUMMARY [#Collection: List of Stock Items] Add:Sub Title :"Item Name" [#Collection: List of Stock Items] Add:Sub Title :"GST" Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate [#Collection: List of Stock Items] Add:Sub Title :"MRP" Add :Format :$MRP Fetch:MRP [#Collection: List of Stock Items] Add:Sub Title :"CL Qty" ;;=====END OF CODE========
[Field : IAMRP] Use : Number Field Set As : If $$IsEmpty:$ExciseMRPRate Then $$GetExciseMRPRateForStkItem:$StockItemName:$..ExciseUnitName Else $ExciseMRPrate Align : Centre Border : Thin Left Right Skip : YES Try this.
Hey, Thanks for the suggestion. Unfortunately it is still returning zero along with the error that the function is not defined.
Send you Demo Tally Company data with items as shown in your Invoice...so i can work on it............
Hello Sir I want to display MRP price in List of Stock Item, but i cann't fetch the value. So please send me code for that. My code is :::: [*Collection: Vch Stock Item Extract] Use : ExtractAlias Collection Source Collection : Stock Item Src Collection : StockItem PartNo With Closing Title : $$LocaleString:"List of Items" Fetch : Name,parent, VchStkItmBalance,Rate Set as : $FirstName Keep Source : ()... Client Only : No Filter : StGroupjobi1 Format : $VchStkItmBalance : "Base" Format : $Rate: "Base" [System:formula] StGroupjobi1: If $$IsEmpty:#TRSPORTF1 or $$IsEndOfList:#TRSPORTF1 or not $EnableGroupWiseBilling:Company:##SVCurrentCompany then not $$IsEqual:$parent:$$LocaleString:#TRSPORTF1 else $$IsEqual:$parent:$$LocaleString:#TRSPORTF1
[Field : IAMRP] Use : Number Field Set As : $StockItemMRPRate Align : Centre Border : Thin Left Right Skip : YES