What is the function of the different price fields in a transaction?

PceGrossPrice  

The field PceGrossPrice is the gross unit price of a product 

PceNetprice

The field PceNetprice is the PceGrossPrice minus discounts at line level (Scales, Offers, manual unit discount)

TotalGrossPrice

TotalGrossPrice is the total of PceGrossPrice multiplied by the quantity of the line.

TotalNetPrice

TotalNetPrice is the total of PceNetPrice multiplied by the quantity of the line.

TotalWeightedNetPrice

The field weighted price (totalweightednetprice) is used for the settlement of other discounts at transaction level or across multiple sales lines (mixedmatches, price agreements, and manual total discount)

The total of all totalweightednetprice fields must be equal to the total of the payment and is therefore used to check the balance of the transaction during processing.

The calculation of this field is done in the cash register and is based on the net total price. The difference between the net total price and the net weighted total price is, for example, a total discount on the receipt. This total discount is distributed proportionally among the lines.

A question that is often asked is why revenue is very high when, for example, a Gift Card is incorrectly scanned with a very high amount.

A gift card payment method often does not allow change, so the overpayment that occurs is offset as a negative total discount through the totalweightednetprice field.

Because statistics and other revenue-based reports rely on this field, in this case, you will see a very strange high revenue or VAT.