DynDeveloper.com

As a SQL developer, I import data into SQL all the time. This article is aimed at the accounting user that wants to be able to do it themselves. You'll need access to SQL, but this is a quicker alternative to calling the developer each time. 

Greetings - In Smart Connect - 

I need to take a Date from a SQL Table, and I need to calculate a Batch ID using the data in the table.

Sql Table is formatted as such: yyyy-mm-dd.

My formula is here:

Here's my result:

I obviously need to do some kind of formatting as part of the calculated smart connect formula?

I'm confused why I get the year (25) and the day (28) correct but not the month (07).

Thanks in advance. I need the result to be: AGCCREDS072825

Hello All,

Is anyone familiar with JobBoss and if there is anyway to integrate it with Dynamics GP?

Thanks

Brett