I would like to create an elimination company. I believe I can use the GL110 to do a company copy over and change the company status to 'E' in GL10.0.  However, I would like to keep the elimination company simple with less Accounting Units set up, etc. Is there another method Is there anything that I should be aware of Thanks Liz

Hi, Anyone have any tips and lessons learned about interfacing drop ship or expense type invoices into MA540 An example would be pharmacy, food, or office suppies. We're in healthcare and use O&M and GHX EDI 810s for for inventory, non-stocks and specials. We are looking for ways to take the data entry load off our AP staff for non receiving type purchase orders. Please post or e-mail to joanna.bledsoejhsmh.org. Looking forward to networking with you.

We are thinking about creating an interface out of Lawson in to the SIS system. The canned HL7 format reports just don't give us what we need since they are designed to pass Item Master data which is more than is needed by SIS. We are concerned however with an interface about how to account for passing only low unit of measure. Notoriously Purchasing will only have a box available to buy which is the only UOM in the system, but items get expensed by the each. Has anyone done anything similar ...

when i run br120 now i get the following viewable output files: BR120.prt ... the report showing what was processed/produced custom5 ... a format of the invoice that uses the tilde (~) character to designate the trailing value; e.g. ~STARTHEADER ~field Invoice Number IN 00000001 00000000 ~field Invoice Date ... ... ~ENDHEADER ... invoice1 ... text version of a printable invoice invoice1.pdf ... pdf version of the invoice i'd like to get an invo...

Does anyone have a solution for the automatic sending of remittance notices electronically to vendors who are paid electronically I have considered using process flow or writing a custom program which would run daily. Please send me your suggestions. Thank you.

Here's our scenario: Some of our suppliers charge our corporate credit card immediately when an item is ordered from them. (we provide some of our suppliers our CC b/c we get $ back on purchases). Once our CC statement is available, these charges only show who the supplier is, but does not reference any PO number that we sent them (nor Invoice they sent us). We are trying to find a way to match these charges to the invoices. I spoke with a Lawson business consultant and she said the b...

My users can't see the drop-down menu for some reason in Portal. I am able to see it with no problem. Would this be a security issue, any idea what could be the issue

I've got two companies that are going to merge and I've got both of them in AP as two separate vendor groups. They currently have separate bank accounts, separate check numbering systems, separate vendors, etc. They will soon be sharing a bank account and checks when they merge but they will still enter invoices and other data separately, while coordinating on the check numbers. There doesn't seem to be any precedent for this. Infor has nothing to offer with regard to this and I didn't see an...

I have an AR250 job. Is there a way I can automically ouput that as a csv file

Hello, Am on Lawson S3, V9. I would like to mass update any unpaid invoices that are sitting in the AP so that a new cash code overrides the existing cash code that was entered when the initial invoice was created. Now that we have changed bank accounts I would like to an easy automated way to pay old, unpaid invoices from our new account without having to manually change the cash code in AP30.3. Does anyone know of an automated process for this Much Thanks, -Ariel

How are vendor mergers and acquisitions handled within your organization If a vendor with active contracts and POs is acquired by another that is not in your vendor master do you add a new vendor and create new contracts/POs or do you change the name on the existing vendor

We are redesigning our GL in Lawson. Does anyone have a list of forms we need to change to update our GL Like HR11, AC07, etc. Thanks, Jim Ollerton

We are merging with another company and need to come up with a way that we can report as company X up until the merger and as company Y the day after the merger. We do not yet know if we will be staying with Lawson or moving to the finanical system they have, right now we just need to figure out a way to have a clean cut off between the two companies and report as Y company going forward. We currently have 23 active companies and we have subsystems and external systems that interface into our ...

Hi, Please help me understand where does the acct-amount from gltrans get its value from. also shouldn't base-amount and acct-amount have same values I have 2-3 scenarios where the base amount doesn't equal to the acct-amount.

Has anyone else run across this We use GHX for our MA540 files. On one specific vendor, the payment terms coming in through MA540 (payment terms are N30) are over-riding the Vendor Terms set up in AP10 for that specific vendor (N1). We need to pay this vendor at N1. We manually have to go change the date on each invoice or all of the invoices pay late. I can ask the vendor to change the terms on our account to N1, but this doesn't solve the root problem. Why is the MA540 file data over-...

Hi, Everyone, We are asked to provide a list of new accounts & new accounting units created during a period of time. However, we do not have auditing features turned on. Is there any way to obtain this list without the auditing feature Does Lawson stores creation date or update date for Accounts/Accounting units in any tables (other than auditing tables) Also, I would like to know if you do not have auditing features turned on, do you use any controls to track creation or changes of new ...

Hi, We are trying to see if the budget amount on an activity was changed. Is there an audit table for activities I have been unable to find any history. I looked at GL01.4 and when I select the AC line, the 'Audit' button does not display. We are on 9.0.1. Thanks!

I am trying to find out if a user for example runs GL165 in update mode, that it posted successfully I can't seem to find any information like this Thanks Frank

We are interfacing transactions over from our OMS system to Lawson every 5 mins. There, of course, will be fallouts from either the importdb's or the interface programs themselves - AR550, AR560, AP510, AP520 and GL165. We are planning to gather all of the log files (.prt's) that have errors in them and put them in a central repository so we can easily identify the issue and resolve them. Couple of questions here: 1) are the output files from either the importdb's or the interface progr...

We have moved to LS9 Security (no more laua). Most of the forms we had access to were removed and now we are piece mealing them back. My director used to have access to an AP form that provided a snap shot of all AP Vendor payments. He also said he was able to compare one fiscal year to another using this form, but cannot remember which one it was. Our IT department is also not able to tell us. We looked in the Excel Add in list since that is our only window to all Lawson forms under eve...

We are adding a new data area to the production product line tonight. We are working with a very experienced consultant to do the work with us but I wanted to see if any of you had been through this and have any lessons learned you'd like to pass on. Things to look out for Pre-game preparations Post-create procedures Backstory: HR wants to create a new data area and make a copy of Production so they can use it as a historical archive. Create it, copy the data, secure it and lock it from c...

How do you merge summary accounts in mass efficiently, without going through the painstaking process of moving accounts individually account by account. Some of our summary accounts have a large number of individual GL accounts within them, and we'd like to merge them into one summary account. Thank you.

Hi, I am new to the cost allocation module and I need help to understand CA and its links to FB and GL module. I currently have an issue where the amounts for certain AU-Account-sub account combination have values where some combination dont. As far as my understanding goes, once CA110 is run, the cost is allocated according to the mentioned allocations in CA10. Once CA190 is executed the values then moved to GL. Question: What are the sources from where CA110 is getting its input v...

There are multiple UI's in the AR module requied to be used to define and maintain EFT-related data: - AR09.2 - Banks - updates table DTCUSTBANK - AR09.6 - EFT - updates table DTCUSTBANK - AR09.5 - EFT Notification - updates table FTCUSTNOTE -------------------------------- However - there appears to be no auditing, by the application, of users having added or maintained this sensitive data (confirmed by Lawson Engineers). The only AR auditing appears to...