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
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
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???
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,
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?
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'.
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, no the issue has not been resolved. I will be working with the Sales Work table?
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,
I wonder if you have solved the issue you are having.
Try correcting the SOP Type using SQL and then void the invoice.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156