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
Try correcting the SOP Type using SQL and then void the invoice.
I wonder if you have solved the issue you are having.
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,
My apologies, no the issue has not been resolved. I will be working with the Sales Work table?
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.
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'.
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?
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,
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???
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
