Openbravo Issue Tracking System - Localization Pack: Spain |
View Issue Details |
|
ID | Project | Category | View Status | Date Submitted | Last Update |
0041317 | Localization Pack: Spain | SII Retail | public | 2019-07-08 17:46 | 2020-12-30 11:17 |
|
Reporter | psanjuan | |
Assigned To | AtulOpenbravo | |
Priority | urgent | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | |
Platform | | OS | 30 | OS Version | Openbravo Appliance 14.04 |
Product Version | | |
Target Version | | Fixed in Version | | |
Merge Request Status | |
Regression date | |
Regression introduced by commit | |
Regression level | |
Review Assigned To | |
Support ticket | |
OBNetwork customer | |
Regression introduced in release | |
|
Summary | 0041317: Correct "Clave de Tipo de Factura" needs to be assigned to the invoices, once Invoicing improvementes are implemented in POS |
Description | Correct "Clave de Tipo de Factura" needs to be assigned to the invoices, once Invoicing improvementes are implemented in Openbravo for Retail. |
Steps To Reproduce | n/a |
Proposed Solution | Once the changes described in the document below are implemented, Openbravo Web POS need to assign the correct "Clave de Tipo Factura", as described below:
https://docs.google.com/document/d/14sfEAWuMZgSBKgKP8WTLkKRiEsHGaOxsjIROy3Guz-Y/edit [^]
(1) Channel toucpoint type parameter "Generate Simplified Invoices" = Yes
This configuration will create a sales invoice with the value "VBS AR Simplified Invoice" in the field "Transaction Document" (Document Type for Simplified Invoices, in the backoffice).
In such cases the value of the SII field "Invoice Type Key" must be "Simplified Invoice". See image "Simplified Invoice". (F2)
(2) POS menu option "Issue Invoice" is used, regardless Channel Touchpoint type configuration.
This configuration will create a sales invoice with the value "AR Invoice" in the field "Transaction Document" (Document Type for Invoices, in the backoffice).
In such cases the value of the SII field "Invoice Type Key" must be "Invoice". See image "Invoice". (F1)
(3) Partial or total Returns (Verified or Blind). Channel toucpoint type parameter "Generate Simplified Invoices" = Yes
This configuration will create a negative Sales Invoice, originated from a RFC Order having a given document type in the field "Document Type for Simplified Invoices", for instance "Reverse Sales Simplified Invoice".
In such cases the value of the SII field "Invoice Type Key" must be "Corrective Invoice", the value of the field "Rectification Invoice Type" must be "Differences" and the value of the field "Rectification Reason" must be " R5 - Simplified Invoice" - See image "Reverse Simplified Invoice". (R5)
(4) Partial or total Returns (Verified or Blind). POS menu option "Issue Invoice" is used, regardless Channel Touchpoint type configuration.
This configuration will create a negative Sales Invoice, originated from a RFC Order having a given document type in the field "Document Type for Invoices", for instance "Reverse Sales Invoice".
In such cases the value of the SII field "Invoice Type Key" must be "Corrective Invoice", the value of the field "Rectification Invoice Type" must be "Differences" and the value of the field "Rectification Reason" must be " R1 - Founded error " - See image "Reverse Invoice". (R1)
|
Additional Information | |
Tags | No tags attached. |
Relationships | related to | design defect | 0040247 | | new | Retail | Retail Modules | Cancel and Replace Cancellation order is not Invoiced Immediately having Immediate Invoice Terms | related to | design defect | 0044251 | | new | Retail | Retail Modules | Cancel and replace Cancellation order is not invoiced inmediatly having After Delivery Invoice Terms. | related to | defect | 0045662 | | closed | AtulOpenbravo | Localization Pack: Spain | SII module does not support "Issue Sales Order" function related to Delivery Modes. | has duplicate | design defect | 0040466 | | closed | psanjuan | Localization Pack: Spain | Partial returns need to be handle in SII as "Clave Tipo Factura" F5 |
|
Attached Files | Simplified_Invoice.jpg (67,482) 2020-12-14 12:43 https://issues.openbravo.com/file_download.php?file_id=15154&type=bug

Invoice.jpg (66,829) 2020-12-14 12:45 https://issues.openbravo.com/file_download.php?file_id=15155&type=bug

Reverse Simplified Invoice.jpg (81,176) 2020-12-14 12:55 https://issues.openbravo.com/file_download.php?file_id=15156&type=bug

Reverse Invoice.jpg (71,233) 2020-12-14 12:56 https://issues.openbravo.com/file_download.php?file_id=15157&type=bug

|
|
Issue History |
Date Modified | Username | Field | Change |
2019-07-08 17:46 | psanjuan | New Issue | |
2019-07-08 17:46 | psanjuan | Assigned To | => psanjuan |
2020-06-25 10:22 | psanjuan | Proposed Solution updated | |
2020-07-07 09:52 | psanjuan | Proposed Solution updated | |
2020-07-07 10:06 | psanjuan | Note Added: 0121291 | |
2020-07-07 10:06 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21276 |
2020-07-07 10:07 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21277 |
2020-07-07 16:28 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21282 |
2020-07-07 16:55 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21283 |
2020-07-07 16:56 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21284 |
2020-07-07 17:01 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21285 |
2020-07-07 17:15 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21286 |
2020-07-07 17:16 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21287 |
2020-07-07 17:45 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21288 |
2020-07-07 17:45 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21289 |
2020-07-08 16:13 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21298 |
2020-07-08 16:22 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21299 |
2020-07-14 17:46 | psanjuan | Proposed Solution updated | |
2020-07-14 17:46 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21342 |
2020-07-14 17:47 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21343 |
2020-09-01 15:40 | psanjuan | Relationship added | has duplicate 0040466 |
2020-09-01 15:44 | psanjuan | Proposed Solution updated | |
2020-09-01 15:45 | psanjuan | Proposed Solution updated | |
2020-11-04 12:10 | psanjuan | Proposed Solution updated | |
2020-12-14 12:39 | psanjuan | Proposed Solution updated | |
2020-12-14 12:42 | psanjuan | Proposed Solution updated | |
2020-12-14 12:43 | psanjuan | File Added: Simplified_Invoice.jpg | |
2020-12-14 12:45 | psanjuan | File Added: Invoice.jpg | |
2020-12-14 12:50 | psanjuan | Proposed Solution updated | |
2020-12-14 12:54 | psanjuan | Proposed Solution updated | |
2020-12-14 12:55 | psanjuan | File Added: Reverse Simplified Invoice.jpg | |
2020-12-14 12:56 | psanjuan | File Added: Reverse Invoice.jpg | |
2020-12-14 13:05 | psanjuan | Proposed Solution updated | |
2020-12-14 13:49 | psanjuan | Note Added: 0124807 | |
2020-12-14 13:59 | psanjuan | Note Edited: 0124807 | bug_revision_view_page.php?bugnote_id=0124807#r21931 |
2020-12-14 15:21 | psanjuan | Note Added: 0124809 | |
2020-12-14 15:21 | psanjuan | Note Edited: 0121291 | bug_revision_view_page.php?bugnote_id=0121291#r21932 |
2020-12-14 15:23 | psanjuan | Note Edited: 0124809 | bug_revision_view_page.php?bugnote_id=0124809#r21934 |
2020-12-14 15:29 | psanjuan | Note Edited: 0124809 | bug_revision_view_page.php?bugnote_id=0124809#r21935 |
2020-12-14 15:33 | psanjuan | Note Edited: 0124809 | bug_revision_view_page.php?bugnote_id=0124809#r21936 |
2020-12-14 15:33 | psanjuan | Relationship added | related to 0040247 |
2020-12-14 15:34 | psanjuan | Relationship added | related to 0044251 |
2020-12-14 18:10 | AtulOpenbravo | Assigned To | psanjuan => AtulOpenbravo |
2020-12-14 18:10 | AtulOpenbravo | Status | new => scheduled |
2020-12-15 20:24 | AtulOpenbravo | Note Added: 0124840 | |
2020-12-15 20:41 | hgbot | Note Added: 0124841 | |
2020-12-29 09:52 | psanjuan | Note Edited: 0124840 | bug_revision_view_page.php?bugnote_id=0124840#r21983 |
2020-12-29 09:55 | psanjuan | Note Edited: 0124840 | bug_revision_view_page.php?bugnote_id=0124840#r21984 |
2020-12-29 09:59 | psanjuan | Note Added: 0125130 | |
2020-12-29 10:00 | psanjuan | Note Edited: 0125130 | bug_revision_view_page.php?bugnote_id=0125130#r21986 |
2020-12-29 10:02 | psanjuan | Note Edited: 0125130 | bug_revision_view_page.php?bugnote_id=0125130#r21987 |
2020-12-29 10:02 | psanjuan | Note Edited: 0125130 | bug_revision_view_page.php?bugnote_id=0125130#r21988 |
2020-12-29 10:12 | psanjuan | Note Added: 0125131 | |
2020-12-29 10:13 | psanjuan | Note Edited: 0125130 | bug_revision_view_page.php?bugnote_id=0125130#r21989 |
2020-12-29 10:13 | psanjuan | Note Edited: 0125131 | bug_revision_view_page.php?bugnote_id=0125131#r21991 |
2020-12-29 10:27 | psanjuan | Note Added: 0125132 | |
2020-12-29 11:22 | psanjuan | Note Edited: 0125132 | bug_revision_view_page.php?bugnote_id=0125132#r21993 |
2020-12-29 11:22 | psanjuan | Note Edited: 0125132 | bug_revision_view_page.php?bugnote_id=0125132#r21994 |
2020-12-29 11:28 | psanjuan | Note Edited: 0125132 | bug_revision_view_page.php?bugnote_id=0125132#r21995 |
2020-12-29 11:28 | psanjuan | Note Edited: 0125132 | bug_revision_view_page.php?bugnote_id=0125132#r21996 |
2020-12-29 11:29 | psanjuan | Note Added: 0125133 | |
2020-12-29 11:55 | psanjuan | Note Edited: 0125131 | bug_revision_view_page.php?bugnote_id=0125131#r21997 |
2020-12-29 11:55 | psanjuan | Relationship added | related to 0045662 |
2020-12-29 11:56 | psanjuan | Note Added: 0125134 | |
2020-12-29 12:04 | psanjuan | Note Edited: 0124840 | bug_revision_view_page.php?bugnote_id=0124840#r22000 |
2020-12-29 12:13 | hgbot | Resolution | open => fixed |
2020-12-29 12:13 | hgbot | Status | scheduled => closed |
2020-12-29 12:13 | hgbot | Note Added: 0125135 | |
2020-12-29 12:13 | hgbot | Note Added: 0125136 | |
2020-12-29 14:12 | hgbot | Note Added: 0125137 | |
2020-12-30 11:17 | hgbot | Note Added: 0125165 | |
Notes |
|
(0121291)
|
psanjuan
|
2020-07-07 10:06
(edited on: 2020-12-14 15:21) |
|
1.- Issue of a Simplified Invoice at sales time
Requires:
- Backoffice paramenter “Generate Simplified Invoice” = Yes
- A Web POS order with a Non identified or an Identified Customer having “Inmediate” Invoice Terms
In such cases a simplified invoice is created in Openbravo POS.
That invoice needs to be created in the Openbravo backoffice (Sales Invoice windows) as described below:
Operation Date (Fecha de Operación) = order date
Invoice Type = Factura Simplificada (F2)
2, Issue of a Full Invoice
2.a - at sales time requires:
- Backoffice paramenter “Generate Simplified Invoice” = Yes
- A Web POS order with an Identified Customer, having “Inmediate” Invoice Terms
- Usage of “Issue Invoice” feature
2. b – at delivery time requires:
- Backoffice paramenter “Generate Simplified Invoice” = Yes
- A Web POS order with an Identified Customer, do NOT having “Inmediate” Invoice Terms
In both cases (2,a and 2,b) a Full Invoice will be created in Openbravo POS either at sales time or at delivery time. That invoices needs to be created in the Openbravo backoffice (Sales Invoice windows) as described below:
Operation Date (Fecha de Operación) = order date
Invoice Type = Factura (F1)
3. Issue of a Simplified Return Invoice
This type of invoices can be created in Openbravo Web POS by using either "Verified Returns" or "Return this Receipt" (Blind Returns), besides below listed features:
- Backoffice paramenter “Generate Simplified Invoice” = Yes
- A Web POS order with a Non identified Customer
* it is important to remark that in the case of a Return Invoice of any type, Invoice Terms are not relevant. Every time that a sales return is booked in the system, the products are delivered back from the buyer, therefore the corresponding return invoice is created, either simplified or full.
In such cases a simplified return invoice is created in the Openbravo backoffice (Sales Invoice window) as described below:
Operation date = Original simplified invoice date (Verified Returns), Order Date (Blind Return)
Invoice Type (Clave tipo Factura) = Factura Rectificativa
Rectification Type (Tipo Rectificativa) = I (Por diferencias)
Rectification Reason (Motivo Rectificación) = R5
4. Issue of a Full Return Invoice
This type of invoices can be created in Openbravo Web POS by using either "Verified Returns" or "Return this Receipt" (Blind Returns), besides below listed features:
- Backoffice paramenter “Generate Simplified Invoice” = Yes
- A Web POS order with an identified Customer
- Usage of “Issue Invoice” feature
In such cases a full return invoice is created in the Openbravo backoffice (Sales Invoice window) as described below:
Invoice Type (Clave tipo Factura) = Factura Rectificativa
Rectification Type (Tipo Rectificativa) = I (Por diferencias)
Rectification Reason (Motivo Rectificación) = R1
This value could be changed in the backoffice, if required to R1, R2 or R3
|
|
|
(0124807)
|
psanjuan
|
2020-12-14 13:49
(edited on: 2020-12-14 13:59) |
|
"Generate Aggregated Invoices" configuration is already working as that one generates an Aggregated Invoice, created with the value "Simplified Invoice Summary" (F4) in the field "Invoice Type Key". This type is correctly sent to SII as the last order or ticket number is included in the XML tag: NumSerieFacturaEmisorResumenFin
The number of that aggreated invoice is included in the XML tab: NumSerieFacturaEmisor
|
|
|
(0124809)
|
psanjuan
|
2020-12-14 15:21
(edited on: 2020-12-14 15:33) |
|
Cancel and Replace feature does not work, if the parameter "Generate Simplified Invoice" is selected. The negative order (VBS1/0000132*R*) is NOT invoiced. See issues related : 40247 and 44251
Cancel and Replace feature while having the parameter "Generate Aggregated Invoice" active works correctly because only one Simplified invoices summary is created adding all lines (positive and negatives).
|
|
|
(0124840)
|
AtulOpenbravo
|
2020-12-15 20:24
(edited on: 2020-12-29 12:04) |
|
Test Plan - issue of simplified and full invoices/return invoices
Test 1
- Login as The White Valley Admin role
- Navigate to window Channel - Touchpoint Type
- Select record VBS POS Terminal Type
- Set Generate Simplied Invoices = Yes
Test 2
- Login into WebPOS using vallblanca user.
- Create a Ticket for "VBS Customer" business partner with any product. Pay Total Ticket.
- Login into Back Office.
- Navigate to Sales Invoice, select record created for previous Ticket created in WebPOS.
- Realize that Transaction Document is set as "VBS AR Simplified Invoice", Invoice Type Key is set as "Simplified invoice"
Test 3
- Login into WebPOS using vallblanca user.
- Create a Ticket for "Carl Studson" business partner with any product, In Menu select Issue Invoice option. Realize that Invoice flag appears as Yes. Pay Total Ticket.
- Login into Back Office.
- Navigate to Sales Invoice, select record created for previous Ticket created in WebPOS.
- Realize that Transaction Document is set as "VBS AR Invoice", Invoice Type Key is set as "Invoice"
Test 4
- Login into WebPOS using vallblanca user.
- In Menu select Verified Return option.
- Select Ticket that was created for "Carl Studson" business partner. Select all the ticket lines.
- Realize that Invoice flag appears as Yes. Pay Total Ticket.
- Login into Back Office.
- Navigate to Sales Invoice, select record created for previous return Ticket created in WebPOS.
- Realize that Transaction Document is set as "VBS Reversed Sales Invoice", Invoice Type Key is set as "Corrective invoice", Rectification invoice type is set as "Differences", Rectification Reason is set as "R1 - Founded error"
Test 5
- Login into WebPOS using vallblanca user.
- In Menu select Verified Return option.
- Select Ticket that was created for "VBS Customer" business partner. Select all the ticket lines.
- Pay Total Ticket.
- Login into Back Office.
- Navigate to Sales Invoice, select record created for previous return Ticket created in WebPOS.
- Realize that Transaction Document is set as "VBS Reversed Sales Simplified Invoice", Invoice Type Key is set as "Corrective invoice", Rectification invoice type is set as "Differences", Rectification Reason is set as "R5 - Simplified invoice".
|
|
|
(0124841)
|
hgbot
|
2020-12-15 20:41
|
|
|
|
(0125130)
|
psanjuan
|
2020-12-29 09:59
(edited on: 2020-12-29 10:13) |
|
Additional Test Plan - Blind Returns
Test 6
-Login into Web POS using vallblanca user
- In Menu select "Return this Receipt", select any product. Complete and pay the return sale.
- Go to the backoffice
- Navigate to Sales Invoice, select record created for previous return Ticket created in WebPOS.
- Realize that Transaction Document is set as "VBS Reversed Sales Simplified Invoice", Invoice Type Key is set as "Corrective invoice", Rectification invoice type is set as "Differences", Rectification Reason is set as "R5 - Simplified invoice".
Test 7
-Login into Web POS using vallblanca user
- In Menu select "Return this Receipt", select any product. Select the end-customer Arturo Montoro
- Select Menu option "Issue Invoice". Realize that Invoice flag appears as Yes.
- Complete and pay the return sale.
- Go to the backoffice
- Navigate to Sales Invoice, select record created for previous return Ticket created in WebPOS.
- Realize that Transaction Document is set as "VBS Reversed Sales Invoice", Invoice Type Key is set as "Corrective invoice", Rectification invoice type is set as "Differences", Rectification Reason is set as "R1 - Founded error".
|
|
|
(0125131)
|
psanjuan
|
2020-12-29 10:12
(edited on: 2020-12-29 11:55) |
|
Additional Test Plan - Delivery Modes
- Enable Delivery Mode function.
- Log in to Web POS using Vallblanca User
- Select Arturo Montoro customer
- Select Menu option "Receipt Properties" to change Invoice Terms to "After Delivery" and Default Delivery Mode as "Pick Up in Store". Press Apply.
- Select any product and make sure that product line has Pickup in Store" delivery mode.
- Complete and pay the sale
- Navigate to the backoffice and verify that no invoice has been created for this sale but a sales order set as not invoiced.
- Go back to Web POS and Issue the sales order (ie 147).
- Go back to backoffice, navigate to the Sales Invoice, select the record created for previous sales.
- Realize that Transaction Document is set as "VBS AR Invoice", Invoice Type Key is set as "null".
See issue related : 45662
|
|
|
(0125132)
|
psanjuan
|
2020-12-29 10:27
(edited on: 2020-12-29 11:28) |
|
Additional Test Plan - Aggregated Invoices and Returns.
Test 9
- Login as The White Valley Admin role
- Navigate to window Channel - Touchpoint Type
- Select record VBS POS Terminal Type
- Set Generate Simplied Invoices = No
- Set Generate Aggregated Inovices = Yes
- Set Generate Aggregated Return Invoices = Yes
Test 10
- Login into WebPOS using vallblanca user.
- Run a cash up.
- Create a Ticket for "VBS Customer" business partner with any product. Pay Total Ticket (ie 18.90€).
- Create another ticket for "VBS Customer" business partner witn any product. Pay Total Ticket. (ie. 150.50 + 169.00)"
- Create another ticket for "VBS Customer" business partner with any product. Paty Total Ticket (ie. 169)
- Create another ticket for "Arturo Montoro" business partner with any product.
- For this sale use the menu option "Issue Invoice". Complete and pay the sale (ie. 169.00+169.00= 338.00).
- By using the option "Verified Returns", select any sale (ie. 18.90) and return it. Complete and pay return sale.
- Run cash up process
- Go to the backoffice and navigate to the sales invoice window. Verify that:
* a Invoice with transaction type "VBS AR Invoice" and "Invoice Type Key = Invoice" has been created for Arturo Montoro customer, for an amount of 338.00
* an Invoice with transaction type "VBS AR Aggregated Invoice", and Invoice Type Key = Simplified Invoices summary" has been created for the VBS Customer for an amount of 507.40 (18.90+150.50+169.00+169.00)
* and an Invoice with transaction type "VBS Reversed Sales Aggregated Invoice" and Invoice Type Key "Simplified Invoice Summary" has been created for the customer VBS Customer, for an amount of -18.90
|
|
|
|
Additional Test Plan - Aggregated Invoices
Test 9
- Login as The White Valley Admin role
- Navigate to window Channel - Touchpoint Type
- Select record VBS POS Terminal Type
- Set Generate Simplied Invoices = No
- Set Generate Aggregated Inovices = Yes
- Set Generate Aggregated Return Invoices = NO
Test 10
- Login into WebPOS using vallblanca user.
- Run a cash up.
- Create a Ticket for "VBS Customer" business partner with any product. Pay Total Ticket (ie 18.90€).
- Create another ticket for "VBS Customer" business partner witn any product. Pay Total Ticket. (ie. 150.50 + 169.00)"
- Create another ticket for "VBS Customer" business partner with any product. Paty Total Ticket (ie. 169)
- Create another ticket for "Arturo Montoro" business partner with any product.
- For this sale use the menu option "Issue Invoice". Complete and pay the sale (ie. 169.00+169.00= 338.00).
- By using the option "Verified Returns", select any sale (ie. 18.90) and return it. Complete and pay return sale.
- Run cash up process
- Go to the backoffice and navigate to the sales invoice window. Verify that:
* a Invoice with transaction type "VBS AR Invoice" and "Invoice Type Key = Invoice" has been created for Arturo Montoro customer, for an amount of 338.00
* an Invoice with transaction type "VBS AR Aggregated Invoice", and Invoice Type Key = Simplified Invoices summary" has been created for the VBS Customer for an amount of 488.50 (18.90+150.50+169.00+169.00-18.90) |
|
|
|
Test Plan executed successfully.
Issue can be closed. |
|
|
(0125135)
|
hgbot
|
2020-12-29 12:13
|
|
|
|
(0125136)
|
hgbot
|
2020-12-29 12:13
|
|
|
|
(0125137)
|
hgbot
|
2020-12-29 14:12
|
|
|
|
(0125165)
|
hgbot
|
2020-12-30 11:17
|
|
|