Search this forum:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 8 << < 12345 > >>
 Last Post
0 Replies and 722 Views Allocations  722  0 Started by  Ruma Malhotra 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.
0 722
11/04/2014 11:44 AM
6 Replies and 3329 Views ACH and EDI  3329  6 Started by  JonA 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
6 3329
by  jj2020Jump to last post
10/31/2014 11:03 AM
0 Replies and 843 Views Invoice entry AP20.2 Discounts AP22.3  843  0 Started by  chatt 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...
0 843
10/23/2014 5:06 PM
7 Replies and 1527 Views Asset Management with 2 books??  1527  7 Started by  maluhia1979 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 ...
7 1527
by  jjcyeshuaJump to last post
10/22/2014 3:48 PM
2 Replies and 2112 Views Lawson Depreciation Reports  2112  2 Started by  JFutrelle Hey guys, I'm rather new to Lawson. We're running version 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...
2 2112
by  jjcyeshuaJump to last post
10/20/2014 4:00 PM
0 Replies and 570 Views GM System control  570  0 Started by  whitey1287 Is there a GM system control closing job Similar to the other closing jobs
0 570
10/13/2014 11:40 AM
0 Replies and 713 Views Intercompany Relationships  713  0 Started by  Russ M Looking for a suggestion on creating a relationship between two companies in Lawson where an intercompany entry in the GL40 is not require. The scenario would play out like this: Company nbr 1 orders product from company nbr 2. Co nbr 1 bills co nbr 2. There is no payment out the door, instead the dollars would pass from one co to another in the GL. Everytime I walk through the scenario, everything works until co nbr 2 tries to pay nbr 1.
0 713
10/03/2014 2:11 PM
0 Replies and 706 Views Foreign Vendors and 1042S Reporting  706  0 Started by  JenDavis We are looking for insight on how other organizations are handling the withholding section in Lawson. Also, how are you processing/tracking foreign payments and issuing 1042S We were told Lawson doesn't support 1042S and just wanted to discuss how others might be adjusting that that.
0 706
10/03/2014 11:00 AM
1 Replies and 981 Views Invoices in AP36  981  1 Started by  Ruma Malhotra We have a process by which we are feeding invoices from external systems into AP36. These invoices are released but have not been approved to be paid. Once they are in AP36 the AP person has to approve the invoice and add the image using onbase before it gets paid. We have had a situation last wekk that about 5k invoices were randomly approved to pay and left AP36 without the AP processor looking at the invoice. We checked into the tables if someone would have accidentally done this but it do...
1 981
by  darwin collinsJump to last post
10/02/2014 9:24 AM
7 Replies and 4277 Views Balance Sheet Report  4277  7 Started by  Deleted User I am new to Lawson&160; but knows Crystal Reporting.&160; I was asked to create a balance sheet report that contains current and prior year balances.&160; I am not familiar with the General Ledger tables.&160; Can someone get me started on which tables to use to create this report
7 4277
by  AliseJump to last post
09/23/2014 3:37 PM
1 Replies and 1300 Views Accounts Payable Invoice Automation Invoice Scanning  1300  1 Started by  Jack Peters My company is considering implementing Accounts Payable Invoice Automation and I'm wondering if anyone has experience with the scanning side of the process. We use Kofax currently as our scanning solution for other apps and could concievably start with that, but I simply don't know what would be required. Any shared experience would be greatly appreciated!
1 1300
by  Any ideas?Jump to last post
09/09/2014 11:24 AM
0 Replies and 866 Views Load AP161 with Separate Payment & Remit to Document Express  866  0 Started by  Bob Canham We are working on implementing Wells Fargo SPS solution for healthcare vendor electronic payments. The process uses the remit file of the AP161 only, so we have our cash code set up to do a separate payment and remittance file. For our own records, we would like to be able to have a human readable copy of the payment to attach to the invoice for archiving. We use Document Express for check printing today, and it does a good job importing the AP161 as long as the Payment and Remittance are com...
0 866
09/09/2014 9:51 AM
0 Replies and 753 Views Changing Fiscal Year-end Date  753  0 Started by  mmcgOmaha We have been instructed to change the year-end of a small associate company from 6/30 to 12/31. That means that the current period will be 'stub' period. Our understanding is that all history will convert to years ending 12/31. That would make it difficult to reproduce any financial statements for the 12 months 7/1/13 to 6/30/14 without actually doing the math to add and subtract from years ending 12/31. How do others handle the transition
0 753
09/04/2014 12:20 PM
0 Replies and 769 Views How people track Customer Comments In AR?  769  0 Started by  mrw562 Based on the information I am finding Lawson AR does not have a dynamic area to track comments on customer accounts. Does anyone have or is aware of a method to track customer comments obtained by AR reps in Lawson Preferably they would like to be able to pull up all previous comments and add additional comments/status comments up to 140 characters. Anyone else have this issue Or previously performed a customization
0 769
08/26/2014 5:27 PM
1 Replies and 666 Views Prenotification without processing via alternative method  666  1 Started by  Nikki W We would like to submit prenotifications to the bank without cutting checks for invoices that we pulled into Lawson via AP520. We want to wait until the account is verified by the bank and then allow payment. Is there a flag that would allow us to do this on the vendor setup
1 666
by  Mark F. HardyJump to last post
08/26/2014 10:23 AM
0 Replies and 683 Views Tax Reports/Queries by Accounting Unit???  683  0 Started by  Bill Does anyone run a report or a query to attach the Accounting Unit/ Cost Center to a Tax Code and Amount One of our companies that we just added has reporting requirements for additional Use Tax to be reported by County. Only way we are able to do this is if we can tie the AU/CC back to the Distribution Lines with Tax Codes used. I have not been able to find a relation in any of the tables to get this done. Anyone else run into this issue
0 683
08/19/2014 1:28 PM
1 Replies and 775 Views Override Base Zone on JE Header  775  1 Started by  DennisM I'm attempting to determine why any one would ever want to override a Company's Base Zone on a JE Header (GL40.2). Infor provides the functionality, but why would any one wish to perform this action. What would be gained... What would be some of the reasons for doing this... it seems to me it might increase difficulty with elimination entries at month-end. I'm just looking for rationale and/or reasons for ever wanting to override the base zone on a JE Header...
1 775
by  BShortJump to last post
08/19/2014 12:27 PM
2 Replies and 896 Views APINVOICE: MATCH_STATUS and MTCH_ERR_TYPE  896  2 Started by  JonA Can anyone shed some light on what each code number means for... MATCH_STATUS 0 = 1 = 2 = 3 = 4 = 5 = MTCH_ERR_TYPE 0 = 1 = 2 = 3 = 4 = Any others
2 896
by  JonAJump to last post
08/18/2014 11:54 AM
1 Replies and 841 Views Cannot delete non-GL journal entries GL45  841  1 Started by  Ariel I am trying to delete some old entries that are lingering in GL45. However, I am unable to delete those Journal Entries that are in an unreleased state. The error message that I receive is: 'Cannot delete non-GL journal entries'. Any insight on this is much appreciated. I've been carrying stuff forward for years now and would just like to get it out of there. Thanks, -Ariel
1 841
by  Ragu RaghavanJump to last post
08/14/2014 11:32 AM
3 Replies and 4976 Views Recurring Journal Entries  4976  3 Started by  Deleted User I have several recurring journal entries that were set up as automatic zero but post the previous month amounts and have the release status. These entries were than interface to the general ledger and are now posted. Is there an easier way to fix these entries without having to upload or key in the entire entry over I try to copy the entries but since they were set up as automatic zero they have no dollar amounts.
3 4976
by  dcaianiJump to last post
08/07/2014 1:36 PM
10 Replies and 9143 Views How to Upload Journal Entries  9143  10 Started by  rsq2_15 Hello, I'm relatively new to Lawson.&160; I've been using it now for six months.&160; During our budget process, I learned to use the Excel addin to upload account information into FB20.&160; This made things MUCH easier and faster.&160; I know there has to be a way to upload monthly journal entries but I haven't figured out how to do it.&160; Can someone point me toward a good resource for learning how to upload entries into the General Ledger (GL) as well as Recurring Journal (RJ) areas&...
10 9143
by  John HenleyJump to last post
07/24/2014 1:54 PM
3 Replies and 632 Views AC20.4_Activity Budget by Activity  632  3 Started by  whitey1287 Hi, In AC20.4 I have a budget of $20,000 in the amount fields, but next to Total Cost Budget Amount the total is $40,000. Any guidance on this issue is greatly appreciated. Thanks!
3 632
by  whitey1287Jump to last post
07/24/2014 12:22 PM
3 Replies and 1261 Views Cash Book Poor Performance  1261  3 Started by  SteveB Is anyone else experiencing very slow Cash Book performance When users run single line reconciliations, it takes 2 minutes for the process to complete. But when users try to do multiple lines, the process times out in Smart Office and Portal (multiple lines can be successfully processed using LID). We have opened a case with Infor and they had us rebuild indexes on CBTRANS and CBCONSOL which did not solve the issue. To resolve the time out issue, Infor had us increase the read/write time...
3 1261
by  John HenleyJump to last post
07/17/2014 2:46 PM
1 Replies and 1339 Views PA52.1  1339  1 Started by  whitey1287 I am trying to change an activity in PA52.1 -> Selected Items 2 tab. But, I am getting the error message, 'account unit not defined within range for activity.' I have checked AC07 to ensure everything is accurate, but still get the error. Any guidance on this issue is greatly appreciated. Thanks!
1 1339
by  Jason BeardJump to last post
07/16/2014 9:03 PM
6 Replies and 1320 Views Add Image Link in AP150 Output  1320  6 Started by  Giulia We use Image Express by MHC to scan and store all of our AP Invoices. We would like to add a link/hyperlink to the AP150 output report so that a user can see the scanned image when they click on an invoice number in the report. I have been trying to figure out a way to do this via Smart Reports Designer but have been unsuccessful. Has anybody else been able to do this either through Smart Reports Designer, or through any other approach. Or has anybody been successful in re-creating the AP150 out...
6 1320
by  GiuliaJump to last post
07/15/2014 9:27 AM
3 Replies and 1012 Views Tax Codes and Imaging Solution into AP20.2  1012  3 Started by  Bill We are using Perceptive's ImageNow to scan our AP Invoices and add our financial accounting information. We have been a non-profit entity until our recent acquisition of some practices that are for profit. That being said we are having issues with trying to get the proper information to flow into Lawson AP20.2. Does anyone else have this in their world and could offer any tips Thanks!
3 1012
by  BillJump to last post
07/11/2014 10:46 AM
4 Replies and 11861 Views Patient Refund .CSV file  11861  4 Started by  Deleted User I have been tasked with providing Vendor= Epic with the field mapping for Patient Refund processing. I believe I need the APCINVOICE, APCDISTRIB, & APCPAYMENT tables - but, am not sure the best route to go for figuring out the proper mappings. They (Epic) did provide me with a Standard Extract guide, but was hoping someone could offer some advice
4 11861
by  John HenleyJump to last post
07/07/2014 2:12 PM
2 Replies and 890 Views GL190 - (GL190.prt) modify sort order  890  2 Started by  Tom When I run a GL190 journal posting, I would prefer that the journal posting report (GL190.prt) sort in Company order (it appears the current primary sort is by company but the company numbers are out of order). Can the sort order of the journal posting report (GL190.prt) be modified and, if so, where would that be done Thank you.
2 890
by  TomJump to last post
07/01/2014 3:05 PM
2 Replies and 1270 Views GL20.2  1270  2 Started by  whitey1287 I am trying to update GL20.2 via Add-ins. In the upload I have as my headers: 1._f2:GLN-COMPANY 2._f3:GLN-ACCT-UNIT 3. _f6:GDT-ACCOUNT 4.Sub 5._f1:FC 6._f1:More 7._f29:GLM-ACTIVITY-REQ 8._f33:GLM-ACCT-CAT When I run the upload on thr first row as a test, the result is 'cannot add/delete/change blank detail lines,' but I have each field filled. Any help on what I am doing wrong is very much appreciated. Thanks
2 1270
by  whitey1287Jump to last post
06/19/2014 3:00 PM
0 Replies and 613 Views Lines in MA43  613  0 Started by  BenignVanilla I am looking for documentation on the MA43 screens, and the process of adding line items. Can anyone point me towards a user guide on this process I am trying to debug a process that is adding invoices via AP20, and line items via MA43. We are seeing a condition where the AP20 works fine, the MA43.1 works fine, but when we look at the AP20, the goods amount is twice the invoice amount, even if a single line item exists for the proper amount. When I drill around into the invoice lines, the line ...
0 613
06/16/2014 2:39 PM
4 Replies and 1045 Views Using a WellsFargo Commercial Card in AP  1045  4 Started by  LeslieP The bank wants us to submit a file that can include ACH, Checks and C-Card payments. The file can be either processed immediately or the various parts manipulated in their CEO module. AP161 has some of the information but not all and would require major re-working. Which I can do. But I don't have a test system to play with so I am going to have to test on prod...or build a new productline to test with. Neither of which are appealing. I am considering running the payments through like an...
4 1045
by  Greg MoellerJump to last post
06/04/2014 2:51 PM
0 Replies and 2365 Views Report Writer Training Manual  2365  0 Started by  Vince Does anyone know of a link to a copy of the Lawson Report Writing training manual I Have been out of Lawson for many years and need to refresh my memory. The user guide is not much help.
0 2365
06/02/2014 4:37 PM
3 Replies and 1628 Views Asset Mgmt partial disposal  1628  3 Started by  Diane G 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
3 1628
by  JRC3769Jump to last post
05/13/2014 1:00 PM
0 Replies and 748 Views Adding additional costs to assets after placed in service  748  0 Started by  erical77 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.
0 748
05/05/2014 9:04 AM
9 Replies and 1170 Views ESS Pay  1170  9 Started by  bernfc10 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. &91;IMAGE:755&93;
9 1170
by  bernfc10Jump to last post
05/02/2014 10:17 AM
2 Replies and 1061 Views Invoice Approval using ProcessFlow  1061  2 Started by  Ollerton 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 ...
2 1061
by  OllertonJump to last post
04/30/2014 10:48 PM
2 Replies and 1130 Views Reconcile Received not invoiced between IC and AP  1130  2 Started by  Mary Porter 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
2 1130
by  DaveJump to last post
04/30/2014 7:18 PM
0 Replies and 687 Views sales tax partner  687  0 Started by  tdwcpa I am searching for a sales tax partner for Lawson S3. Please provide recommendations.
0 687
04/22/2014 8:24 PM
0 Replies and 752 Views PR85 - reopen void  752  0 Started by  StacyR 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
0 752
04/22/2014 10:14 AM
1 Replies and 786 Views Location of GL40.1 attachment comment text  786  1 Started by  Donna What table contains the field that contains the journal entry attachment comments which can be entered in GL40, GL41 or GL45
1 786
by  DonnaJump to last post
04/16/2014 10:52 AM
2 Replies and 1180 Views GL199 Company Values changing  1180  2 Started by  Austin 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...
2 1180
by  AustinJump to last post
04/15/2014 2:46 PM
0 Replies and 593 Views Activity Group POP- RNI Interface  593  0 Started by  Ian 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...
0 593
04/09/2014 2:30 PM
0 Replies and 620 Views BR120/130 not balancing  620  0 Started by  Basia Has anyone turned burden calculations on and by turning them on, did it throw off your BR120 and BR130 balance
0 620
04/09/2014 1:51 PM
1 Replies and 1272 Views Using MS Excel Database Connection Wizard  1272  1 Started by  Michael Ewing 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...
1 1272
by  AriJump to last post
04/07/2014 4:51 PM
1 Replies and 726 Views AR20 batch processed under wrong process level  726  1 Started by  Basia 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.
1 726
by  BasiaJump to last post
03/28/2014 2:40 PM
3 Replies and 2453 Views GL90 csv export name  2453  3 Started by  Mark S 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...).
3 2453
by  DebbieKJump to last post
03/27/2014 1:49 PM
4 Replies and 2153 Views DIFFERENCE B/W COST CENTER AND ACCOUNTING UNIT  2153  4 Started by  batmanprime Hello, I am new to Lawson , can anyone tell me what is DIFFERENCE Between COST CENTER AND ACCOUNTING UNIT
4 2153
by  Kat VJump to last post
03/24/2014 10:44 AM
0 Replies and 459 Views Discount with no Net Due  459  0 Started by  Bill 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
0 459
03/20/2014 7:54 AM
2 Replies and 869 Views GL double posting LP accruals  869  2 Started by  bernfc10 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
2 869
by  bernfc10Jump to last post
03/11/2014 1:02 PM
0 Replies and 1109 Views CB185 Cash code not found for bank  1109  0 Started by  Billy Andrews 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...
0 1109
02/27/2014 2:28 PM
2 Replies and 910 Views Employer Medical Insurance Costs posted to GL  910  2 Started by  scuba80 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.
2 910
by  scuba80Jump to last post
02/26/2014 3:40 PM
0 Replies and 1160 Views Open Payables Report  1160  0 Started by  AP Clerk 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...
0 1160
02/22/2014 1:25 PM
0 Replies and 804 Views AP240  804  0 Started by  AP Clerk 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
0 804
02/22/2014 1:20 PM
2 Replies and 984 Views Best Practices for tracking Discounts on Purchase Orders  984  2 Started by  Margaret 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
2 984
by  Kat VJump to last post
02/19/2014 3:58 PM
0 Replies and 1830 Views Journal Entry Data dump  1830  0 Started by  MarirajSankar 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...
0 1830
02/19/2014 3:36 PM
2 Replies and 1339 Views Uploading Assets into Lawson Asset Management  1339  2 Started by  Ash 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...
2 1339
by  AshJump to last post
02/19/2014 1:29 PM
2 Replies and 887 Views Nee help figuring out activity structure  887  2 Started by  Basia 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!
2 887
by  BasiaJump to last post
02/19/2014 8:51 AM
1 Replies and 1047 Views PO20.1  1047  1 Started by  MChism Hey guys! I need help again, I am attempting to add a special item into a purchase order. I have done this on several occasions and have never had any issues. Now it is telling me that I can not add the item for this reason: 'Vendor Agreement and/or payment terms cannot be combined'. Does anyone know why it is throwing this error or how to fix it ~~~I have attached a screen shot of the error message. ~~~
1 1047
by  Kat VJump to last post
02/14/2014 1:29 PM
3 Replies and 1461 Views Open A/P Invoices  1461  3 Started by  martyzoet How do I get a list of all open A/P invoices that were open as of a certain date
3 1461
by  BShortJump to last post
02/11/2014 7:54 AM
2 Replies and 1181 Views Lawson Financials S3 Archive/Purge Solutions?  1181  2 Started by  R. Lapierre We are currently looking for a Lawson Third Party Vendor Product with Financials S3 Archive/Purge Solutions We are currently looking at the NTTDATA's 'PARCr2' and Absolute's 'Archive.S3' Product Solutions. Are there any other third party products out there for the Lawson S3 Financial Suite Thank you, Ron Lapierre
2 1181
by  R. LapierreJump to last post
02/07/2014 3:25 PM
0 Replies and 806 Views GL190 journal posting sort order  806  0 Started by  Tom When I run a GL190 journal posting, I would prefer that the journal posting report (GL190.prt) sort in Company order (it appears the current primary sort is by company but the company numbers are out of order). Can the sort order of the journal posting report be modified and, if so, where would that be done Thank you.
0 806
02/03/2014 4:22 PM
1 Replies and 3010 Views Functional user manuals for V 9.0.1  3010  1 Started by  wanda2013 Does anyone know where i can get functional manuals for S3 version 9.0.1 I mean functional user manuals, not the official Lawson user guide (with about 500 sheets ...) I need to provide training regarding Lawson S3 Financial Suite (AP, AR, AM, CB and GL). I have it in a week and i have no time to make them!! :(
1 3010
by  JimYJump to last post
02/02/2014 5:23 PM
1 Replies and 2132 Views AM 255 Depreciation Projection  2132  1 Started by  Boyd Earlier this year we upgraded to v 9.0.&160; In the old version of Lawson 8.03 I&160;was able to export the AM 255 to excel and you would see the information as it appeared on the PDF report.&160; In version 9.0 the projection information is summarized by year for each asset.&160; Does anyone konw how to change this.&160; I also tried to change the flag on Assets in Other Output options to 'D' Detail, but this exported the informaiton by month into three different columns.
1 2132
by  EllenPJump to last post
01/27/2014 4:10 PM
4 Replies and 3046 Views Too Many Decimals  3046  4 Started by  MChism We have a few vendors that use half quantities when ordering. For example an order of envelopes comes in a box of 2,500 we use the UOM of 'M' and typically enter the order for 2.5. Recently we are having issues with Lawson not allowing us to use decimals giving the error message 'too many decimals entered'. Is there a way to fix this We are now trying to match invoices to the PO's and obviously they are not matching becuase the PO will show 2M and the invoice will show 2.5M. Any help would be g...
4 3046
by  MChismJump to last post
01/23/2014 12:30 PM
0 Replies and 700 Views Financial Roll reporting  700  0 Started by  Randy Not sure if this belongs here or LBI. Has anyone had success customing reports that would whow accounting unit summary at highest level, then the next levels downward I'm thinking the dbo.GLCONSOL table would be a start, but wonder if anyone has completed this and how
0 700
01/13/2014 3:49 PM
10 Replies and 11961 Views Budget Upload  11961  10 Started by  jjcyeshua Hello!... lawson people.... I'm in the process of uploading a budget from excel spreadsheet to FBDETAIL, but i can't seem to find the form that would let me add new budget. Knowledge Search in says that i have to use budget interface to convert the new budget data that i have, but when i access FB165 its only generating report. Where should i start the process of uploading the budget and how.. Thanks again in advance
10 11961
by  TesterJump to last post
01/07/2014 4:13 PM
5 Replies and 1930 Views PO230 Error  1930  5 Started by  MChism Each month before month end we run a few jobs to make sure month end goes smoothly. One of those reports is a PO230 report (Unreleased Receiving List). This month we have 5 PO's show up. From the notes that I can find the way to clear them is by going into PO30 and 'release and print' however when I do that it tells me that 'receiver has no line; cannot release'. I have no idea what needs to happen for these items to get cleared before month end. Any insight would be great!
5 1930
by  JonAJump to last post
12/27/2013 3:43 PM
4 Replies and 1058 Views Asset Transfer Load in AM30.1  1058  4 Started by  Ian HI, I have 2000 assets that need to be moved from Account Unit to another within the same company with Asset Management. I am on Lawson 9.1. I have tried to upload into the AM30.1 screen but I am getting the message 'Asset type does not exist'. I know for sure that the asset Type does exist. Has anyone had issues with this before and can you give me insight into where I am going wrong Your help is very much appreciated.
4 1058
by  IanJump to last post
12/23/2013 11:51 AM
5 Replies and 2685 Views Defaulted Payment Terms  2685  5 Started by  Deleted User When entering an invoice in AP20.1 can the default vendor payment terms populate in the pmt terms field when the Vendor is selected Otherwise you have to drill into the vendor number and find out what the default is to know it you need to change it in the AP20 field. Our Data Entry staff would like to know if the field can auto populate from the vendor record.
5 2685
by  dcaianiJump to last post
12/17/2013 8:30 AM
4 Replies and 1048 Views Company Status = Test  1048  4 Started by  Kelly Hello! This is my first post on this forum so go easy on me! :) We are on v9.0.1 and I need to create a new company (which I might be able to copy from another). I first have to check to see if the same AUs are going to be used. I'd rather not copy them over with the company copy and then inactivate them in the new company. This new company will use system codes: GL, AP, CB and RJ. If the company is designated as Test status, is there anyway to truly test the subsystems posting to the GL...
4 1048
by  DeronJump to last post
12/12/2013 3:40 PM
1 Replies and 912 Views AR/BL from Lab Software to interface w Lawson  912  1 Started by  This_Guy Hi There - We have a Lab Application that will be interfacing with the Lawson Billing for all Client Lab Charges. I see the bL520 out there and will probably look to use this for replacing the manual efforts. However, the problem I am running into is the 'Fee Schedule' per Lab Test. For example, Customer 1234 takes Blood Test Ab123 that fee is $30/test - but, the same test AB123 is taken by Customer 6789 and that fee is $50/test. This presents the problem, so does anyone out there have a sim...
1 912
by  Ken UJump to last post
12/10/2013 6:13 PM
0 Replies and 823 Views LPA/IPA naming standards  823  0 Started by  Erin We have Interfaces that start with an assigned interface number (e.g. I114APInterface). Subsequent IPAs that are from called within the main IPA are named free-form (e.g. APControlReport, APMatrixReport, APVendorList) This makes it difficult to know by site what triggers or relates to what without checking out the IPA and review or having a reference doc. Anyone care to weigh in on the plusses and minuses of naming For example, if the above I114APInterface runs and you see APControlRe...
0 823
12/06/2013 4:54 PM
0 Replies and 698 Views Invoice Matching Workfile Cleanup  698  0 Started by  Sandy L We are running Lawson Financial version 9.0 on an IBM I. There is a work file, MATPRLWR that is now almost 10 GB with 936 members. I would like to remove the majority of these members but I am not sure if it will hurt anything else or if perhaps there is a menu option within Lawson that I could run to clean up this file.
0 698
12/04/2013 8:03 AM
0 Replies and 1334 Views Death notice of LACOBRTS  1334  0 Started by  National Trust for Historic Preservation Mon Dec 2 11:22:15 2013: ERROR: Exited with error code 1 Ɖ“…ÓÁæÁ××ùaÁÙ×èÔÕãÈÄÙKƉ•„ÄÂÙ…ƒ…™™–™‰¢Ä£‚¢……™™–™Mùô&93;KÁ„„‰£‰–•“ã…§£‰¢zƉ•„☓مƒM“¦——ù„‚KÄÂÁÙÁ×Èkð&93;ÄÂòÆÁãÁÓÅÙÙÖÙ†–™âØÓŧ…ƒ¤£…`Ö„…zõõðñùa`÷ððøÄÂÁÙÁ×ȉ•ÓÁæÁ××ùÄ•–£¥“‰„†–™–—…™£‰–•KÉÕÆÖÙÔÁãÉÖÕÆÙÖÔãÈÅÓÁãÔKÓÖÇcTPCrash): Received death notification of lacobrts, Uid=14, Pid=719239 Mon Dec 2 11:22:15 2013: Program Code = AR21 , DataArea/DataID = LAWAPP9 Mon Dec 2 ...
0 1334
12/02/2013 12:55 PM
2 Replies and 838 Views Remove a displayed benefit in the add beneificiaries ESS  838  2 Started by  Deleted User I have never worked with Employee Self Service; can I remove one of the displayed benefits from the Beneficiaries display. We do not want employees to be able to add beneficiaries to one of the defined benefits. Thank you if you can help.
2 838
by  LisaJump to last post
11/25/2013 4:46 PM
1 Replies and 752 Views AP155 Payer Address on File  752  1 Started by  Jeremy When running the AP155, can you make it include the payer's address also or does that have to be coded into whatever software (such as MHC) you use to print the checks
1 752
by  JeremyJump to last post
11/20/2013 4:55 PM
3 Replies and 715 Views Online Entries & Interface Source  715  3 Started by  Erin We are using the R_DESC column 'Interface Transaction' to tell us if an invoice was entered online or through an interface. Now we need to determine what external systems are sending in the invoices. Is there a way to determine which system e.g. Billing is sending the interface transaction
3 715
by  John HenleyJump to last post
11/15/2013 12:28 PM
3 Replies and 5219 Views Infor’s Lawson Accounts Payable Invoice Automation system  5219  3 Started by  DougAB I'm curious to know if anyone uses Infor’s Lawson Accounts Payable Invoice Automation system, or any invoice automated system. We deal with many suppliers that send their invoices via EDI, email, and csv files. We want a way to flow these invoices into Lawson and automate the matching process. We'd deal with the fallouts thereafter. Any help is appreciated. Thanks.
3 5219
by  John HenleyJump to last post
11/08/2013 1:07 PM
1 Replies and 1253 Views AP520 and One Time Vendor  1253  1 Started by  jbertoli We would like to upload stipend type of AP invoices. We want to give them the same invoice number (like XXX Stipend) and use the One Time Vendor flag so it will create vendor numbers. Has anyone done this
1 1253
by  brainetJump to last post
11/01/2013 9:22 AM
2 Replies and 710 Views Employer Issued Credit Cards - Where Maintained  710  2 Started by  BradF Is there anyone who does this
2 710
by  Greg MoellerJump to last post
10/31/2013 8:55 AM
8 Replies and 2112 Views Loading Fixed Assets into Lawson AM  2112  8 Started by  Ian I am trying to load new assets from a legacy system into Lawson AM. I have uploaded the assets into the system using AM96.1 (AMASSET), AM97.1(AMASTITEM) and AM98.1 (AMASTBOOK). Everything uploaded successfully. However, When I progress to process then using AM500 I get the following message in my report. 'Conversion nbr exists in AMCNVASSET file, use AM300 to purge' At this point I have run it in non-update mode. Can anyone tell me what this means before I proceed any further It appies...
8 2112
by  Bob CanhamJump to last post
10/24/2013 2:34 PM
1 Replies and 943 Views Converted Assets Not Calculating Depreciation  943  1 Started by  Joanna We are in the process of converting our fixed assets into Lawson. We uploaded the data to populate AM 96, AM97 and AM98. We then ran AM500 and AM170. After that, we ran the AM580 and depreciation is not calculating. Any ideas what to look for
1 943
by  IanJump to last post
10/23/2013 6:04 PM
1 Replies and 826 Views Restricted Funds  826  1 Started by  Vince In the past I have worked at a place that ran all restricted fund transactions through an account (net Assets) on the balance sheet. Now at a place installing Lawson and the cosultant wants transactions through a cost center in the P&L. What do others do I would prefer all through balance sheet.
1 826
by  Bob CanhamJump to last post
10/22/2013 12:14 PM
0 Replies and 713 Views Audit Data? EFT/Banking Information in AR  713  0 Started by  Garth Gerwing There are multiple UI's in the AR module requied to be used to define and maintain EFT-related data: - AR09.2 - Banks - updates table DTCUSTBANK - AR09.6 - EFT - updates table DTCUSTBANK - AR09.5 - EFT Notification - updates table FTCUSTNOTE -------------------------------- However - there appears to be no auditing, by the application, of users having added or maintained this sensitive data (confirmed by Lawson Engineers). The only AR auditing appears to...
0 713
10/21/2013 3:04 PM
0 Replies and 1134 Views Cost Allocation  1134  0 Started by  SN Hi, I am new to the cost allocation module and I need help to understand CA and its links to FB and GL module. I currently have an issue where the amounts for certain AU-Account-sub account combination have values where some combination dont. As far as my understanding goes, once CA110 is run, the cost is allocated according to the mentioned allocations in CA10. Once CA190 is executed the values then moved to GL. Question: What are the sources from where CA110 is getting its input v...
0 1134
10/21/2013 12:25 PM
0 Replies and 613 Views Merging Summary Accounts  613  0 Started by  Dixon How do you merge summary accounts in mass efficiently, without going through the painstaking process of moving accounts individually account by account. Some of our summary accounts have a large number of individual GL accounts within them, and we'd like to merge them into one summary account. Thank you.
0 613
10/14/2013 5:35 PM
0 Replies and 996 Views Adding a new Data Area tonight  996  0 Started by  Nathan E We are adding a new data area to the production product line tonight. We are working with a very experienced consultant to do the work with us but I wanted to see if any of you had been through this and have any lessons learned you'd like to pass on. Things to look out for Pre-game preparations Post-create procedures Backstory: HR wants to create a new data area and make a copy of Production so they can use it as a historical archive. Create it, copy the data, secure it and lock it from c...
0 996
10/14/2013 2:02 PM
5 Replies and 1103 Views What Lawson form??  1103  5 Started by  Bev Edwards We have moved to LS9 Security (no more laua). Most of the forms we had access to were removed and now we are piece mealing them back. My director used to have access to an AP form that provided a snap shot of all AP Vendor payments. He also said he was able to compare one fiscal year to another using this form, but cannot remember which one it was. Our IT department is also not able to tell us. We looked in the Excel Add in list since that is our only window to all Lawson forms under eve...
5 1103
by  Greg MoellerJump to last post
10/11/2013 3:27 PM
2 Replies and 1158 Views List of forms to change GL information - Changing GL  1158  2 Started by  Ollerton We are redesigning our GL in Lawson. Does anyone have a list of forms we need to change to update our GL Like HR11, AC07, etc. Thanks, Jim Ollerton
2 1158
by  OllertonJump to last post
10/09/2013 4:38 PM
2 Replies and 1313 Views Managing GL,AP, AR interface fallouts  1313  2 Started by  DougAB We are interfacing transactions over from our OMS system to Lawson every 5 mins. There, of course, will be fallouts from either the importdb's or the interface programs themselves - AR550, AR560, AP510, AP520 and GL165. We are planning to gather all of the log files (.prt's) that have errors in them and put them in a central repository so we can easily identify the issue and resolve them. Couple of questions here: 1) are the output files from either the importdb's or the interface progr...
2 1313
by  John HenleyJump to last post
10/03/2013 5:04 PM
9 Replies and 1138 Views How to tell if a job posted successfully i.e. GL165  1138  9 Started by  Frank I am trying to find out if a user for example runs GL165 in update mode, that it posted successfully I can't seem to find any information like this Thanks Frank
9 1138
by  Greg MoellerJump to last post
10/03/2013 4:43 PM
1 Replies and 798 Views Track new accounts or new accounting units created during a period of time  798  1 Started by  Anna Tian Hi, Everyone, We are asked to provide a list of new accounts & new accounting units created during a period of time. However, we do not have auditing features turned on. Is there any way to obtain this list without the auditing feature Does Lawson stores creation date or update date for Accounts/Accounting units in any tables (other than auditing tables) Also, I would like to know if you do not have auditing features turned on, do you use any controls to track creation or changes of new ...
1 798
by  Anna TianJump to last post
10/02/2013 2:18 PM
1 Replies and 941 Views Audit for Activities  941  1 Started by  Lynne Hi, We are trying to see if the budget amount on an activity was changed. Is there an audit table for activities I have been unable to find any history. I looked at GL01.4 and when I select the AC line, the 'Audit' button does not display. We are on 9.0.1. Thanks!
1 941
by  LynneJump to last post
09/30/2013 7:57 AM
1 Replies and 1142 Views MA540 Vendor Payment Terms v. AP10 Vendor Payment Terms  1142  1 Started by  Shannon R Has anyone else run across this We use GHX for our MA540 files. On one specific vendor, the payment terms coming in through MA540 (payment terms are N30) are over-riding the Vendor Terms set up in AP10 for that specific vendor (N1). We need to pay this vendor at N1. We manually have to go change the date on each invoice or all of the invoices pay late. I can ask the vendor to change the terms on our account to N1, but this doesn't solve the root problem. Why is the MA540 file data over-...
1 1142
by  JonAJump to last post
09/24/2013 9:23 AM
1 Replies and 958 Views GLTRANS field acct_amount  958  1 Started by  SN Hi, Please help me understand where does the acct-amount from gltrans get its value from. also shouldn't base-amount and acct-amount have same values I have 2-3 scenarios where the base amount doesn't equal to the acct-amount.
1 958
by  SNJump to last post
09/21/2013 9:47 PM
15 Replies and 10658 Views EDI 810 Invoices  10658  15 Started by  Deleted User Hi, Anyone have any tips and lessons learned about interfacing drop ship or expense type invoices into MA540 An example would be pharmacy, food, or office suppies. We're in healthcare and use O&M and GHX EDI 810s for for inventory, non-stocks and specials. We are looking for ways to take the data entry load off our AP staff for non receiving type purchase orders. Please post or e-mail to Looking forward to networking with you.
15 10658
by  Shannon RJump to last post
09/20/2013 10:07 AM
0 Replies and 699 Views Merging with another company  699  0 Started by  Brenda We are merging with another company and need to come up with a way that we can report as company X up until the merger and as company Y the day after the merger. We do not yet know if we will be staying with Lawson or moving to the finanical system they have, right now we just need to figure out a way to have a clean cut off between the two companies and report as Y company going forward. We currently have 23 active companies and we have subsystems and external systems that interface into our ...
0 699
09/18/2013 5:11 PM
3 Replies and 1783 Views Vendor Mergers and Acquisitions  1783  3 Started by  JonA How are vendor mergers and acquisitions handled within your organization If a vendor with active contracts and POs is acquired by another that is not in your vendor master do you add a new vendor and create new contracts/POs or do you change the name on the existing vendor
3 1783
by  JonAJump to last post
09/06/2013 3:05 PM
4 Replies and 1155 Views Report job to csv  1155  4 Started by  Justin R I have an AR250 job. Is there a way I can automically ouput that as a csv file
4 1155
by  Greg MoellerJump to last post
08/27/2013 1:57 PM
2 Replies and 2036 Views BR120 output, need an invoice in a format readable by Crystal Reports  2036  2 Started by  johne when i run br120 now i get the following viewable output files: BR120.prt ... the report showing what was processed/produced custom5 ... a format of the invoice that uses the tilde (~) character to designate the trailing value; e.g. ~STARTHEADER ~field Invoice Number IN 00000001 00000000 ~field Invoice Date ... ... ~ENDHEADER ... invoice1 ... text version of a printable invoice invoice1.pdf ... pdf version of the invoice i'd like to get an invo...
2 2036
by  BaloyJump to last post
08/27/2013 1:28 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 8 << < 12345 > >>

RSS Feed Available