LE_HST_TL.MO_NO_TX_TOT Column Value Not Updated When Both Taxable and Non-Taxable Items Exist In The Transaction
Last updated on APRIL 28, 2017
Applies to:Oracle Retail Point-of-Service - Version 14.1.2 and later
Information in this document applies to any platform.
LE_HST_TL.MO_NO_TX_TOT (NontaxableTotalAmount) column is not updated correctly when both Taxable and Non-Taxable Items exist in the transaction.
Steps to reproduce:
1. Scan Item:41 (Non-Taxable)
2. Scan Item:42 (Taxable)
3. Click on "Tender F6" >> "Cash F2" and complete the transaction
4. Check the value on LE_HST_TL.MO_NO_TX_TOT and notice that it's value is zero for the transaction
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms