Hello everyone, I have created a report, and now I want to fetch the GST and cess rate from the item in my report Please, can anyone provide me the $ value to fetch GST Rate & cess rate in my collection. Current for GST rate I am using $GSTIGSTRate, but sometimes it does show the value in the report. Please help
Try this Code: $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0:@@IGSTDutyHead $$GetInfoFromHierarchy:$Name:"StockItem":"GSTRate":##SVCurrentDate:"GST":0:@@CessDutyHead
Thanks for replying, buddy. I am asking how can I Fetch in the collection This is my collection how can I fetch Cess in This [Collection:ISR Coll] Source Collection:ISR Base Coll Walk:inventory entries By:name:$Stockitemname By:nrate:$rate By:tax:$GSTIGSTRate:StockItem:$StockItemName Aggr Compute:amount:Sum:$Amount Aggr Compute:BillQty:Sum:$billedQty Computeisc:$discount Fetch:billedqty, rate, discount, amount, Stockitemname,GSTIGSTRate, cessrate Fetch:* Sort: @@default :$name
Collection for GST Analysis is : GSTAnalysisPrintSummary You have to define field accordingly for CESS Amount, Rate & Per%
Solved by doing it another way. No need to fetch in the collection just make a change in the " Set as" of the field. For GST % : Set as: $_IntegratedTax:StockItem:$StockItemName For Cess % Set as: $_cess:StockItem:$StockItemName
Hello Every Expert I need Solution for Getting IGST Rate Of item. I am trying to get Item Rate With GST Set($LastPurcPrice:StockItem:$StockItemName * $BasicRateOfExcise:StockItem:$StockItemName) / 100) + $LastPurcPrice:StockItem:$StockItemName Its Only Get RATE, No IGST Added I think This Line is Not fetch "$BasicRateOfExcise:StockItem:$StockItemName" the IGST Rate Please .. Guide me....
Hi, The above function work perfectly for me. However, Just want to learn, can I use this function to retrieve any other value... What is the description of the parameter of this formula... It would be helpful If you could elaborate or provide any reference for this formula. ($$GetInfoFromHierarchy) Further, In a scenerio where GST Rate for few items are set in Master (Either Item or ItemGroup) and for few Items if not set in master then it should be fetch from Company Default GST Rate. The above formula fetch the GST Rate from (Item or ItemMaster) and in case it has not been defined in ItemMaster, It return 0 (Zero) even if the rate has been defined in Company Master. Is there any common formula to fetch the rate from Item Master / Item Group / Company Master as applicable. Thank you for your help & support.