Employees locked out of Time and Labor entry and approval

by donnasnodgrass @ Payroll

Tue Oct 11 15:21:29 PDT 2016

6/24/16 All employees are currently locked out of Time and Labor entry and approval screens for all pay periods, this is due to the PeopleSoft Finance project. Access will be restored Friday, July 1st in the afternoon, time entry is …

Test mode and non-GP report with a Word template

by Emily H @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 20:03:45 PDT 2018

Hello,

I am trying to use the 'run report' statement in Dexterity to create a docx file.  This is my first word template, but I think I have it set up and permissions/access are allowing me to see my report in runtime when I select the Template in Report Destination window and name the output file.  I want to automate this, so the run report will go directly to the docx file without user interaction.  Test mode doesn't seem to know about the Template, it only has "Standard" in the drop down list.  Can this be done in Test Mode?  Or do I have to build a chunk and try it in runtime?

I saw in the old forums that Dave Dusek posted a video years ago on how to debug, but I get "This video is unavailable" from YouTube when I try the url.

BTW - I am working in GP 2018, but the filter below does not have that as an option.

Thanks,

Emily

Pay Stub Direct is Certified

by Shawn Dumouchele @ Pay Stub Direct

Mon Jul 28 20:10:33 PDT 2014

Yayyyy....  We can now officially say that Pay Stub Direct is Certified.  We've been working on this site for a few years now, and we finally saved up some money to get an external audit, and recieved our SSL certificates.   Which means that we were verified as legit.    We provide what we say, and we have […]

The post Pay Stub Direct is Certified appeared first on Pay Stub Direct.

What Does Pay Frequency Mean?

by Michele Bossart @ Payroll Tips, Training, and News

Wed Feb 21 05:10:38 PST 2018

When you have employees, you need to run payroll so they can receive their wages. Before paying employees, you need to decide on a pay frequency. Your industry, the number of employees you have working for you, the type of workers you have, and legal requirements determine your pay frequency. But first, what does pay […]

The post What Does Pay Frequency Mean? appeared first on Payroll Tips, Training, and News.

A New W-4 Just Landed—Here’s Why You Should Care

by Caleb Newquist @ Answers to your top small business questions

Tue Mar 06 16:05:42 PST 2018

We partnered with CPA-turned-blogger Caleb Newquist to get his take on the tax topics that seriously affect small businesses. Have...Read more

The post A New W-4 Just Landed—Here’s Why You Should Care appeared first on Answers to your top small business questions.

RE: Does anyone know how Direct Deposit amount calculated on Duplicate Pay Stub?

by Robert Yao @ Does anyone know how Direct Deposit amount calculated on Duplicate Pay Stub?

Tue Jan 23 11:34:04 PST 2018

The direct deposit history table DD30101 held the direct deposit amount in DDAMTDLR field, all you need to do is to update this amount in a sql statement. The other information on this duplicate pay stub are on UPR30100. 

Make a paystub for Caretaker

by Shawn Dumouchele @ Pay Stub Direct

Sat Sep 06 19:33:05 PDT 2014

Make a paystub for caretaker We have been asked many times why someone would need to create a paystub.   We already know why you need a paystub,  like getting a loan for a car or needing a paystub to get an apartment.  Basically, any time you need to prove income or employment, you will need […]

The post Make a paystub for Caretaker appeared first on Pay Stub Direct.

Should You Offer a Nonqualified Deferred Compensation Plan?

by Mike Kappel @ Payroll Tips, Training, and News

Mon Mar 26 05:10:00 PDT 2018

You know employees like employer-sponsored benefits. As an employer, offering benefits is advantageous for your business, too. A nonqualified deferred compensation plan is one type of benefit that both you and your employees can enjoy. Find out what a nonqualified deferred compensation plan is, why you might consider offering it, and how to set it […]

The post Should You Offer a Nonqualified Deferred Compensation Plan? appeared first on Payroll Tips, Training, and News.

SmartList Issue with Inter company Transactions

by John S Miele @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 14:08:52 PDT 2018

Running GP Version 2016.00.0620

