|View Issue Details|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|feature request||[Openbravo ERP] 07. Sales management||major||always||2019-03-12 16:29||2019-03-13 16:40|
|Priority||urgent||Resolution||open||Fixed in Version|
|Status||new||Fix in branch||Fixed in SCM revision|
|OS||Linux 64 bit||Database||PostgreSQL||Java version||7.x|
|OS Version||Openbravo Appliance 14.04||Database version||9.3.x||Ant version||1.9.x|
|Product Version||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0040363: A new field needs to be created in the sales invoice header to reflect the amount paid/prepaid of an invoiced POS order.
|Description||A new field needs to be created in the sales invoice to reflect the amount paid/prepaid of an invoiced POS order.|
This new field can be created next to "Prepayment Amount".
|Steps To Reproduce||In an Openbravo enviroment with both backoffice and frontoffice (Web POS) install Cash VAT management module, together with the path attached (patch developed to make Cash VAT feature to work in Web POS).|
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.
|Proposed Solution||Openbravo backoffice needs to be improved to manage paid/prepaid invoice information, at the very same time an invoice is created from Web POS.|
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.
|Tags||No tags attached.|
|Attached Files|| Issue_40363.jpg [^] (77,648 bytes) 2019-03-12 17:28
|2019-03-12 16:29||psanjuan||New Issue|
|2019-03-12 16:29||psanjuan||Assigned To||=> Triage Finance|
|2019-03-12 16:29||psanjuan||Modules||=> Core|
|2019-03-12 16:29||psanjuan||Triggers an Emergency Pack||=> No|
|2019-03-12 16:42||psanjuan||Steps to Reproduce Updated||View Revisions|
|2019-03-12 16:51||psanjuan||Steps to Reproduce Updated||View Revisions|
|2019-03-12 16:51||psanjuan||Proposed Solution updated|
|2019-03-12 17:07||psanjuan||Steps to Reproduce Updated||View Revisions|
|2019-03-12 17:07||psanjuan||Proposed Solution updated|
|2019-03-12 17:10||psanjuan||Proposed Solution updated|
|2019-03-12 17:28||psanjuan||File Added: Issue_40363.jpg|
|2019-03-12 17:29||psanjuan||Steps to Reproduce Updated||View Revisions|
|2019-03-12 17:30||psanjuan||Steps to Reproduce Updated||View Revisions|
|2019-03-12 17:48||psanjuan||Summary||A new field needs to be created in the sales invoice to reflect the amount paid/prepaid of an invoiced POS order. => A new field needs to be created in the sales invoice header to reflect the amount paid/prepaid of an invoiced POS order.|
|2019-03-12 17:48||psanjuan||Description Updated||View Revisions|
|2019-03-13 10:37||psanjuan||Assigned To||Triage Finance => guilleaer|
|2019-03-13 16:40||psanjuan||Proposed Solution updated|
|Copyright © 2000 - 2009 MantisBT Group|