Cannot save column order for a detail table in Sage 300

Description

After rearranging the columns for a detail table, then logging off from Sage 300 ERP, the column order are restored to the default order after loggng into Sage 300 ERP.

Example.

  1. Login to Sage 300 ERP.
  2. In Accounts Payable, click A/P Transactions, then Invoice Entry.
    The A/P Invoice screen appears.
  3. Click New.
  4. Select a Vendor Number.
  5. In the detail table, rearrange the column order. (e.g. switch the order of the Dist Code and Description columns.)
  6. Close the A/P Invoice Entry screen.
  7. Log out from Sage 300 ERP.
  8. Login to Sage 300 ERP.
  9. Reopen the A/P Invoice Entry screen.
    The Description and Dist Code fields in the detail table are restored to the original order.

Cause

Corruption to the Sage 300 ERP user profile.

Resolution

To resolve the issue:

  1. Login to Sage 300 ERP.
  2. Under the Help menu, click System Information.
  3. Identify the Shared Data Directory.
  4. In Windows Explorer, browse the Shared Data Directory.
  5. Browse the USER folder.
  6. Rename the folder for the affected user.
    For example if the Sage 300 ERP username is “ADMIN2”, then there will be a folder with a folder name that matches the username “ADMIN2”. 

Going forward when you change the column order for any grids, Sage 300 ERP will save the column order.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.