Does anyone know how the name of the export file is built We are having an issue when the path name the file name exceeds 60 charaters. It truncates the file name (i.e somtimes we get ...print1.cs....print1.c....pri...).

We recently purchased land to build a branch office, but did not need all of the land we had to buy. The land was added as one asset with a quantity of 1. We sold off the portion of the land not needed. Now I need to dispose of a percentage of that asset. However, Asset Mgmt won't let me do that because a partial requires a quantity of more than 1. Any ideas

We currently have activities/grants for Research and Capital however our Marketing department has just requested a new and separate activity structure in Lawson/Infor. I need help in establishing a structure since this will be completely different from our current. What steps should I take to setup a Marketing activity Group that does not want budget editing turned on and only wants to use Activities to monitor their expenses. Any help would be greatly appreciated. Thanks!

I am currently researching how to start uploading assets in a fast and easy way. The current method I use to capitalize assets is to see when an invoice payment hits my asset clearing account and then finding the invoice and keying the asset in using AM20.1. Nothing is automated in my system, so there are no asset templates assigned to invoices or POs. In all the forums I have read so far nothing has fit my particular situation. Just looking for any help anyone can give me. I am fixing to h...

We want to track discounts on purchase orders. Our procurement department tried to do this by adding a negative AOC, but that caused a lot of issues when accounts payable tried to enter the invoice. Any tips or suggestions on how to track this Thanks, Margaret

Hi All, I need query for a data dump of all the GL transactions for 2013 for company X and Y for the year end audit for 2013. I tried but got confused about tables. Here i used only two tables GLCONTROL and GLTRANS Please anyone help on this query. select CONVERT(VARCHAR(4),GLC.COMPANY)'-'CONVERT(VARCHAR(4),GLC.FISCAL_YEAR)'-'CONVERT(VARCHAR(4),GLC.ACCT_PERIOD) '-'CONVERT(VARCHAR(4),GLC.SYSTEM)'-'CONVERT(VARCHAR(4),GLC.JE_TYPE)'-'CONVERT(VARCHAR(4),GLC.CONTROL_GROUP) as JE,CONV...

After running AP240, there were no hold invoices on the report. However, there were several 'out of balance' invoices. I can go to AP30.3 or 30.4 to adjust amount--my question is--if the invoices are a prior period/year, should the adjustments be done differently

There are invoices/credits on the report that should be removed. Example: An invoice was entered and then a credit for the same amount was entered. The net result is zero. However the two line are still showing on the report. I tried to remove the lines by AP35. However, it shows no invoices for that vendor. The invoices are prior period/year. Does that matter Or, could I remove the two lines by AP55--even though it is prior period Thanks for your help. I have asked several people i...

Starting in 2014, employer medical insurance premiums are now being tracked in Lawson to report on W2. Prior to this, ther was a manual work around and the employer costs were not in the sysytem. Now that the employer premiums are in Benefits they are posting to the GL causing an astronomical increase to our payrol expense. Is there a way to shut those codes off so they do not post to the GL but we still can report on them.

I am adding P-card payment processing at a shop that uses Lawson AP for expense vendor payments and a separate AP system for trade vendor payments. The trade vendor payments are interfaced from the separate system into Lawson via CB500 and reconciled in Lawson. This arrangement has been in use for paper checks with no problems for a long time. I set up a cash code, transaction code, etc. for the P-card payments to expense vendors, and got the outbound electronic file from AP165 going with...

My users ran LP198 twice and we now have double posting entries in GL. We are trying to figure out how to reverse this, but nobody in finance have any idea how to. There is a screen GL40 that we normally would use but doesn't have LP only TA. I have attached a sreenshot showing all the sytems except LP. Any suggestions/ideas would be greatful. Thanks

Does anyone else have a customer that gives a discount regardless of the due date We are trying to set up the terms to take the 2 discount but does not have a due date. Any thoughts

Hello, I am new to Lawson , can anyone tell me what is DIFFERENCE Between COST CENTER AND ACCOUNTING UNIT

Hello....we processed an AR20 batch under the incorrect process level in Lawson. The batch is released and processed (AR190 and 195 have been run as well). Is there are way we can assign this batch to a different AR process level Any help would be greatly appreciated. Thanks in advance.

Recently participated in a process review with Infor consultants; one of the recommendations for the Financial users was that they try to use the capabilities of the MS Excel Data Connection Wizard for working with the Lawson/Infor data. Is it possible to connect MS Excel to RW100 reports using an ODBC connection Or do we need to use the OLEDB connector to do this If anyone has done this, would greatly appreciate your sharing a sample of the process. Also, if you could share comments...

Has anyone turned burden calculations on and by turning them on, did it throw off your BR120 and BR130 balance

Does anyone know the answer to the following question I am using the Period of Performance AC10.6 at the Activity group level to stop PO's being set up against a project after a certain date but still allow all other transactions to go through against an activity. I have tested this scenario and everything seems to work. However, the only piece I am not sure of is if the RNI accrual would hit the activity. The RNI accrual has a PO R_System code and I was wondering if the RNI accrual would st...

We have come into an interesting issue when some of our companies are running their GL199 closing. The issue is sporadic & not consistent across other companies. What we are seeing is that the company value is changing somehow from a numerical value (eg. 3201) to an 'otoc' value somehow. Has anyone ever come across this here is an excerpt from the exam log of the job below. What makes this more interesting is when we actually recover the job, it completes successfully. Infor has added slight re...

What table contains the field that contains the journal entry attachment comments which can be entered in GL40, GL41 or GL45

Emp can log into Lawson fine, but no data is displayed for her under paychecks, leave balances, etc. I have no idea how to troubleshoot this one. Any suggestions would be greatly appriceated. [IMAGE:755]

Payroll did a void on a payment but posted to the wrong year (2015 vs 2014). Is there a way we can correct this When trying to 'reopen' the void thru PR85 we received the message 'cannot reopen; reversal has been closed'. Has anyone else ran into this and been able to correct

I am searching for a sales tax partner for Lawson S3. Please provide recommendations.

Our Finance department is asking for a report to reconcile the General Ledger PO Receipt Accrual account. The report must compare Inventory Control data for RNI against AP invoiced items, similar to the PO135, so that the AP dept and Materials dept can work the exceptions and close the open receipts. Does anyone have anything or know of any Lawson canned reports that would help them accomplish this

I am looking for advice on creating a processflow for invoice approval. I envision using process flow for invoice header and some cases line item approval routed to different departments. I would like to utilize department number for the filter category for the inbasket records. I have not seen anywhere we can associate department number on an invoice. We do incorporate department number in our accounting units so we could use that. If anyone has any advice or sample flows to share I would ...

Our fixed asset person is out on medical leave and we don't have contact with her. If I recall, if we need to add to an asset already placed in service, via AM20.3, then this will not show up on an asset addition report. Is this correct Is there a way to rectify this For rollfward and reconciling purposes and for year-end audit, it is much cleaner if this adjustment/addition shows as a current year addition. Thanks for your help.