Ax SP3 bug on checkSalesQty method of SalesTableType Class?

pedroparra
pedroparra Member Posts: 58
edited 2007-03-24 in Dynamics AX
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!

Comments

  • pedroparra
    pedroparra Member Posts: 58
    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.