Decimal Places passed in on XTNDPRCE does not match setup

Error Number = 4647 Stored Procedure= taSopLineIvcInsert Error Description = Decimal Places passed in on XTNDPRCE does not match setup
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = 684426
SOPTYPE = 3
Related Error Code Parameters for Node : taSopLineIvcInsert
XTNDPRCE = 4.70

Resolution:

We had moved a GP company to another dynamics system db and ran check links.  Check links did not find the currency ID and auto created the currency id with 0 decimal. Comparing MC40000 and dynamics..MC40200 was the key for resolution.  Updated the decimal places for currency – the error econnect was able to process the transaction successfully.

Cheers

Sanjay

 

 

 

 

Integration Manager – DOC 1 ERROR: Not all required fields have been entered. Required fields appear in bold & italic red type. – Not all required fields have been entered. Required fields appear in bold & italic red type.

Integration manager Fails with error message for PM Transaction

DOC 1 ERROR: Not all required fields have been entered. Required fields appear  in bold & italic red type. – Not all required fields have been entered. Required fields appear  in bold & italic red type.

All fields were  mapped.  For Batch ID, Add new was enabled.  The problem was, when a new batch was getting created, the check book ID was not defaulting.  Defaulting the check book id, resolved the issue.

Cheers!

Sanjay

 

 

 

Integration Manager – Unable to cast COM object of type ‘MSScriptControl.ErrorClass’ to interface type ‘MSScriptControl.IScriptError’.

Integration Manager – Error message. 
DOC 1 ERROR: Unable to cast COM object of type ‘MSScriptControl.ErrorClass’ to interface type ‘MSScriptControl.IScriptError’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{70841C78-067D-11D0-95D8-00A02463AB28}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
DOC 1 ERROR: Argument ‘Number’ is not a valid value. – Argument ‘Number’ is not a valid value.
DOC 1 ERROR: Unable to cast COM object of type ‘MSScriptControl.ErrorClass’ to interface type ‘MSScriptControl.IScriptError’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{70841C78-067D-11D0-95D8-00A02463AB28}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Solution : regsvr32  c:\windows\system32\msscript.ocx

Cheers!

Sanjay

 

 

Integration Manager – the destination could not be initialized due to the following problem: cannot create activex component

Error message when starting Dynamics GP integration using integration manager.

  1. Close Dynamics.exe and Integration manager.
  2. Re register dynamics.exe file, click Start, click Run,  type <path>\NameOfFile.exe”  /REGSERVER, and then click OK
  3. Re register IM.exe file, click Start, click Run,  type <path>\NameOfFile.exe”  /REGSERVER, and then click OK
  4. Re register IMRun.exe file, click Start, click Run,  type <path>\NameOfFile.exe”  /REGSERVER, and then click OK

Cheers!

Sanjay

Electronic Bank Reconcile – Dates won’t import properly

06/17/2016 – Today was setting up configuration for electronic bank reconcile and every time  the download of the statement was done the date imported into the system was either 1/1/1900 or 12/31/9999.  After several un successful attempts to fix the issue finally  the eureka moment…  The excel source file had a hidden column and the copy paste to text file added an invisible column which shifted all columns to the right messing the mapping!  The lesson learnt here is, check the source file in text editor …

Cheers!
Sanjay

 

 

Error number = 1254 Store Procedure = taPATimeSheetLineInsert Error Description = Employee access does notexist for this project in the PA01408 table The project number is

Hi Sanjay,

I am providing you a copy of our scope agreement for your issue.

Issue Definition:

Customer is getting error message “Error number = 1254 Store Procedure = taPATimeSheetLineInsert Error Description = Employee access does notexist for this project in the PA01408 table
The project number is <NONE>” when sending a time sheet with eConnect.
Scope Agreement:

The scope of this case is to advise customer on the error message “Error number = 1254 Store Procedure = taPATimeSheetLineInsert Error Description = Employee access does notexist for this project in the PA01408 table The project number is <NONE>” when sending a time sheet with eConnect.

Assessment:
You had a phone call with Mike yesterday and are going to first attempt to mark the option Allow Add Access on the fly per below in your test company.

In Dynamics GP, go to Tools > Setup > Project > Timesheets. Click the Options button. The last line in Timesheet Setup Options is “Allow Add Access on the fly”. Be sure this is check marked and please verify you no longer receive the error.

If you do not agree with the scope defined above, or would like to amend it, please let me know as soon as possible.  Please let me know if you have any questions or concerns in the meantime. I will follow up with you in a few days if I don’t hear back. Have a great afternoon!

Best Regards,

The solution worked – however need to understand the consequence.

Follow ups:

 
1)      When the time sheet with none project was sent access to the none project was to be provided to user.
2)      The only way access to none project can be provided was to let permission be provided on fly.
3)      Because we gave the permission on for access release on fly for none projects, this is having allowing provisioning of access to all projects on the fly which is not what we want.
 
Can we first enable on the fly – get all user access to Non and then take away on the fly – this should solve the problem for now correct ?
Your analysis is correct and I understand in your 3rd remark that they do not want to allow access to on all projects by using the grant access on the fly.  This is actually a known issue (TFS#86337) that is marked to be fixed in the next release of GP16 later this year. 

Cheers!
Sanjay

VAST to GP intergration

VAST staging area:

SELECT     TOP (200) IDENTITYFIELD, COMPANY_NUMBER, GL_NUMBER, TRANSACTION_DATE, DOCUMENT_NUMBER, CUSTOMER_NAME, DEBIT, CREDIT, SOURCE, 
                      GL_TYPE, STATUS, WDATE, IDATE, WRITEROUTINE, CUSTOMER_TYPE, COMPOUND_GL_NUMBER, SEND_TO_THIRDPARTY, JOURNAL_NUM, GUID, COMMENT, 
                      WORKORDER, WORKORDER_LINE_ID, Goodyear_Claim_No, REF_Doc_ID, BIG_Invoice_No, REF_Order_Type, PARENT_GUID, Eod_Status, Eod_DateStamp, 
                      DO_NOT_SEND_VENDOR
FROM         GLTRANSACTION

 

VAST Staging area to GP Resend:

UPDATE GLTRANSACTION SET SEND_TO_THIRDPARTY = 1 WHERE  (TRANSACTION_DATE = CONVERT(DATETIME, '2016-05-05 00:00:00', 102))

Cheers!
Sanjay