mibuso.com

Hi all,

Some users were complaining about long delays when pressing the POSTING button on Sales Forms.

Looking around I saw that the delay was in the checkSalesQty method of SalesTableType Class.

I have read in another forum that the problem is a bug with SP3 in the following lines of code:

while select salesLine
index hint SalesStatusIdx
where salesLine.salesId == salesTable.salesId
&& (salesLine.salesStatus != SalesStatus::Invoiced &&
salesLine.salesStatus != SalesStatus::Canceled)
|| (salesLine.SalesDeliverNow < 0)

the (||) causes to lost the salesTable.salesId filter.

Can the following code be a proper solution for this bug?

while select salesLine
index hint SalesStatusIdx
where salesLine.salesId == salesTable.salesId
&& ((salesLine.salesStatus != SalesStatus::Invoiced &&
salesLine.salesStatus != SalesStatus::Canceled)
|| (salesLine.SalesDeliverNow < 0))

Thank you!

The perfomance of the POSTING has improved greatly in our system solving this bug.

Everyone with Axapta SP3 should look to check if they have this same bug.