When the client runs a smartlist on Account Transactions and it brings back Inter company Transactions and will show the IC Transaction as an account for the company they are in.  So the original trx went to an expense account in another company and that account index in

FFSM (IC Account) was 54 and an expense account.

Now in the original company 54 is for a Prepaid account instead and it is showing the prepaid account.  Which if you are using the SmartList for backup is totally throwing them off.

Of course if you print the trial balance for the account, there is nothing in the Prepaid account for the Original company.

So, can anyone see if there has been a fix for this.  This is the second customer that I have run into this issue.  They want to know if there is a fix for it.

This is the second client we have run into this on and both using normal GP Inter company.

Thanks in advance 

John m

Pay Stub Security

by Shawn Dumouchele @ Pay Stub Direct

Sat Nov 22 05:08:06 PST 2014

Our website and your pay stubs just got a bit more, with our SSL certificate.   You may or may have heard of this.   An SSL certificate is just one more layer of security you should always look for when you make a purchase online.    Pay stub security is always important, but, when you spend your […]

The post Pay Stub Security appeared first on Pay Stub Direct.

Support Partner

by dynamic12 @ Microsoft Dynamics GP - Recent Threads

Fri Mar 23 12:20:57 PDT 2018

Hello,

We have a support agreement for Microsoft Great Plains, we pay a yearly fee, which I understand entitles us to all current upgrades.  If we are unhappy with our current support partner, how do I go about locating a new partner, and can you confirm we can switch partners.  We are in Illinois.

Thanks

Getting an error while creating invoice header in GP

by Priyank Bhavsar @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 06:26:54 PDT 2018

I'm trying to create an invoice header by calling the procedure 'taSopHdrIvcInsert'. It is giving me the following error:

The INSERT statement conflicted with the CHECK constraint "CK__SY00500__GLPOSTD__59F03CDF". The conflict occurred in database "TWO", table "dbo.SY00500", column 'GLPOSTDT'.
The statement has been terminated.

I googled about this error and found that it has something to do with the DocDate.

I'm passing the DocDate like below

cmd.Parameters.AddWithValue("@I_vDOCDATE", dtDocDate.ToString());

Any help would be appreciated.

Pay Stub with Tips.

by Shawn Dumouchele @ Pay Stub Direct

Mon Aug 11 15:51:48 PDT 2014

As you may know, we are constantly trying to improve our product.   So, we now ask you to tell us, or show us, what is a good format for a pay stub, with tips options on it.   Most of our pay stubs are created to assist people that have an hourly wage.    But, don't have […]

The post Pay Stub with Tips. appeared first on Pay Stub Direct.

Vendor Master Summary - Current Balance Calculation

by njstevenson86 @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 13:26:03 PDT 2018

A little background information: 

I'm working in an environment that has multiple GP 2010 instances setup (separate databases), and I've been asked to start developing consolidated AP reports directly from the SQL Databases. I've already successfully re-created the Historical ATB report for the Payment Module with an exact match, I'm now working on the Vendor Master Summary but cannot get the amounts on that to tie to the same amounts as my Historical ATB. Does anyone know how GP calculates that current balance, and from what tables? 

Thanks, 

Payroll batch with employer benefit contribution and no wages

by BillB5 @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 16:07:11 PDT 2018

Is it possible to run a payroll batch with just an employer benefit contribution and no wages?  Our management recently added a new healthcare plan that includes an HSA.  The company is going to contribute $25 a month to any employee who was employed for the entire month.  They have to verify the employee was employed for the whole month so the contribution will come the following month.  We need to be able to record the benefit contribution for W2s but they don't want to print a check for it, or include it with a normal payroll.  Any thoughts or suggestions would be greatly appreciated.

I’m a Co-Founder of Gusto and Y Combinator Alum—Here’s the Advice I Give Every Startup Founder

by Tomer London @ Answers to your top small business questions

Mon Mar 05 11:33:50 PST 2018

When we graduated from Y Combinator in the winter of 2012, we had a pretty limited payroll product and a...Read more

