Fetch GST & Cess rate in collection [Solved]

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.