Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Rafael Guerrero]

All: I have a highly technical issue with an invoice. An issue occurred during the posting of the invoice and it is now in limbo.  The order is in the history table, sop30200, but the invoice is in the order work table, sop10100. I ran sales edit list report, where is shows some parts are missing serial numbers.  I queried the IV00200 and they are in fact missing. 

At this point, my suspicions is that  we need to get the serial numbers back into the iv00200 table so that the posting can proceed. Anyone on this forum have an idea how to do this without having to execute a manual SQL statement? Or if SQL is the only route, what other tables should get updated?

Best,

Rafael Guerrero
Gnnovation, Inc.

——————————
Rafael Guerrero
Gnnovation, LLC.
plano TX
——————————

[Neil Vidt]

Rafael,
Check the SOP10201 (Serial Lot work and History Table for SOP) table for the order number in the SOP10100 that you are having issues with.  It could be the order in the line in the SOP10201 did not flop to an invoice when it was transferred.  If that is the case update the record to the correct invoice (SOPNUMBE) number and SOPTYPE.
Good luck,
Neil

——————————
Neil Vidt
Database Analyst 2
Dynavox Technologies
Pittsburgh PA
——————————
——————————————-

[Chris Donnelly]

Rafael,

You can try running checklinks on the sales and inventory tables (in a test company first) to fix the corruption.  But, I’m quite sure this won’t fix it.  This should confirm your question that someone will need to write some SQL scripts to fix it.

As far as finding the tables to update…   Victoria Yudin’s site is an awesome reference.  But, you don’t want to give this task to anyone who doesn’t already know the tables.  Your partner should be able to deal with this if you don’t have the skill on staff.

This is a fairly common issue.  Good luck!

Chris

——————————
Chris Donnelly
Sr Mgr of Info Systems and Financial Reporting
Healthmark Industries
——————————
——————————————-

[Jeff Strait]

I would run Checklinks first. before messing in SQL.
Jeff

——————————
Jeff Strait
Ideal Deals, LLC dba Ideal Aluminum Products
St. Augustine FL
——————————
——————————————-