Can Someone Help Me with how to display Gst rate of products in the below mentioned code, [#Menu: Inventory Books] Key Item : @@prcchk : K : Display : Stock price : $$IsInventoryOn:$$CurrentCompany [System: Formula] prcchk:$$LocaleString:"Stock Item Price List" [Report:Stock price] Form:Stock price [Form: stock price] Usesp Template Part:Form title,subtit, list of products [Part:Form Title] Lines:form title [Line:form title] Field:title Space Bottom: 1 Border: thin bottom [Field: title] Info:"Price List of Products" Align:Center Full Width:Yes Style: Normal Bold [Part:subtit] Line:subt [Line:subt] Field:tpname,tpcstock,tprate,tgst Border : column titles [Field: tpname] Info:"Products" Full Width:Yes ;;Border:Thick box Align:Left [Field: tpcstock] Info:"Qty" Width:20 ;;Border:Thick box Align:Center [Field: tprate] Info:"Sales rate" Width:20 Align:Center ;;Border:Thick box [Field: tgst] Info:"GST" Width:20 Align:Center [Part:List Of Products] Lines:lst Repeat:lst:Stockitem Vertical : Yes Scroll : Vertical CommonBorder: Yes [Line:lst] Fieldname,pcstock,prate,pgst [Field: pname] Use : Name Field Set as : $NAME fullWIdth : Yes [Field: pcstock] Use : Qty Primary Field ;; Invisible : @@QtyInvisible Width : 20 Format : "NoZero" Align:Center Set as : $ClosingBalance [Field: prate] Use : simple field Width : 20 Align:Center SET AS: $STANDARDPRICE ;;Set as: @@krgst [Field: pgst] Use : simple field Width : 20 Align:Center Set as:$IGSTRate [ Collection : lst] Type : stockitem
[Field: pgst] Use : simple field Width : 20 Align:Center Set as:$(StockItem, $Name).GstDetails[Last].STATEWISEDETAILS[1].RateDetails[1, @@IsIGST].GSTRate ;; But here you will get only the Last GST Rate of the item i mean Latest GST Rate.
@Jay kumar TAILER sir please do mail me a small queary regading the pricelist report , kacubeanandh@gmail.com