Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Lawson 10 Excel Journal Entry Tool

 4 Replies
 3 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Joe Carey
Basic Member
Posts: 6
Basic Member
4/13/2016 5: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
    Posts: 3353
    4/13/2016 8:28 PM
      do you want to just attach it to this thread?
      Thanks for using the LawsonGuru.com forums!
      John
      Joe Carey
      Basic Member
      Posts: 6
      Basic Member
      4/14/2016 4:32 PM
        Sure, that would work. I have the code up on github: https://github.com/indepndnt/vba_Lawson_Upload

        Joe Carey
        Basic Member
        Posts: 6
        Basic Member
        4/20/2016 11:30 AM
          Has anyone gone out and looked at it? Any thoughts?
          Joe Carey
          Basic Member
          Posts: 6
          Basic Member
          9/17/2016 3:04 PM
            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/indepn...rnalEntry_with_Query