Process "Create AP Expense Invoices" creates wrong AP and expense postings if product's price list "isTaxIncluded=Y"
Fixed
Description fields
Description
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
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