web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RMS General Ledger Import
Microsoft Dynamics GP (Archived)

RMS General Ledger Import

(0) ShareShare
ReportReport
Posted on by Carlos Pérez 55

 Hi,

I have Microsoft Dynamics GP 10.0 Spanish. I'm importing General Ledger data using RMS Integration, after I specify the date range I get this message:

[Microsoft][SQL Native Client][SQL Server] La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.

How can I import this data?

Thanks,

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: RMS General Ledger Import

    Hola Carlos, puedes intentar cambiar la configuracion regional a US (Estados Unidos) y reintentar?

    En algunos casos como por ejemplo con Integration Manager, Sharepoint, Business Portal existen algunos lineamientos y requisitos a seguir, en este caso yo lo desconozco pero por experiencia pregunte sobre la configuracion regional.

    Si puedes intentarlo y te resuelve el incidente, deberias considerar cuales son las desventajas de no dejar tu servidor con esa configuracion regional.

    Saludos

  • Carlos Pérez Profile Picture
    Carlos Pérez 55 on at
    Re: RMS General Ledger Import

    Gracias por la ayuda.

    Francisco, la configuración regional y de idioma de mi servidor es: Español(Guatemala)

    Espero eso ayude.

    ---

    Thanks for the help.

    Francisco, the regional setting on the server is: Español(Guatemala)

    Hope this help.

  • Community Member Profile Picture
    Community Member on at
    Re: RMS General Ledger Import

    Carlos, me puedes comentar por favor cual es la configuración regional en el servidor de Dynamics GP, creo que el problema con estas herramientas de integracion es que asumen/requieren que tu manejas la configuracion regional US.

    Dejame saber

    ---

    Carlos, can you tell me please details about your Regional Settings on the Dynamics GP server, i believe that the problem with those integration tools is that they assume/require that you use US regional settings

    Let me know please

  • Community Member Profile Picture
    Community Member on at
    Re: RMS General Ledger Import

    Hi, Carlos

    I have the same problem when I try to Integrate GL with Analytical Accounting, I reported to Microsoft Support, dont have any answer yet.

    See u.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans