“Error 1 file does not exist called from g_cgtary” Message Appears When Trying to Post Payroll

  • Created:
  • / Author: tombucci
Issue

 

When posting individual, selective or automatic payroll postings after a conversion, the following message appears:

“Error 1 file does not exist called from g_cgtary”

This only occurs in the converted data, not company 99.

Note: The error message also occurs when for other functions such as Edit Postings, Calculate Postings and Enter Payments.

Solution or Workaround

This issue is caused by a missing backslash (\)  at the end of the path in the SYCPATH.Cdosdbf field. This field holds the location of the PR tables and tells Sage Pro ERP where to look for the tables.

When the PR module is selected in Sage Pro, the PRFDOSXX.mem* file is created; is lists the location of the PR tables. This file is created in the root directory of the Sage Pro installation and is used to locate the tables. Since the backslash is missing, Sage Pro combines the value in the SYCPATH.Cdosdbf field with the table name. The resulting value is a location that does not exist.

Example One:

The value in the SYCPATH.Cdosdbf field is C:\Pro73B\Data99 and the table is PRBENFT99.dbf. The mem file will record the location is C:\Pro73B\Data99PRBENFT99.dbf.

Therefore when Sage Pro uses the PRFDOSXX.mem file to locate the table, the error message occurs because the location written in the file is invalid. For the example above, the value in SYCPATH.Cdosdbf should be C:\Pro73B\Data99\. The mem file will then record the location as C:\Pro73B\Data99\PRBENFT99.dbf which is correct.

A backslash (\) should be added to the incomplete records in SYCPATH.Cdosdbf. The resulting value should be a valid location. The old PRFDOSXX.mem file should be deleted and Sage Pro should be exited. The error should no longer occur when logging onto Sage Pro and attempting the same process.

Note: Data edits should only be done by a Sage Certified Consultant or Business Partner. Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

*XX is the company ID

© Copyright Sage Software

 

Leave A Comment?