RE: Inventory items and serial numbers not available after void of sales invoice
I have read once an interesting article by Mr. Marian Gomez, about Sales Order Processing posting statuses. Different posting status is assigned to the record throughout the posting process, and the 508 status indicates "PSTGSTUS is assigned the value of 508 while GP is is in the process of transferring the record from Work (SOP10100) to History (SOP30200)." quoted
I do believe there has been some sort of posting interruption which resulted with the situation you described above. In this essence, I would like to ask about how you proceeded to correct, you said "an invoice was voided" ? Sales transaction entry can not be voided, it is reversed through Return entry.
Further hopeless correction criteria would be to reconcile your inventory first, is it the one you tried out ? If no suitable outcome, move on for what's mentioned below.
Apparently, you might need to take a backup, and dig in for some database level correction since neither the reconciliation nor the check links worked out.
- IV10002: in this table, you will find the available serial number for these items. Apparently, these serial numbers will be missing, as they have been moved to history through the posting
- SOP10201: check the sales serial work and history
- IV10200 and IV10201 to check the cost layers, and whether the sales transaction affected these tables correctly.
- SOP30200 Sales transaction history
In case you don't have such sufficient technical knowledge with Dynamics GP table, I do believe you need to discuss this with your partner as it is not an easy case to handle.
Your feedback is highly appreciated,
Share
Report
All responses (
Answers (
32,738
