Ax SP3 bug on checkSalesQty method of SalesTableType Class?

pedroparra

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!

pedroparra

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.