The post I’m a Co-Founder of Gusto and Y Combinator Alum—Here’s the Advice I Give Every Startup Founder appeared first on Answers to your top small business questions.

RE: Year End routine process cycled

by Juli @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 10:14:26 PDT 2018

Hi Mariano, GP is in SP1 and is running in the GP client server, now I have a test server to check the problem we are closing 2016 year, but the user reported the close year for 2015 was fast.

I found in SY00500 table a record with Bachnumb= GL Closing, I needed to delete this record in order to run the close year to 2016, maybe some information is incorrect or some else in tables is in incorrect, I don´t know if this can be a problem.

Last night was running the process but It doesn´t finish, and I only found the GL20001 table updated

Regards

Julia

Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by Arfcorp @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 15:45:17 PDT 2018

Microsft GP 2016:

How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or using Integration Manager?

We have 200 customers and we bring in sales documents through IM. So, if I bring in 200 sales and about 25 credit memos. I would like to post the sales invoices, then post the credit memos and have them auto apply to the sales invoices. This way, when we bring in the cash receipts these will auto apply to the balance correctly. Currently, we are having to either manually auto apply or use apply sales documents.  I see a tool RM Auto Apply mentioned on forums - is this available for GP 2016? does this work?

These Are the Paid Holidays Most Small Businesses Give Their Teams

by Tim Sackett @ Answers to your top small business questions

Mon Mar 12 14:31:03 PDT 2018

HR pro Tim Sackett is here to break down the top human resources issues that affect small businesses. Have a...Read more

The post These Are the Paid Holidays Most Small Businesses Give Their Teams appeared first on Answers to your top small business questions.

Year End routine process cycled

by Juli @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 11:27:38 PDT 2018

Hi,

     A client is trying to run the year end process, but this never ends... I activated a SQL Tracer and it shows an insert in GL20001 table, but the proceess seems to be cycled, if I check the table I found the same records number and they don´t change the amounts for debit and credit columns, this process never ends and never execute the routine to copy from GL20000 to GL30000.

The versión of GP is GP2010.

Regards

Julia Gallegos

Blog Post: Setting a New Default Checkbook

by L Vail @ Microsoft Dynamics GP

Tue Mar 27 13:34:00 PDT 2018

So, you’ve changed banks and opened a new account. Now it’s time to create a new checkbook in GP and assign it as the default Checkbook ID. No problem, you’ve got this: Create a New GL Account Create a New Checkbook ID Assign the new Checkbook as the default. This is where the trouble starts. Where in the world can you set the default company Checkbook ID? The truth is, there is no single place to set the default Checkbook ID. You need to set it in several places if you want to use the same checkbook for all of the modules. Each of the following modules has a default checkbook setting. Payables Management Purchasing | Setup | Payables Receivables Management Sales | Setup | Receivables Sales Order Processing Sales | Setup | Sales Order Processing Payroll HR & Payroll | Setup | Payroll | Payroll Bank Reconciliation Financial | Setup | Financial | Bank Reconciliation Now, you need to check to see if you have any checkbook default identified on the Vendor card or Customer card. When processing a receivables or SOP transaction, GP will look for a checkbook ID at the customer card first. If it doesn’t find one there, it will look to the Receivables Management Setup window or the Sales Order Processing Setup window, depending on what kind of transaction you are entering. For payables, it will look first to the Vendor card and then to the Payables Setup window. You should never have the same Checkbook ID on a card that you have on the setup window. Let the program do the work for you. Only put a separate Checkbook ID at the card level if you have an exception from your usual checking account. If you find that you do have a Checkbook ID set on the cards and want to remove it, you can use the Class ID to remove it and then roll down the changes. If you have too many classes to do it manually, or no classes at all, you can use SQL to remove the Checkbook IDs. Your update statements would look similar to those below if you wanted to remove them all. For Vendors: UPDATE PM00200 SET CHEKBKID = '' For Customers: UPDATE RM00101 SET CHEKBKID = '' If you are using a third-party product such as Mekorma MICR or BGE Green Payable there will be other places where you’ll need to change the default. Take a look at the setup screens for any add-on products you are using and look for a Checkbook ID setting. If you find some other places where the Checkbook ID may need to be changed, please leave a comment and I’ll include it in the body of the post. Live the dream! Leslie

