Need to create an interface direclty to GL40.1, has any done that?

Hi,
I would like to create a monthly accrual interface directly to GL40.1. We will be using processflow to do that. We would prefer not to use the GL65 route because of the setup required on GL08/GL09. We don't use automatic journal numbering. My question is:
1.Do I need to manually set up the journal header with my own journal entry number on GL40.2 before I start interfacing with the detail or will the system do it automatically?
2.Once I create my own journal entry number on Gl40.2 can I use that number going forward? I need it to auto-reverse every month and re-use the same number for the next months accrual file.
3.How does the system know not to overwrite my journal number if someone happens to the same journal entry number?

Thanks.

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Comments

unknown

You don't need to do the GL08/GL09 setup to use GLTRANSREL/GL165. On the GL165 parameters, use "Bypass Organization Code=Y" and "Bypass Account Code=Y" When you do this, the OLD-COMPANY field (organization code in GL65) needs to be your four digit company concatenated with your accounting unit. The OLD-ACCT-NBR (account code in GL65) needs to be your account and sub-account concatenated. Even if you don't use sub-accounts, fill the field with four zeroes. Hope this helps!

0911060553270289.pdf

unknown

Thanks Marybeth! I learned something new, I will certainly give it a try! Is there somewhere on GL65 I can put my own journal entry number?

amacknig

Rather than use GL40, since you want to reuse the same number each period, could you use GL70, Recurring Journal? We upload to GL70 when the amounts/and or accruals change each period, and if necessary, we can override the GL account as well.

unknown

I don't see anything in GLTRANSREL/GL65 for a journal entry number. We auto-number. As Gail mentioned above, when a user wants to repeatedly use the same number each month, they utilize GL70/Recurring Journal. I don't remember why we chose auto-numbering when we first moved to Lawson, but it may have been for interface entry processing.

robert-canham

According to the 2 kb articles I found (1207705 and 1193914) GL165 autonumbers journal entries whether you have it set or not. There is not a function to specify the journal numbers.

misreb

The GL165 uses the next available JE number even if you do not have auto number set to Y on the GL10 Journal options tab or not. If you want the JE number to be the same each month you have several options. The best one is to use the RJ screens. All RJ entry numbers are controlled by what number you enter when you create the header in GL70.2. If the amounts change every month you set the JE with auto zero turned on so each month the system creates a new version but with no amounts. You can then upload or manual enter the amounts. If you do an upload make sure the spreadsheet has the line numbers to match the JE70 or you may load the amounts to the worng accounts and AU's.

Option 2. Create a user defined system code for this accrual file. If you only book 1 JE a month it would automatically be assigned JE #1 assuming no one else uses the system code. This also makes it easier to be sure the entry was done becuase you can use the fliter on GL45 for the user defined system code to make sure it is in.

The downside to both these are the transactions are under a system code other then GL so you might have to be careful if you are using tools to query GLTRANS or running report or online inquiries and you only fitler for
system code GL

jreese

Is your accrual file coming from another system? For entries that repeat monthly, whose accounts remain fairly constant but amounts change, our Finance department uses the Excel upload template created by Don Peterson that allows them to key in minimal changes each month and upload the journal entries each month from the spreadsheet. We use auto-numbering but I believe there may be a version that does allow you to enter the journal number. You can access the spreadsheet through the Infor Product Download Center under Performance Management > Technology Sample Content > MS Add-ins Spreadsheet.

unknown

Another option, depending on your needs, is to create a "dummy" JE number in GL 40 that is higher than anything else that you will use. The first successful GL165 will create a JE with that number + 1. Then each successful GL165 after that will increment the number by 1. We do something like that with a department number, period, and year in the "dummy" JE number. After the first new "real" JE is created you can delete the "dummy" JE.
You can use the add-in wizard to load entries into GL40 (regular JE) or GL70 (recurring JE). The process will basically be the same for either of those. Depending on how many line items you have, either of those may work. If you have tens of thousands of line items I would strongly recommend the GL165 option. You will need to build an interface into the GLTRANSREL table using the "rungroup" as a batch identifier. You can have multiple rungroups at the same time. Then run GL165 for one or more rungroups to create a JE, which will then delete that rungroup from GLTRANSREL.

Copyright © 2025 Infor. All rights reserved.