Search found 117 matches
- Thu Jun 10, 2021 12:59 pm
- Forum: General Ledger (Financials)
- Topic: Understanding General Ledger Sets
- Replies: 0
- Views: 19118
Understanding General Ledger Sets
What is a General Ledger Set? A general ledger set is a table of 'cross references' that acts as the connecting link between your sub ledgers and your general ledger. You can create as many sets as you need and typically each set will serve some specific purpose in telling the general ledger which ...
- Mon Jun 07, 2021 10:32 am
- Forum: Printing
- Topic: Remove Invoice Copies From Statement Runs
- Replies: 0
- Views: 24750
Remove Invoice Copies From Statement Runs
If your software is attempting to include a copy of all transactions for the period, or unpaid invoices, when a statement run is performed and you do not wish to do this, you should remove the statement invoice form from your statement process. The steps to do this are as follows: 1. Close all runni...
- Sun May 30, 2021 11:54 am
- Forum: Scripting & Advanced Techniques
- Topic: R-CLIMIT.MAC Hook Usage Example
- Replies: 0
- Views: 17753
R-CLIMIT.MAC Hook Usage Example
The following script demonstrates how to customise the credit checking system by adding a rule to fail credit approval if a customer owes more than $50 in a 90 day or greater time period. The script must be pasted into a text file with the name: R-CLIMIT.MAC * If over 50 dollars in 90 days or more, ...
- Sun May 30, 2021 11:43 am
- Forum: Scripting & Advanced Techniques
- Topic: Example: Create a Simple Spreadsheet Using Script
- Replies: 0
- Views: 12249
Example: Create a Simple Spreadsheet Using Script
The following script demonstrates how to create a simple Excel compatible spreadsheet. * Create a Spreadsheet SpreadCreate() SpreadWrite(1, 1, "Hello World") SpreadWrite(2, 1, 100) SpreadWrite(3, 1, 200) SpreadWrite(4, 1, 6.66) SpreadWrite(5, 1, Today()) SpreadSave("C:\TEMP\Test Sprea...
- Sun May 30, 2021 11:39 am
- Forum: Scripting & Advanced Techniques
- Topic: Example: Creating Lookups Using Form Functions
- Replies: 0
- Views: 12060
Example: Creating Lookups Using Form Functions
The following script demonstrates how to include look-up lists using the Form***() CBS functions. Declare aTable Type Array Declare aHeader Type Array aTable := { { "TEST1", "TEST2", FALSE }, { "TEST3", "TEST4", TRUE } } aHeader := { { "Header 1", 10...
- Sun May 30, 2021 11:35 am
- Forum: Scripting & Advanced Techniques
- Topic: Export Customer Notes to an RTF text file
- Replies: 0
- Views: 12048
Export Customer Notes to an RTF text file
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...
- Fri May 28, 2021 9:25 am
- Forum: Processes
- Topic: Working With Column Properties Manager
- Replies: 0
- Views: 12077
Working With Column Properties Manager
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...
- Thu May 27, 2021 5:46 pm
- Forum: General Ledger (Financials)
- Topic: End of Financial Year Checklist
- Replies: 0
- Views: 12000
End of Financial Year Checklist
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...
- Thu May 27, 2021 12:38 pm
- Forum: Processes
- Topic: How To Create a Stock List Spreadsheet
- Replies: 0
- Views: 11731
How To Create a Stock List Spreadsheet
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 ...
- Wed May 26, 2021 10:44 am
- Forum: Servers & PCS
- Topic: Moving Corporate Edition to New Server
- Replies: 0
- Views: 19547
Moving Corporate Edition to New Server
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...