HOW TO SET ALERT FOR ASSESSABLE VALUE IN SALE INVOICE

[Former Member]

Hi Everybody,

One of our Client belongs to SSI unit (in INDIA). Their requirement is as follows,

a) Assessable value upto 1.5 crores does not have Excise Duty . Once it exceeds 1.5 crores, we need to set a alert for the user to enable him to select the respective Excise Duty using Tax Combination.

b) We need to have 2 types of Assessable Value (DOMESTIC & EXPORT). Hence domestic sales belongs to the above scenario. In EXPORT sales there will be no duty for ever. Again, we need to have a calculation done separately item wise for DOMESTIC & EXPORT

sales assessable values.

[former_member1190345 · Accepted solution]

Hi Sriram,

Assessable value as you must be aware are set up at the item Master Level. when you open the item master Data and for an item when you activate the Excisable item check box below a field will appear where in you can enter the assesable value per item basis. Now having set this up in your case you will have to accummulate the assessable value of the item ( correct me if I am wrong) and once it crosses 1.5 crores the system should automatically take the excise duty calculation. Follow these steps:

1. Add a UDF at the Delivery Row level named Cummulative assessable Value. Put a FMS here with the follwoing characteristics

a. Search by saved query

b. Put this query there - SELECT sum(T0.AssblValue) FROM DLN1 T0

c. choose Auto refresh

d.When Existeng Altered Column - item No.

e.Refresh Regularly

This will add the assessable value and you will have to use similar query in the Alerts management in order to alert the user that the value has crossed 1.5 crores.

In case of having to calculate assessable values for domestic and Export then the best way out would be to maintain 2 seperate items master in which you enter the Assesable value for domestic item and leave it blank for Export items.

Hope this helps.

Nagesh