In short, could you arrange that the Product ABV field be available data in the report called “Products sold (order lines) data explorer input options”?
In Australia, Excise payable is calculated on the total volume of alcohol sold not on individual products. Each month, we total up all types of products sold, and apply the excise calculation to work out the litres of alcohol (LALs), then apply appropriate code and rate for the particular type of alcohol and size/type of vessels.
To calculate the Lals we need the ABV on each product sold.
FYI the LALs calc is =(TRUNC(SUM(ABV-1.15)%*(Total Volume),1))
FYI the rate/codes and types are listed here on the ATO website (Excise duty rates for alcohol | Australian Taxation Office)
This would reduce our reporting effort in Oz.