Page 1 of 2 1 2 >
Topic Options
#34044 - 11/28/12 08:49 AM Duplicate Order number allowed?
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
We posted an order twice and billed the customer twice. No error message came up during posting. Is that a new feature that allow posting an order more than once now? Please clarify. Thanks.

Top
#34047 - 11/28/12 09:01 AM Re: Duplicate Order number allowed? [Re: Fong]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(205.172.16.190)
Hello Fong,

You can produce multiple invoices from an order. You may be able to add lines to an existing order (depends on profile setting). You can never have a duplicate invoice number or order number. Nothing has been changed in OrderEntry in this regard for many years.
_________________________
Andrew Bates

Top
#34050 - 11/28/12 09:17 AM Re: Duplicate Order number allowed? [Re: Retired_Guy]
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
Thank you Andrew.

We accidently posted an order twice (the branch sent us 2 copies of the same order)in a same batch and we produced 2 invoices to that order. In the past, if we enter a order number twice, even in the same batch, error message would popped up. In this case, no warning.

Top
#34055 - 11/28/12 12:57 PM Re: Duplicate Order number allowed? [Re: Fong]
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
Just a glitch may be?

Top
#34056 - 11/28/12 01:06 PM Re: Duplicate Order number allowed? [Re: Fong]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(205.172.16.190)
Hello Fong,

If your data passes the integrity check, then it is impossible to have two orders or invoices with the same document number in OrderEntry.

If you are saying that an order was entered twice from the same purchase order received from your customer, then this is possible but the orders will have different numbers (as will the invoices). You can check for this condition in OrderEntry by an option in the company profile (System Options - Check for duplicate reference).
_________________________
Andrew Bates

Top
#34060 - 11/28/12 02:09 PM Re: Duplicate Order number allowed? [Re: Retired_Guy]
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
Integrity check has no error in DataCare.
Sorry my English is not too good so I will attach a screenshot for you to see.


Attachments
A71157.PNG (94 downloads)


Top
#34062 - 11/28/12 02:15 PM Re: Duplicate Order number allowed? [Re: Fong]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(74.198.164.254)
Oh. Two invoices from one order. That's OK (think partial shipments). If you check the order, you should find a line to support each invoice line.
_________________________
Andrew Bates

Top
#34078 - 11/29/12 09:35 AM Re: Duplicate Order number allowed? [Re: Retired_Guy]
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
The exact same sales order form was sent twice to the office, and was entered twice in error in the same invoicing batch. Normally, once a sales order is posted the first time, if someone tries to enter in another order using the same order number, an error message pops up preventing a duplicate entry. It didn't happen this time. It allowed us to post the exact same order (same line items, same order number, same customer) twice in full.

It was not a partial order or anything of the like.

Top
#34084 - 11/29/12 11:31 AM Re: Duplicate Order number allowed? [Re: Fong]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(205.172.16.190)
Do you manually enter your order numbers or have the system automatically assign them?
_________________________
Andrew Bates

Top
#34116 - 11/30/12 08:53 AM Re: Duplicate Order number allowed? [Re: Retired_Guy]
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
We enter order numbers manually.

Top
#34143 - 11/30/12 04:10 PM Re: Duplicate Order number allowed? [Re: Fong]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11640
Loc: Vancouver, BC Canada
(184.70.7.174)
Hi fong,

The image you attached earlier is from the Invoice grid, and it is possible to have multiple invoices associated with the same order. Though I notice that the Order Date is different for both of the invoices on this screen, it is possible to edit an existing order and change the date when posting the second invoice. To assist further, an image of the Order grid and the duplicated order records would help.

I cannot enter a duplicate order number in OE by typing an order number that already exists in either the Current or Historical list of orders. In either case, I correctly get an error that the order number is already on file. So if you indeed have 2 order numbers duplicated in the order list (and the integrity check is clean), then we'd need to know how you get orders into your system. Something funky and unexpected has occurred and know the precise steps is required. I presume they are not imported based on the discussion. Did different people enter the 2 orders?
_________________________
Regards,
Softrak Tech Support

Top
#34166 - 12/03/12 08:05 AM Re: Duplicate Order number allowed? [Re: Softrak Support]
Fong Offline
Adagio Ace

Registered: 09/11/06
Posts: 201
Loc: Canada
(209.121.78.108)
Quote:
Yes, we know that we can create multiple invoices for the same oder, but in this case I did not edit the 1st order. This order was entered & invoiced twice(by same person) yes the date is different it shouldn’t make a difference. It never posted the same order before.

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
1 registered (Brian_Shead), 223 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1873 Members
5 Forums
14553 Topics
71030 Posts

Max Online: 432 @ 01/20/25 10:17 PM
October
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31