COMMUNITY FORUM

I attempted using the new excel template for importing journal entries into GP today after getting feedback from clients that they couldn't get it to work.  I never had any luck with getting the old ones to work so I decided not to stop until I got this one working.  After I got the steps completed in the instructions I kept running into the 'Subscript out of range' error every time I hit the submit button.  After trying many troubleshooting techniques and not getting any further I found that it was actually succeeding to import my JE every time, but not reporting a success back to me.  I found that there was one line of vba code in the Submit_Click procedure that is referring to the "TransEntry" sheet which looks like it comes from the purchase order import template.  That had to be changed to refer to the "Journal Entry" sheet that exists in this template and then everything seemed to work perfectly.  Please fix the template in your download.  Thanks for a good example of how to make a pretty template and how to get away with not installing the addin and how to use one template for multiple companies.  Now I just have to figure out how to customize it to have more fields :).