Sage Accpac Macros

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!

Questions:

Posted by: Francisco Flores Answered by: Daniela Puzzo I am looking after a training on macro programing on sage ACCPAC. Regards Hi Francisco, We don't offer a class specific to Accpac Macros but, can and do provide training for customers.  Are you currently an Accpac user? Feel free to contact us directly if you prefer. Kindly, Team Bredet

Enter Your Comment or Question:

Please specify if this is a general comment or a question - Comment - Question

Name:

E-mail: (will not be published)

Comment / Question: (500 Char. Max)

Verification Code This step helps prevent use of automated programs that send bulk spam through this form. To counteract this practice, we ask that you type in the word below in the space provided Enter the Word exactly as it is shown in the box above: If you can't read the word, click here to load a new word