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

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036907

Retail Modules

Web POS

public

2017-09-20 18:07

2017-11-14 17:34

Reporter

ngarcia

Assigned To

ranjith_qualiantech_com

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR18Q1

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

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

Steps To Reproduce

As 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)

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	design defect	0035571	closed	ranjith_qualiantech_com	wrong payment term in sales invoice created from WebPOS using credit
related to	defect	0037343	closed	ranjith_qualiantech_com	Schedule details should also be split when using split payment terms
related to	defect	0037571	closed	ranjith_qualiantech_com	Wrong Payment Plan for a sales invoice with split payment terms paid on credit