Payment Selection > Payment Selection Line allows the same invoice to be added several times for payment

Description

Window Payment Selection > Payment Selection Line does permits the same invoice document to be added manually multiple times. I have reconstructed the issue in https://demo.globalqss.com/, payment selection = 2022-10-18 20:42:30.

Environment

None

Linked work items

duplicates

IDEMPIERE-1962

Payment Selection Can Create the Same Invoice Multiple TImes

Activity

Michael Powacht
November 22, 2022 at 12:38 AM

Hi @Elaine Tan ,

many thanks. Solution works as expected based on my tests in my development environment.

Elaine Tan
November 21, 2022 at 10:15 AM

Hi @Michael Powacht ,

I’ve added a new validation rule called 'C_PaySelectionLine Invoice'

include completed/closed invoices
exclude invoices that have been prepared but not paid
exclude invoices that have already been added to the payment selection

I’ve set the 'Dynamic Validation' of Table: C_PaySelectionLine > Column: C_Invoice_ID to 'C_PaySelectionLine Invoice'.

No changes in the code. Please get the migration script from https://github.com/idempiere/idempiere/pull/1574/files

Thanks,
Elaine

Resize issue view side panel

Fixed

Details

Assignee

Elaine Tan

Reporter

Michael Powacht

Due date

Oct 19, 2022

Components

Accounting

Core

Fix versions

Affects versions

Priority

Minor

Created October 19, 2022 at 1:53 AM

Updated January 26, 2025 at 6:18 PM

Resolved November 23, 2022 at 10:06 AM