Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

RMS General Ledger Import

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans