Sage 100

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

Update... Still not resolved and still open to more suggestions:

1. We followed the Sage article to reinitialize the GL_CompanyActiveBatch file; this did not correct the error
2. We followed the Sage article to rename the Links folder (to rule out 3^rd party); this did not correct the error
3. We cleared the Physical Count (unfroze) and then refroze; this did not correct the error
4. Per Sage's suggestion, followed this module Activation article (https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924750023940&fromemail=true); this did not correct the error
5. IT turned off Anti-Virus, rebooted the servers, tested again; this did not correct the error
6. In the Activity Log, the error is not even being logged
7. In the SQL Logs, the error is not even being logged

We have cases with Sage, Scanco, and AvaTax. We are escalating with each of them, but any other thoughts or suggestions?

Here are the steps:

1. Freeze Inventory
2. Entered Count Card Entries
3. Run the Count Card Report (we chose just one of the Card Numbers)
4. Click no on the variance register
5. Click yes on updating the Count Card Entry; this start to look like it runs and then immediately throws the error "Module P/R not on file"

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

Update... Still not resolved and still open to more suggestions:

1. We followed the Sage article to reinitialize the GL_CompanyActiveBatch file; this did not correct the error
2. We followed the Sage article to rename the Links folder (to rule out 3^rd party); this did not correct the error
3. We cleared the Physical Count (unfroze) and then refroze; this did not correct the error
4. Per Sage's suggestion, followed this module Activation article (https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924750023940&fromemail=true); this did not correct the error
5. IT turned off Anti-Virus, rebooted the servers, tested again; this did not correct the error
6. In the Activity Log, the error is not even being logged
7. In the SQL Logs, the error is not even being logged

We have cases with Sage, Scanco, and AvaTax. We are escalating with each of them, but any other thoughts or suggestions?

Here are the steps:

1. Freeze Inventory
2. Entered Count Card Entries
3. Run the Count Card Report (we chose just one of the Card Numbers)
4. Click no on the variance register
5. Click yes on updating the Count Card Entry; this start to look like it runs and then immediately throws the error "Module P/R not on file"

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

Update... Still not resolved and still open to more suggestions:

1. We followed the Sage article to reinitialize the GL_CompanyActiveBatch file; this did not correct the error
2. We followed the Sage article to rename the Links folder (to rule out 3^rd party); this did not correct the error
3. We cleared the Physical Count (unfroze) and then refroze; this did not correct the error
4. Per Sage's suggestion, followed this module Activation article (https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924750023940&fromemail=true); this did not correct the error
5. IT turned off Anti-Virus, rebooted the servers, tested again; this did not correct the error
6. In the Activity Log, the error is not even being logged
7. In the SQL Logs, the error is not even being logged

We have cases with Sage, Scanco, and AvaTax. We are escalating with each of them, but any other thoughts or suggestions?

Here are the steps:

1. Freeze Inventory
2. Entered Count Card Entries
3. Run the Count Card Report (we chose just one of the Card Numbers)
4. Click no on the variance register
5. Click yes on updating the Count Card Entry; this start to look like it runs and then immediately throws the error "Module P/R not on file"

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

Is the payroll module installed?  If not then look in sy0ctl.soa for records that begin with lP/L and delete them after backing up the table first.  Also look for records that begin with P/R in the sy_,module table and delete.

Update... Still not resolved and still open to more suggestions:

1. We followed the Sage article to reinitialize the GL_CompanyActiveBatch file; this did not correct the error
2. We followed the Sage article to rename the Links folder (to rule out 3^rd party); this did not correct the error
3. We cleared the Physical Count (unfroze) and then refroze; this did not correct the error
4. Per Sage's suggestion, followed this module Activation article (https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924750023940&fromemail=true); this did not correct the error
5. IT turned off Anti-Virus, rebooted the servers, tested again; this did not correct the error
6. In the Activity Log, the error is not even being logged
7. In the SQL Logs, the error is not even being logged

We have cases with Sage, Scanco, and AvaTax. We are escalating with each of them, but any other thoughts or suggestions?

Here are the steps:

1. Freeze Inventory
2. Entered Count Card Entries
3. Run the Count Card Report (we chose just one of the Card Numbers)
4. Click no on the variance register
5. Click yes on updating the Count Card Entry; this start to look like it runs and then immediately throws the error "Module P/R not on file"

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

Correction to a typo in my previous post: Look in sy0ctl.soa for records that begin with lP/R and delete them after backing up the table first.  Also look for records that begin with P/R in the sy_module table and delete.

Is the payroll module installed?  If not then look in sy0ctl.soa for records that begin with lP/L and delete them after backing up the table first.  Also look for records that begin with P/R in the sy_,module table and delete.

