Microsoft Dynamics GP (Archived)

Duplicate Document Number in SOP

(0) Share

Report

Posted on by Community Member

Hi,

I am encountering a problem where the Invoice and Return of unrelated SOP transactions is the same.

Return transactions are set up to 'Use next number from Fulfillment Order/invoice ID) in Sales Return Setup window.

For some reason I still have an Invoice and Return with the same SOPNUMBE in SOP30200.

Could someone shed some light on this please?

Regards,

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report

What problem is this causing? It isn't that uncommon to have more than one type of transaction under the same SOP number. If you need to you can always filter on SOPTYPE. 3 is an invoice, 4 is a return.

Best regards,

Kirk

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Yep,
Kirk is right. The SOP30200 table's primary key is a combination of the document number and document type. Having different document types with the same number is not restricted. You may want to change your 'next number' settings such that they do not cross.
Kind regards,
Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your replies. there is no issue with the actual duplicate, my only concern is that the Returns are set up to use the next number from Invoice setup.

So why is the number still duplicate?

ref to: receivables doc setup > doc type: returns > 'Use next number from Fulfillment Order/invoice ID' tick box.

regards,

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Hi, why are you going through 'receivables doc setup'??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

for the setup shown above.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (1)

Report

Interesting,

So the document type ID was SOPRETURN for the Return document and the document type ID was SOPINVOICE for the duplicate document number? If yes, it's a good question. This is the kind of thing where a consultant would need to look at the details behind the scenes. I'm with you though, if the setup were like this at the time both documents were created, they shouldn't have the same number.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Leslie,

That's exactly my concern and was wondering if anyone had encountered any similar issue on GP.

thanks

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

How do you enter your invoices. Are they imported or are they typed in by hand. Also, how do you enter returns. Do you use the 'Create Return Document' off of the Additional menu or are they typed in by just changing the document type? I've been trying to make it do this, but it keeps doing it right. Of course, the database doesn't care because it doesn't violate the primary key constraints. This might just be one of those things that stay in the mystery box.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, Invoices are inputted manually, whilst returns are inputted from the same window, just by changing the document type to 'Return'.

The issue happened more than once, and I cannot think of any logical explanation why this could have happened, apart from a partial halting of the system which coincidentally allocated the same document number to two concurrent users at the same time.

Regards,

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Maybe I am not reading this right, but if they are different document types, why is there a concern about them having a 'similar' number. Doesn't the document type make them unique?

Was this reply helpful? Yes No