Our accountants currently use Hyperion Essbase on a daily basis to pull financial (GL summary) information via Excel. We use Hyperion Reports for period close reports - P&L's, Revenue/Expense, etc. The financial cube is reloaded periodically via a scheduled Analytic Architect job several times a day to provide timely data. We are due to upgrade our Hyperion products but it is very expensive. I've heard of Cognos and Microsoft has an OLAP product that may work with Analytic Architect also...

I'm building a report using the APAUDIT table and in looking in the data dictionary at the Field ID values I'm noticing a bunch of them are blank and a few that my report is pulling are not even on the list. Is there a table in Lawson that would list the Field IDs and a descriptiondefinition Are the missing ones custom and possibly unique to our org Thanks in advance to any advice.

With internal controls, it would not be uncommon for a JE that a staff member creates to have six touch points as it goes from creation to entry (signatures, someone keys, someone reviews in Lawson). Currently, any JE that needs to be keyed into GL40 is on paper to get the necessary signatures. Has anyone had someone design a better way for JE's to get into Lawson, perhaps using process flow We use GL165 for larger imports, but I've envisioned someone creating a spreadsheet, approvals are ca...

We are attemping to setup a NACHA file format using AP160. Our file currently is outputting a file that puts the data in one long string. We wanted to get this type of format below. Basically the normal NACHA looking format....any help or thoughts Where are we missing a flag or parameter to get the output to look like this Thanks! 1 data 5 data 8 data 9 data

See the attachment for reference. On AP 90, if you drill down for an invoice, you get a pop-up page called 'Drill Around'. There is a list of options on the left section of this page. The first option in the list is 'Invoice URL Attachment'. Expanding this option gives you a link to the invoice image. When you click on the Invoice Image link, you see the Title and the Url on the right section of the page. Which Lawson table holds this title and URL I'm assuming each URL is tied to the ...

Hi everyone, We have the Lawson Financials but have not installed the AP matching module. We currently use inhouse written Matching, Purchasing and Inventorysystems. We will continue to use the inhouse Purchasing and Inventory systems for now but are considering moving to the AP matching module. I am sure once we get the system we will get the tech docs but we would like to find out what minimum fields are needed for 3 way matching from our inhouse systems as soon as we can so we...

We are receiving a logon failure: unknown user name or bad password when running RW100 - we are running 9.0.1. Anyone else running into this

Our tax accountant is wondering which reports other companies use to get to year-end tax information on assets. We currently run a bunch of different reports that she uses (AM255, AM260, AM280, AM290) to essentially verify that Lawson matches all of her manual Excel tracking. Is there a way to make Lawson the source of truth / avoid all the manual Excel work / just have Lawson kick out the numbers needed for form 4562 Or does anyone have a Crystal or Query Wizard report built that does t...

Is there a table similar to the GLAMOUNTS table which contains the reporting currency period totals instead of the Base Amount totals contained in the GLAMOUNTS table Does that exist For example: When running a GL95 with Type = R Reporting & Currency = USD (in our case), is the begging balance amount stored in a Lawson table for the specifiied account(s) or is the beginning balance calculated at the time of the retrieval Thanks!

Hello All, I am trying to replicate the MA236 form 'PO received but not invoiced' using Crystal since we need an additional field (invoice date) to be added to the report and is currently not included in the report Lawson produces. I have identified the tables that I would need to create the report but I am not sure how to link them properly. I have identified the following tables: APVENMAST APINVOICE POLINE MMDIST I like to know what the proper relationship is between these tables ...

Hello - is there a way to attach journal entry support within lawson, specifically on GL40 screen I'd like to be able to pull up a JE and view the support for it within Lawson. I believe there is a module that allows this - has anyone utilized it and how does it work

Is there an API that I can call to calculate the previous month given the parameter current month

Trying to find out if anyone is using Lawson Analytics to integrate patient accounting data and finance data to perform the cost allocations and patient revenue allocations necessary for preparing data for Medicare cost reports.

