Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0040363
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementmajoralways2019-03-12 16:292019-06-18 17:03
ReporterpsanjuanView Statuspublic 
Assigned Togorka_gil 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version7.x
OS VersionOpenbravo Appliance 14.04Database version9.3.xAnt version1.9.x
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040363: A new field needs to be created in the sales invoice header to reflect the amount paid/prepaid of an invoiced POS order.

DescriptionA 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 ReproduceIn 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 SolutionOpenbravo 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.
TagsNo tags attached.
Attached Filesjpg file icon Issue_40363.jpg [^] (77,648 bytes) 2019-03-12 17:28

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0033973 closedgorka_gil Retail Modules Handling Cash VAT Management during the creation of Orders or Invoices from POS 

-  Notes
(0112870)
gorka_gil (administrator)
2019-06-18 17:03

 Fixed as part of issue:
https://issues.openbravo.com/view.php?id=33973 [^]

- Issue History
Date Modified Username Field Change
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
2019-05-30 17:19 gorka_gil Relationship added related to 0033973
2019-06-10 12:26 gorka_gil Assigned To guilleaer => gorka_gil
2019-06-18 17:03 gorka_gil Note Added: 0112870
2019-06-18 17:03 gorka_gil Status new => closed
2019-06-18 17:03 gorka_gil Resolution open => fixed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker