Orders with same master number

[Borvik]

Hey all,

I'm having some difficulties with Master numbers.

In my web interface, I'm allowing customers to lookup their order history. In order to make things quick, I'm doing lookups via master number.

Today when viewing a customer's history, I noticed that it wasn't their order at all. I've narrowed it down to the fact that it was grabbing the incorrect order - from the master number.

I did a lookup on that master number, and noticed 4 different unrelated orders plus a return. It would appear multiple documents are receiving the same Master number when they should be getting different ones.

Any ideas on how that could happen?

 

[jazgeek]

the only way the interface will give you the same master number is when you transfer a document

ie transfer sales order to invoice with a back order then transfer the backorder back to a sales order then backorder and invoice again and transfer the back order to a sales order

in that case you will get 3 sales orders, 2 backorders and 2 invoices with the same master number


not sure about the return though, might get the same master number if you do a return against an invoice.... worth looking into though.



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

that may be jazgeek - but I'm telling it how it is.

a search of that master number only brought up those four orders, and the return.

and each of those orders was unrelated to the other.

it could be the web interface, i've been working on, but that uses the same stored procedure to grab a master number as GP uses - and the stored procedure increments it when you use it too, so I'm not sure what to think there.

we actually have seen it before I started work on the web interface, but it was rare (still could be rare and I just caught the batch as it happened).

 

[jazgeek]

hrrm.... in sales order processing setup, do you have the checkbox for Track Master numbers checked?

-----------
and they wonder why they call it Great Pains!

jaz

 

[jazgeek]

just for chuckles, can you pull up via inquiry one of your "duplicate master #" documents and hit the expansion button next to the document number and see if the other documents are there?



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

Track Master numbers is indeed checked.

And yes the expansion button from viewing one of the documents does show the other documents as well.

 

[jazgeek]

wow. are you absolutely sure they weren't generated that way on purpose?

if you're posative they weren't generated automatically via transfers, I'd definatetly get a support issue logged with MSGP to get your data looked at.



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

I don't think our salespeople are smart enough to generate them that way on purpose.

And I definately know that they were generated via transfers - looks like I'll have to go with the support incident, just thought I'd try to resolve it here first.

I'll post what I find out - when/if it gets resolved by them.

Thanks jaz.

 

[jazgeek]

sorry.... I'm not sure if you made a mistake in your reply. but if they WERE generated via transfers then they will have the same master number.



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

yup - mistake in my reply they were NOT gerenated by transfers