Issue

 

The following message appears when attempting to post batches released from a submodule:

Error 1526: Invalid Column Name ‘Subcode’

When attempting to edit the unposted batches, the batch opens as empty. This issue may occur when:

• Converting to Sage Pro ERP 7.3
• Converting to Sage Pro 7.3 with Microsoft SQL Server.

Solution or Workaround

The issue has been documented under Product Trouble Report (PTR) 78098 and has been fixed in Sage Pro 7.3 Service Pack 1. It occurs when Project Accounting or any Manufacturing module has not been installed. This issue can also be resolved by adding the Jobcode, Phase and Subcode fields to the GLDENT and GLDUNP tables and entering the corresponding field information. Please refer to the table below for more information. Follow the steps below:

Note: The following 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.

1. Open System Manager.
2. Under the Maintain menu, point to Dictionary and click Tables.
3. Type “GLDENT” into the Table ID field.
4. Select “Field” from the list box.
5. Click Select.
6. Type Jobcode into the Field Name field; a message appears indicating the field is not found.
7. Click Add; a message appears asking whether to copy the default values from an existing record to the new field.
8. Click No.
9. Refer to the table below and enter the corresponding values for Description, Base Type, Length and Input Mask.
10. Click Save.
11. Repeat steps 6-11 for the Phase and Subcode fields.
12. Repeat steps 3-12 for the GLDUNP table.
13. Update from Data Dictionary for GL in all companies.

Field Property Information

Field Name	Description	Base Type	Length	Input Mask
Jobcode	PA Job Code	Character	10	!!!!!!!!!!
Phase	PA Job Phase	Character	6	!!!!!!
Subcode	PA Category Code	Character	4	!!!!

 © Copyright Sage Software