Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question