Windows 10 - USB Mouse disconnects or loses power randomly. You hear the sound of the USB device being unattached. How to restart a usb port or connection.

Original Workarounds here
https://support.microsoft.com/en-us/help/817900/usb-port-may-stop-working-after-you-remove-or-insert-a-usb-device

http://www.tomshardware.com/answers/id-1783536/usb-ports-disconnecting-reconnecting.html

At the end of the day the only thing that really worked for me was restating the machine, or restarting the Chipset Host Controller under the Universal Serial Bus Controllers

• How to restart a usb port or connection
• Go to Control Panel>Device Manager>Universal Serial Bus Controllers
• Each USB port will have a corresponding Host Controller
• For each one, right click and disable, then right click and enable
• How to disable USB Suspend Power Settings
• Scroll to the right and type 'Power Options' in the search field and click on it.
• Click 'Change plan setting' on your chosen plan.
• Click 'Change advanced power setting' on your chosen plan.
• Find 'USB settings' and open.
• Find 'USB selective suspend setting' and change it to disabled.

Dynamics GP - Table Open Error

This error occurs if a specific report in a dictionary may have been corrupted or is out of date.
Restore your dictionary to resolve.

eOne Flexicoder - Access to the window1 window was denied

Create a task to give users access to this window under security tasks Flexicoder>Windows>System>Window1

Dynamics GP - Report Writer - Display 0 dp for Quantity on SOP Invoice

• Create a calculated field of type integer equal to the Quantity field
• Integer fields naturally have 0 dp, and require no formatting
• To display 2 dp, create a calculated field of type currency equal to the Quantity field
• go to the field properties, and select the formatting from the SOP Work Amounts table > Decimal Places Currency 
• This will force it to format to the currency decimals for this item (which should be 2)
• To remove the $ sign, apply the format DLR_RB0_STR, remove the format field (set to none)

SQL - Dynamics NAV - Row Combine - How to combine a single field with multiple rows into a long string with | to use in filters

https://tableplus.com/blog/2018/10/concatenate-multiple-rows-from-subquery-to-a-string-sql-server.html

Example2

SELECT p1.grp,

          ( SELECT [Item No_] + '|'  + [BI_ItemQty] where QtyOnHand <> 0 ) p2

             WHERE p2.grp = p1.grp

             ORDER BY [Item No_]

               FOR XML PATH('') ) AS AllComm

      FROM (select [Item No_], 1 as grp from [BI_ItemQty] where QtyOnHand <> 0 ) p1

     GROUP BY grp ;

To combine all rows in a table

--------------------------------------

SELECT distinct

       (STUFF((SELECT distinct CAST(', ' + [Location Code] AS VARCHAR(MAX)) 

         FROM [BI-ItemQty]

         --WHERE (item_id = products.item_id) 

         FOR XML PATH ('')), 1, 2, '')) AS AllComm

FROM [BI-ItemQty]

Windows 10 - Disk Usage goes to 100% or very high after resuming from sleep, suspend, or raising the lid

https://support.microsoft.com/en-us/kb/2922899

Workaround

• Change power plan to Balanced.
• Start Command Prompt as administrator, and then run the following commands:

powercfg /setacvalueindex scheme_max sub_disk 0b2d69d7-a2a1-449c-9680-f91c70521c60 1
powercfg /setdcvalueindex scheme_max sub_disk 0b2d69d7-a2a1-449c-9680-f91c70521c60 1

•  Change the power plan back to Power Saver.

 

You can also contact the computer vendor for a BIOS update that may fix the issue.

Dynamics GP - "Duplicate Numbers are not allowed" in Edit List

One of your tables has errant or half-posted numbers

Use these queries to figure out what has been duplicated

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/12/04/identifying-duplicate-transactions/



— RM Duplicates
select RMDTYPAL, DOCNUMBR, COUNT(*) as [COUNT] from
(
select RMDTYPAL, RMDNUMWK as DOCNUMBR from RM10301 W
UNION ALL
select RMDTYPAL, DOCNUMBR from RM10201 W
UNION ALL
select RMDTYPAL, DOCNUMBR from RM20101 O
UNION ALL
select RMDTYPAL, DOCNUMBR from RM30101 H
) C
group by RMDTYPAL, DOCNUMBR
having COUNT(*) > 1