Hi does anyone have any ideas why the following item cannot be closed in AX 4.0 SP1. Pasted below is the ValueOpen=Yes transactions (can cut and paste the text into excel I believe to get nicely formated).
No dimensions are ticked for financial inventory and warehouse is ticked as physical To me there is enough Qty that can be settled I am thinking maybe AX does some kind of rounding in the closing such that there is 0.01 short of qty and so it decides cannot close. I am little concerned that the SQL data is not rounded on the QtySettled field (I assume thsi is the filed AX uses during closing to work out the open qty of a transaction) Or maybe it is something to do with a Transfer being the last transaction? Thanks James Warehouse Physical date Financial date Reference Receipt Issue Quantity AX Settled quantity AX OpenQty SQL QtySettled SQLOpenQty 43701 10/9/2007 10/9/2007 Transfer Purchased 1 0.93 0.07 0.933333330 0.066666670 4156 10/10/2007 10/10/2007 Transfer Purchased 1 0.75 0.25 0.750000000 0.250000000 45201 11/7/2007 11/7/2007 Sales order Purchased 1 0.83 0.17 0.833333340 0.166666660 45201 11/7/2007 11/7/2007 Sales order Purchased 1 0.5 0.50 0.500000000 0.500000000 45201 11/7/2007 11/7/2007 Transfer Sold -2 45211 11/7/2007 11/7/2007 Transfer Purchased 2 0.98 1.02 0.983333330 1.016666670 4 3.99 2.01 4.000000000 2.000000000