0012250: The posting process on the Matched Invoices window does not work properly.

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #12250		[ All Revisions ] [ Back to Issue ]
Summary	0012250: The posting process on the Matched Invoices window does not work properly.

Revision	2010-02-12 18:19 by dalsasua
Steps To Reproduce	Using a application with EURO as system currency (an standar application with sample data): -Create conversion rate from EUR to USD with multiplier rate 1.5 -Create a conersion rate from USD to EUR with divide rate 1.5 -Create a price list for purchasing in USD -Create a new product. Add a price using the created pricelist in USD with price 150. Add a cost to the product. -Create a new Purchase Order using the pricelist in USD created previously. -Create a line with the product created. Qty=1, price=150 tax=exempt. -Complete the order. -Execute the process "pending goods receipt" to create a receipt for the order created in a previous step. -Complete and post the receipt. (to be able to post the receipt you should activate the m_inout table for posting, and add a cost to the product used. The cost in EUR is 100) See the receipt.png file from the attached compressed file -Create a purchase invoice using the partner used on the order and on the receipt. Use also the price list in USD. -Use the create lines from to select the line of the shipment created on a previous step. -Complete and post the invoice. See the invoice.png file from the attached compressed file -Finally go to the Matched Invoices window and select the entry for the invoice created. -Post it. *See the matchinvoice.png file from the attached compressed file In red appears the account that is not correct. It should be the the 350 account that is used in the gl_journal shown after post the receipt. In blue is the row that is incorrect. This is because the amount has not converted from USD to EUR. The DocMatchInv.java and DocMatchinv_data.xsql files does not do any conversion.

Revision	2010-02-12 18:06 by dalsasua
Steps To Reproduce	Using a application with EURO as system currency (an standar application with sample data): -Create conversion rate from EUR to USD with multiplier rate 1.5 -Create a conersion rate from USD to EUR with divide rate 1.5 -Create a price list for purchasing in USD -Create a new product. Add a price using the created pricelist in USD with price 150. -Create a new Purchase Order using the pricelist in USD created previously. -Create a line with the product created. Qty=1, price=150 tax=exempt. -Complete the order. -Execute the process "pending goods receipt" to create a receipt for the order created in a previous step. -Complete and post the receipt. (to be able to post the receipt you should activate the m_inout table for posting, and add a cost to the product used. The cost in EUR is 100) See the receipt.png file from the attached compressed file -Create a purchase invoice using the partner used on the order and on the receipt. Use also the price list in USD. -Use the create lines from to select the line of the shipment created on a previous step. -Complete and post the invoice. See the invoice.png file from the attached compressed file -Finally go to the Matched Invoices window and select the entry for the invoice created. -Post it. *See the matchinvoice.png file from the attached compressed file In red appears the account that is not correct. It should be the the 350 account that is used in the gl_journal shown after post the receipt. In blue is the row that is incorrect. This is because the amount has not converted from USD to EUR. The DocMatchInv.java and DocMatchinv_data.xsql files does not do any conversion.

Revision	2010-02-12 18:04 by dalsasua
Steps To Reproduce	Using a application with EURO as system currency (an standar application with sample data): -Create a price list for purchasing in USD -Create conversion rate from EUR to USD with multiplier rate 1.5 -Create a conersion rate from USD to EUR with divide rate 1.5 -Create a new product. Add a price using the created pricelist in USD with price 150. -Create a new Purchase Order using the pricelist in USD created previously. -Create a line with the product created. Qty=1, price=150 tax=exempt. -Complete the order. -Execute the process "pending goods receipt" to create a receipt for the order created in a previous step. -Complete and post the receipt. (to be able to post the receipt you should activate the m_inout table for posting, and add a cost to the product used. The cost in EUR is 100) See the receipt.png file from the attached compressed file -Create a purchase invoice using the partner used on the order and on the receipt. Use also the price list in USD. -Use the create lines from to select the line of the shipment created on a previous step. -Complete and post the invoice. See the invoice.png file from the attached compressed file -Finally go to the Matched Invoices window and select the entry for the invoice created. -Post it. *See the matchinvoice.png file from the attached compressed file In red appears the account that is not correct. It should be the the 350 account that is used in the gl_journal shown after post the receipt. In blue is the row that is incorrect. This is because the amount has not converted from USD to EUR. The DocMatchInv.java and DocMatchinv_data.xsql files does not do any conversion.