Anonymous | Login
Project:
RSS
  
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.


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker