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

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

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...