Openbravo Issue Tracking System - Openbravo ERP
This new field can be created next to "Prepayment Amount".
Go to channel touchpoint type and configure it as:
- Group orders in one invoice = No
- Generate invoice for orders = Yes
- Allow prepayments and partial payments = Yes
Configure Cash VAT feature for the organization White Valle Spain S.A., as described below:
- In the organization window set as Yes the field Cash VAT for White Valle Spain S.A.
- In the Account tree window create two new accounts:
Account 47700T, with the same set up as 47700
Account 47200T, with the same set up as 47200
- In the tax rate window, create a new tax rate named "Entregas IVA 21% IVA de Caja" with below setup:
Tax Category = IVA Normal
Sales/Purchas Type = Sales Tax
Country/Destination Country = Spain
Rate = 21
Cash VAT = YES
In the accounting tab, enter above created accounts in the fields "Tax Due Transitory" (47700T) and "Tax Credit Transitory" (47200T) for The White Valley Group General Leger.
Go to Openbravo Web POS.
Create a new sales for Arturo Montoro. Verify that the check Invoice is selected.
Select 1 unit of product "Avalanche Transceiver". Veriy that just create tax rate "Entregas IVA 21% IVA de Caja" is used.
Confirm the sale and pay it by cash.
Go to Sales order window and verify that the order is there (ie. order 134). Verify it is paid.
Go to Sales invoice window and verify that the corresponding invoice has been created there. (ie. invoice 33, related to receipt 134). See image attached.
Verify it is paid (Payment Complete = Yes).
Go to tax tab, cash vat subtab and verify that a 100% percentage is shown in there. This means total VAT amount is final VAT (can be settle), so no transitory VAT posting is required.
Post the invoice.
Verify below posting is shown, which is not correct.
150.50 (43000) Clientes DEBIT
124.38 (70000) Ventas CREDIT
26.12 (47700T) VAT Transitory CREDIT
Correct posting should be:
150.50 (43000) Clientes DEBIT
124.38 (70000) Ventas CREDIT
26.12 (47700) VAT Final CREDIT
In case the invoice is partially paid the VAT amount corresponding to that amount paid would need to be accounted to a final VAT account, while the rest to a transitory VAT account.
Above it is required to get Cash VAT management feature properly working, on top of Openbravo for Retail.
Currently Openbravo backoffice only handle "order" prepaid amounts, not "invoice" prepaid amounts, this last one is key for Cash VAT management.
Proposed solution would be to add a new field in the sales invoice header (next to Prepayment Amount", named:
"Paid Amount at Invoicing".
If that new field is not null, that would allow the system to check:
- the VAT amount to account to a final VAT account (the one corresponding to the invoice amount paid, that is the one calculated in the Cash VAT sub-tab, field Tax Amount)
- and the VAT amount to account to a transitory account (invoice amount do not paid, that is the rest)
Later on, and while making and posting rest of invoice payments, pending transitory VAT amount will have to be move to final VAT account.
Nice to have - only show this new field wheneverCash VAT management module is installed, on top of an Openbravo for Retail enviroment; and for those Organizations (and children org) configured as Cash VAT.
| related to | feature request | 0033973 | closed | gorka_gil | Retail Modules | Handling Cash VAT Management during the creation of Orders or Invoices from POS |
Issue_40363.jpg (77,648) 2019-03-12 17:28https://issues.openbravo.com/file_download.php?file_id=12740&type=bug