DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In

Archives

 

SmartConnect can be used to integrate documents into your system (I use Dynamics GP and Business Central, it works with both)

If possible, I'd like the source table to be SQL, so that I can mark the records as having succeeded or failed. 

This tutorial will detail how to use the before/after document tasks to run a SQL task. 

*** if I've not provided enough information, please leave a comment and I'll clarify it.

Example of how to use the Telerik Winforms ItemDataBound Event
I need to have a Telerik Winforms radgrid filter by using a textbox outside the grid. This code example shows how

This request operation sent to net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations did not receive a reply within the configured timeout (00:01:00).  The time allotted to this operation may have been a portion of a longer timeout.  This may be because the service is still processing the operation or because the service was unable to send a reply message.  Please consider increasing the operation timeout (by casting the channel/proxy to IContextChannel and setting the OperationTimeout property) and ensure that the service is able to connect to the client.

Standing orders from the boss (sigh) <smiles>

"Blog every error that you get"

So, here goes: I was adding a company to an existing client and got the error above. eConnect did a 30 second timeout and returned this message.

 

 

 


GridGroupSplitterColumn

So, the deal is this: I'm developing for a phone, and I need the real estate. I need to get rid of this column. Here's how. 


There's no good native control that displays a hyperlink and behaves like a button... so I'll generally just use the code below. 

I'm coding a SmartConnect integration, I'm trying to write the error back to the source table using a SQL task, but the GlobalLastError variable is blank. 

This article describes the workaround. 

If your GlobalLastError has single quotes in it, you won't be able to (easily) save it back to the source table with SQL

This article describes the work around. 

Discerning viewers will note that this is the exact same piece of code as the previous article (smiles)

I need two articles because they're different problems and I need to put them on the SmartConnect menu. Sorry for the spam. 

Today I opened SmartConnect, and I get the message 

Could not log into the SQL Server

Login failed for user 'xxx'. Reason: The password of the account has expired.

Doh.

Creating the service account for SmartConnect was an oversight... but it happened. So I went to fix it, and didn't have a record of what I had created. And, I couldn't find anyplace to reset it. 

Grrr.

I'm trying to integrate into Business Central using SmartConnect, and a lot of the lines are returning 

Failed to create record. Unable to call service: The Sales Header does not exist. Identification fields and values: Document Type='Quote', No=''

This article discusses this error

 

On the forum today, a user asked:

I have an SQL query that shows me the GL distribution for all invoices. But the problem I have is that for invoices that were posted using the Intercompany  functionality, it just shows me that the item was posted to the Intercompany Account, not the GL distribution from the other side of the transaction.

Does anyone know how to get it to return the G/L where the item is posted to in the other company, and not the Intercompany account in the ledger where it is posted?

My query for that is below

 

 

This was from a SmartConnect to Business Central integration

Failed to create record. Unable to call service: Control 'xxx' is read only

This error is for taxGroupCode, but in my experience it works for quite a few fields


I don't know how useful this will be, but I'm going to blog it before I lose the article that I got it from 

This technique will allow you to create a folder on a Win 10 desktop that has 200-some admin menus

 

