Sticky FAQs

Area/agent codes do not appear when I select them in debtor/creditor aging report.

Description

This usually happened when user upgraded from version 9.1 (dated 02 March 2006 or earlier version) to version 9.2.
The fields of area, agent and business have been
changed and stored separately in different database file (arcust.area to icarea.dbf , arcust.agent to icagent.dbf, arcust.business to business.dbf.)

Solution

1. Copy files ‘movecust.exe’ into folder c:\ubsacc90\tools.

2. Add a new file into External Application (ReportsàExternal Application).

3. Click Run to execute the new file just added.

4. System
will prompt a message ‘Are you sure to move area, agent and business from

Debtor
& Creditor to individual file ’ Click on ‘Yes’ to proceed.

Tip:

1. This option only applicable when
icarea.dbf, icagent.dbf & business.dbf are empty.

2. 8 characters will be converted starting from left description

Eg.

a) b) c)

Kuala Lumpur Kuala Lumut Kuala Luma

converted to unique code
= ‘Kuala Lu’ (8 characters )

converted to unique code = ‘Kuala L1’

converted to unique code
= ‘Kuala L2’ (the last

character will be run from 1-9, a-z, A-Z

User may able to do amendment on the agent or area code in Boss Menu (if necessary) after the conversion has been done.