Update... Still not resolved and still open to more suggestions:

1. We followed the Sage article to reinitialize the GL_CompanyActiveBatch file; this did not correct the error
2. We followed the Sage article to rename the Links folder (to rule out 3^rd party); this did not correct the error
3. We cleared the Physical Count (unfroze) and then refroze; this did not correct the error
4. Per Sage's suggestion, followed this module Activation article (https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924750023940&fromemail=true); this did not correct the error
5. IT turned off Anti-Virus, rebooted the servers, tested again; this did not correct the error
6. In the Activity Log, the error is not even being logged
7. In the SQL Logs, the error is not even being logged

We have cases with Sage, Scanco, and AvaTax. We are escalating with each of them, but any other thoughts or suggestions?

Here are the steps:

1. Freeze Inventory
2. Entered Count Card Entries
3. Run the Count Card Report (we chose just one of the Card Numbers)
4. Click no on the variance register
5. Click yes on updating the Count Card Entry; this start to look like it runs and then immediately throws the error "Module P/R not on file"

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.

1. Does happen for all users?
2. Does this happen on all workstations, including the workstation on the server?
3. Does this happen with any printer selected?
4. Does this happen with any other reports, journals, registers, etc?
5. Have you seen this KB article, Error: "200 SY_ReportCommon.pvc 621 or 627" "Crystal:" "P/R Not on File", "I/T Not on File" when trying to print (sage.com)?

From what I saw while briefly looking through the related stock programs for 2019.4, the message "Module P/R is not on file" is set when SY_ReportEngine calls the GetModuleInfo method to determine the minimum PR conversion level.  It does so without even checking if the P/R module is installed.  This causes the LastErrorNum$ and LastErrorMsg$ properties to get set and are not caught by specific error handling as Kevin mentioned when SY_UpdateUI calls the ErrCheck method to see if any errors occurred but this only occurs if the retVal variable is equal to -1.  It appears to be set last as a result of the ProcessReport method so I would double-check the printer selected, if they are using Deferred, make sure they haven't hit the upper limit for the number of deferred files waiting to be printed, it is something like 99,999, you can check in the MAS90\Home\Deferred directory.  I recall a client who hit this limit because they were using a scheduled task to auto-post the Scanco WHS 100 transactions and were sending them to deferred printing.  If no change is seen regardless of the printer selected, then it is likely something in the ProcessReport method that is failing and there are a lot of failure points in the method.  A few things to check would be the following.

1. Is the IM_CountCardVarRegister.rpt file accessible?
2. Has the IM_CountCardVarRegister.rpt been converted to the current version?
3. Does the IM_CountCardVarRegister.rpt file have any added tables or a modified connection that might be preventing is from logging into the database?

Correction to a typo in my previous post: Look in sy0ctl.soa for records that begin with lP/R and delete them after backing up the table first.  Also look for records that begin with P/R in the sy_module table and delete.

Is the payroll module installed?  If not then look in sy0ctl.soa for records that begin with lP/L and delete them after backing up the table first.  Also look for records that begin with P/R in the sy_,module table and delete.

Update... Still not resolved and still open to more suggestions:

1. We followed the Sage article to reinitialize the GL_CompanyActiveBatch file; this did not correct the error
2. We followed the Sage article to rename the Links folder (to rule out 3^rd party); this did not correct the error
3. We cleared the Physical Count (unfroze) and then refroze; this did not correct the error
4. Per Sage's suggestion, followed this module Activation article (https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222924750023940&fromemail=true); this did not correct the error
5. IT turned off Anti-Virus, rebooted the servers, tested again; this did not correct the error
6. In the Activity Log, the error is not even being logged
7. In the SQL Logs, the error is not even being logged

We have cases with Sage, Scanco, and AvaTax. We are escalating with each of them, but any other thoughts or suggestions?

Here are the steps:

1. Freeze Inventory
2. Entered Count Card Entries
3. Run the Count Card Report (we chose just one of the Card Numbers)
4. Click no on the variance register
5. Click yes on updating the Count Card Entry; this start to look like it runs and then immediately throws the error "Module P/R not on file"

Thank you for the reply.

We have tried the following (all without success)...

1. Updated all open batches; reinitialized the GL_CompanyActiveBatch table; still received the error
2. Renamed the Links folder; created a new Links folder; copied the default file to the new Links folder; still received the error

We are now testing the following:

1. Clearing Frozen Items; confirming the table is clear; freezing Inventory again
2. If #1 doesn't work, we may have to look at clearing IM_Physical and the Count Card tables

If we still get the error after that, I am running out of troubleshooting options.  The lock clearly is happening when the Count Card Entry is trying to update the Card Count to the IM_Physical table.