Answers to 18 Payroll Questions You Are Dying to Ask

by Rachel Gray @ Payroll Tips, Training, and News

Mon Mar 05 05:10:18 PST 2018

For some business owners, running payroll might be like learning a foreign language. You are a master of your business idea, not the administrative responsibilities that come with it. Because you might not be familiar with these responsibilities, you might have some payroll questions. Payroll questions and answers When you become an employer, you need […]

The post Answers to 18 Payroll Questions You Are Dying to Ask appeared first on Payroll Tips, Training, and News.

RE: Password Change Failed for an Unknown Reason

by Béat Bucher @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 11:31:06 PDT 2018

Yes it is.. but it worth 10 times the money you pay for it every year.. just as an example like this, it would have paid for itself already :-)

No Records in Table SY09400 - GP2016

by Anvar @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 04:00:04 PDT 2018

All,

I couldn't see the below option in GP 2016 to generate the records in table SY09400. 

1. Click Microsoft Dynamics GP, point to Maintenance, and then click Clear Data to open the Clear Data window. 
2. On the Display menu, click Physical.  
3. In the Series list, click System.  
4. In the Tables pane, click the Security Resource Descriptions table, and then click Insert.   
5. Click OK.   
6. Click Yes.   
7. In the Report Destination window, select the Screen check box, and then click OK to send the report to the screen.   
8. Close the report.

Please advice.

Thanks,

Anvar

Pay Stub with a Logo

by Shawn Dumouchele @ Pay Stub Direct

Mon Aug 11 15:41:32 PDT 2014

In our constant push to make our Pay Stubs accurate, and authentic,  we're adding a LOGO option.   yes..  now, you can create your Pay Stub with a Logo on it, of your choosing.   Just get the image, and upload it, with our easy addon ability right in the maker. This has never been done online […]

The post Pay Stub with a Logo appeared first on Pay Stub Direct.

Will the Courts Accept a Jury Duty Excuse Letter If You’re in a Pinch?

by Rachel Gray @ Payroll Tips, Training, and News

Mon Mar 19 05:10:23 PDT 2018

Sometimes, you or your employees’ personal responsibilities conflict with your business. For many small businesses, if you miss work or lose an employee for an extended period of time, there can be harmful effects on productivity in the workplace. But if you or an employee are called in for jury duty, you might not have […]

The post Will the Courts Accept a Jury Duty Excuse Letter If You’re in a Pinch? appeared first on Payroll Tips, Training, and News.

RE: GP 2016 Web Client user can login but errors are showing up in SQL error log

by Derek Albaugh @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 11:00:15 PDT 2018

The Runtime Service uses the FQDN if it is a self-signed certificate or one created in CA. If using a third-party certificate, you could potentially have it setup however.

The fact that your users can login to Web Client, but get prompted for the GP login window means that Identity Management is not setup correctly. The 3 parts of this setup is:

1. In GP Utilities, you create a proxy login which then gets created in SQL with the DYNGRP role assigned for all system and company databases for GP.

2. When installing Web Client, this exact proxy login and password needs to be entered in the GP Configuration window, which shows the paths to your GP code directory, Dex.ini and Dynamics.set file.

3. Lastly, in the User Setup window in GP, the GP logins need to be tied/associated to the Windows account they are logging into Web Client's initial login window as.

If this is all setup correctly, then yes, when the user logs onto Web Client using their Windows account, it should see they are tied to a GP login and log them into the GP application automatically as that user, only seeing a company selection window if they have access to more than one GP company.

I'd verify the above 3 settings again, as most likely they are not correct. I'd also recommend not copying/pasting user ids and passwords as well, as I've seen that not always work.

Thanks

Forum Post: RE: Getting an error while upgrading Dynamics GP company database to 2016R2

by Preetham theGP @ Microsoft Dynamics GP

Tue Mar 27 12:16:00 PDT 2018

Beat, Thanks for your help but i am having issues again though i updated to 2230. Same errors again, please find below. Please let me know if you have any comment. "There was a problem ascertaining product version information Microsoft Dynamics GP Utilities will now exit. Please check the duinstall.log file for more information" When i checked duiinstall.log file here is the error i have noticed, "Failure encountered ON 3/27/2018 at 2:12:16 PM. Error: Product 0 does not support upgrading from version 12.0.2230."

Forum Post: Vendor Master Summary - Current Balance Calculation

by njstevenson86 @ Microsoft Dynamics GP

Tue Mar 27 13:26:00 PDT 2018

A little background information: I'm working in an environment that has multiple GP 2010 instances setup (separate databases), and I've been asked to start developing consolidated AP reports directly from the SQL Databases. I've already successfully re-created the Historical ATB report for the Payment Module with an exact match, I'm now working on the Vendor Master Summary but cannot get the amounts on that to tie to the same amounts as my Historical ATB. Does anyone know how GP calculates that current balance, and from what tables? Thanks,

Test mode and non-GP report with a Word template

by Emily H @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 20:03:45 PDT 2018

Hello,

I am trying to use the 'run report' statement in Dexterity to create a docx file.  This is my first word template, but I think I have it set up and permissions/access are allowing me to see my report in runtime when I select the Template in Report Destination window and name the output file.  I want to automate this, so the run report will go directly to the docx file without user interaction.  Test mode doesn't seem to know about the Template, it only has "Standard" in the drop down list.  Can this be done in Test Mode?  Or do I have to build a chunk and try it in runtime?

I saw in the old forums that Dave Dusek posted a video years ago on how to debug, but I get "This video is unavailable" from YouTube when I try the url.

BTW - I am working in GP 2018, but the filter below does not have that as an option.

Thanks,

Emily

Pay Stub Direct from Manufacturer

by Shawn Dumouchele @ Pay Stub Direct

Wed Jun 18 22:22:23 PDT 2014

Accurate Authentic and Detailed, these are the 3 most important values we strive for here at Pay Stub Direct, in our quest to create our masterpiece.  Yes, Easy is important, yes, Value is important, and we do very well.     But, our primary objective, is the 3 we mentioned.    Ultimately, that is why you are here, […]

The post Pay Stub Direct from Manufacturer appeared first on Pay Stub Direct.

What Is an FEIN?

by Mike Kappel @ Payroll Tips, Training, and News

Mon Feb 26 05:10:00 PST 2018

When you run a business, you must meet many IRS requirements. You might need an FEIN to identify your business on documents like payroll tax forms. What does FEIN mean? What is an FEIN? FEIN is an acronym for Federal Employer Identification Number, also known as an EIN. This unique, nine-digit number is used by […]

The post What Is an FEIN? appeared first on Payroll Tips, Training, and News.

Forum Post: Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by Arfcorp @ Microsoft Dynamics GP

Tue Mar 27 15:45:00 PDT 2018

Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or using Integration Manager? We have 200 customers and we bring in sales documents through IM. So, if I bring in 200 sales and about 25 credit memos. I would like to post the sales invoices, then post the credit memos and have them auto apply to the sales invoices. This way, when we bring in the cash receipts these will auto apply to the balance correctly. Currently, we are having to either manually auto apply or use apply sales documents. I see a tool RM Auto Apply mentioned on forums - is this available for GP 2016? does this work?

RE: Migrate to new SQL server

by Zaza @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 10:12:42 PDT 2018

Thanks Leslie for your insight.. I'm going from GP2013 to 2016 and I want move to a new server with a fresh new OS and SQL.. I will do it the way you suggest (without installing GP2013 but just copying the db and then install 2016.. Hoping it will work as we have many extra modules (Mekorma, ePaystub for Canadian Payroll, customization everywhere.... and integrations with other systems... etc etc).. But I always prefer a fresh install to an upgrade so your scenario works for me..  Crossing my fingers..  (but will be doing it as a test only first )

