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
