Martin Jahn, Author at FMT

Search Archive
NetSuite Commissions and Outsourced Payroll in 3 Easy Steps
The sales commission functionality, part of the Incentive Compensation module in NetSuite, is robust with a solid feature set that supports varied compensation requirements. It allows you to easily pay commissions through the NetSuite payroll module or through standard Accounts Payable process (Vendor Bills). But what if you outsource your payroll processing to ADP, PayChex, Paylocity or another payroll processing service? How do you effectively process your commissions within NetSuite to support payment through the payroll provider? Here’s the step-by-step process on how to make it work. Step 1:  Setup the Required Accounts You will need to set-up a few new accounts if these do not already exist within your NetSuite environment. When setting up these accounts, pay particular attention to the account Type as this is critical to allowing the commission related transactions to be entered and processed properly. Commissions Payable– This account will be used to record the […]
Changing the Customer on an Invoice without Losing Audit Trail in Microsoft Dynamics GP
A common question that has come up recently is ‘How do I change the customer on an invoice?’ Well, in short, it’s not possible without significant unsupported updates to SQL data which compromises the audit trail that is part of a GAAP compliant accounting system such as Microsoft Dynamics GP. The good news is that there are some tools available in Dynamics GP that can assist you in crediting the original invoice and a new invoice. Below is a step-by- step example of how to handle the following scenario: a sales order is processed for a customer, and an invoice is sent to that customer. the customer subsequently advises that the order should be paid for by a different company. The general steps are: Post the original customer invoice even though it may have the wrong customer listed. Create a return based on the original customer invoice – verify the […]
Implementing Multiple EFT File Formats for a Single Checkbook in Microsoft Dynamics GP
ACH (EFT) file format configuration within Microsoft Dynamics GP is a relatively straightforward process. However, what do you do when your bank requires you to use one particular format for Consumer transactions and another for Business transactions? For example, your bank’s requirements could be that you must use a PPD (Prearranged Payment and Deposit) format for Consumer Account transactions and a CCD (Cash Concentration and Disbursement) format for Business Account transactions. This requirement can easily be addressed by using the standard functionality and tools within Dynamics GP 2013 by following the steps outlined below: Step 1 Create the two separate EFT formats – one for PPD and one for CCD. This process can be simplified by using the Export function to export the current format, import as a new name, and finally perform any updates to the formats. In this example, there will be separate CCD and PPD formats for […]
Security Considerations for Microsoft Dynamics GP 2010 SQL Reporting Service Reports
While most Microsoft Dynamics GP system administrators are accustomed to securing access to the ERP system data using both built in and custom security roles and tasks, a completely different security model must be employed when using the SQL Reporting Services Reports. Access to reports within SQL Reporting Services (SSRS) is controlled using Active Directory (AD) authentication of AD users or groups. Additionally, by default, the data behind the standard GP reports is secured by SQL database roles that need to be mapped to AD users and/or groups. The Microsoft Dynamics® GP 2010 SQL Server Reporting Services Guide provides a decent step by step guide of how to setup security for the reports based on predefined database roles that are created during the deployment process. Below is the listing of database roles: DYNAMICS database rolesCOMPANY database roles rpt_all user rpt_all user rpt_executive rpt_executive rpt_human resource administrator rpt_human resource administrator rpt_payroll […]
 FMT Consultants, LLC.
Privacy Policy

Contact Us


Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram