0028527: Wrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added.

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #28527		[ Back to Issue ]
Summary	0028527: Wrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added.

Revision	2015-01-07 10:45 by psanjuan
Steps To Reproduce	Make sure that F&B España is set as a Cash VAT organization. Navigate to Organization window, search by F&B España and select below two parameters in "Information" tab: Cash VAT Double Cash Criteria. Go to sales order window and create a new one for "Hoteles Buenas Noches" dated on 07/01/2015. Change invoice terms to "Inmediate". Go to Lines and select below two products: Agua sin Gas 1L - Ordered quantity 1.500 units. Change Tax to Entregas IVA 4% IVA de Caja". Vino Rosado 0.75L - Ordered quantity 1.500 units. Book the order. Add a prepayment of the order of an amount of 3200,00 € by using "Add Payment" process button. Go to Sales Invoice window and create a new one for "Hoteles Buenas Noches" by using "Create Lines From" process button. Select the order just created. Realize that a prepayment amount = 3.200 is shown at the top of the sales invoice header. Navigate to Lines and add two new lines: Limonada 0.5L - Invoiced Quantity = 800 units Vino Blanco 0.75L - Invoiced Quantity = 800 units Complete the invoice. Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 483.88 (17.23% VAT paid due to prepayment) Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 15.82 (17.23% VAT paid due to prepayment) Post the invoice. Posting looks like: Debit: (43000) Clientes 15.368.13 Debit: (43800) Anticipos 3.200.00 Credit: (70000) Venta 15.668.00 Credit: (47700T) HP Iva repercutido temporal 2.400.43 Credit: (47700) HP IVA repercutido 499.70 (483.88 + 15.82) Add a new partial payment by using "Add payment " process button. Pay now 12.000.00 € Navigate to Payment Plan tab and realize that a new payment has been created that has two lines: First line does have a received amount = 5.962.88 Second line does have a received amount = 6.037.12 total of 12.000.00 Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is: 901.75 + 912.99 = 1814.74 Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is: 29.48 + 29.84 = 49.32 Go now to payment in window and post the new payment. Posting looks like: Debit: (55500) Partidas pendientes aplicación 12.000.00 Debit: (47700T) HP IVA repercutido temporal 942.83 (912.99 + 29.84) Credit: (43000) Clientes 12.000.00 Credit: (47700) HP IVA repercutido 942.83 (912.99 + 29.84)

Revision	2015-01-07 10:26 by psanjuan
Steps To Reproduce	Make sure that F&B España is set as a Cash VAT organization. Navigate to Organization window, search by F&B España and select below two parameters in "Information" tab: Cash VAT Double Cash Criteria. Go to sales order window and create a new one for "Hoteles Buenas Noches" dated on 07/01/2015. Change invoice terms to "Inmediate". Go to Lines and select below two products: Agua sin Gas 1L - Ordered quantity 1.500 units. Change Tax to Entregas IVA 4% IVA de Caja". Vino Rosado 0.75L - Ordered quantity 1.500 units. Book the order. Add a prepayment of the order of an amount of 3200,00 € by using "Add Payment" process button. Go to Sales Invoice window and create a new one for "Hoteles Buenas Noches" by using "Create Lines From" process button. Select the order just created. Realize that a prepayment amount = 3.200 is shown at the top of the sales invoice header. Navigate to Lines and add two new lines: Limonada 0.5L - Invoiced Quantity = 800 units Vino Blanco 0.75L - Invoiced Quantity = 800 units Complete the invoice. Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 483.88 (17.23% VAT paid due to prepayment) Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 15.82 (17.23% VAT paid due to prepayment) Post the invoice. Posting looks like: Debit: (43000) Clientes 15.368.13 Debit: (43800) Anticipos 3.200.00 Credit: (70000) Venta 15.668.00 Credit: (47700T) HP Iva repercutido temporal 2.400.43 Credit: (47700) HP IVA repercutido 499.70 (483.88 + 15.82) Add a new partial payment by using "Add payment " process button. Pay now 5.000.00 € Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 756.28 (26.93% VAT paid due to new payment) Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 24.72 (26.93% VAT paid due to new payment) Go now to payment in window and post the new payment. Posting looks like: Debit: (55500) Partidas pendientes aplicación 5.000.00 Debit: (47700T) HP IVA repercutido temporal 781.00 Credit: (43000) Clientes 5.000.00 Credit: (47700) HP IVA repercutido 781.00

Revision	2015-01-07 10:25 by psanjuan
Steps To Reproduce	Make sure that F&B España is set as a Cash VAT organization. Navigate to Organization window, search by F&B España and select below two parameters in "Information" tab: Cash VAT Double Cash Criteria. Go to sales order window and create a new one for "Hoteles Buenas Noches" dated on 07/01/2015. Change invoice terms to "Inmediate". Go to Lines and select below two products: Agua sin Gas 1L - Ordered quantity 1.500 units. Change Tax to Entregas IVA 4% IVA de Caja". Vino Rosado 0.75L - Ordered quantity 1.500 units. Book the order. Add a prepayment of the order of an amount of 3200,00 € by using "Add Payment" process button. Go to Sales Invoice window and create a new one for "Hoteles Buenas Noches" by using "Create Lines From" process button. Select the order just created. Realize that a prepayment amount = 3.200 is shown at the top of the sales invoice header. Navigate to Lines and add two new lines: Limonada 0.5L - Invoiced Quantity = 800 units Vino Blanco 0.75L - Invoiced Quantity = 800 units Complete the invoice. Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 483.88 (17.23% VAT paid due to prepayment) Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 15.82 (17.23% VAT paid due to prepayment) Post the invoice. Posting looks like: Debit: (43000) Clientes 15.368.13 Debit: (43800) Anticipos 3.200.00 Credit: (70000) Venta 15.668.00 Credit: (47700T) HP Iva repercutido temporal 2.400.43 Credit: (47700) HP IVA repercutido 499.70 (483.88 + 15.82) Add a new partial payment by using "Add payment " process button. Pay now 5.000.00 € Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 456.28 (26.93% VAT paid due to new payment) Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 24.72 (26.93% VAT paid due to new payment) Go now to payment in window and post the new payment. Posting looks like: Debit: (55500) Partidas pendientes aplicación 5.000.00 Debit: (47700T) HP IVA repercutido temporal 781.00 Credit: (43000) Clientes 5.000.00 Credit: (47700) HP IVA repercutido 781.00

Revision	2015-01-07 10:07 by psanjuan
Steps To Reproduce	Make sure that F&B España is set as a Cash VAT organization. Navigate to Organization window, search by F&B España and select below two parameters in "Information" tab: Cash VAT Double Cash Criteria.