Dynamics Community Forum Thread Details

"Record added by Check Links" in SY00500 After running Check Link

Let's summarize

You ran checklinks and some batches were added with the batch comment 'Record added by Check Links'
Some batches will not post.
The batches DO include transactions
The posting error returned is 'You cannot enter transactions for a date that isn't within a fiscal year'
You have printed Edit Lists on those batches and no errors were reported (neither on the batch nor any transactions)
You are posting by batch date and the date on the batch is 2018
The transaction date on the individual entries is 2018
The 2018 year has been created and the January 2018 period is open
The 2017 GL year is not closed.

What's next?

Did you run reconcile on the batches in the Financial, Sales and Payables modules? Batch reconciliation is in the Utilities pane of the corresponding Area Page.
Using SQL Server Studio Manager, I would look at the raw data in the SY0500 table.
Look at the POSTDT field and make sure no strange looking dates are present.
Each one of the batches should have a date in 2017 or 2018, also let us know if any of them have a date of 1900-01-01 00:00:00.000.
Look at the BCHSTTUS field of each batch, you want the value to be 0. If it is not, please let us know what it is.
Look at the NUMOFTRX, to determine how many transactions are in the batch.
For your problem batches, look at the BCHSOURC field. That field will reveal to you from which module the transactions originated.
There is a relationship between the BCHSOURC field and the SERIES field. Here's the relationship

- If 0 then This batch is a problem. You should change this number to match the BCHSOURC. If those fields are blank then there is a problem with the batch.
- If 1 then All (I've never seen this one)
- If 2 then Financial - these are in GL10000 table
- If 3 then Sales - these are in RM10201, RM10301 or SOP10100. Look at the value in the SOP10100.SOPTYPE field. Only transactions that contain 3 or 4 can post.
- If 4 then Purchasing - these are in PM10000, PM10200, PM10300, PM10400, POP10100, POP10107 or POP10300,
- If 5 then Inventory - these are in IV10000
- If 6 then Payroll - these are in UPR10302
- If 7 then Project - I don't know this one
- If 10 then a 3rd Party (this isn't in the SY022008. Look at the DOCDATE (ReceiptDate for POP10300) field of each transaction and make sure it is in January 2018.

I think if you work through these steps, you can identify the problems.

You mentioned the batches were added by Check Links. On which module or modules did you include in your Check Links?

If you can't find any of the Batch IDs, download a free SQL search tool from Apex called ApexSQL Search from https://www.apexsql.com/sql_tools_search.aspx. Enter the batch number and search all of the text fields in the database. The tool will return the table and field that includes that value.