UPR30100 and UPR30300

by WindyCityGP @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 06:58:56 PDT 2018

I have found a some payroll checks that are in the UPR30300, but not in the UPR30100; should that be posssible?  This is after I ran Checklinks across the payroll module.  Is there a script that I could run that would list out those transactions that are in the UPR30300 and not in the UPR30100?

Thank you.

What You Need to Know About a Qualifying Life Event

by Rachel Gray @ Payroll Tips, Training, and News

Mon Mar 12 05:10:40 PDT 2018

Employees have a window of time each year to sign up for certain types of employer-sponsored insurance. Although this open enrollment period takes place at the end of each year for all employees, an employee can add or remove coverage at any time of the year if they have a qualifying life event. What is […]

The post What You Need to Know About a Qualifying Life Event appeared first on Payroll Tips, Training, and News.

Why Create your own paystubs

by Shawn Dumouchele @ Pay Stub Direct

Sat Nov 22 05:09:08 PST 2014

The post Why Create your own paystubs appeared first on Pay Stub Direct.

Vendor Master Summary - Current Balance Calculation

by njstevenson86 @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 13:26:03 PDT 2018

A little background information: 

I'm working in an environment that has multiple GP 2010 instances setup (separate databases), and I've been asked to start developing consolidated AP reports directly from the SQL Databases. I've already successfully re-created the Historical ATB report for the Payment Module with an exact match, I'm now working on the Vendor Master Summary but cannot get the amounts on that to tie to the same amounts as my Historical ATB. Does anyone know how GP calculates that current balance, and from what tables? 

Thanks, 

Password Change Failed for an Unknown Reason

by john.ellisrsmus @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 18:05:59 PDT 2018

Hello: If the error "password change failed for an unknown reason" is not attributable toward group policies or other Active Directory items, what else could it be attributable toward? Thank you! John

Add a logo to your paystub

by Shawn Dumouchele @ Pay Stub Direct

Fri Sep 26 17:00:32 PDT 2014

Some paystubs have Company Logos that show the validity of the Company,  and authenticity.    This can also make your stubs look more professional.   In 2017,  I'd say about 80% of paystubs have a paystub logo on them. We have upgraded our site to be able to add a logo to your paystub.   This new feature […]

The post Add a logo to your paystub appeared first on Pay Stub Direct.

Upgrading Without Source Code Control?

by chadbruels @ Microsoft Dynamics GP - Recent Threads

Fri Mar 23 10:03:26 PDT 2018

In the near future I will be helping someone upgrade a development dictionary from GP 2013 R2 to GP 2016 R2. The environment does not have any source code repository, so I am writing today to explore options for a successful upgrade.

The help document for Dex Utilities states:

The Developer Update utility is no longer used to move integrating applications to new versions of Microsoft Dynamics GP. You must now use the source code control capabilities in Dexterity to update your integrating applications. Refer to the Integration Guide for a complete description of this process.

So I believe that option is not viable. I am interested in why that utility can no longer be used for this if anyone has background there.

Setting up a Generic provider in Source Control Options:

I feel the next easiest option would be defining a Generic provider in Dexterity. I have some assumptions about that I would like to ask about.

1. This will not provide version control, but that should not matter for this process.
2. It will allow us to check in the dictionary resources - pointing to a compressed 2013 R2 dictionary in the Original Dictionary field - which will simply store them as text files in a folder on the drive.
3. Then we can pull those resources "down" into a compressed copy of a 2016 R2 dictionary - pointing to a compressed 2016 R2 dictionary in the Original Dictionary field - and that should give us a proper upgrade. 
4. We always want to use an Index file. Is there any issue with doing that with a Generic provider? 

I feel this should be obvious, but I have always done this process with either Visual Source Safe or Team Foundation Server. 

How to Calculate a Raise

by Rachel Gray @ Payroll Tips, Training, and News

Wed Mar 14 05:10:09 PDT 2018

Employees have money on their minds. According to a Gallup poll, 59% of employees were not completely satisfied with their current pay. And, one SHRM survey found that 44% of respondents said they would leave their job to make more money elsewhere. To avoid losing their top employees, many businesses offer pay raises. Learn why employee […]

The post How to Calculate a Raise appeared first on Payroll Tips, Training, and News.

Deleting Stuck FA Purchasing Transactions

by TracySam @ Microsoft Dynamics GP - Recent Threads

Fri Mar 23 11:15:12 PDT 2018

Hi,

There are 2 transactions which appear to be stuck in the FA Purchasing table and are automatically added to any transaction I pull on from the Purchase window.  I can see the amounts if I click on the expansion beside Acquisition Cost.  I have checked the FA01100 table and they are not there.  They are also not the Purge Purchasing Transactions window.

How can I get rid of these transactions ?

Thanks

A Look at Federal, State, and Local Minimum Wages

by Mike Kappel @ Payroll Tips, Training, and News

Wed Mar 21 05:30:00 PDT 2018

You can’t just pay your employees any amount you want. You must follow federal, state, and local laws that set minimum wages. What is minimum wage? Minimum wage is the lowest amount you can pay an employee per hour of work. You can pay more than the minimum wage, but you should never pay less […]

The post A Look at Federal, State, and Local Minimum Wages appeared first on Payroll Tips, Training, and News.

Correcting Employment Taxes: What to Do If You Withhold the Wrong Amount

by Rachel Gray @ Payroll Tips, Training, and News

Wed Feb 28 05:10:52 PST 2018

It’s easy to make mistakes, especially when you have a million and one things on your plate. One error you could make is deducting the wrong amount from employee wages. Correcting employment taxes is necessary if you withhold too much or too little from your employees’ paychecks. This article provides an overview of employment taxes […]

The post Correcting Employment Taxes: What to Do If You Withhold the Wrong Amount appeared first on Payroll Tips, Training, and News.

Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by Arfcorp @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 15:45:17 PDT 2018

Microsft GP 2016:

How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or using Integration Manager?

We have 200 customers and we bring in sales documents through IM. So, if I bring in 200 sales and about 25 credit memos. I would like to post the sales invoices, then post the credit memos and have them auto apply to the sales invoices. This way, when we bring in the cash receipts these will auto apply to the balance correctly. Currently, we are having to either manually auto apply or use apply sales documents.  I see a tool RM Auto Apply mentioned on forums - is this available for GP 2016? does this work?

RE: Getting an error while upgrading Dynamics GP company database to 2016R2

by Preetham theGP @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 12:16:11 PDT 2018

Beat,

Thanks for your help but i am having issues again though i updated to 2230. Same errors again, please find below. Please let me know if you have any comment.

"There was a problem ascertaining product version information Microsoft Dynamics GP Utilities will now exit. Please check the duinstall.log file for more information"

When i checked duiinstall.log file here is the error i have noticed,

"Failure encountered ON 3/27/2018 at 2:12:16 PM.  Error:  Product 0 does not support upgrading from version 12.0.2230."

Password Change Failed for an Unknown Reason

by john.ellisrsmus @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 18:05:59 PDT 2018

Hello: If the error "password change failed for an unknown reason" is not attributable toward group policies or other Active Directory items, what else could it be attributable toward? Thank you! John

Hiring Time

by Bobby @ 5 STAR Event Services

Fri Feb 12 11:48:26 PST 2016

Hello Houston, It’s Rodeo time and we’re hiring! Get in on some Rodeo action and get paid! If you’re a Non-commission security officer or if you would like to become one, give us a call and we’ll get you started. Qualified applicants must have strong customer service

The post Hiring Time appeared first on 5 STAR Event Services.

Forum Post: RE: Inventory Reconcile and QTY on Hand

by L Vail @ Microsoft Dynamics GP

Tue Mar 27 15:50:00 PDT 2018

