Wednesday, July 20, 2016

Dynamics GP - Add Custom Reports to the "Assign Reports" default report list

  • Create New Report in SSRS under company folder structure
  • Run GP>Tools>Utilities>System>Reconcile>Select All>Run
  • This will scan the SSRS folders and update the Default Reports list to include your customized SSRS Reports

Dynamics GP - How to Reset "Set as Default" settings on lookup lists

Delete the user's record from the DYNAMICS..ASIEXP99 table.

Tuesday, July 19, 2016

Dynamics GP - How to use In-Transit Transfers

  • Create In-Transit Transfer
    • If you fill in a "Via Site" id, you have to use the "Receivings Transaction Entry" window to receive the In Transit Transfer
    • If you do not fill in the Via Site, the Transfer acts like a regular direct transfer

Dynamics GP 2015 - How to Populate the Lot Number Expiry Date Field

  • Inventory Control Setup
    • Ensure "Use Expired Lots" is ticked for the areas you want
  • For Lot Numbered Items
    • Whenever you do a positive inventory transaction, the system will prompt for a lot number
    • On the lot number screen, enter the new lot number, then click on the blue arrow next to the "Auto Generate" lot number field
    • Enter your expiry date here

Thursday, July 14, 2016

Office Sharepoint OneDrive Excel Word Outlook keep Asking for office 365 login credentials

Whenever you attempt to launch Excel, Word, Outlook, OneDrive, OneDrive for Business to sync to Sharepoint, or any Office product, it repeatedly prompts you to login with your Office 365 account. After you enter it the first time, the screen becomes unresponsive. You can click "sign in", but it doesn't do anything.

  • Go to Control Panel\All Control Panel Items\Credential Manager
  • Click on Windows Credentials on the top
  • Scroll down to "Generic Credentials"
  • Click on the down arrow and Remove any credentials with the word "Office" in them
  • press win+r > input regedit > ok to run the registry editor.
  • navigate to and delete the following key and all of its subkeys from the registry.
  • hkey_current_user\software\microsoft\office\16.0\common\identity
  • open word > file > account > under user information > sign in with your office 365 account.

  • hkey_current_user\software\microsoft\office\16.0\common\identity
  • Add Dword value 32
  • NoDomainUser, value 1

Thursday, July 7, 2016

Dynamics GP - SQL - SSRS Report List View

This view will display all SSRS objects

SELECT        ReportServer.dbo.Catalog.Name, ReportServer.dbo.Catalog.Path, Catalog_1.Name AS SubName, Catalog_1.Path AS SubPath
FROM            ReportServer.dbo.Catalog INNER JOIN
                         ReportServer.dbo.Catalog AS Catalog_1 ON ReportServer.dbo.Catalog.ParentID = Catalog_1.ItemID