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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036907
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2017-09-20 18:072017-11-14 17:34
ReporterngarciaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityurgentResolutionfixedFixed in VersionRR18Q1
StatusclosedFix in branchFixed in SCM revisionc927513c10e9
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036907: Wrong sales invoice payment plan is created when paying a ticket using credit

DescriptionWrong sales invoice payment plan is created when paying a ticket using credit
Steps To ReproduceAs group admin role:
   Create a new record in Payment Terms:
      Overdue Payment Days Rule: 90
   Add two lines to it:
      1. Percentage Due: 33.33
         Overdue Payment Days Rule: 30
         Rest: N
      2. Percentage Due: 33.33
         Overdue Payment Days Rule: 60
         Rest: N
   Create a Business Partner, set it as Customer, add a price list and the previously created Payment Term
   Assign a credit limit of 10000 to it
   Set Allow Pay on Credit to 'Y' in POS Terminal Type window
   Set a product price in the business partner price list to 508.01

EXAMPLE 1:
In the POS:
   Change to previously created customer
   Add the product with a price of 508.01
   Add a payment of 300 to the ticket
   Use Credit for the rest (208.01)

In the backend:
   Check the created sales invoice has two payment plans (wrong):
      1. Due Date: 19-11-2017
         Expected Date: 38.64
         Received Amount: 0.00
         Outstanding Amount: 38.64

      2. Due Date: 19-12-2017
         Expected Date: 169.37
         Received Amount: 300
         Outstanding Amount: 169.37

   Reactivate and complete the invoice again
   Check three payment plans are created this time:
      1. Due Date: 20-10-2017
         Expected Date: 169.32
         Received Amount: 169.32
         Outstanding Amount: 0

      2. Due Date: 20-11-2017
         Expected Date: 169.32
         Received Amount: 130.68
         Outstanding Amount: 38.64

      3. Due Date: 19-12-2017
         Expected Date: 169.37
         Received Amount: 0
         Outstanding Amount: 169.37

EXAMPLE 2:
In the POS:
   Change to previously created customer
   Add the product with a price of 400
   Add a payment of 100 to the ticket
   Use Credit for the rest (300)
In the backend:
   Check the created sales invoice has three payment plans (see attachment wrongPaymentPlanExample2.png):
      1. Due Date: 15-11-2017
         Expected Amt: 33.32 (wrong, it should be 133.32)
         Received Amount: 0.00 (wrong, it should be 100)
         Outstanding Amount: 33.32

      2. Due Date: 15-12-2017
         Expected amt: 133.32
         Received Amount: 0
         Outstanding Amount: 133.32

      3. Due Date: 14-01-2017
         Expected Date: 133.36
         Received Amount: 100 (wrong, it should be 0)
         Outstanding Amount: 133.36
  Reactivate and complete the invoice again: the payment plans are regenerated with correct values. See attachment rightPaymentPlan2.png

  Go to Payment In window:
    . create new record to previous business partner, and selecting the correct financial account
    . click in "Add Details": previous invoice is displayed, but only one payment detail (see attachment wrongPaymentInDetails.png)
Three details should be displayed to this invoice (see attachment rightPaymentInDetails.png)
TagsNo tags attached.
Attached Filespng file icon wrongInvoicePaymentPlanExample2.png [^] (177,267 bytes) 2017-10-16 18:53


png file icon rightInvoicePaymentPlanExample2.png [^] (174,183 bytes) 2017-10-16 18:53


png file icon wrongPaymentInDetailsExample2.png [^] (176,701 bytes) 2017-10-16 18:54


png file icon righPaymentInDetails.png [^] (190,382 bytes) 2017-10-16 18:54

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0035571 closedranjith_qualiantech_com wrong payment term in sales invoice created from WebPOS using credit 
related to defect 0037343 closedranjith_qualiantech_com Schedule details should also be split when using split payment terms 
related to defect 0037571 closedranjith_qualiantech_com Wrong Payment Plan for a sales invoice with split payment terms paid on credit 

-  Notes
(0100009)
hgbot (developer)
2017-10-24 09:24

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 3393f965bba2ec6aedaeeb5d8426b78ec614e605
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Oct 24 12:42:57 2017 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3393f965bba2ec6aedaeeb5d8426b78ec614e605 [^]

