A macro is a file you create that contains a series of commands and functions to automate a process. Macros help you complete your work more quickly and efficiently. They are often used to automate repetitive, routine procedures.
Macros will create an icon in your Sage Accpac database where you can run the macro just like you would run a report.
Below are the different options for Sage Accpac Macros:
- Budget.xls, an Excel spreadsheet containing a macro that lets you manipulate and update General Ledger budget data.
- Sales.PPT, a Power-Point presentation containing a macro that updates sales figures from the General Ledger.
- GIFI.xls, an Excel file containing a macro that creates the following file: A separate Excel worksheet in which accounts are associated with GIFI codes and a GIFI export file that contains the information required by T2 corporation income tax software.
- BAS.AVB, a macro that let you complete and submit electronically a Business Activity Statement for the Australian Tax Office (ATO).
- Wroffeur.avb, automatically writes off rounding differences that can arise on settlement of multicurrency invoices.
- GETRATE.abv, lets you generate Multicurrency rates from an external source (ex: Web site) to update exchange rates on the spot.
- Recchrg.xls, lets you easily update recurring charge records created with Accounts Receivable by assigning schedules to existing recurring charge records.
- CashFlow.avb, ages your receivables and payables, using this information to calculate the amount of cash you will have at the end of a specified period.
- Workflow.avb, lets employees send the details of requisitions for approval from Purchase Order
- Workmon.avb, lets managers approve requests for purchases from employees
- Workreq.avb, lets employees complete a form to request approval for the purchase of items and to specify the estimated cost of the purchase.
- Oeordact.avb, you can use to produce a dynamic Order Action report in Microsoft Excel from Order Entry.
Click here to obtain more information on Macros with Sage Accpac and how they can help you!