Cash Management
Leave a Comment
Purpose This procedure is used to reconcile statements received from your Bank with the transactions recorded in the Bank Reconciliation system. It may be used at any time. You can either reconcile statements manually, or use auto-reconciliation – where you upload your statement from the bank and have items match automatically. At the end of […]
Read more »
Purpose This procedure is used to enter or modify the details of Bank Accounts. At least one Bank Account must be established for use in the Accounts Payable and Accounts Receivable Ledgers so that payment and receipts transactions can be recorded on the system. You can set up as many banks as you need. Each […]
Accounts Payable Accounts Receivable Cash Management
Purpose This procedure is used to enter or modify the details of Currencies you want available in the system. You can maintain exchange rates for each currency you transact in as and when required via this function. Data Input Step 1 – Currency Code Currency Code Enter a new, unique currency code, that does […]
Statement Format Code Format Code can be numeric or alpha. Name Enter a name to describe the statement format. This will be used when selecting a format to associate with the bank in Bank Details entry. For more details on descriptions, see The Role of “Names & Descriptions” in Online Advantage File Format Displays the […]
Purchasing
Payment Method Code Payment Method code can be numeric or alpha. For details on the use of “codes”, see The Role of “Codes” in Online Advantage Description Enter text to describe the Payment Method. This is shown when selecting a payment method on a Supplier or during Purchase Order Entry. For more details on descriptions, […]
General Ledger
Purpose This procedure is used to upload and update the forecast details from a file created outside of the system. Since General Ledger financial forecasts are mostly made up of the estimated movements for each account for each month of the year, it is often easier to enter this detail in via a spreadsheet like […]
Online Tools
Purpose This function is used to create and update Custom Data Sets. This ‘Custom Data’ tool offers you the opportunity to store data specific to your business needs. Data that is not covered in the standard Online Advantage database structures. For example, with Assets you may want to record additional purchase and/or insurance details. Perhaps […]
Purpose This function is used to set up and maintain ‘Custom Data Lists’ that can be used within ‘Custom Data Sets’. If you’re not familiar with ‘Custom Data Sets’, then we recommend you take a look at the details of that function before determining whether you need to set up any ‘Custom Data Lists’ via this function. You would create […]
Manufacturing
Purpose In case labels printed for Work Orders are damaged, this function is available to print additional labels. There are two additional label print options available – one for ‘Current’ Work Orders and one for ‘Completed’ Work Orders. Data Input Step 1 – Work Order Number Work Order Number Enter the Work Order Number for […]
Accounts Receivable
Purpose This function is used to enter receipts details of payments from your Customers as well as ‘Sundry Receipts’ that need to be banked from non-debtors sources e.g. rental income, insurance policy refunds, sale of assets etc. These sundry receipts are manually posted to one or more General Leger Accounts. Where these receipts affect customers, the […]
Customer Trading Terms Code Trading Terms code can be numeric or alpha (or a combination). It is often descriptive e.g. ‘C’ for ‘cash’, ‘7’ for 7 days, ’30N’ for 30 days from invoice date. For details on the use of “codes”, see The Role of “Codes” in Online Advantage Standard Terms This shows the Trading […]
Inventory Control
Purpose This procedure is used to cancel a stock take run – use it carefully as once a run is submitted for cancellation there is no facility to reverse the changes made. The routine will ask you to specify which stock take run you wish to cancel. Only runs that have not yet been finalised […]
Purpose This function can be used to perform Profit and Loss Analysis from the figures held in the General Ledger system. It is designed to be used with the Online Cube to provide the figures in a tool where they can be analysed more interactively. However the Excel/CSV/Text file options can also allow users to […]
Purpose This function can be used to manually enter the details of ‘Stock Receipts’ that have occurred in a given Stock Location. Once a receipt is completed using this facility the items appear in the inventory for the receiving stock location via ‘Manual Stock Receipts (MSR)’ transactions, and the value of the inventory being received […]
Purpose This function can be used to manually enter the details of ‘Stock Issues’ that have occurred in given Stock Locations. Once an issue is completed using this facility, the items are moved out of the inventory from the issuing stock location via a ‘Manual Stock Issue (MSI)’ transaction, and the value of the inventory being […]
Purpose This function can be used to manually enter the details of Stock Transfers that have occurred between two Stock Locations. Once a transfer is completed using this facility the inventory items are moved out of the inventory of the issuing stock location via ‘stock transfer issue’ transactions, and into the stock on hand of […]
Purpose This function is used to adjust the average cost of a product that is currently on a stock take run. Such a change would be by exception – usually to correct some previous problem/mistake typically caused by the incorrect processing of a stock receipt transaction value. Because the processing of stock transactions during a stock […]
Purpose This function is used to adjust the average cost of a product in stock in order to revalue it. Such a change would be by exception – usually to correct some previous problem/mistake typically caused by the incorrect processing of a stock receipt transaction value. This value maintenance is carried out at either the Warehouse […]
Purpose This function is used to transfer stock from one ‘Bin’ to another, within the same Stock Location. The stock location selected must be using Multi-Bin tracking (Bin Tracking Code ‘3’) in order to use this bin transfer facility. Please refer to Bin Tracking Options for more details. This function provides the ability to keep track […]
Purpose This function can be used to create a working copy or ‘draft’ of Future Pricing based on existing pricing details. With this tool you can ‘copy’ part or all of the existing current pricing, applying inflation factors to create new pricing. This new set of prices are basically held in a ‘work in progress’ area […]
Purpose This procedure is used to enter and/or modify future prices for products. It is designed to be used for the fine tuning of new pricing after the bulk updating of prices via the Create New Prices function and/or the Upload New Prices tool. Using this function, new pricing can be entered or changed on […]
Purpose This function is used to ‘activate’ the Future Prices held in the system. This function copies ‘New Prices’ overwriting any current product pricing with the new details. Future pricing would normally be applied automatically via the overnight End of Day routine when the ‘Apply To’ date on the new prices is reached. This means […]
Purpose This function is used to clear all the new/future prices from the ‘New Price List’ work space in the Future Pricing system. This routine could be used if you need to scrap any previous ‘New Price List’ work and want to start fresh with no future pricing. You might also use this function if […]
Purpose This tool is used to change the Price List of a Stock Location to a new price list. Making such a change essentially moves the location selected to a new set of costs and prices by changing the price list it uses for all costs and sell prices. This change is set up as a […]