Have you ever received a Calculate Replenishment Parameters Unexpected Error in Sage 500 ERP? To be more specific any of these messages:
Unfortunately, the message does not provide you with what is actually occurring. So here are the detailed steps for resolving this error message in Sage 500 ERP.
This issue will only occur if the company is setup to track changes for the IM module. If anything is set to 'Summary' or 'Detail' within the IM Options/Data Retention/Maintenance Audit for Additions, Changes, and/or Deletions then entries are recorded in the tciMaintAuditLog.
Part of this process inserts rows into table tciMaintAuditLog. This is where the error occurs but not all the time. Originally it was thought we had some type of permissions issue since it was only happening to certain users. It turns out that one column in this table is populated with a concatenated value. This value is different if you are running the Sage 500 ERP Client local or from Terminal Services or Citrix.
The column is ProgramName. Let me explain the details of the concatenated string.
The value above, that is passed into spimCalcEOQ for example, is used to populate the column ProgramName in table tciMaintAuditLog. The column is varchar(80). The above string is 84 characters long. There is not error checking and so the INSERT fails.
The string is broken down as such:
The next part is where some of the variability comes into play.
I think you closed this ticket as you could not find anything wrong. Well I found the issue. The column name was too short for the ProgramName column in tciMaintAuditLog.
This has been reported as a bug but I do not believe you will see this corrected. This is the same in all versions prior to Sage 500 ERP v2013 (v7.5) as of the time of this writing.