Hi Tania, It is my understanding that the reconcile utility doesn't interact with the SEE30303 table. The reconcile utility goes through 6 steps. I know there is a KB out there, but I don't recall the number. Here's what I have in my notes as to what goes on in the reconcile: Quantities are reconciled between the Purchase Receipts Work (IV10200) and Purchase Receipts Detail (IV10201). In this step, Item Balance is calculated. If the in and out tables don’t match, RECON records are added to the Purchase Receipts Detail (IV10201). Item Balance is reconciled against the Serial/Lot Number Master Tables (IV002/300) Quantities are reconciled between the Purchase Receipts Work (IV10200) and the Item Quantity Master (IV00102). Quantities are reallocated according to several tables: Inventory Transactions Amounts Work (IV10001) Inventory Serial and Lot Number Work (IV10002) Sales Transaction Amounts Work (SOP10200) Sales Serial/Lot Work and History (SOP10201) Invoicing Transaction Amounts Work Invoicing Serial and Lot Number Work On order Qtys in the POP receipt and line tables are compared to the Item Quantity Master (IV00102) The Item Quantity Master (IV00102) is checked for internal consistency between site and record total Kind regards, Leslie

FREE PAY STUB PROMO

by Shawn Dumouchele @ Pay Stub Direct

Tue Aug 12 13:16:25 PDT 2014

Yes... It's true..     We love testimonials.   and happy customers..  with our Free Pay Stub Promo Deal!!! So, here it is..          Use (Purchase)  our pay stubs, and then take a Selfie in front of the purchase or rental or whatever you use the pay stub for.     With you in it, and a piece of Cardboard   […]

The post FREE PAY STUB PROMO appeared first on Pay Stub Direct.

Year End routine process cycled

by Juli @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 11:27:38 PDT 2018

Hi,

     A client is trying to run the year end process, but this never ends... I activated a SQL Tracer and it shows an insert in GL20001 table, but the proceess seems to be cycled, if I check the table I found the same records number and they don´t change the amounts for debit and credit columns, this process never ends and never execute the routine to copy from GL20000 to GL30000.

The versión of GP is GP2010.

Regards

Julia Gallegos

RE: GP 2016 Web Client user can login but errors are showing up in SQL error log

by Béat Bucher @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 10:43:13 PDT 2018

Derek,

Yes.. the SQL user login GPWebClient has the permissions in the security to access the DYNAMICS db and all the company DB's under the DYNGRP & Public role..

Regular GP user can fully login into the fat client without any issues.

When trying to use the web client, they do get prompted with the GP Login screen too, instead of selecting the company straight after the Windows login page..

Trying to select 'Directory Account' in the GP login rather then "SQL server account" returns the error pop-up "This login failed. Attempt to log in again or contact your system administrator."

Using the regular GP login in the WebClient works fine.. just defeats the purpose of the SSO..

Consult This Employee Termination Checklist to Keep Things Running Smoothly

by Rachel Gray @ Payroll Tips, Training, and News

Wed Mar 07 05:10:00 PST 2018

Employees leave companies every day to pursue growth opportunities, accommodate personal lives, or experience change. As an employer, you hope employees won’t leave your business, but you know this is wishful thinking. When an employee resigns, you need to know what to do. The average annual overall turnover rate is 19%, according to SHRM. If […]

The post Consult This Employee Termination Checklist to Keep Things Running Smoothly appeared first on Payroll Tips, Training, and News.

Pay Stub to book a Vacation

by Shawn Dumouchele @ Pay Stub Direct

Wed Jul 01 18:46:08 PDT 2015

Nowadays,  to book a flight, all you need to do is get online, submit locations and dates, and you'll get the best prices available from participating airlines.    But,  a little-known fact,  that is not the best way to book full vacations.    The best way is to use a travel agent.   Those relics of the past.    […]

The post Pay Stub to book a Vacation appeared first on Pay Stub Direct.

Fall is Rockin’ – Now Hiring

by Bobby @ 5 STAR Event Services

Tue Sep 15 09:07:12 PDT 2015

  Fall has some exciting events this year and we are NOW HIRING security and event staffing.  If you are looking for a fun and event filled fall, be sure to check out our events calendar for the full fall schedule.  New events are being added all

The post Fall is Rockin’ – Now Hiring appeared first on 5 STAR Event Services.