Invoice with Payment Schedule is not displayed in Invoice Not Realized Gain/Loss

Description

steps to reproduce in Garden World:

  1. Create Invoice Customer with payment term: 50% Immediate - 50% in 30 days (or other payment term with schedule)

  2. Create some lines

  3. Complete it

  4. Run Invoice Not Realized Gain/Loss and fill the params with (for testing purpose only):

    • Accounting Schema: GardenWorld US/A/US Dollar

    • Revaluation Conversion Type: Spot

    • Revaluation Date: today

    • AP - AR: Receivables only

    • Include All Currencies: Yes

    • Currency: USD

    • Revaluation Document Type: Blank

  5. Your invoice with payment schedule is not displayed in the report

Environment

None

Activity

Show:
Anozi Mada
October 28, 2013, 3:58 AM

The problem is C_Invoice_v will break down the invoice's grandtotal based on payment schedule so it fails to fulfill the condition in Line 144

I just change the C_Invoice_v to C_Invoice and now it works.
https://bitbucket.org/anozimada/idempiere-databiz/commits/3958215fae418abba138eb877abc347eb9591b19

Carlos Ruiz
August 22, 2020, 11:03 AM

The issue is reproducible.

The solution suggested by doesn't work because the view C_Invoice_V also changes the sign of the GrandTotal depending on Sales/Purchase.

I found some other bugs when testing this and committed pull request 225

Assignee

Carlos Ruiz

Reporter

Anozi Mada

Labels

Tested By

None

Priority

Minor
Configure