Jeff,
Thanks for the reply.
With the processing of work orders by multiple registers at the same time; how can I correct the data for the 11 work orders that I have identified? I would think that the inventory movement doubled. I would also think that the "redeemed deposits" might also be misstated.
Can a custom key be created that the user could click prior to tendering the sale that would hit the database to determine if the work order was still open? While not the greatest solution, it might close the windows a little bit on the time frame that allows the problem to occur.
Any help, advise, or information would be greatly appreciated.
Thanks, Terry
"Jeff @ Check Po> Terry,
> As far as your deposit pickups at the same time, this is a bug/design flaw
> that MDR refuses to fix. The issue is that there is nothing in the
> program that if one register is working with deposits/sales/holds that
> stops another register working on the _same_ deposits/sales/holds. We had
> that worked out in our own designed program over 20 years ago.
>
> --
>
> Jeff
> Check Point Software
>
> "PGC_Developer" wrote in
> message news: snipped-for-privacy@microsoft.com...
>
> I have found, in our existing data, 11 work orders from
> last year that were invoiced twice on separate registers using the same
> single deposit as the tender. One of those 11 sales transactions > appears to
> have occurred at exactly the same time on two different registers. The > others
> are all within minutes/seconds of each other. I have looked in the > journal
> batches to verify this and journaled receipts were found in their > respective
> batches.
>
> How is this possible? My assumption (love that word!) is that a work > order
> can only be filled once and that a deposit on a work order can also only > be
> used once during the sales transaction tending process. Can multiple > people
> be working on processing the work order at the same time? If so, > shouldn't
> there be something in place to prevent this from happening?
>
> Our situation is that work orders get filled in groups. Work orders X > thru
> Y are "picked" and prepared for shipping at the same time. At that > point it
> is reported back to the office that they have been picked and are ready > to be
> invoiced. At that point two people on different registers start recall > the
> work orders and generate the respective invoice. Is it possible that > both
> people got "in sync" with each other while processing? Is it possible > that
> the system allows for the commital of the invoice without "knowing" that
> someone else is also process the invoice at that time? Shouldn't the > system
> check the current status of a workorder prior to the commital of the > invioce? >
> Did we just stumble in to a big logic hole?
>
> Any info would be greatly appreciated.
>
> Thanks,
> Terry