Hi
We have a shipping dashboard but when we compare it to the sales order it has double releases. See attached:
sales order entry
Hi
We have a shipping dashboard but when we compare it to the sales order it has double releases. See attached:
sales order entry
Pull in all the fields in the OrderRel and OrderDtl tables and compare between the duplicates if there is anything different.
Yeah that, but we need to see all that text.
do you have multiple parts in multiple locations or multiple lots.
We actually do have both. We have some in a nonconforming location and then some in the primary bin and yes different lot #'s.
The part bin join would be what Devin is getting at maybe?
yeah that is what i am getting at.
Tanya hasn’t written back so Idk.
sorry i have been gone for a week and now covering for someone at work. i think i figured it out. we have lot tracking and they are two different lot #'s would that be the reason?
lots and bins, yeah.
If there are multiple lots for one part, then it would double.
If there are multiple locations for a part then it would double too.