Fixed issue 36907 : Updated OrderLoader to validate PaymentTermLine

* Create Payment Schedule based on Customer Payment Term and lines

---
M src/org/openbravo/retail/posterminal/OrderLoader.java
---
(0100010)
hgbot (developer)
2017-10-24 09:25

 Repository: tools/automation/pi-mobile
Changeset: e61b84638494c43b82abc8351ac65ace875d71d9
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Oct 24 12:43:04 2017 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/e61b84638494c43b82abc8351ac65ace875d71d9 [^]

Verifies issue 36907 : Added automated test 'I36907_VerifyReceiptWithPaymentTermLine'

Modified test 'I35571_VerifyReceiptWithMutiPaymentTerm'
Modified test 'I31471_PayLayawayAlreadyInvoiced'
Modified test 'I31600_VerfiyPaidOnCredit'

---
M src-test/org/openbravo/test/mobile/retail/pack/database/WebPOSDatabaseConstants.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/layaway/I31471_PayLayawayAlreadyInvoiced.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31600_VerfiyPaidOnCredit.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I35571_VerifyReceiptWithMutiPaymentTerm.java
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I36907_VerifyReceiptWithPaymentTermLine.java
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I36907_VerifyReceiptWithPaymentTermLineII.java
---
(0100491)
hgbot (developer)
2017-11-13 15:23

 Repository: tools/automation/pi-mobile
Changeset: c927513c10e9ab0eda3463cf4e8a8edd5341a6d4
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Thu Nov 09 11:24:07 2017 -0500
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/c927513c10e9ab0eda3463cf4e8a8edd5341a6d4 [^]

Related to Fixed issue 36907 : Updated OrderLoader to validate PaymentTermLine

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I36907_VerifyReceiptWithPaymentTermLineII.java
---

- Issue History
Date Modified Username Field Change
2017-09-20 18:07 ngarcia New Issue
2017-09-20 18:07 ngarcia Assigned To => Retail
2017-09-20 18:07 ngarcia Resolution time => 1507672800
2017-09-20 18:07 ngarcia Triggers an Emergency Pack => No
2017-09-20 18:08 ngarcia Relationship added related to 0035571
2017-09-20 18:08 ngarcia Issue Monitored: networkb
2017-09-21 16:03 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2017-09-21 16:03 ranjith_qualiantech_com Status new => scheduled
2017-10-16 18:52 malsasua Steps to Reproduce Updated View Revisions
2017-10-16 18:53 malsasua File Added: wrongInvoicePaymentPlanExample2.png
2017-10-16 18:53 malsasua File Added: rightInvoicePaymentPlanExample2.png
2017-10-16 18:54 malsasua File Added: wrongPaymentInDetailsExample2.png
2017-10-16 18:54 malsasua File Added: righPaymentInDetails.png
2017-10-24 09:24 hgbot Checkin
2017-10-24 09:24 hgbot Note Added: 0100009
2017-10-24 09:24 hgbot Status scheduled => resolved
2017-10-24 09:24 hgbot Resolution open => fixed
2017-10-24 09:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3393f965bba2ec6aedaeeb5d8426b78ec614e605 [^]
2017-10-24 09:25 hgbot Checkin
2017-10-24 09:25 hgbot Note Added: 0100010
2017-10-26 18:59 egoitz Issue Monitored: egoitz
2017-10-30 11:28 marvintm Review Assigned To => marvintm
2017-10-30 11:28 marvintm Status resolved => closed
2017-10-30 11:28 marvintm Fixed in Version => RR18Q1
2017-11-13 15:23 hgbot Checkin
2017-11-13 15:23 hgbot Note Added: 0100491
2017-11-13 15:23 hgbot Status closed => resolved
2017-11-13 15:23 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3393f965bba2ec6aedaeeb5d8426b78ec614e605 [^] => http://code.openbravo.com/tools/automation/pi-mobile/rev/c927513c10e9ab0eda3463cf4e8a8edd5341a6d4 [^]
2017-11-14 17:34 marvintm Status resolved => closed
2017-11-23 12:40 ranjith_qualiantech_com Relationship added related to 0037343
2018-01-02 18:36 ngarcia Relationship added related to 0037571

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker