Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
In Microsoft Dynamics GP you can now copy and paste payroll transactions from Excel straight into the Payroll Transaction Entry window similar to our General Ledger and Payables Transactions Copy and Paste features. This is a great feature which makes it easier for those who may have an external time keeping system that can export data to Excel in the required format for pasting or for those who might currently be using Integration Manager to enter a larger payroll transaction.
TIPS AND TRICKS:
Baseline testing showed best results with 1000 or less transaction lines. 2000 transaction lines processed within about 8 minutes and will vary depending on the environment. For those with larger numbers eConnect may be a better solution, otherwise it is best practice to break up the data and paste it into separate smaller batches for best results. As you can see in our examples below if you did 4 batches of 1000 transactions it could take 8-12 minutes total. Versus doing 4000 all in the same batch could take 20+ minutes.
Performance can vary widely due to environmental factors and the number of 3rd Party Add-ins installed on top of our code. Copy and Paste works when you have security to the core Dynamics GP window.
Here are some baseline testing examples on SQL Server with Local Install of Microsoft Dynamics GP without any customizations or add-on products.
Leaving any fields that you wish to default, don't include those columns when you copy your range, such as departments, position or dates can help speed up the process. For example if you are using the default position on the employee, don't put it in the excel sheet as it will be redundant and slow down the import process. Example below:
SUMMARY OF FEATURE:
Below is a quick overview of this feature. For full documentation on this feature and other new features please see the Microsoft Dynamics GP Resource Directory.
A new Paste button will be visible in the Payroll Transaction Entry window. To view this window go to the Transactions menu, point to Payroll, and click on Transaction Entry.
TIP: If the Paste button does not appear, verify that your user security set to the Microsoft Dynamics GP version of the Payroll Transaction Entry window, not the HRM Solutions or any other alternate window. Also make sure that your batch does not contain any previously entered transactions as you cannot add to existing transaction data, best practice would be to create a new batch id.
Once you have selected a batch and the Paste button is available, you can copy data from a table (excluding the column headers) using the following table format.
If any Validation errors or warnings occur, the UPR Transaction Paste Validation Report will print and display the errors that it has identified, and no data will Pasted. The validation report will not print if there are no errors or warnings.
Warning messages such as 'WARNING - The pay rate amount cannot be edited.' will appear on the Payroll Transactions Paste Validation Report but will not prevent the data from pasting. Default pay rates would be used in this situation instead of the rates on the Excel spreadsheet.
15 Character Max; Must exist in company;
Pay Code, Deduction, or Benefit;
6 Character Max; Must be assigned to employee;
Number must be between 0 and 9999.99; Cannot be negative;
Number must be between 0 and 999999999.99; Decimal Places must follow Payroll Setup. Must be blank for Salary, Benefits and Deductions;
6 Character Max; Must exist in company;
MM/DD/YYYY Date format;
This feature will update Human Resources Attendance information if you are using that for tracking instead of Payroll.
This feature is not compatible with Web Client or Analytical Accounting at this time.
I hope you enjoy this feature! Continue to check back to the Microsoft Dynamics GP October 2021 - Feature Blog Series Schedule page to review upcoming blog posts related to our new features and other helpful resource links.
Business Applications communities