Hey guys, I'm rather new to Lawson. We're running version 9.0.1.9.153. I am trying to figure out how to run depreciation reports for a prior year. The reports that my company has been running (AM280 for instance) don't seem to have a field for run dates(i.e. 1/1/2012 - 12/31/2012). I've been told by those here before me that all depreciation reports have to be run at the end of a given period(on that actual day) to get an accurate depreciation report. That sounded a little ridiculous to m...

Our AR dept has requested a place where they can record conversations with customers. They need to be able to recap their discussions for future reference. The only place I see is AR17.1 but this does not look like it will be easy to use. Can anyone share what they do to record comments and actions

We are trying to change the TIN type for vendors via add-ins from '0' to '1' in AP14.5 using add-ins. When I map to AP14.5, I get a message telling me 'tax ID must be 9 digits' If I try mapping to AP10.1 and select the TIN type as a hidden field, I get change complete continue, but it doesn't change the TIN type to '1'

Payroll processed the PR197 on Friday 10/17/14 with the G/L Date of 10/08/2014 instead of 10/22/2014. I was hoping that there is a way to back it out and re-post it to the correct date. Does anyone have any ideas for me

My company is trying to create 2 separate books for our asset management. I created a second book as non-posting. This book needs to always contain the historical book value (i.e. can never be impaired over the life of the asset). The original book should have all regular functionality. The hope was that we could create one asset template that will post a newly created asset to both books, but as adjustments are made over the life of the asset, only the posting book would be updated. This ...

New user here (3rd day) and I have a couple of questions which I've asked my staff and they did not know. (1) How do you enter discounts within the AP20.2 {TAXED INVOICE} module on the Main tab I do see a 'Discount' box and have clicked on that, which took me to AP22.3 {DISCOUNT}. My staff instructed me to enter the discounted amount of the invoice in the INV AMOUNT box and then use distribute out the cost to the various GL account(s). The PMT TERMS box is indicated with 'N00' = pay imme...

I have an RW100 income statement that works, but it takes 8 hours to run. I would like to rewrite this just using the lawson tables in crystal reports, but i'm having trouble with the grouping for my subtotals. I've read a couple posts that said they were able to create a view using the rwrowdet file to control the grouping in crystal, but I'm not sure how to do this/what fields to use. If anyone has information on how I could do this or a diffrent way i could write this I would greatly apprec...

Does anyone have some straight forward instructions on how to setup ACH via EDI AP is able to get the funds to the vendor's bank but they want to set up EDI to send remittance information and the Lawson KB doesn't really explain how this is set up. I'm on the supply chain side so I'm not completely clear on ACH but the AP manager asked me to help because I know EDI for supply chain. Do we need to do any setups in ED02 or ED10

Is there anyway to back out a Non-AR payment so the payment can be reapplied directly to the appropriate invoice

Has anybody tries to setup an allocation where you are allocating from multiple and to multiple accounting units a summary account like EBITDA. Can you share the steps used to set up this allocation Thanks, ruma.

Due to a merger, our new health system has to select either Lawson or McKesson for ERP (Financial & Supply Chain) to move forward with. Has anyone gone through a similar selection process recently between these two vendors who would be willing to share their thought process on which selction you made either way Thanks.

Like APCINVOICE for APINVOICE or APCVENMAST for APVENMAST. We are trying to interface AP comments along with the AP invoices. Whats the equivalent for APCOMMENTS

Is there a screen or report that will list all PO20's that used against items in a PO25.6 Vendor Agreement/Contract Or another way of saying it.... We have a PO25.6 Contract in place for copy paper, 4 items to be exact. Our audit team want to see if the Contract items are being used. Th audit team wants to see a list of PO20's that were issued using the 4 items in the contract. Thanks.

I'm not sure I's posting this problem in the right location. I wrote rules to restrict users by process levels, which works, but it doesn't allow for Drill Around access. For example, I can restrict a user to process level using the rule which looks at ProcessLevelControl and AccountingUnitControl in RMID, but no information is displayed when the users tries to use Drill Around. There should be a way to make this work. Does anyone have any experience with process level restriction and access to ...

I'm pretty sure I know the answer to this question... but has anyone used Lawson Asset Management for managing 'physical' assets and tracking its location and any potential related inventory I know Lawson AM manages depreciation and its integration with GL, but the request is simpler than that. We have internal customers wanting to manage equipment which is on a trial, loan, demonstration or evaluation from a vendor. If so, how did you do it Thanks.

On an aging report (AR251), does I.P.A. stand for Invoice Payment Average Is this closer to a DSO average or is the F.O.R. - Funds Outstanding Ratio closer in measurement to the DSO

We have 3 GL companies that are no longer active. Is there a way in Lawson to make them inactive so that nothing can be accidentally posted to them from AP or IN etc. There is a status field in GL10, but it doesn't seem to be where I would accomplish inactivating a company. Any thoughts as to what my best plan of action would be Thanks Dave

Hello Everyone, I ran AR199 without the 'Year End' option clicked to yes. Is there anyway to go back and change the close to year end now

We have a new AP employee who started as a vendor and was given an appropriate Vendor user ID in for AD and Lawson. Now that she is an employee we have assigned a different login for AD and Lawson but the original vendor user is still populating the APINVOICE file. It appears that her new user ID has no impact on populating the value in the APINVOICE OPERATOR field. I tried to find a screen that allows the entry of the Operator ID for any AP table and did not find one. We have a Crysta...

The user believes that the Current Period Depreciation on an AM260 report is an accumulated to date figure, for the current period and will change any time she runs it. I am certain the CP Depr shows up after AM180 is run. And when AM190 is run I assume the CP Depr is cleared and the YTD, LTD is updated. Can someone verify this sequence for me These are folks on 8.1 with no on site staff who were ever trained on Lawson. I am just trying to look at manuals and help. Thanks.

We just found out that Lawson does not support our state's requirement of reporting income and taxes withheld on 1099 forms/filing. This year we can file manually with the State but going forward, we're wondring if anyone has solutions for housing and reporting the state income and tax withheld for both printing and electronic filing We can use the combined State/IRS filing but we still need to report the state data directly. Thanks for your help!

Hello, I am looking for the information on the AP270, if possible to get the cost center and the expense account, which table should I pull from Any help would be great.

Hello, hope some can help me out here. We have a custom program that creates a vendor's payment history report. It reports vendors ID, name, tax ID, invoice amt, Net Payment Amount, class, and address. The only problem is the some of the address are incorrect because they want to see not the main address but the transaction address. So if a vendor's main address is in IL, but they did the transaction in WNY, the it should report the WNY address. I don't know where this address would be store ot...

Good afternoon - looking for some information regarding paying the state of Alabama withholding taxes via ACH with AP161. According to our users, they have to go to the AL website, and file a report prior to sending the dollars. When the report is filed, they receive a confirmation number, and they have to re-enter this when paying the tax via ACH Doesn't make a lot of sense to me.... So, if you use standard Lawson/Infor AP and pay AL state withholding via AP161, would you share your process...

Good afternoon - not a lot of AP info available..... Is anyone using AP160's NACHA format to pay state withholding taxes Hoping I may be able to pick your brain! We're currently using AP161 and a custom program to reformat that file, but would rather use out of the box if possible. Thanks!!