I'm struggling to find the accurate process for both purchasing and accounts payable to process a return. Our issue with our current process is that our purchasing team will process a return in PO31 for an item. The credit will then be processed by accounts payable and will keep the PO closed. When the replacement item comes in, AP attempt to match to the same PO as referenced on the invoice and they will receive an error that the credit can not be processed on a closed PO. I feel that there...

We are implementing Lease Management (LM) module and are wanting to upload them rather than key them in. Since we are new to this module, creating our own mapping we could miss some fields that we would need later etc so looking for someone who has done that already. Thanks Dave

We are reevaluating several of our practices and one that has come us is invoices for PO Lines that are closed. How do other handle these I'm not sure if there's a way or a setting that would allow the match screen (MA43) to display PO lines that are closed so we could enter the invoice for the PO line and let it trigger a buyer message or something like that. Is this possible How do others handle these types of invoices

I need to dump data from Lawson for budgeting analysis and need help with finding the right data fields/databases to pull from. Is there a Lawson screen/table that stores monthly activity for income statements accounts and ending balances for balance sheet accounts Any input would be greatly appreciated

Here are the details of my example: PO with one amount-type service line for $1000. Invoice comes in for $1000 and is fully matched and paid. PO Line is now 'closed' but PO190 not yet ran, so header is still open. We should have only been invoiced partially, let's say for $500. Credit memo for $500 comes in. So, what I have done is entered the credit memo information, including the information on the Misc. tab, selecting the original invoice. Then, go to MA42.1 - Memo Line Detail - Purc...

We are trying to extract AP and PO data for financial reporting and not sure what tables would give me purchase order info including accounting unit/account/sub account, fiscal year/month, number of units order, cost per item, invoice number, invoice date, invoice status, PO number, line number, line description, vendor code/name, check number, journal number, journal entry ID, line number, and check date/payment date Thanks in advance for your assistance

Hello, what Lawson tables would I need to join to create a crystal report showing company, unit cost center, account, sub account, start date, and amount I was thinking possibly the GLTRANS, thanks in advance for your assistance.

Hello, does anybody know if there is a Lawson report to see how many invoices are processed by each A/P clerk

My Director is requesting report that will show all spend for a particular activity. I can't look at a canned report as I need to pull data from our expense management system. I need to look at the fields on paid invoices as this will capture both Lawson data and Expense management data. What fields do I need to build a Crystal report for this

We are having trouble reconciling a CB bank account to GL. We have verified that all transactions are present in the bank account, CB and GL. Also, we verified that our beginning balance matches the ending balance from 12/31/17. We have run out of places to look. Any thoughts/tips/tricks are appreciated.

I am trying to write an GL detail report in Crystal or SQL that should include the following data. I think I can get most of the information from GLTRANS. Lawson suggested I extract the data from GL90 but that seems very simple Company department code account code as assigned by client in their GL Sub account Fiscal Month Fiscal year amount Post date of the transaction line Item description of the transaction line Journal number Journal line...

We have noticed that sometimes quantity issues will appear on MA236 and sometimes they will go to MA64. We want to know the criteria that would cause a quantity issue to go to one or the other so we can better work our invoice discrepancies. Has anyone else experienced this

We are in the process of setting up a new company in Lawson. Unfortunately, our most recent process narratives for AP, PO, MA and IC don't appear to be the latest and greatest. Therefore we can't seem to get MA and IC fully set up. Is someone willing to share set up process documentation for MA and IC We are on version 10.

We are trying to transfer assets in AM between companies. When we complete this on a line by line basis in AM, all seems to work fine. When we attempt to complete this using AM135 we receive the following error message: 'To-company accounting unit does not exist'. Any thoughts are appreciated.

St. Jude was purchased by Abbott last year. We updated the vendor on all open St. Jude POs in January. Some could not be changed due to previously matched invoices. We have an invoice for one of these POs that AP needs to pay to Abbott. I'm on the procurement side so I'm no that familiar with AP processing. Can AP match the PO and change the vendor on their side to pay to Abbott even though the PO vendor is St. Jude

Our finance department is creating requisitions with the Quantity field populated with the dollar amount and the unit cost field with 1 for PO's that are for services. They are also making all requisitions a special type and not using the service type when creating these. The reason being from what I have heard is you can't receive on Service PO's and there are no reports for viewing open Service PO's. One suggestion I had was to add another item type code to identify it as Special\Service or wh...

Is anyone using the AR system to key in product sales We are looking to do this but currently do not have the AR system set up at all so trying to see if this is an option for that part of the application.

Hello all, We are looking to develop an OnBase form for entry and approval routing of expense reports. After submission the reports would sit in an audit queue until approved. After approval we would run a report and extract of 'approved pending payment' reports. We are working though option of import into Lawson. Since they will be paid through payroll that would be our preference but can't figure out how to have one payment code with multiple expense distribution lines. Our other t...

I have been tasked with providing Vendor= Epic with the field mapping for Patient Refund processing. I believe I need the APCINVOICE, APCDISTRIB, & APCPAYMENT tables - but, am not sure the best route to go for figuring out the proper mappings. They (Epic) did provide me with a Standard Extract guide, but was hoping someone could offer some advice

We have read through the user guide but were hoping to find a training video or additional documentation to ensure we are using it correctly. I haven't seen any videos on Infor Campus related to this. Does anyone know of any resources we could use to train our end users Thank you!

Currently our buyers work messages on MA64 but we don't have a good way to send these messages back to Accounting when needed. We are considering building the AP Clerks as buyers so that they can view these messages OR building an AP buyer user that all AP Clerks can use to view their messages on this screen. Has anyone ever tried to do this before and if so, how did you achieve it Thank you!

Does anyone know if there is a way to get a dump/report of Completed user jobs We're trying to perform some job analysis; determine run times, number of times users are running jobs, etc. In LID I can copy from Completed Jobs in jobschd manually but that's going to be time consuming. Any help would be greatly appreciated. Thank you.

I am using a Infor-provided IPA flow which drops a file into the /work/GL65CSV folder. It then attempts to execute a GL65.5 to import the CSV file. I get an error every time in the Work Unit log: File has already been processed. (I can also do this via Portal and get the same errors when executing GL65.5 directly without the IPA flow.) When I look at the LAPM log, I see different errors: 1) 'CSV Hdr Read Error: Fld Name A-N-Y--F-I-E-L-D--N-A-M-E Not Found' 2) File GL65CSV Al...

Hello, We recently went through a system conversion to a different ERP and we were still using Lawson 9.0.4. Today the system is tossing the servlet call /ssoconfig/SSOCfgInfoServlet error and we can't connect through portal. I can RDP into the machine, connect to LID, and LDAP bind to our active directory. But I cannot figure out why this error is popping up now. I cannot access the Lawson RM or Lawson Security tools, i receive an SSO connection failure response. I know this is way ...

So our issues have been going on for almost a year. As it turns out we are one of two clients on S3 version 10, on a windows platform, attempting to use the Vertex O series. We have multiple environments and have not had any success with configuring, patching, etc getting the systems to talk to each other correctly. Our other integration's, which number in the 100's, run flawlessly. The keep or toss moment is here as its' implementation is holding up several large initiatives and I was hopin...