Microsoft Dynamics GP (Archived)

uploading journal entries from Excel into GP

(0) Share

Report

Posted on by Mary Friedel

285

Hello,

I'm trying to upload a journal entry from Excel to GP via the integration manager.

I'm using "GL transaction using one source file"

I'm using a csv file in excel and the following is the format:

7800-08 JE TEST .01

no headers.

I run integration and get the following error message:

Source: Ln 174 Col 16, Update module, Last CBOM field read was 'Entries'.'Account Number', Last window field visited was 'Account Number' of window 'Transaction_Scroll' of form 'GL_Transaction_Entry'

Log:DOC 1 ERROR: Length of account '000114000' is 9. You must use the Great Plains account length of 6.

status code: 0x90040010 (-1878786032)

Help?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

For some reason it thinks you are trying to reference an account number: '000114000', which you shouldn't because your account numbers are only six digits. If you right click on the source and select Preview data do you see your accounts in the correct format?

On a side note I recently created a simple customization of Microsoft Excel that allows you to import a journal entry directly into GP via an excel template. Let me know if you are interested and I can send you more info.

Kevin Jones

Was this reply helpful? Yes No
K Day 7,365 on at

Like (0)

Report
Copy link

Link copied!

Kevin, what does your customization consist of? Are you using VBA to execute e-connect stored procs? I am have customized some excel templates, but we are using a product called SmartConnect. They have an excel add in that they build which is okay, but I have been able to use VBA so submit an XML file to their webservice, which takes care of the rest. But the end result is sending data to e-connect to process.
What type of authentication are you using for excel to connect to the database? You can't be using GP users, right?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Our customization uses eConnect and GP user names and passwords.

Kevin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Kevin,

I am very new to Microsoft Dynamics GP, I'm trying to figure out how to export an journal entry from an Excel spreadsheet to GP, please could you help me on this and let me know how I should do it, thank you so much!

Cathy

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

Select source and click properties to refresh columns. And select preview to check whether the datas are showing properly or not.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

I would go to www.DynamicsInnovations.com and download Excel Paste for GP. The GL integration is free and it works!

Was this reply helpful? Yes No