Fixed
Details
Details
Assignee
Heng Sin Low
Heng Sin LowReporter
Michael Powacht
Michael PowachtComponents
Fix versions
Affects versions
Priority
Created July 26, 2018 at 1:09 AM
Updated October 1, 2018 at 10:09 AM
Resolved August 8, 2018 at 3:17 AM
Here is how to simulate the above error condition:
1. Create Price List and set Price includes Tax=Y
2. Create Price List version for Price List in 1.
3. Create Product, Product Type=Service, Tax Category: any category with VAT (in my example 7%). Create Price for Price List version in Product>Price
4. Create BP, set Employee=Y, create user in BP>Contact(User)
5.1 Create expense report using >Expense Report, enter Price List from 1. BP from 4.
5.2 Create expense report line, Product from 3, Expense amount=1,070.00 (includes 7% VAT)
5.3 Complete expense report
8.1 Execute process Create AP Expense Invoices, BP from 4.
An invoice will get generated with the following values:
C_InvoiceLine-LineNetAmt=1070 OK
C_InvoiceLine-LineTotalAmt=1070 OK
C_InvoiceLine-PriceEntered=1070 OK
C_InvoiceLine-PriceActual=1070 OK
C_InvoiceLine-TaxAmt=70 OK
C_Invoice-Totallines = 1070 OK
C_Invoice-GrandTotal = 1,140.00 *NOT OK (should be 1070) *
C_InvoiceTax-TaxAmt = 70 OK
C_InvoiceTax-TaxBaseAmt = 1000 =OK
Price includes Tax=N NOT OK (should be Y)
As a result, the invoice is wrongly posted
CR AP 1140 NOT OK (should be 1070)
DR Expense 1070 NOT OK (should be 1000)
DR VAT 70 OK
I have simulated this in https://demo.globalqss.com
Expense Report=10000004
Invoice=10000004