This article applies to SmartConnect, the system that it attaches to is not really important (but I happen to be doing an integration from a SQL table into Dynamics 365 Business Central

The task today was to aggregate errors in the integration and report them via email at the end. So... we'll need a global variable

 

 

We are using Dynamics GP 2015, and I need to know which tables are used for the built-in smart list for Inventory Transactions.

Is there any SQL script that would highlight the difference between AP Sub Ledger and Payable account in GL? I have already tried the GL Reconciliation within GP but that didn't help.

Thanks

Paul

Does anyone know the value definitions for MOPLOCKLOCATION and MOPLOCKLOCATION2?

I have a question regarding void date in the RM20101 (Open Transactions) Table.

When I go into GP, from "Posted Transactions", select my customer and payment, (Which brings me to the "Receivables Posted Transactions Maintenance" screen, I fill in the field "Void Date" with "January 1st, 2019", and I put "January 3rd, 2019", in the "Posting Date" field.  I then click Void.

Now, when I query the RM20101 Table for that document number, I see the "January 3rd, 2019" appearing in the "VOIDDATE" field.   And the date I entered as the void date, "January 1st, 2019" seems to be appearing in the "DINVPDOF" (Date invoice paid off field).

To make it even stranger, if go into Inquiry -> Transaction By Document, and drill down to my document, there is a field on there called "Date Voided", and it's also showing the proper date of "January 1st, 2019"  

Can anyone explain why this is behaving this way?  Why do the fields on the GP screens have a label of "VOIDDATE", but GP isn't actually storing the value in that "VOIDDATE" field in the table?

 

Permissions question - what tasks does a user need to be able to update 1099 information (amounts) on the vendor card?

I have an SQL query that shows me the GL distribution for all invoices. But the problem I have is that for invoices that were posted using the Intercompany  functionality, it just shows me that the item was posted to the Intercompany Account, not the GL distribution from the other side of the transaction.

Does anyone know how to get it to return the G/L where the item is posted to in the other company, and not the Intercompany account in the ledger where it is posted?

Any help would be greatly appreciated. 

Thanks

 

 

Hi,

how to connect webapplication with CSHARP Salesorder console application example in econnect . 

I found this script on another site. It works great to provide details about cash transactions. However, I cannot get it to provide the additional information based on the Journal Entry, which it is providing. 

Is there any way to bring in the 'ACTNUMST' and the 'ACTDESCR' fields from the following tables and join them to the select statement in the script below? I know that the tables this script is accessing has the ACTINDX field to join on, I just cannot figure out where to do this?

inner join BFS..GL00105 GM
 on GL.ACTINDX = GM.ACTINDX
 
inner join BFS..GL00100 GA
 on GL.ACTINDX = GA.ACTINDX

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

 

SELECT  X.CHEKBKID 'Checkbook ID',
        CMRECNUM 'CM ReconNumber' ,
        CMTrxNum 'CM Transaction Number',
           TRXDATE AS 'CM Transactin Date',
           CASE X.VOIDED
              WHEN 1 THEN 'Yes'
              WHEN 0 THEN 'No'
           END AS 'Voided',
           CMTRXTPE 'CM Transaction Type',
           paidtorcvdfrom 'Paid To/Received From',
           DSCRIPTN 'Description',
           JRNENTRY 'Journal Entry',
           DEBITAMT 'Debit Amount',
           CRDTAMNT 'Credit Amount'
FROM
          ( SELECT A.CHEKBKID ,
                B.ACTINDX ,
                A.CMRECNUM ,
                            A.sRecNum ,
                            A.CMTrxNum ,
                            A.TRXDATE ,
                            CASE A.CMTrxType
                                   WHEN 1 THEN 'Deposit'
                                   WHEN 3 THEN 'Check'
                                   WHEN 4 THEN 'Withdrawal'
                                   WHEN 5 THEN 'Increase Adjustment'
                                   WHEN 6 THEN 'Decrease Adjustment'
                                   WHEN 7 THEN 'Transfer'
                                   ELSE ''
                            END AS CMTRXTPE ,
                            A.paidtorcvdfrom ,
                            CASE 
                                    WHEN A.DSCRIPTN = ' '
                                AND A.CMTrxType <> 7
                                     THEN 'Bank Transaction Entry'
                                    WHEN A.DSCRIPTN = ' '
                                    AND A.CMTrxType = 7 
                     THEN 'Bank Transfer Entry'
                                     ELSE A.DSCRIPTN
                            END AS DSCRIPTN ,
                            A.AUDITTRAIL ,
                            A.SRCDOCNUM ,
                            A.VOIDED
                            FROM   CM20200 AS A
                LEFT OUTER JOIN DBO.CM00100 AS B 
                ON A.CHEKBKID = B.CHEKBKID
                UNION ALL
                SELECT    A.CHEKBKID ,
                B.ACTINDX ,
                A.CMRECNUM ,
                A.sRecNum ,
                A.RCPTNMBR ,
                A.RECEIPTDATE ,
                CASE A.RcpType
                                    WHEN 1 THEN 'ReceiptCheck'
                                    WHEN 2 THEN 'ReceiptCash'
                                    WHEN 3 THEN 'ReceiptCreditCard'
                                    ELSE ''
                END AS ReceiptType ,
                A.RcvdFrom ,
                CASE A.DSCRIPTN
                                    WHEN ' ' THEN 'Bank Transaction Entry'
                                    ELSE A.DSCRIPTN
                END AS DSCRIPTN ,
                A.AUDITTRAIL ,
                A.SRCDOCNUM ,
                A.VOIDED
                FROM   CM20300 AS A
                LEFT OUTER JOIN DBO.CM00100 AS B 
                ON A.CHEKBKID = B.CHEKBKID
                ) AS X
                LEFT OUTER JOIN 
                ( SELECT  A.JRNENTRY ,
                          A.DEBITAMT ,
                          A.CRDTAMNT ,
                          A.ACTINDX ,
                          B.CHEKBKID ,
                          A.REFRENCE ,
                          A.SOURCDOC ,
                          A.ORGNTSRC ,
                          A.ORMSTRNM ,
                          A.ORMSTRID ,
                          A.ORDOCNUM ,
                          A.ORTRXSRC ,
                          A.VOIDED
                          FROM   
                          ( SELECT JRNENTRY ,
                                   DEBITAMT ,
                                   CRDTAMNT ,
                                   ACTINDX ,
                                   REFRENCE ,
                                   SOURCDOC ,
                                   ORGNTSRC ,
                                   ORMSTRNM ,
                                   ORMSTRID ,
                                   ORDOCNUM ,
                                   ORTRXSRC ,
                                   VOIDED
                                   FROM   GL20000
                                   UNION ALL
                                   SELECT JRNENTRY ,
                                   DEBITAMT ,
                                   CRDTAMNT ,
                                   ACTINDX ,
                                   REFRENCE ,
                                   SOURCDOC ,
                                   ORGNTSRC ,
                                   ORMSTRNM ,
                                   ORMSTRID ,
                                   ORDOCNUM ,
                                   ORTRXSRC ,
                                   VOIDED
                                   FROM   GL30000
                                   ) AS A
                                   LEFT OUTER JOIN DBO.CM00100 AS B 
                                   ON A.ACTINDX = B.ACTINDX
                                   ) AS Y 
                                   ON ( 
                                   X.ACTINDX = Y.ACTINDX
                                   AND X.DSCRIPTN = Y.REFRENCE
                                   AND X.CHEKBKID = Y.ORMSTRID
                                   AND X.AUDITTRAIL = Y.ORGNTSRC
                                   AND X.AUDITTRAIL = Y.ORTRXSRC
                                   AND X.CMTrxNum = Y.ORDOCNUM
                                   AND X.CMTRXTPE IN 
                                   ( 'Increase Adjustment',
                                                    'Decrease Adjustment',
                                                    'Check', 'Withdrawal',
                                                    'ReceiptCheck','ReceiptCash',
                                                    'ReceiptCreditCard' 
                                   )
                                   )
                                   OR     
                                   (   
                                       X.ACTINDX = Y.ACTINDX
                                                 AND X.DSCRIPTN = Y.REFRENCE
                                                 AND X.AUDITTRAIL = Y.ORTRXSRC
                                                 AND X.CMTrxNum = Y.ORDOCNUM
                                                 AND X.CMTRXTPE = 'Transfer'
                                                 )
WHERE   
ISNULL(X.AUDITTRAIL, 0) LIKE 'CMT%' OR
ISNULL(X.AUDITTRAIL, 0) LIKE 'CMX%'


UNION


SELECT  X.CHEKBKID 'Checkbook ID',
        CMRECNUM 'CM ReconNumber' ,
        CMTrxNum 'CM Transaction Number',
           TRXDATE AS 'CM Transactin Date',
           CASE X.VOIDED
              WHEN 1 THEN 'Yes'
              WHEN 0 THEN 'No'
           END AS 'Voided',
           CMTRXTPE 'CM Transaction Type',
           paidtorcvdfrom 'Paid To/Received From',
           DSCRIPTN 'Description',
           JRNENTRY 'Journal Entry',
           DEBITAMT 'Debit Amount',
           CRDTAMNT 'Credit Amount'
FROM
          ( SELECT A.CHEKBKID ,
                B.ACTINDX ,
                A.CMRECNUM ,
                            A.sRecNum ,
                            A.CMTrxNum ,
                            A.TRXDATE ,
                            CASE A.CMTrxType
                                   WHEN 1 THEN 'Deposit'
   WHEN 3 THEN 'Check'
                                   WHEN 4 THEN 'Withdrawal'
                                   WHEN 5 THEN 'Increase Adjustment'
                                   WHEN 6 THEN 'Decrease Adjustment'
                                   WHEN 7 THEN 'Transfer'
                                   ELSE ''
                            END AS CMTRXTPE ,
                            A.paidtorcvdfrom ,
                            CASE 
                                    WHEN A.DSCRIPTN = ' '
                                AND A.CMTrxType <> 7
                                     THEN 'Bank Transaction Entry'
                                    WHEN A.DSCRIPTN = ' '
                                    AND A.CMTrxType = 7 
                     THEN 'Bank Transfer Entry'
                                     ELSE A.DSCRIPTN
                            END AS DSCRIPTN ,
                            A.AUDITTRAIL ,
                            A.SRCDOCNUM ,
                            A.VOIDED
                            FROM   CM20200 AS A
                LEFT OUTER JOIN DBO.CM00100 AS B 
                ON A.CHEKBKID = B.CHEKBKID
                UNION ALL
                SELECT    A.CHEKBKID ,
                B.ACTINDX ,
                A.CMRECNUM ,
                A.sRecNum ,
                A.RCPTNMBR ,
                A.RECEIPTDATE ,
                CASE A.RcpType
                                    WHEN 1 THEN 'ReceiptCheck'
                                    WHEN 2 THEN 'ReceiptCash'
                                    WHEN 3 THEN 'ReceiptCreditCard'
                                    ELSE ''
                END AS ReceiptType ,
                A.RcvdFrom ,
                CASE A.DSCRIPTN
                                    WHEN ' ' THEN 'Bank Transaction Entry'
                                    ELSE A.DSCRIPTN
                END AS DSCRIPTN ,
                A.AUDITTRAIL ,
                A.SRCDOCNUM ,
                A.VOIDED
                FROM   CM20300 AS A
                LEFT OUTER JOIN DBO.CM00100 AS B 
                ON A.CHEKBKID = B.CHEKBKID
                ) AS X
                LEFT OUTER JOIN 
                ( SELECT  A.JRNENTRY ,
                          A.DEBITAMT ,
                          A.CRDTAMNT ,
                          A.ACTINDX ,
                          B.CHEKBKID ,
                          A.REFRENCE ,
                          A.SOURCDOC ,
                          A.ORGNTSRC ,
                          A.ORMSTRNM ,
                          A.ORMSTRID ,
                          A.ORDOCNUM ,
                          A.ORTRXSRC ,
                          A.VOIDED
                          FROM   
                          ( SELECT JRNENTRY ,
                                   DEBITAMT ,
                                   CRDTAMNT ,
                                   ACTINDX ,
                                   REFRENCE ,
                                   SOURCDOC ,
                                   ORGNTSRC ,
                                   ORMSTRNM ,
                                   ORMSTRID ,
                                   ORDOCNUM ,
                                   ORTRXSRC ,
                                   VOIDED
                                   FROM   GL20000
                                   UNION ALL
                                   SELECT JRNENTRY ,
                                   DEBITAMT ,
                                   CRDTAMNT ,
                                   ACTINDX ,
                                   REFRENCE ,
                                   SOURCDOC ,
                                   ORGNTSRC ,
                                   ORMSTRNM ,
                                   ORMSTRID ,
                                   ORDOCNUM ,
                                   ORTRXSRC ,
                                   VOIDED
                                   FROM   GL30000
                                   ) AS A
                                   LEFT OUTER JOIN CM00100 AS B 
                                   ON A.ACTINDX = B.ACTINDX
                                   ) AS Y 
                                   ON ( 
                                   X.ACTINDX = Y.ACTINDX
                                   AND X.DSCRIPTN = Y.REFRENCE
                                   AND X.CHEKBKID = Y.ORMSTRID
                                   AND X.AUDITTRAIL = Y.ORGNTSRC
                                   AND X.AUDITTRAIL = Y.ORTRXSRC
                                   AND X.CMTrxNum = Y.ORDOCNUM
                                   AND X.CMTRXTPE IN 
                                   ( 'Increase Adjustment',
                                                    'Decrease Adjustment',
                                                    'Check', 'Withdrawal',
                                                    'ReceiptCheck','ReceiptCash',
                                                    'ReceiptCreditCard' 
                                   )
                                   )
                                   OR     
                                   (   
                                       X.ACTINDX = Y.ACTINDX
                                                 AND X.DSCRIPTN = Y.REFRENCE
                                                 AND X.AUDITTRAIL = Y.ORTRXSRC
                                                 AND X.CMTrxNum = Y.ORDOCNUM
                                                 AND X.CMTRXTPE = 'Transfer'
                                                 )
WHERE   
ISNULL(X.AUDITTRAIL, 0) LIKE 'CMT%' OR
ISNULL(X.AUDITTRAIL, 0) LIKE 'CMX%'

 

 

 

SALUDOS A TODOS:

recientemente se daño mi computadora por lo que se me asignó una nueva, dell inspiron 15 5000 Series  i7 8th Gn. 

con windows 10 pro. he instalado todas mis aplicaciones, sin embargo no me deja instalar dynamic GP 10.0 que es el que aun utilizamos en la empresa.

el error que indica es el siguiente:

"no se detectaron los componentes compartidos de Microsoft Dexterity"

 

Greetings to all:
I recently damaged my computer so I was assigned a new, Dell Inspiron 15 5000 Series i7 8th Gn.
With Windows 10 Pro. I installed all my applications, however not let me install dynamic GP 10.0 which is the one we still use in the company.
The error that indicates is as follows:
 "Microsoft dexterity Shared components not detected"

 

Hi

We have several old unprocessed EFT batches in the system [screenshot attached].

How do I get rid of them without processing it [because as soon as I hit 'Generate EFT file', it will dump the ACH file and it will be transmitted to the back because the process is automated.

Any ideas? Delete thru GUI or behind the scene?

Thanks

Paul Chacko

I have created form like so : 

<h3> PO Number&nbsp;
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<h3> Vendor
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

I took a look at this code:

taPoLine_ItemsTaPoLine purchaseLine = new taPoLine_ItemsTaPoLine();

 purchaseLine.PONUMBER = "po123";

 purchaseLine.VENDORID = "2rolda";

 

However I would like to replace those literal string with the value represented in my textbox in the form. How do I do this?

I use a product called Mineral Tree. They integrate fully with GP, but there are limits. We have especially had issues with getting their payment functionality to work. Their reporting and interface are slow and clunky.

However, they do save us a lot of time. We send invoices to a dedicated email address and they scan and code everything according to the accounts / departments in our AP system. They also allow routing to various Managers for approvals based on dept and amount, with multiple levels available. 

I am looking to see if anyone else is using something similar that works better. I would especially like something that automated a purchase requisition as well.  

Thank you for your assistance. 

 

 

 

 

 

 

 

Dynamics GP 2018.

Do you have, or can you please direct me to documentation on eConnect Business Objects (stored procedures).

There's a pile of them and I can't seem to find documentation on what they do.

 

Thanks,

Joe

I am trying to create a new Smartlist in GP using SQL tables from the DYNAMICS database.   Most of our other Smartlists use tables from a different database that houses a lot of our GP data, but the tables I want to use are in DYNAMICS for this one. 

When I go into Smartlist Builder and try to add a SQL Table, when I choose the DYNAMICS Database, there are no tables listed for it to choose from.

I think this is a security/permissions problem with DYNAMICS? 

 

 

Do you know of a way to run Environ$("Path") against another computer in the domain that the VBA program is running on?