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.