0033744: Module script required to fix wrong data created by 33671

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0033744

Retail Modules

Web POS

public

2016-08-18 17:26

2016-09-19 18:22

Reporter

guilleaer

Assigned To

mario_castello

Priority

normal

Severity

trivial

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

RR16Q4

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0033744: Module script required to fix wrong data created by 33671

Description

Module script to fix data is required

Wrong data PSD should be updated. You can reuse module script UpdateBpPaymentLine.
It's recommended to modify the update queries to filter by isinvoicepaid = 'N', so it performs faster:

update fin_payment_scheduledetail psd
set c_bpartner_id = (select c_bpartner_id from c_invoice i, fin_payment_schedule ps
                     where ps.fin_payment_schedule_id = fin_payment_schedule_invoice
                     and ps.c_invoice_id = i.c_invoice_id)
where c_bpartner_id is null and fin_payment_schedule_invoice is not null and isinvoicepaid = 'N';

update fin_payment_scheduledetail psd
set c_bpartner_id = (select c_bpartner_id from c_order o, fin_payment_schedule ps
                                                     where ps.fin_payment_schedule_id = fin_payment_schedule_order
                                                     and ps.c_order_id = o.c_order_id)
where c_bpartner_id is null and fin_payment_schedule_order is not null
and fin_payment_schedule_invoice is null and isinvoicepaid = 'N';

Steps To Reproduce

N/A

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0033671		closed	mario_castello	Retail Modules	FIN_PaymentScheduleDetail created from POS doesn't include the Business Partner
related to	defect	0035377		closed	aferraz	Openbravo ERP	Modulescript required to fix data related with issue 33776