How to easily implement Wine Equalization Tax WET

[john-paul_dellaputa]

Wine Equalization Tax (WET) is tax on a the base price of a bottle of wine.

Then when the WET is added to the base price of the wine, GST is added to the base price + WET.

I have tried to do this with Formatted Searches and UDF's:

AR Invoice : Selling to Wholesaler / Distributor

Qty RawUnitPrice WET UnitPrice Line Total Line GST Gross Total

Std UDF UDF Std Std Std Std

WINE101 2 $120.00 $34.80 $154.80 $309.60 $30.96 $340.56

Validation 1 : when validating Quantity field

set($[$38.U_RawUnitPrice.0]| SQL: SELECT Price from ITM1 where pricelist = 'Raw' AND ItemCode = $[$38.1.0]) // Sets RawUnitPrice on row

Validation 2: when validating RawUnitPrice

Condition A : BP is a Wholesaler or Distributor (based on BP property)

set($[$38.U_WET.0]| $[$38.U_RawUnitPrice.0] * 0.29) // Sets WET on row

set($[$38.12.0]| $[$38.U_RawUnitPrice.0] + $[$38.U_WET.0]) // Sets UnitPrice on row

The main issue is that with 3 Formatted Searches on the document row, this isn't reliable.

I am thinking that a custom Add-On is the best solution.

[Former Member]

Have you tried by a new tax code? That would be much better than UDF+FMS.

Thanks,

Gordon

[john-paul_dellaputa]

I cannot add a new tax code, as in the AU version, you cannot have a tax on a tax.

The way the tax works is as follows:

Total Gross Sale Price = (Base price + 29%(WET))+10%(GST)

But some customers are WET exempt, so they are only charged the GST on the Base price.