Saturday 24 June 2023

Microsoft Dynamics GP Integration Manager Error: “Are you sure you want to delete this customer record?”

 Trying to integrate customers from integration manager and received the above error?


Try creating a customer maually, then saving and see if you experience any errors there. That would assist in guiding you to the reason for same. 


Mine was due to collections management not being installed on the brand new company that was added to an existing instance. As this client did not renew the module, I just removed CM from the dynamics set file and this resolved the error. 

Sunday 16 October 2022

Unable to add new code to Web Server (Where the GP Web Client is setup)

 When adding a new product to the Web Server you may experience the following error "Privilege error" unable to install new code. 


This is because although, everyone is logged out of GP, there are stranded Web Client Sessions. 

To end these, go to task manager and end the processes as follows: "Microsoft.Dynamics.GP.Web.Services.Runtime.Process (32 bit)"

Tuesday 23 August 2022

Trinidad and Tobago Passport Renewal 2022

Trinidad and Tobago Passport Renewal - MRP for Child Under 16.

23-August-2022 FAQ (ttpassport.info)


First:

  1. Create an account on the passport login page. Passport Office (ttpassport.info)
  2. Make an appointment.

Copies needed:

  1. Copy of Passport Bio Page
  2. Copy of Birthpaper
  3. Copy of Parent's ID/Passport Bio Page
  4. Print the appointment received from the online page, this includes a barcode. 

Other:

  1. Fill out the TT Post Authorization Form. Note, the Name at the top will be parent's name and also write 'on behalf of' then write in the child's name. Name at the bottom of the form is parent's name and parent's signature.               Form_THIRDPARTYAUTHORISATIONFORMforcollectionofalreadycompletedpassport.pdf (nationalsecurity.gov.tt)
  2. TT Post A5 Envelope, self addressed to Child with Parent's name in Attention field. 


Originals needed:

  1. Old Passport of Child
  2. New Birthpaper
  3. Custody Documents if any
  4. Authorization from other parent if they are not attending. 
  5. Parent's ID/Passport


No you do not need:

  • A picture for a renewal of MRP for a child under 16. 


What happens:

  1. You will be seen at the receptionist downstairs who will check all your documents. Once in order, you will be sent to third floor. 
  2. You get to wait to see the other receptionist there. Then you get seated and wait to hear your name called. 
  3. You will then be seen by an officer to verify all information. 
  4. Then you get to wait in the waiting area again.
  5. Then someone will call your name to go in and pay (via linx) and get your photo taken. 
  6. They will take a sticker off the TT Post envelope and give it to you. This can be used to track the package after 3 weeks when it is expected to be in TTPost's possession. The documents in the package will be the new passport and your original custody documents if any were provided. 

When do you get it back?

  • It takes 3-4Weeks for Immigration to organize a non expedited document. 
  • Then TT Post will collect and dispatch for delivery. 
  • You will be contacted for receiving and need to sign for receipt. 
  • You can track the package via the paper they provide to you at the Passport office. 

Other Info

Monday 1 March 2021

KingswaySoft SSIS Error at Merge Join - An item with the same key has already been added

Issue

  • You are trying to join two sets of data using a Merge Join. 
  • No matter what you try you get the error "An Item with the same key has already been added"

 

Background:

  •           It works well using Visual Studio 2017, but your same map design does not work on Visual Studio 2012.

 

What you may have tried and did not work:

  •          Deleting and recreating map
  •          Renaming connections and every other node in VS
  •          Restarting your server

 

What worked for me:

  •          Add a two-layer sort for both outputs before the merge join as the error is complaining about a key.


Thursday 11 February 2021

Integrating data to Dynamics GP from KingswaysSoft which sits on SSIS

Scenario: 

You create a map and the resulting errors are to be written to a sql table via use of the OLE DB connector, so that triggers can be executed in SQL so other records can be updated to remove your failed lines as necessary due to KingswaySoft not playing by the rules of GP. 

 

Issue:  

SQL Table Trigger does not run when the records are inserted from Kingswaysoft. 

SQL Table Trigger only runs when the records are inserted through SQL. 

 

Resolution: 

Right click on the Ole DB output,  Go to the Advanced Editor , navigate to Component Properties of the OLE DB connector and change Access Mode from "OpenRowset using FastLoad" to "OpenRowset" 

Tuesday 2 June 2020

Dynamics GP Error - Cannot drop the index 'taErrorCode.AK2taErrorCode' because it does not exist or you do not have permission

So you are upgrading GP and get the below error.

This is due to a missing index.

Script one out from a working machine and script into your 'troubled' environment. Be sure to also script in the primary key as well in case it is also missing.

Error: the stored procedure smgrantaccessonaccountmstr returned the following results dbms:0 Microsoft Dynamics GP

So you receive the above error on doing an update/upgrade.

You have re-run the grant sql script, change db owner, etc, multiple times.

Even reviewed the stored procedure.

Reason for issue:
-There is a mis-named table. Possibly with a period in the name.

Resolution:
- Just rename the table.
-Continue to utilities.

Voila!