I am writing an extract of GL account balances from Lawson and I am trying to find out which table to use for this. Historically, I have used GLAMOUNTS to gather all the data from the most recently closed period in Lawson. However, the Lawson users report GL amounts from GL95.1, which uses GLTRANS as the source. Can someone provide a description of what each one is supposed to be for and which one is more accurate for the closed period. I have found about a 3.5 difference between th...

Hi, We needed to send some GL update reports on a daily basis to a few third party vendors. In order to avoid duplication of the records sent, we ideally liked to filter the GL transactions in the DB based on the posted time stamp and schedule a job to run once a day. However, we developed a circuitous work-around to meet this requirement. Currently, we are trying to eliminate the work-around and send the list of GL transactions based on the posted time stamp (please note that it is not ...

How do I get a list of all invoices that have been paid from certain date I need to provide auditors with a crystal report

To preface, I'm new to inbound Lawson GL technical integrations. I've sourced from it plenty of times but never wrote into it. We are looking to upload an externally managed Chart of Accounts to Lawson as a regular business process to keep various GL systems (not all Lawson) in synch with corporate mandated 'common CoA'. We can create pretty much any format, parent/child, generational, xml, etc but can't find any documentation of how this is done for Lawson GL. Is it as simple as just writ...

We are looking for some ideas related to 3rd party check printing. How secure they are etc... How are people pulling the check file from Lawson after they run AP155.

The company I am supporting created a new company in FY 2014 after declaring bankruptcy and closing the old company number. The new company actually stated in Period 03 of FY 2014. It appears the person that set up the new company put the equivalent of Beginning Balance Amounts in the DB or CR fields for Period 03. From there, JE's posted to the accounts through the remainder of the year. At the end of the FY 2014 some issues came up with balances and the rollover to 2015. I think...

Hey Guy's, Just joined a new company that does monthly billing by emailing invoices on a per partner basis after being released and printed(by the print manger). Imagine sending out 500 emails to different partners. Is there a way to automate this (we use the excel add on to upload/creating the invoices) I am just wondering what other company's do in such matter. I can also provide more information if needed. Thanks.

How do you separate shift differential hours or on call hours from posting to the general ledger We need the dollars posting but not the hours because these are not paid hours to calculate FTEs. I see a flag called Post Hours in prtime table. What does this do

Hi, Our company is a developer of Account Receivables suite (invoice distribution, outstanding monitoring, dispute workflow, collection workflow, etc). We have done integrations with many ERP systems - SAP, Oracle, Axapta, etc. As a matter of fact, our potential customer is using Lawson Financials Suite S3 and asks us about the posibility to get integrated. We are doing integration in three areas: 1. Issued invoices - in case of SAP we are fetching iDoc messages using webservice 2. Custo...

I need to use addin's to pull information regarding Accounting Units and accounts that have a the relationship say yes it exists (GL20.2). I don't know what table the 'exists' field lives. Anyone know

Is there a screen where I can see an accounting unit and all the accounts with their current balances Also which table can I pull this information from. Thank you!

Would anybody have an idea how the CBPMTLOAD table is loaded or why it would be empty My user is getting an error when submitting the CB554 job and the error suggest there was not any data to process for that run group. I ran a query and indeed there is nothing in this file.

We prepay many of our vendors, so we don't get invoices from them...at least not invoices that we enter into Lawson. Back in Lawson 7, we could enter $0 AP invoices and match them to the PO receipt. As of Lawson 8, we could no longer enter $0 AP invoices into Lawson...so we would create $.01 AP invoices. This just floods our AP with $.01 invoices. MA80 and MA180 just don't seem to be the type of solution that our accounting group is looking for. Does anyone else have a solution they are wil...

We are having an issue with some Reqs that are being created with an unknown operator ID= 'essuser'. We looked in security and there isn't such user. The requester is a Handheld device and header source is Upgrade. I have attached a screenshot.

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!

Anyone using Smart Reconciliation that is willing to share their setup/best practice in regards to who works what Currently our buyers work the MA64 and MA60. When we went live in 2004 'Matching' was listing in the Procurement suite and assigned to the buyers. As we have been testing Smart Reconciliation we are wondering if AP should be more involved in this function. Thanks in advance for your help with this project.

We are getting ready to use the Lawson EDI GTIN and I (IT) am being asked to give a guesstimate on how much time would take to implement. I was wondering if anyone is using the GTIN and can provide any feedback. Is it a simple/complex setup Would the users or IT be doing the setup and loads We are on ESP 13 and MSP 9, Lawson 9 technology.

We use PO code for PO. Based on the PO codes,AP decides which handling code to select. Now our operations want to get rid of PO code. Anyone have input on how to handle this at AP side so they don't have to select a handling code

How do I find what has accrued for specific accounts Is there a screen or a table I can reference thanks

I've recently been given a lot more job duties so I'm looking to make my account reconciliation process more efficient to save time. I currently run a GL 290 and use that information to complete account rec schedules. What are your best practices for reconciling accounts What reports do you pull from Lawson to streamline the process

Does anybody has a document on how to work on MA126-Match exceptions Thanks

Does anybody has a document on how to work on MA126-Match exceptions Thanks

Does anybody know what job on the MSCM side (MSCM9_TASK table) uploads/sends the counts to MSCM Is it the outboundscheduler job I am trying to figure out how and when the HH orders get uploaded into MSCM

We upgraded the environment this weekend and we are seeing some weird data in IC99.2. We are fine in LID but not portal. I have attached an screenshot.

I am trying to create a list of vendors including name, tax id, diverse code, phone number, class, and address. I joined the APVENMAST AND APVENADDR but I am getting multiple address per vendor. I think I'd like to get the maximum date or most current vendor's address from the file and I don't know how to. Any help would be greatly appreciated. Example: Vendor 1 MED PO box 1235 1/18/11 Vendor 1 MED PO box 3953 3/26/12