If this needs to go in the technical forum, somebody please let me know!
We are using Dynamics GP 10 and Crystal Reports 11
We have an inventory report that we use in Crystal Reports and it is showing item quantities in bins that aren't actually there in GP.
For instance, I have item number abc123 and I have 57. GP shows that I have 25 in bin 1 and 32 in bin 2 (which is correct). But the crystal report is showing that I have 25 in bin 1, 32 in bin 2, and 25 in bin 3 (not correct).
Does anyone know why this would happen and what I can do to fix it?
I guess Crystal report programmer has not considered bin quantity, instead he taken warehouse i mean site.