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
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.
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
