*CAPITAL Office Business Software

1. Locate and run the SAP Advantage SQL installation package applicable to your version. For example: ADSwin_x86_64.exe 2. Accept terms of the licence agreement, specify installation folder, and "Complete Install". 3. When prompted for Collation or ANSI Character Set, select "ASCII&qu...

The following script scans an invoice or related transaction before saving it to the database and prevents the transaction from being saved if a product item with a zero invoice quantity is found. The script must be saved in your main ..\CAPITAL folder with the filename R-ITOTAL.MAC. Refer to the pr...

The following script returns the last date and time that CAPITAL Server Agent ran, or attempted to run, a scheduled task: Declare dLastDate Type Date Declare cLastTime Type String Declare cINI Type String cINI := PathData() + "SCHEDULE\AGENT.INI" dLastDate := CTOD(ReadINI("Scheduler&q...

1. Open the General Ledger area. 2. From the top menu select Record|Open Year 3. Under the Lock column tick the period to lock it, or untick it to unlock it. 4. Press Open to continue. Note: If you wish to edit transactions before the current financial year, untick Lock Previous . To prevent users f...

1. Launch CAPITAL Business Manager. 2. Open the General Ledger area. 3. From the menu select Manage|General Ledger Sets. 4. Set "0" (Under Code column) should be selected. Press Copy button. 5. In Set Code enter a short code to represent your cash book or bank, i.e., NAB Note: Remember thi...

Versions Prior to Release X: All users must close down their running copies of CAPITAL before you execute the following steps. The process will take several minutes to execute. There is no need for users running Release X or higher, to exit the software. 1. Open the General Ledger area. 2. From the ...

To clear a GL accounting period so that you may start over, the procedure is: 1. Make a back-up of your general ledger files or your entire company database. 2. Open the General Ledger area. 3. Select from the general ledger menu, Journals|System Journal Batches. 4. Delete or reverse post any system...

To add a custom report or form or a script to your reporting system do the following: 1. Start CAPITAL Business Manager. 2. From the drop down menu at the top select Reports and then select the area where you wish to add the report to. 3. On the right hand side of the screen press the Add button. 4....

To associate a particular form with a transaction follow these steps: 1. Start CAPITAL Business Manager 2. From the main menu select Company|Administration|Customise Note: you may be prompted to log in with your administrator password. 3. From the menu select Install Settings|Transactions. 4. Click ...

When using the SAP/Advantage ODBC connector, the following configuration settings are recommended: DataDirectory=path_name a valid path name to where the data files are located (e.g., x:\data). This path is used to automatically select all tables in the specified directory. DefaultType=FoxPro Server...