Unit price with GST and remove GST from that price SAP B1

[nikunjmehta2290]

Dear Team,

Good day!

We would like to set up specific functionality for one particular item group in SAP Business One. Please refer to the scenario below for a better understanding:

Scenario:

• We have an item with a unit price of 600 INR.
• A 50% discount is applied, bringing the new unit price to 300 INR after the discount.
• When 18% IGST is selected as a tax code, the calculation should work as follows:
1. The price before discount (before applying GST) is calculated as:
• 300 INR - 18% (GST) = 254 INR.
2. The user will apply 18% IGST on the 254 INR.
3. The total document value should be:
• 254 INR × 18% (GST) = 299.72 INR.

We require this setup to only apply to one specific item group and ensure the system follows the above logic when creating sales orders for items within this group.

Could you please guide us on how to configure this setup in SAP Business One? If customization or further actions are needed, kindly provide the necessary steps or suggestions.

How can i handle?

Regards,

Nikunj 

[msundararaja_perumal]

IF

$[$38.1.0]=(Select A.ItemCode From OITM A Where A.ItemCode=$[$38.1.0] AND A.ItmsGrpCod='Enter you item group code')

Begin

Select $[$38.14.number]/2 --For 50% discount

End

Else

Begin

Select 'Check'

End

[nikunjmehta2290]

This is FMS OR how to apply it?

[msundararaja_perumal]

Dear @nikunjmehta2290 ,

This can be enabled via sap support's help. But it is applied across the database and cannot be made only with specific item group.

Alternatively, you may apply this logic using FMS is the row total against the specific item group.

Thanks.

[nikunjmehta2290]

Can you share the FMS is possible?

[msundararaja_perumal]

You have to apply on Linetotal.

The syntax is for SQL, for HANA you need to change them accordingly.