We're updating the issue view to help you get more done. 

Performance improvement of MInOut.prepareIt() method.

Description

Hi,

I am Hideaki Hagiwara in Japan.
I found a performance improvement point in MInOut.prepareIt() method.

In spite of a check of the credit limit is unnecessary,
MBPartner.getNotInvoicedAmt(getC_BPartner_ID()) is performed at MInOut.prepareIt() method.

Please, confirm the patch.

And Calculation cost of MBPartner.getNotInvoicedAmt(getC_BPartner_ID()) rises if Sales Order become many data.

So,I think that We have better to add index at Bill_BPartner_ID column in C_Order Table.

Best regards.

Environment

None

Status

Assignee

萩原秀明(Hideaki Hagiwara)

Reporter

萩原秀明(Hideaki Hagiwara)

Labels

Tested By

None

Affects versions

iDempiere HEAD

Priority

Minor