We have to start reporting and withdrawing a percentage of money before paying foriegn vendors.Then we have to submit that money to the IRS. New FACTA regulation also known as 1042. Currently we just created another income code, 1042, and setting vendors up with that. But we need to have a field so we know how much of a percentage to keep and then it would be nice to have it somewhere in the invoice. Anyone else been doing this

I'm looking for Lawson customers that are using Paymode-X (Bottomline Technologies) to make electronic payments. The issues that we are facing are: • Paymode-X assigns each vendor a 20 digit identifier that needs to be entered somewhere in AP10 (APVENMAST). There are a couple of non-critical fields that can house a number of that size. Email, which we currently use. URL, which we currently use. • Are have 8 GL and 8 AP companies and 2 Vendor Groups. We are not planning on having all ...

I'm loading new activity attributes into ACIFATTR for existing activities that have an attribute already assigned for the matrix category being used in the ACIFATTR records. I'm using today as the effective date. Using AC510, the records are found, brought into the system and removed from ACIFATTR. Run AC10 to view the activity, click on the Attributes button to access AC13.1 and I see that the attributes still contain the 'old' values. The 'Eff Date' button now has a...

Given IRC changes in cell phone policies. How are Lawson users handling cell phone reimbursement Are you still using stipends through PR or are you using AP My understanding of the IRC is that cell phone reimbursement is no longer taxable as long as there's a business need. If use PR how are you preventing it from being taxed or are you supplementing the amount to account for tax Any feedback would be appreciated. We are looking to setup a process flow to automate the request and impl...

We are new to Lawson and some of the staff will be attending Workflow training. For those of you who are experts, what can we do to be best prepared for the training (to maximize learning). Are their certain skill sets required Secondly, Once training is complete, what would be the estimated time someone out of training would take for creating low to max-complexity workflows Thanks!

I am working in a healthcare on ETL tools, now a requirement assigned to me, is to calculate the daily productivity on each day basis dollar amount. Could you please provide some details on tables. I am currently looking at GLTRANS table based on fiscal year, account, sub_account. But acct_amount and trans_amount fields are showing values zeros mostly and Units_amount has values. which field value should i sum to calculate daily productivity select fiscal_year, acct_period, account, ...

Where can i find descriptions for Account and sub_account fields under GLTRANS table. Thank you very much for the helpful info.

When looking at an Aging Report (AR251), what does F.O.R. stand for at the bottom of each client summary and overall total I believe the term is comparable to the term DSO (Days Sales Outstanding). Thanks.

Has anyone come across the following: (Version 9.0.1) We have lists built in MX10 which suddenly fail to produce data. If we replicate the list and making no other changes the new list works. What I found was that the sequence number was missing on the old list (MXLISTDR - Table) So I did a change on the lines of the list, previewed (returned data again) and validated the sequence numbers now existed. We are trying to figure out why this would have happen and any insight would be appreciat...

Does anyone know if it is possible to merge orders together to create one invoice. I saw that you can merge shipments in the Warehouse, however, the documentation specifially talks about doing this when the ship-to location is the same on both shipments. We have orders that we want to combine on an invoice that have different ship-to locations. What we are looking for is the ability to combine more than one order, possbily for more than one ship-to location, on one system invoice to the custo...

I am looking for best practice in regards to the default setting for vendor payment codes in AP10. Our default setting is set to SYS. We have some vendors set up with a payment code of ACH on AP10 that have multiple remits (locations). These remits will pull as ACH and not SYS because of how the vendor is set up on the main screen in AP10. Idealy we want the system default setting to drive the payment code and not have to override it in the remit (location) forms. Any input or thought is we...

I'm going to start by apologizing. Not only am I new to Lawson, but I am also new to the company that I'm currently working for. We are having a problem with Lawson which nobody here has been able to track down. Here is a rundown of the issue, as summed up by one of the application owners. ---------------------------------------------------------- 'We have been experiencing several incidents with Lawson ProcessFlow Integrator workflow units not executing. This is causing significant ...