check links error in Sales Master 1

[SpeedBWild]

When I ran check links this morning on the sales series I received the following error for several records.
"A record for XXX was removed from the Sales Master Number Setup table: no corresponding record was found in the Sales Transaction History table"

I went to SOP40500 the Sales Master table and the records did not exist. Select * from SOP40500 where NSTRNUMB =xxx

I then went to both the SOP30200 Sales Trans Hist table and the SOP30300 Sales Trans Amt Hist table and the records did exist
Select * from SOP30200 Where sopNumbr=xxx
Select * from SOP30300 Where sopNumbr=xxx

What does this error mean and how do I fix it?

Is there a flag I need to set in a table someplace?

Thank you,

 

[Luvsql]

The master number is one that tracks all documents that are transferred to other types. Are the documents that have the missing master number legit (ie we had the problem if a user was in the middle of entering a document and citrix disconnected therefore leaving an abandonned record)?

 

[SpeedBWild]

Yes, these are good numbers. From the back-end everything looks good. I had the accounting department take a look at the front-end data and everything looks good. Just as a side-note we don't use Citrix. Any ideas?

 

[stef315]

It's basically something like the number was about to be used but then wasn't so it's removing the reference that the number was used. No need to do anything about it as check links already fixed it.

 

[SpeedBWild]

But the numbers are used and they are good numbers? Are you sure I don't need to do anything? We are getting several of these a week.

 

[stef315]

oh, sorry! thanks for clarifying. so you're saying the master number was used in a document and now was removed? if you do an inquiry (Inquiry-Sales-Sales Docs) and pull up the document associated then go into the expansion box next to Document number does the master number show? does it show other documents linked? are the documents linked correctly?

 

[SpeedBWild]

When I go into Inquiry-Sales-Sales Documents, I see the
Doc Type, Type Id, Document #, Customer #, Customer PO #,
Customer Name, Date, Sub Total, Trade Discount, Freight, Misc. Tax, Total and Currency Id. All of these fields have values in them except the Currency Id field. I have compared this record to other and they all look the same.

When I click on the Document number and go into the Sales Transaction Inquiry Zoom screen all of the data from the first screen is populated into this screen. Every things appears to look good.

Any ideas. I am getting several of these error messages every time I run check links on the sales series.

 

[stef315]

Do you have access to Customer or PartnerSource?

If so, you may need to follow KnowledgeBase: Recreating the Sales Master Number Setup Table (SOP40500) (850051).

Let me know if you don't have access and I'll see if I can help you.

 

[SpeedBWild]

I have read the post, it say's to delete SOP40500 is that correct?

 

[stef315]

If that's what it says...

Basically, it's a table of all master numbers used.

 

[SpeedBWild]

I did what the post, Recreating the Sales Master Number Setup Table (SOP40500) (850051), said to do. I delete the SOP40500 table and then ran check links on the sales work and sales history tables in the sales series. I didn't get any error when I ran the sales history table, but I got an error on the sales work table. It stated that 'This file cannot be porcessed while others useres are accessing it.' What I found was that in the dynamics..SY00800 an old record was locked. I delete that record and ran the sales work twice. I am getting a bunch of error messages.

The first set of error came from-
Sales Commissions work and history - these were for quotes, which we are not really concerned about. (according to finance)

Sales Distribution Work and History - two invoice records.
error- a record for invoice XXX was removed from the sales distribution work and history table: not corresponding record was found in the sales transaction work table

Sales taxes work and history - A record for invoice was removed from the sales taxes work and history table: no corresponding record was found in the sales transaction work table ( this did not tell me what invoice)

Sales transaction amount work - these were for the same quotes as listed above.

I thought that maybe this was just the clean up of deleting the SOP40500 table so I ran it again

Now I am getting the following errors:
Sales commissions work and history - one quote and two invoices the invoices are the same two from the previous checklink.

Sales payment work and history - one invoice the same as from the previous checklink

Sales transaction amounts work one quote and three invoices
two of the invoices where from the previous checklink, but there is now a new invoice record in there.

Sales transaction work - one invoice record for the new inovice. The error states 'Totals have been adjusted for document XXXX (Which is the new invoice record)

Sales user-defined work history - one invoice record the same from the previous check links.

At this point I am not sure how to correct the problem.

Any ideas would be appreciated.

Thanks,