using the Order Entry

[Guest]

I downloaded the Order Entry database. The Problem is say for example: I have
a Dealer that calls in a order at 8:00am and I process that order by 10:00am
then at 2:00 Pm he calls and orders the same exact thing. basically a
duplicate order. just a different shipping address. If I enter payments and
mark as paid when I view the Receivables aging report it will show one order
as not being paid.
How do I fix this?

 

[Guest]

when I say duplicate Orders I mean all info including shipdates and all. Some
of my Customers have up to 30 different stores and they may Place the same
exact order for say 20 stores but with different Invoice#'s and shipping
Options
I have added a [Invoice#] to my Order form and Order Table if this helps.
Thank you in advance.

 

[Guest]

Alvin:

Not being familiar with the db, I would suggest you look at the design of
the aging report. There is probably something in the base query that can be
modified to recognize a distinction between the 2 orders, and the 2 payments.


It sounds like the query comparing payments against receivables may be
assuming a single order/day. So you may need to bring Order#, or your
Invoice# into the data mix.

Good luck.

Sharkbyte

when I say duplicate Orders I mean all info including shipdates and all. Some
of my Customers have up to 30 different stores and they may Place the same
exact order for say 20 stores but with different Invoice#'s and shipping
Options
I have added a [Invoice#] to my Order form and Order Table if this helps.
Thank you in advance.

I downloaded the Order Entry database. The Problem is say for example: I have
a Dealer that calls in a order at 8:00am and I process that order by 10:00am
then at 2:00 Pm he calls and orders the same exact thing. basically a
duplicate order. just a different shipping address. If I enter payments and
mark as paid when I view the Receivables aging report it will show one order
as not being paid.
How do I fix this?