Tax Field for Inventory Items

Create a Custom Inventory Item tag called Tax.

Define tax values

Purchase Items

Prepare Report

Sample Report Template

[Purchase Tax:1.4,1, 1, 1.1, 1.1]
>Item|Unit|Tax%|Total Purchase|Tax Total
{REPORT INVENTORY TRANSACTION DETAILS:
	T.Name,
	T.Unit,
	[IT.Tax],
	[T.TotalPrice.Sum],
	[($4*$3)/100];#.00
	:(ITT=Purchase Transaction Type)
}
>Totals
{REPORT INVENTORY TRANSACTION DETAILS:
	[IT.Tax],
	[T.TotalPrice.Sum],
	[($1*$2)/100];#.00
:(ITT=Purchase Transaction Type)
:{0}% Total|||{1}|{2}
}
>{REPORT INVENTORY TRANSACTION DETAILS:[T.TotalPrice.Sum],[([IT.Tax]*[T.TotalPrice]).Sum]/100 :(ITT=Purchase Transaction Type):Total|||{0}|{1}}

You can test it with latest release (5.2.12)

3 Likes