Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Document ID and SOP Type different

Posted on by 2

We have a document where the document ID is 'return' and the SOP type is 'invoice'. How can this be corrected, I cannot void because the type/type id is not consistent.

*This post is locked for comments

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Document ID and SOP Type different

    When you say remove the 'Type ID', I guess you are referring to remove it from the invoice which you want to void.

    If this is the case, once you correct the invoice in SOP10100 table with the right 'Type ID' you should be able to void the invoice using the Sales Transaction Entry window.

    Thanks

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Document ID and SOP Type different

    We don't use serial numbers, actually the document had no line items. I think the user realised what happened before inputting anything. 

    That's why I would prefer removing the type id, it does not appear to have any impact on anything???

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Document ID and SOP Type different

    I would advice to leave the posted transactions as is, nothing wrong with them except for the serial number.

    The most important thing is that future transactions will be assigned to the new correct document type and ID.

    Let us know if you need any further assistance,

  • Verified answer
    Rosemary Profile Picture
    Rosemary 2 on at
    RE: Document ID and SOP Type different

    I tried this and it worked in the test environment, but I would like to remove the 'type id'.

    I am hoping this error does not occur again, so I would like to remove the inconsistent 'type id', but I can't because it is seeing a transaction.

    Do I remove the transaction history?

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Document ID and SOP Type different

    My apologies for the late response, just to make sure I understand, since document types are 'predefined', all that is necessary would be to create a 'type id' for the 'return'.  

    So the 'type id' for this return will be 'sopinv'.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Document ID and SOP Type different

    As Mahmoud mentioned, Document Type and Document Type ID are 2 different fields.

    It will be easier to help you if you attach a screenshot of the Sales Transaction Entry window showing the above fields in this post.

    P.S. The table that stores Document Type & Document Type ID is SOP10100.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Document ID and SOP Type different

    My apologies, no the issue has not been resolved. I will be working with the Sales Work table?

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Document ID and SOP Type different

    Nothing more valuable to add up, I just would like to keep draw your attention that document id and type are two different things. Document types are "predefined" in Dynamics GP while IDs can be defined on the type level.

    In this essence, under the predefined "invoice" type, you may have several document IDs such as "Manual", "INV" ...etc

    Create a new document ID and make sure to get rid of the old "return".

    Your feedback is highly appreciated,

  • Verified answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Document ID and SOP Type different

    I wonder if you have solved the issue you are having.

  • Verified answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Document ID and SOP Type different

    Try correcting the SOP Type using SQL and then void the invoice.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans