BC Workflow- No Approval, Rejection, Delegate comments in notification emails

-
Image
  According to Microsoft, there is no roadmap to add workflow approval, rejection and delegate comments to the BC out of the box email notifications. You can always add an extension, but this should be OOB.  I need the community to help vote this up!  Please go here and vote today:  https://experience.dynamics.com/ideas/idea/?ideaid=a2be05ef-3d3c-eb11-8fed-0003ff68d921
Post a Comment

Dynamics GP Year-End Payroll Audit List for W-2

-


It's that wonderful time of year for payroll administrators, where you need to validate employee information prior to sending out your W-2 wage reports. 

The SQL script below can either be ran via SQL or inserted into SmartList Builder as a SQL statement and used to build a SmartList. 

It will return Employee and Employee Address Information.


Run the following Script against each company Database:  

select UPR00100.EMPLOYID ID, CASE INACTIVE WHEN 0 THEN 'ACTIVE' when 1 THEN 'INACTIVE' END AS STATUS, LASTDAYWORKED_I LASTDAY, EMPLCLAS CLASS, LASTNAME LAST_NAME, FRSTNAME FIRST_NAME, MIDLNAME MIDDLE, UPR00100.ADRSCODE ADDRESS_CODE, SOCSCNUM SOCIAL_SEC_NUM, CASE GENDER WHEN 1 THEN 'MALE' WHEN 2 THEN 'FEMALE' END AS GENDER, DEPRTMNT DEPARTMENT, DIVISIONCODE_I DIVISION, JOBTITLE TITLE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, ZIPCODE from UPR00100 

left outer join UPR00102

on UPR00100.EMPLOYID=UPR00102.EMPLOYID and UPR00100.ADRSCODE=UPR00102.ADRSCODE

order by LASTNAME


Comments

Post a Comment

Popular posts from this blog

Formatting Phone Numbers in SQL Reporting Services

-
Image
Every time, without fail, I need to create a phone number on an SSRS report for a client and get stuck with phone formatting. Every time I am searching forums. I thought it would be awesome if it was in some amazing blog that I could visit and copy from each time. So... here it is, if not for myself, then for others: In Report Builder or visual studio, add your phone number field to the report.  Right click on that text box where you added the field and click on expression.  Clear the formula box and type in the expression below. Formula to Use:  =IIF(Fields!Phone.Value Is Nothing, Nothing, IIF(IsNumeric(Fields!Phone.Value), Format(Val(Fields!Phone.Value), "(000) 000-0000"), Fields!Phone.Value)) Note:  My field is actually called Phone. If your field is not called phone, you will need to replace it with your phone field name. (Like: Fields!E_T_PHONE_HOME.Value) Then click on OK at the bottom of the expression box. Run your report.
Read more

Dynamics 365 Business Central vs. NetSuite and Other Competitors- Common Myths Debunked

-
Image
  Dynamics 365 Business Central (BC) vs. NetSuite and Other Competitors- Common Myths Debunked A former colleague of mine was recently emailed a copy of the NetSuite partner monthly newsletter. The head article from NetSuite sales was regarding Business Central and it's upgrade versions, all taken from a personal blogger/system administrator. They were using this blog as facts as what was going on with Business Central. After digging on the World Wide Web a little deeper, I was able to find many sites and documentation from NetSuite on what appeared to be "facts" about Business Central (BC). I also found similar articles from other competitors: Acumatica and Intaact. Here are some of the common myths I am seeing published online: Business Central is siloed Business Central doesn't have automated upgrades and users are all on different versions Business Central is not a robust ERP Business Central is new Business Central doesn't have a lot of customers Business Cen
Read more

Business Central Versus NetSuite- Side by Side Comparison

-
Image
Side-by-Side Comparison  After my last blog post, I have received lots of requests for my version of a side-by-side comparison chart for Microsoft Dynamics 365 Business Central vs. Oracle NetSuite.  Here you go!  Feel free to Share the Business Central love!  Dynamics 365 Business Central vs. NetSuite Features Comparison Chart Features Comparison Dynamics 365 Business Central NetSuite Core Financial Capabilities (GL, AP, AR, BR) Included Included Multi-Budgets, Currencies, Fixed assets, Distribution, Manufacturing, Job Costing Included Al La Carte Pricing Modern  Interface Included Not Included Users Can Personalize All Windows Included Not Included Number of  Included Upgrades per Year 2 2 Recommended Company Annual Revenue $1-999M $1M-5
Read more