Crystal Report showing wrong data

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?

 

Thanks!!

 

  •  

    Hi Candice, 

    I guess Crystal report programmer has not considered bin quantity, instead he taken warehouse i mean site. 

     

    Regards,

Related
Recommended