By Kim Anselmo, The Resource Group
Our days are filled with endless tasks, projects and deadlines. Every little bit of process improvement can help. For example, consider how often you might be manually re-entering information from spreadsheets into your financial accounting software system.
The Resource Group has developed two nifty add-on tools for Microsoft Dynamics® GP called the TRG GL Copy/Paste and AP Copy/Paste. The GL Copy/Paste tool allows the creation of a general ledger journal entry by doing a standard copy and paste function from an Excel spreadsheet directly into the Microsoft Dynamics GP financial management system. In addition, the GL Copy/Paste tool validates account numbers and confirms that the Journal Entry is a balanced entry. If any errors are found, the tool will alert the user.
The AP Copy/Paste tool allows users to copy and paste vender transactions from a spreadsheet. This tool features built-in safe guards, which allow users to ensure general ledger accounts exist, document types of invoice and credit memos, confirms the document number is not a duplicate and verifies that the vendor already exists within the Microsoft Dynamics GP system.
By using the GL Copy/Paste and A/P Copy Paste tools in your daily processes, you can reduce the steps and time it would normally take you to re-key this information manually.
Want to see a quick video on how the AP Copy/Paste tool can save you time during your day? Watch now.