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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032114
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2016-02-03 20:502016-03-11 14:04
ReportermalsasuaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR16Q2
StatusclosedFix in branchFixed in SCM revisionfeee81b7cb73
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket40482
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032114: document sequence is repeated when receipts are not processed in backend

Descriptionwhen the receipts are not processed in backend (they are stored in errors while importing window), and the cache of terminal is cleaned, the next document number calculated to the next receipt is repeated
Steps To ReproduceA)
. execute this query in the db:
  update c_bpartner set invoicerule=null where c_bpartner_id = 'ABD91C9D3BC94175B876FBBE9CACA008';
. create a new receipt, add a product, finish it
. verify that in the 'errors while importing data' windows, there is a new error


B)
in backoffice
. close the period, so the receipts will not be processed and they will be stored in errors while importing window

in webpos
. create and paid new receipt (doc no: X)
. create and paid new receipt (doc no: X+1)
. create and paid new receipt (doc no: X+2)
the receipts are synced with backoffice
. clean the terminal cache
. create new receipt: the new receipt is created with the document number: X
Proposed SolutionThere is supposed to be some logic to get the docno from the errors while importing data table
There is a variable that keeps the lastDocumentNumber in the server

This should also be verified for quotations

Test suggestions
  To create the test, implement a try finally block:
    boolean isTestSuccessful = false
    try {
      execute "update c_bpartner set invoicerule = null where c_bpartner_id = 'ABD91C9D3BC94175B876FBBE9CACA008' and name ='"VBS Customer';"
      create a sale with the default VBS Customer
      verify that there is an error in the import table
      restoreDatabase()
      create a new sale
      verify that the docno has increased properly
    } finally {
      if(!isTestSuccessful) {
        restoreDatabase()
      }
    }

    void restoreDatabase() {
      execute "update c_bpartner set invoicerule = 'I' where c_bpartner_id = 'ABD91C9D3BC94175B876FBBE9CACA008' and name ='"VBS Customer'"
    }


Create the same test with quotations
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0084304)
hgbot (developer)
2016-02-18 05:35

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: feee81b7cb73ec2df54bffc852ba21b6bd7c28ca
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Feb 18 10:05:10 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/feee81b7cb73ec2df54bffc852ba21b6bd7c28ca [^]

Fixes issue 32114 : Updating OBPOSError Document No to Last Document no in Terminal

Same applies for Quotation also

---
M src/org/openbravo/retail/posterminal/POSUtils.java
---
(0084305)
hgbot (developer)
2016-02-18 05:36

 Repository: tools/automation/pi-mobile
Changeset: 0673f61ffbb16b42d720e625dc674300140f8fd4
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Feb 18 10:04:32 2016 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/0673f61ffbb16b42d720e625dc674300140f8fd4 [^]

Verifies issue 32114: Added automated test 'I32114_VerifyDocumentNoWithPOSError'

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashmanagement/I31757_CashMgmtTrxDate.java
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/documentno/I32114_VerifyDocumentNoWithPOSError.java
---

- Issue History
Date Modified Username Field Change
2016-02-03 20:50 malsasua New Issue
2016-02-03 20:50 malsasua Assigned To => Retail
2016-02-03 20:50 malsasua OBNetwork customer => Yes
2016-02-03 20:50 malsasua Support ticket => 40482
2016-02-03 20:50 malsasua Triggers an Emergency Pack => No
2016-02-04 17:41 malsasua Resolution time => 1457823600
2016-02-04 17:41 malsasua Severity minor => major
2016-02-05 13:09 Orekaria Steps to Reproduce Updated View Revisions
2016-02-05 13:09 Orekaria Proposed Solution updated
2016-02-05 13:11 Orekaria Proposed Solution updated
2016-02-05 13:11 Orekaria Status new => acknowledged
2016-02-16 08:06 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2016-02-16 08:06 ranjith_qualiantech_com Status acknowledged => scheduled
2016-02-18 05:35 hgbot Checkin
2016-02-18 05:35 hgbot Note Added: 0084304
2016-02-18 05:35 hgbot Status scheduled => resolved
2016-02-18 05:35 hgbot Resolution open => fixed
2016-02-18 05:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/feee81b7cb73ec2df54bffc852ba21b6bd7c28ca [^]
2016-02-18 05:36 hgbot Checkin
2016-02-18 05:36 hgbot Note Added: 0084305
2016-03-11 14:04 marvintm Review Assigned To => marvintm
2016-03-11 14:04 marvintm Status resolved => closed
2016-03-11 14:04 marvintm Fixed in Version => RR16Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker