Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0041317 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Localization Pack: Spain] SII Retail | major | always | 2019-07-08 17:46 | 2020-12-30 11:17 | |||
| Reporter | psanjuan | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| 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 | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| 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) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Simplified_Invoice.jpg [^] (67,482 bytes) 2020-12-14 12:43
Invoice.jpg [^] (66,829 bytes) 2020-12-14 12:45
Reverse Simplified Invoice.jpg [^] (81,176 bytes) 2020-12-14 12:55
Reverse Invoice.jpg [^] (71,233 bytes) 2020-12-14 12:56
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0121291) psanjuan (manager) 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 (manager) 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 (manager) 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 (developer) 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 (developer) 2020-12-15 20:41 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail/-/merge_requests/1 [^] |
|
(0125130) psanjuan (manager) 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 (manager) 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 (manager) 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 |
|
(0125133) psanjuan (manager) 2020-12-29 11:29 |
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) |
|
(0125134) psanjuan (manager) 2020-12-29 11:56 |
Test Plan executed successfully. Issue can be closed. |
|
(0125135) hgbot (developer) 2020-12-29 12:13 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail [^] Changeset: 54fadd602fadb19ae598ef1f79a87616a661e296 Author: Atul Gaware <atul.gaware@openbravo.com> Date: 2020-12-16T00:03:54+05:30 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail/-/commit/54fadd602fadb19ae598ef1f79a87616a661e296 [^] Fixes BUG-0041317: Correct "Clave de Tipo de Factura" needs to be assigned to the invoices, once Invoicing improvementes are implemented in POS **When a Simplified sales invoice is created, set Invoice Type Key as "Simplified Invoice". **When a Simplified Invoice is returned, set the correct Rectification Reason as "R5 - Simplified Invoice". --- M src/org/openbravo/module/sii/retail/hook/SIIOrderLoaderHook.java --- |
|
(0125136) hgbot (developer) 2020-12-29 12:13 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail/-/merge_requests/1 [^] |
|
(0125137) hgbot (developer) 2020-12-29 14:12 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail [^] Changeset: d44ef6936874e0ae447821d3a0cf4ce4b405515c Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com> Date: 2020-12-29T14:12:02+01:00 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail/-/commit/d44ef6936874e0ae447821d3a0cf4ce4b405515c [^] Related to BUG-0041317: Update module version --- M src-db/database/sourcedata/AD_MODULE.xml --- |
|
(0125165) hgbot (developer) 2020-12-30 11:17 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail [^] Changeset: 18bfd9aff629b49b772bbbe905846277931915d4 Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com> Date: 2020-12-30T11:16:43+01:00 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii.retail/-/commit/18bfd9aff629b49b772bbbe905846277931915d4 [^] Related to BUG-0041317: Update dependency to 20Q3 --- M src-db/database/sourcedata/AD_MODULE.xml M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml --- |
|
Notes |
|
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 | View Revisions |
| 2020-07-07 10:07 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 16:28 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 16:55 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 16:56 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 17:01 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 17:15 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 17:16 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 17:45 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-07 17:45 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-08 16:13 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-08 16:22 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-14 17:46 | psanjuan | Proposed Solution updated | |
| 2020-07-14 17:46 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-07-14 17:47 | psanjuan | Note Edited: 0121291 | View Revisions |
| 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 | View Revisions |
| 2020-12-14 15:21 | psanjuan | Note Added: 0124809 | |
| 2020-12-14 15:21 | psanjuan | Note Edited: 0121291 | View Revisions |
| 2020-12-14 15:23 | psanjuan | Note Edited: 0124809 | View Revisions |
| 2020-12-14 15:29 | psanjuan | Note Edited: 0124809 | View Revisions |
| 2020-12-14 15:33 | psanjuan | Note Edited: 0124809 | View Revisions |
| 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 | View Revisions |
| 2020-12-29 09:55 | psanjuan | Note Edited: 0124840 | View Revisions |
| 2020-12-29 09:59 | psanjuan | Note Added: 0125130 | |
| 2020-12-29 10:00 | psanjuan | Note Edited: 0125130 | View Revisions |
| 2020-12-29 10:02 | psanjuan | Note Edited: 0125130 | View Revisions |
| 2020-12-29 10:02 | psanjuan | Note Edited: 0125130 | View Revisions |
| 2020-12-29 10:12 | psanjuan | Note Added: 0125131 | |
| 2020-12-29 10:13 | psanjuan | Note Edited: 0125130 | View Revisions |
| 2020-12-29 10:13 | psanjuan | Note Edited: 0125131 | View Revisions |
| 2020-12-29 10:27 | psanjuan | Note Added: 0125132 | |
| 2020-12-29 11:22 | psanjuan | Note Edited: 0125132 | View Revisions |
| 2020-12-29 11:22 | psanjuan | Note Edited: 0125132 | View Revisions |
| 2020-12-29 11:28 | psanjuan | Note Edited: 0125132 | View Revisions |
| 2020-12-29 11:28 | psanjuan | Note Edited: 0125132 | View Revisions |
| 2020-12-29 11:29 | psanjuan | Note Added: 0125133 | |
| 2020-12-29 11:55 | psanjuan | Note Edited: 0125131 | View Revisions |
| 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 | View Revisions |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |