PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/17/2016 11:04 AM by  Joe Carey
Lawson 10 Excel Journal Entry Tool
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Joe Carey
Senior Accountant
Vizient, Inc.
Basic Member
(16 points)
Basic Member
Posts:6


Send Message:

--
04/13/2016 1:14 PM

    My company recently upgraded to Lawson 10. We used to be able to use Don Peterson's 9.3 upload template, and some users used add-ins to upload JE headers (GL40.2) and detail (GL40.1) separately (having to find the JE# in the portal in between those two steps), but the old add-ins had to be replaced and the upload template relied on the old ones.

    So I wrote some VBA code to create a new JE upload template. It uploads the header and detail in one step, retrieving the JE# and detail line #'s in the process, and supports changing and deleting either the header or detail lines as well. Then it mimics the GL240 report so you can see what your JE looks like without having to leave the Excel workbook.

    Anyway, where would be a good place to share this so that interested folks can critique my code or suggest changes/improvements? (Besides giving me feedback on whether it even works in other environments?)

    Thanks.

    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    04/13/2016 4:28 PM
    do you want to just attach it to this thread?
    Thanks for using the LawsonGuru.com forums!
    John
    Joe Carey
    Senior Accountant
    Vizient, Inc.
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    04/14/2016 12:32 PM
    Sure, that would work. I have the code up on github: https://github.com/indepndnt/vba_Lawson_Upload

    Joe Carey
    Senior Accountant
    Vizient, Inc.
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    04/20/2016 7:30 AM
    Has anyone gone out and looked at it? Any thoughts?
    Joe Carey
    Senior Accountant
    Vizient, Inc.
    Basic Member
    (16 points)
    Basic Member
    Posts:6


    Send Message:

    --
    09/17/2016 11:04 AM
    Just in case anyone's following this, I've learned that there are updated upload templates for v10 on Infor's site, I just don't have access to the download section. :-)

    I updated my program to work on top of Infor's vba framework, it's a bit faster than what I had before:
    https://github.com/indepndnt/vba_La...with_Query
    You are not authorized to post a reply.