Top 10 Tips and Tricks for Dynamics 365 Business Central
This month's webinar is titled the "Top 10 Tips and Tricks for Dynamics 365 Business Central." Any business owner who uses Business Central won't want to miss this webinar! Learn from the pros as take a deep dive into the heart of Business Central. Watch as they demonstrate the top 10 tips and tricks that all businesses should be utilizing! Join this webinar to learn more about some tips such as:
● Multi-company access made easy
● Personalizing the system (custom fields, columns)
● Saving filtered list views
● and more
Date: Wednesday August 26, 2020
Time: 1:00PM - 1:30PM EST
Phishing emails are a form of fraud. These emails try to get personal information such as usernames, passwords, or credit card numbers. This is done by impersonating a reputable brand or person within an organization. If an employee opens a link that they don't recognize, it can be very harmful to your company. Start protecting your company by adding Microsoft 365 to your business and gaining an advanced level of security and threat protection. It's also recommended to educate employees on how to spot phishing emails to ensure that your business stays safe. Here are two tips on how to spot a phishing email.
Check the Sender's Email Address
There are so many emails that get sent to your inbox on a daily basis. Hackers can create a fake email address and select the display name that it will come from. Any from address that is not compliant with the RFC 5322 will be flagged and handled according to the phishing policy setup in Microsoft 365. When a suspicious email is received here are some things to watch out for:
1) Do you recognize the senders' email address, or it is a random string of letters?
2) You will see that the sender is not someone you work with.
3) There will be links that you are told to click on. The links will be to websites with malicious content, do not click them.
Check for Spelling Mistakes in the Body of the Email and/or in the Send Address
Hackers tend to live in different parts of the world and may not have the strongest writing skills. They rely on online translators to help them write messages, which is great for translating but not necessarily for making text grammatically correct. It's common for a phishing email to have spelling mistakes and be grammatically incorrect, which could be overlooked. If an employee receives a suspicious email, they should ask these two questions to help spot if it's a phishing email or not.
1) Does the message contain grammatical errors an English speaker shouldn't have?
2) Is the email consistent with previous emails I've received from this person?
It's essential for a small business to have security in place to detect these emails before they can cause any harm. Microsoft 365 has an ATP anti-phishing protection to protect your business from any malicious phishing attacks. Microsoft 365 offers a lot of security and advanced threat protection that small businesses should have to run a safe and successful business.
Andrew King, Managing Director at WebSan Solutions shares 10 different tips and tricks about Microsoft Dynamics GP. Watch the following video to learn more:
WebSan Solutions offers an online (SaaS) hosted-enterprise business software solution, leveraging the vast capabilities of Microsoft Dynamics GP. For more information, please contact us.
Incrementing an integer in SQL is easy; all you have to do is + 1 to the value. However, incrementing a number that has padded zeros is a little trickier, since it is probably a string value and not a number. Luckily with some type conversions, it becomes just as easy as incrementing an integer.
First thing you want to do is to get the length of the string, so you know how many padded zeros to add. You can do this by using the LEN function:
1. SELECT @Length = LEN(RTRIM(LTRIM(@Num)))
It is also a good idea to trim the value just in case there are extra spaces.
Next we can increment the number. Now we can't just do a + 1 to the value since it’s a string and doing a + 1 to a string would just concatenate the 1 to the end of the string. So let’s convert the string to an integer:
2. SET @tempNum = CONVERT(INT, @Num) + 1
Nice, now we have incremented the number. Now all we have to do is add those zeros back in and we're done. To do this, we first convert the number back to a string. Then we concatenate a bunch of zeros to the front of the number.
Last, using the RIGHT function we set the length of the string back to the original length, using the length we got earlier, so that we have the appropriate number of leading zeros. Here's how it looks:
3. SET @nextNum = CONVERT(VARCHAR(21), @tempNum)
SET @nextNum = RIGHT('000000000000000000000' + @nextNum, @Length)
There you have your incremented number!