HI, I work for an EPP solutions company and my client is using Lawson 8.3 database. I am working on an interface that stores invoice image URLs. They are linked using the L_INDEX column to our system. From my understanding, Lawson starts with the L_INDEX of ZZZZ and goes down alphabetically. My questions is, what would happen if an L_INDEXes existed that started with YZZZ - YAAA Would Lawson keep going down until it found an un-used index or would it replace the index that is alread...

Hello, What are the steps needed to design an uplod utility for activities instead of manually adding them in using AC10.1

My organization recently started accepting payments from Medicare and other third-party insurance companies. Our current policies and procedures for maintaining the vendor master files require us to obtain a W-9 from the vendor in order to properly identify them using their Federal TIN. We also verify that the vendor is not on any excluded/debarred lists from participation in federal health care programs. In the case of insurance companies, we don't pay them for goods or services, but ...

hi guys I ran AC130 for allocation group the other day and it went into recovery with message 'storeDBRec error is Record not locked (8)' ALLOC-NAME = XXXXXX I ran AC130 again today it completed successfully. I cant even debug as AC130 is not going into recovery. Lawson 8.0.3 Any idea why such unpredictable behaviour

Our current DSS uses the CDM to analyze supply cost data. But we in Materials are a little wary of this because we have no interface between Lawson Procurement and the CDM. So how does finance get accurate supply cost data Is anyone out there interfacing Lawson to a DSS Our vision for a DSS would give us the ability to slice and dice data down to the cost per procedure (DRG), per physician, per vendor, per implant, etc.

My company has implemented AM with new assets acquired beginning Sept. We uploaded 'old' assets in our test environment and ran the reports to verify the results with our GL balances. When the conversion files were uploaded we called the book OLDCAPS. We indicated it as Non-Posting because the assets were already recorded in GL as fixed assets, as well as their corresponding depreciation exp and accumulated depreciation. These conversion files covered all assets prior to Sept 2010. My questi...

Hi All, I work in Not for profit Healthcare charity Organisation using Lawson S3. We are looking at using the Asset Management module. Was wondering if people had any feedback on the module and things to be aware of when implementing this module. Also any fedback on standard reports which come with the module Regards Saurabh

Has anyone tried to bring in credit card payments into the CB module as deposits How would the same transaction number be assigned to CB, credit card processor data, and get transferred to the bank Thx.

I need to build a report that captures activity for all levels of the following company ranges: Co 1200-1299 Co 1500-1599 Co 1600-1699 And level one = 100 and level two = 0-99 for company 1100. Does the question make sense Somewhat of a novice on report writer so any potential responses can be 'dumbed' down as much as possible. Thanks!

Can anyone tell me the ramifications of purging some past years prdistrib records Our file is getting enormous, and it's almost impossible to research anything at this point. Thanks for any input! Stephanie

For as long as i can remember we have used both date and budget edits for our activities within the other Lawson modules (PO, AP, GL). We have always struggled with these edits because our current business process requires us to contantly manually override these edits. If you are currently using the budget/date edits within Lawson AC, how do you maintain them, so that there is not so much manual intervention

I am wondering if anyone has developed a best practice for continuous integration with customer related information. We are integrating from another system that is and will continue to be the owner of the data. We need to interface with this data and using deltas (for both adds and changes) update Lawson. Right now we are developing a process to use ARICST and AR550 as an ongoing integration point. My main question is if anyone has developed a better ongoing process

Hi, I am writing an SQL extract program to get this information. I am trying to find on what table the vendor 1099 indicator is located. I was told the INCOME_CODE can be used for this but nothing there. I am also looking for the table where the Vendor Payment Code field (from the AP10.5 form) is located. Mike

We have been looking over the audit reports for BN/HR/PA/PR to see who changed what and when, but have had trouble finding corresponding reports in the finance area. We are most interested in CB/AR/AM/GL. I saw some posts stating that the financial audits are not so good unless you are running Lawson Security and Portal. We are running the 9.0.0.9 environment, 9.0.0.5 apps, and have most of our users in LSF. Only 12-15 LID users remain (also the ones with widest access). What type of repo...

How do I add some blank spaces between the last line of the format and the first detail line on an RW100 report

Customer name in AR appears to have a maximum length of 30 characters - of which, is a tad limiting (based on existing enterprise customer name usage/definition). Am I missing something - or - does anyone have any tips/techniques as to how to expand upon the size here I am assuming that: - Changing the attribute definition at the DB level - would cause a ripple-effect of possible form and reporting changes down the line (ideally - we want no customization that is required to be maintained)...

It appears that in our last months AM work some transactions made it through to AM20.5 and were processed successfully. However, where ever the data is for the AM221 report these transactions are missing to AM221 and AM270 no longer balance. Does anyone know where the transactions come from for these reports, as it appears they are not the same. We're on 9.0.1.5.153 and using Portal as our interface. Thanks.

Hi All, Apologies if this is not the right forum. I have around 150 accounts which i need to set the Activity flag to be Yes (in GL20.3) Trying to use the Addinns to make the change , the message after update says 'Window Changed - Update Form To Save' and the change does not seem to have been made Regards Saurabh

Hello, How do I go about changing the sequence number of the next GL journal number used through GL165 process

I'm trying to do an SQL extract of data related to the PO31 form and PO231 report. In particular, the Reason code. I'm not just talking about a list of Reason codes, but the data associated with this form; like Company, Return number, Vendor, Reason Code. I'm looking to isolate the records with a Reason code of 'WCR'. I need the table locations of this data. Any help would be greatly appreciated. Thank you.

I am a RW novice and need assistance creating a report. The report (a standard income statement) I would like to create is for a certain level group that I created. I would like the report to show only the information from the level group and at the same time consolidate the results of like accounting units into one on the report. So far the only luck I have had is to either show one of the accounting units or the consolidated group. As of now I am using a style 1 report. Any thoughts are...

Hi This is on 8.1 MSP5. Am trying to create an asset from an AP invoice using the AM115 session but keep getting message 'Account not defined'.[00999/8020] The AP invoice is linked to a PO which has the asset item (which was linked to an asset template) The PO line is against a Bal Sheet AU [00999] and Bal Sheet Account The 8020 Account is a P&L account which seems to be coming from AM06 (see screenshot for more info on setup) Does anyone use this routine to convert assets and if s...

I need to add comments on Asset numbers in the report via using Lawson API for comments. I just figured out that the table used for comments for Asset is L_HAST and L_DAST. Has anyone done it before I am bit confused as notb sure from where to start it. Could anyone suggest.

We are looking at possible solutions to scan our invoices, use OCR and workflow technology to route them and then interface into Lawson. I'm wondering if anyone is doing this today, what software solutions were chosen, what the experience has been, etc. Any information would be greatly appreciated! Thanks in advance! Reed

We are exploring the option of implementing the POP functionality to prevent users from entering requisitions and PO's on the last day right before a grant ends (our grants our tracked using Lawson activities). How and why does your organization use this functionality Tina Dosal Moffitt Cancer Center