ACE Rated by Microsoft as Top VAR at Worldwide Partner Conference 2012! Thanks go to all our great clients and our internal team at ACE!
"We are truly honored by this and grateful for our strong Microsoft Partnership" said Susan Looby, President of ACE Microtechnology, Inc.
Monday, July 16, 2012
Thursday, July 5, 2012
Dynamics GP 2010 Service Pack 3 Install
slidesharecdn.com/swf/doc_player.swf?doc=11-0sp3installguideenus-120705064207-phpapp02&stripped_title=110-sp3-installguideenus&userName=slooby9" />
View more documents from ACE Microtechnology, Inc..
Friday, March 16, 2012
Wednesday, March 14, 2012
GP 2010 Security Report
I received a request from a client who needed to supply a GP User Security Report to their auditors. Prior to GP version 10, we were at the mercy of the GP Report Writer report that was typically several thousands to several tens of thousands of pages long. We would usually modify the report to print one line per record to save space and so that it was easily exported, but even that produced a very large file. Now with the new Role-based Security in GP 10 and 2010, we have access to this data in SQL. I developed the script below and thought that others in the GP community might find it useful. It provides a nice, simple view of the user security in GP. It does not drill down to the specific window level, but it has every user, the companies they access, the roles they are assigned to in each company and the task and task descriptions within each role. Pretty sweet. I hope you guys can use it someday.
The script:
Use dynamics
select rol.userid, cmp.interid, rol.securityroleid, tsk.securitytaskid, td.securitytaskname, td.securitytaskdesc
from SY10500 rol
inner join SY01500 cmp on rol.cmpanyid=cmp.cmpanyid
inner join SY10600 tsk on rol.securityroleid=tsk.securityroleid
inner join SY09000 td on tsk.securitytaskid=td.securitytaskid
order by rol.userid, cmp.interid, rol.securityroleid, tsk.securitytaskid
A sample result set:

Tonya Boyce
ACE Microtechnology, Inc.
www.acemicrotech.com
tboyce@acemicrotech.com
The script:
Use dynamics
select rol.userid, cmp.interid, rol.securityroleid, tsk.securitytaskid, td.securitytaskname, td.securitytaskdesc
from SY10500 rol
inner join SY01500 cmp on rol.cmpanyid=cmp.cmpanyid
inner join SY10600 tsk on rol.securityroleid=tsk.securityroleid
inner join SY09000 td on tsk.securitytaskid=td.securitytaskid
order by rol.userid, cmp.interid, rol.securityroleid, tsk.securitytaskid
A sample result set:

Tonya Boyce
ACE Microtechnology, Inc.
www.acemicrotech.com
tboyce@acemicrotech.com
Sunday, March 11, 2012
Thursday, November 10, 2011
ACE Holiday Fund Raiser

ACE Team is helping our client American Superba by paying tribute to Darin McClure and Stephanie Harrell’s family this year for the Holiday Season!
2011 has added some unforeseen stress for this client and ACE would like to assist in some small way to make their holiday season more joyous!
Background:
Darin McClure, President of American Superba of Dalton, Georgia, departed this life at age 45, September 26, 2011 in Barcelona, Spain of a heart attack while on a business trip. Darin was born April 24, 1966 in Dalton, Georgia, a son of the late Marvin Lee and Pearlene Southerland McClure. He is survived by his loving wife of twenty-two years, Lisa Jones McClure; son, Landon McClure; daughter, Ali McClure all of Chatsworth, GA.

And if that wasn’t enough one of their Key Employees Stephanie Harrell’s son Brock, age 8 was diagnosed with a rare disease *aplastic anemia (AA) and **paroxysmal nocturnal hemoglobinuria (PNH) in early September, 2011.
They are looking at many options for Brock but so far a bone marrow transplant match has not been found. You can get the backstory and keep up with Brock’s journey at www.caringbridge.org/visit/brockharrell
The ACE team is doing a fund raiser for the next six weeks in lieu of “Client Gift Baskets” to support the Harrell children during a very tough holiday season.
For every “Like” on Brock or Darins’ picture, ACE will contribute $1 towards gift certificates for the children of the Harrell family. We will up the donation once we hit 250 “Likes” to $2 per like. Please take a moment to keep these two families in your thoughts and prayers and click on the “Like” button every time you do.
As President of ACE, I want to thank all of you for your support throughout 2011 and wish all of you a prosperous, happy and healthy 2012!
Sincerely,
Susan Looby, President, ACE Microtechnology
Susan Looby, President, ACE Microtechnology
*Aplastic anemia is a rare, non-contagious and often life-threatening disorder that results from the unexplained failure of the bone marrow to produce red blood cells, white blood cells and platelets. A decrease in the production of blood cells means that patients are more susceptible to bleeding, fatigue and infections.
Incidence
Aplastic anemia affects two to six people per million worldwide. The disease is more prevalent in Asia than in the Western world. Most cases occur in older adults, but a significant number of children are affected.
**Paroxysmal nocturnal hemoglobinuria (PNH), an acquired hematologic disorder characterized by intravascular hemolysis, nocturnal hemoglobinuria, thrombotic events, serious infections, and bone marrow failure, is very rare in children. PNH is caused by a somatic mutation of the phosphatidylinositol glycan (GPI) complementation class A (PIGA) gene, followed by a survival advantage of the PNH clone, which results in a deficiency of GPI-anchored proteins on hematopoietic cells. Currently, immunophenotypic GPI-linked anchor protein analysis has replaced the acid Ham and sucrose lysis test, as it provides a reliable diagnostic tool for this disease. The presence of PNH clones should be considered in every child with an acquired bone marrow failure syndrome, for example (hypoplastic) myelodysplastic syndrome and aplastic anemia, and/or unexpected serious thrombosis. Treatment of PNH in children is dependent on the clinical presentation. In cases of severe bone marrow failure, stem cell transplantation should be seriously considered as a therapeutic option even if no matched sibling donor is available. This article reviews the reported cases of PNH in children using the recently published guidelines for classification, diagnostics, and treatment.
Incidence
Aplastic anemia affects two to six people per million worldwide. The disease is more prevalent in Asia than in the Western world. Most cases occur in older adults, but a significant number of children are affected.
**Paroxysmal nocturnal hemoglobinuria (PNH), an acquired hematologic disorder characterized by intravascular hemolysis, nocturnal hemoglobinuria, thrombotic events, serious infections, and bone marrow failure, is very rare in children. PNH is caused by a somatic mutation of the phosphatidylinositol glycan (GPI) complementation class A (PIGA) gene, followed by a survival advantage of the PNH clone, which results in a deficiency of GPI-anchored proteins on hematopoietic cells. Currently, immunophenotypic GPI-linked anchor protein analysis has replaced the acid Ham and sucrose lysis test, as it provides a reliable diagnostic tool for this disease. The presence of PNH clones should be considered in every child with an acquired bone marrow failure syndrome, for example (hypoplastic) myelodysplastic syndrome and aplastic anemia, and/or unexpected serious thrombosis. Treatment of PNH in children is dependent on the clinical presentation. In cases of severe bone marrow failure, stem cell transplantation should be seriously considered as a therapeutic option even if no matched sibling donor is available. This article reviews the reported cases of PNH in children using the recently published guidelines for classification, diagnostics, and treatment.
Monday, September 12, 2011
Five steps to building a multichannel culture | RetailCustomerExperience.com
5 Steps to a customer-centric multichannel culture: #5 Look outside for competitive models & best practices. More @
Now is the time to implement culture change to be part of the digital age of commerce.
Subscribe to:
Posts (Atom)