Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check Links -RM Key File and Sales Payment Work and History

Status
Not open for further replies.

SpeedBWild

Programmer
Apr 29, 2004
117
US
I ran check links on the sales series today and I received 11 errors on the RM Key File and 11 errors on the Sales Payment work and history. The 11 errors from the RM Key File correspond to the 11 errors for the sales payment work and history. All of these are good records. These are the records that have not been posted yet that have payments.

Here are the exact errors for each table:

RM Key File (I believe this is table RM00401)
PYMN000xxxxx: The transaction for this keys record is missing. The key record has been removed.

Sales Payment Work and History (I believe this is table SOP10103)
A record for Invoice XXX was removed from the sales payment work and history table; no corresponding record was found in the RM Key File table.

In both tables the records exist. The only thing I noticed that may be odd is that in the RM00401 table the DSStatus =0 . Everything else in that table looks good. Nothing seems to be out of the ordinary in SOP10103. All of these records were posted this morning after and the post was successful. Any ideas? Is there another table I need to look at?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top