The real problem is that you are talking about a custom report. No one really knows exactly how your inventory days is calculated.
First I would ask if the transaction is failing in both systems or just the 'new' one.
If just th new one, is there any chance when you split your systems, you changed the batch level in the new one?
When you uploaded your inventory did all the relevant dates get updated? Without knowing the calculation being done for that column and the actual database fields used, it is hard to know.
For instance: you could be doing the calculation based on current date minus batch creation date. Or you could be doing it as current date - last GR date. But since that might be inaccurate due to the possibility of multiple receipts, my guess is that the calculation is based on the material document using a 101 movement type. Since you split the system, you might have loaded the inventory with 561 movement types. As such, you have no material document to base the calculation on. if you start seeing days in inventory for new batches, then this is probably the problem.
But a programmer should be able to help you determine this. Deciding on a solution could be a much more difficult issue.
FF
