*CAPITAL Office Business Software

This script parses the customer table and exports all notes to a text file containing rich text format (RTF) text. Declare cHeader Type Character Declare cNote Type Character Declare cFile Type Character Declare nCount Type Number nCount := 0 cFile := PathCompany() + "NOTESDATA.TXT" OpenTa...

To add or remove columns, click on the grid and press the right-mouse button. Then select Column Properties from the pop-up menu. This will open the Column Properties Manager tool. [ images/column_properties.png The columns that are visible on the grid are displayed in the list to the left and all a...

Ensure you have performed all tasks relating to the general ledger as described by the general ledger help reference topic: End Of Period Procedures Confirm that your opening balances for the year have been entered or correctly transferred, including any final journal adjustments made by your exter...

1. Open the Stock Control area. 2. Right click on the stock list. 3. From the pop-up context menu select Export. 4. Next to "Save As type" select Excel Workbook. 5. Enter a file name and press Save. To change the presentation of your spreadsheet, right click as per step 2 above and select ...

To move Corporate Edition from an existing server to a new server follow these steps: 1. Locate the application main folder and/or any folders associated with this. This is typically <drive>:\CAPITAL. However, it is frequent practice to place the <drive>:\CAPITAL folder inside a <drive>:\CAPSHARE or...

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...