Hello, hope someone can help me. NYS is requesting contracts and POs executed from x date to x date, what Lawson tables can I pull this data from Thanks in advance for your help!

The MA531 is getting a CSV file not found error. I am not sure how the CSV input file is created, but I checked in the directory and the file is not in there so it seems like we are not getting the EDI file in the directory. Any idea how to fix this Error Log: ** Creating .prt and .dtl files Processing MA531 - Receiving Batch Update *** MA531CSV file not found in MA531CSV directory*** *** No Records Found For Company 0010

Ive been having this activities transactions end up with the account category error (suspense) and then hit a particular account, is there any place where an activity group is tied up to where (GL account) to post this ERROR category , Ive notice this varies from activity group to group. second, it supposed that this account category error is made when activity groups are set up to edit option 3(substitute-suspense), but I have em in option 4, but I still get transactions coming from B...

Our A/P department receives a paper invoice from the vendor. The invoice is sent to the end-user where accounting information is entered on a label, the label is affixed to the invoice and approved by the manager. A/P receives the invoices, enters coding against a PO25 Service Agreement at the line level. The paper invoices are then forwarded to internal auditors for review online.. The paper invoices are then approved by the audit team, sent back to A/P, then A/P performs the match...

Can someone tell me what generates an asterisk in the 'PO Vendor' and 'Location' fields in AP10.1 Thank you.

We are looking for a report that will show us vendor discounts taken and lost during the AP/Cash Disbursement process. Is there a report that will show this information Any help is appreciated.

Could someone provide some insight on if whether or not the AROITEM_OPEN_AMOUNT derived field can still be used for calculation purposes, even though this field may not be viewable from within a Lawson Production Database I completely understand that no data is stored in this field. What is the purpose of this field being referenced on the LawsonGuru site and there is no way to reference or leverage it for invoice open amount identification purposes. :confused::confused: Any insight ...

We recently upgraded from V9 to v10 and several of our RW reports are running slow. In v9 the run time for the report in question would be 15-20 min. Now with new larger, faster servers the same report is taking about 45 min to complete. Just wondering if anyone has a tips or tricks that would reduce the completion time of the report.

We recently upgraded from V9 to v10 and several of our RW reports are running slow. In v9 the run time for the report in question would be 15-20 min. Now with new larger, faster servers the same report is taking about 45 min to complete. Just wondering if anyone has a tips or tricks that would reduce the completion time of the report. Lawson support has not been any help.

I was able to pull our table definitions via the following lid cmds: dburf -pw -d D:\LSF\law\prod10\usertext PROD10 (PROD10 is my productline name) This will take a while once complete type in CD D:\LSF\law\prod10\usertext (remember your drive and prod line will be different) next enter the following commands one by one dbdoc -pw PROD10 AC dbdoc -pw PROD10 AD dbdoc -pw PROD10 AM dbdoc -pw PROD10 AP dbdoc -pw PROD10 AR dbdoc -pw PROD10 BL dbdoc -pw P...

My users would like to process our 1099's this year using the AP146 (1099 tape creation) instead of the AP145(1099 forms creation) that we have used in previous years. I am not familiar with this process and what we need to do to prepare to do it this way. Do you know what we would need to process the 1099’s this way Any information that you could give me would be much appreciated. Thank You

Can anyone share their set up of MA00 & MA01 with me I am working with the Reconciliation Message portion to help with Matched Not Received and PO135 issues. I am hoping to see how others are set up in this area. Thanks in advance!

We are having such as difficult understanding understanding the IC527 interface program. Our users think the item cost is incorrect for certain items so they want me to customize the program. According to Lawson, The LAST-REC-COST on the ITEMLOC file is updated upon Match and is what the Lawson System will use for Last Cost defaulting for N items. Does “Match” mean match between item receipt and invoice or does Match mean match between PO and PO receipt Essentially, my users want the cost ...

My users are doing some testing and need to test if they can cut checks out of Document Express. Does AP155 creates an output file and if yes, where is this file located

Anyone have any experience with a process flow to take invoices off of hold Would we automate the AGS call to ap30.1 Can we simply remove the record from APHLDINV Any help is appreciated - thanks!

• What field would be best suited for marking the transactions as (having been extracted for billing)from AROITEMS , ARAPPLIED so that they are not extracted again this month..

Hi all, I have a scenario where our Job MA540 fails and goes into 'Needs Recovery' when we do the matching on an Invoice that has taxes in MA54 and try to run MA540 it goes to 'Needs Recovery' with the following Generic Cobol message : \n Execution error : file 'D:\lawlsf\apps\lsfprod\obj\MA540.gnt' \n error code: 114, pc=0, call=1, seg=0 114 Attempt to access item beyond bounds of memory (Signal 11) I recompiled the program with trace on, and I see that it fails at th...

We have an issue with AP170 producing incorrect postings to the GL for payments written. We are told by our IT that is has something to do with 'Merged Vendors' and they are asking us to produce a report to show all Merged Vendors - does anyone know which report either from A/P itself or a qwery wizard - Thank you,

Does anybody know how to customize rqc 10.6 so that the GL accounts displayed are limited to a certain range When you are searching, it should only show a limited range. RQC Shopping Accounting tab Account sub Account

My GL user is testing a program and comparing the results to production results. The check number/transaction numbers are different in test/live. I am thinking this is a data issue or a missing step. I ran a query against the CBTRANS file and all the details match except for the check number. What would the check be different in each system though

My company has quite a few intercompany relationships defined within Lawson. Is there any way to provide visibility to the originating transaction description The auditors do not like seeing 'auto offset from...' and our accountants don't enjoy hunting down the original JE's for them... So we're trying to create a report that breaks down the intercompany transactions and pairs them with the original transaction's description. Thanks!

We are migrating our Great Plains AP to Lawson AP. Our Great Plains check print process uses MEKORMA MICR to format and print checks. But our Lawson check printing process uses Formspartner. The business is wondering if we can port the Lawson AP155 Check file over to MEKORMA MICR and use the already setup Check Templates in MEKORMA. Anyone encounter or hear of doing this before Thanks!

Hello All, I need to pass the Account Receivables information from INFOR to another Billing Engine.. What are the Table names or Layouts to get the information for BAL-CURR BAL-PAST-DUE LAST-PMT-DT LAST-PMT-AMT TOT-PMT-ON-ACCT -AR-TRAN-POST-DT ADJ-REFRNCE-NBR

Does anyone have the essbase api for AIX

I keep reviewing the required fields and have linked them in my script but I keep getting Field is required and not knowing which field is miissing.