Blank book codes are created when the account posting type is set to 'Both'

Entry Type: Program Issue

Product: FRx

Application: FRx Desktop

Version Reported: 6.5, 6.7

Status:

This issue is being researched by Engineering.

Subject:

Blank book codes are created when the account posting type is set to 'Both'.

Steps to Duplicate:

FRx for Sage MAS 500 ERP:

  1. Create a new Sage MAS 500 company. Activate and set up the General Ledger module.
  2. Open General Ledger / Maintenance / Maintain GL Accounts / Maintain Accounts. Select any account, and set the posting type to 'Both'.
  3. Open FRx Designer, set up the new Sage MAS 500 company, and set the company as default.
  4. Open File / New / Column. Select "GL" as the type.
  5. Click the 'Book Code' drop-down box.
  6. Note that the book code is blank.

Expected Behavior:

The book code should display as "STATISTICAL" for accounts with a posting type of 'Both' or 'Statisitical'.

Possible Workaround:

Create an inactive GL account with a posting type of 'STATISTICAL' in Sage MAS 500. The inactive account should display correctly in FRx.