Skip to Content
avatar image
Former Member

How to easily implement Wine Equalization Tax WET

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 22, 2010 at 02:02 PM

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



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.