Search this forum:
Search
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 > >>
Topics
 Replies
 Views
 Last Post
1 Replies and 936 Views ERP Selection  936  1 Started by  GeoffB 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.
1 936
by  alexrsJump to last post
11/18/2014 6:34 AM
0 Replies and 716 Views Staging table for AP comments  716  0 Started by  L G 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
0 716
11/17/2014 10:36 PM
1 Replies and 1080 Views AP14.5 TIN Type Change with Add-Ins  1080  1 Started by  Jeremy 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'
1 1080
by  jjcyeshuaJump to last post
11/13/2014 6:49 PM
2 Replies and 911 Views Writing an Income Statement in crystal  911  2 Started by  Melissa 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...
2 911
by  jjcyeshuaJump to last post
11/12/2014 2:29 PM
5 Replies and 1194 Views Non-AR Backout  1194  5 Started by  whitey1287 Is there anyway to back out a Non-AR payment so the payment can be reapplied directly to the appropriate invoice
5 1194
by  Ken UJump to last post
11/06/2014 2:59 PM
0 Replies and 747 Views Allocations  747  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 747
11/04/2014 11:44 AM
6 Replies and 3428 Views ACH and EDI  3428  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 3428
by  jj2020Jump to last post
10/31/2014 11:03 AM
0 Replies and 876 Views Invoice entry AP20.2 Discounts AP22.3  876  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 876
10/23/2014 5:06 PM
7 Replies and 1568 Views Asset Management with 2 books??  1568  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 1568
by  jjcyeshuaJump to last post
10/22/2014 3:48 PM
2 Replies and 2151 Views Lawson Depreciation Reports  2151  2 Started by  JFutrelle 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...
2 2151
by  jjcyeshuaJump to last post
10/20/2014 4:00 PM
0 Replies and 586 Views GM System control  586  0 Started by  whitey1287 Is there a GM system control closing job Similar to the other closing jobs
0 586
10/13/2014 11:40 AM
0 Replies and 731 Views Intercompany Relationships  731  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 731
10/03/2014 2:11 PM
0 Replies and 734 Views Foreign Vendors and 1042S Reporting  734  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 734
10/03/2014 11:00 AM
1 Replies and 1011 Views Invoices in AP36  1011  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 1011
by  darwin collinsJump to last post
10/02/2014 9:24 AM
7 Replies and 4324 Views Balance Sheet Report  4324  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 4324
by  AliseJump to last post
09/23/2014 3:37 PM
1 Replies and 1337 Views Accounts Payable Invoice Automation Invoice Scanning  1337  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 1337
by  Any ideas?Jump to last post
09/09/2014 11:24 AM
0 Replies and 895 Views Load AP161 with Separate Payment & Remit to Document Express  895  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 895
09/09/2014 9:51 AM
0 Replies and 793 Views Changing Fiscal Year-end Date  793  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 793
09/04/2014 12:20 PM
0 Replies and 795 Views How people track Customer Comments In AR?  795  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 795
08/26/2014 5:27 PM
1 Replies and 704 Views Prenotification without processing via alternative method  704  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 704
by  Mark F. HardyJump to last post
08/26/2014 10:23 AM
0 Replies and 700 Views Tax Reports/Queries by Accounting Unit???  700  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 700
08/19/2014 1:28 PM
1 Replies and 799 Views Override Base Zone on JE Header  799  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 799
by  BShortJump to last post
08/19/2014 12:27 PM
2 Replies and 935 Views APINVOICE: MATCH_STATUS and MTCH_ERR_TYPE  935  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 935
by  JonAJump to last post
08/18/2014 11:54 AM
1 Replies and 870 Views Cannot delete non-GL journal entries GL45  870  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 870
by  Ragu RaghavanJump to last post
08/14/2014 11:32 AM
3 Replies and 5078 Views Recurring Journal Entries  5078  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 5078
by  dcaianiJump to last post
08/07/2014 1:36 PM
10 Replies and 9277 Views How to Upload Journal Entries  9277  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 9277
by  John HenleyJump to last post
07/24/2014 1:54 PM
3 Replies and 668 Views AC20.4_Activity Budget by Activity  668  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 668
by  whitey1287Jump to last post
07/24/2014 12:22 PM
3 Replies and 1303 Views Cash Book Poor Performance  1303  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 1303
by  John HenleyJump to last post
07/17/2014 2:46 PM
1 Replies and 1399 Views PA52.1  1399  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 1399
by  Jason BeardJump to last post
07/16/2014 9:03 PM
6 Replies and 1357 Views Add Image Link in AP150 Output  1357  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 1357
by  GiuliaJump to last post
07/15/2014 9:27 AM
3 Replies and 1039 Views Tax Codes and Imaging Solution into AP20.2  1039  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 1039
by  BillJump to last post
07/11/2014 10:46 AM
4 Replies and 11907 Views Patient Refund .CSV file  11907  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 11907
by  John HenleyJump to last post
07/07/2014 2:12 PM
2 Replies and 919 Views GL190 - (GL190.prt) modify sort order  919  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 919
by  TomJump to last post
07/01/2014 3:05 PM
2 Replies and 1313 Views GL20.2  1313  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 1313
by  whitey1287Jump to last post
06/19/2014 3:00 PM
0 Replies and 638 Views Lines in MA43  638  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 638
06/16/2014 2:39 PM
4 Replies and 1090 Views Using a WellsFargo Commercial Card in AP  1090  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 1090
by  Greg MoellerJump to last post
06/04/2014 2:51 PM
0 Replies and 2442 Views Report Writer Training Manual  2442  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 2442
06/02/2014 4:37 PM
3 Replies and 1662 Views Asset Mgmt partial disposal  1662  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 1662
by  JRC3769Jump to last post
05/13/2014 1:00 PM
0 Replies and 764 Views Adding additional costs to assets after placed in service  764  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 764
05/05/2014 9:04 AM
9 Replies and 1200 Views ESS Pay  1200  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 1200
by  bernfc10Jump to last post
05/02/2014 10:17 AM
2 Replies and 1087 Views Invoice Approval using ProcessFlow  1087  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 1087
by  OllertonJump to last post
04/30/2014 10:48 PM
2 Replies and 1164 Views Reconcile Received not invoiced between IC and AP  1164  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 1164
by  DaveJump to last post
04/30/2014 7:18 PM
0 Replies and 706 Views sales tax partner  706  0 Started by  tdwcpa I am searching for a sales tax partner for Lawson S3. Please provide recommendations.
0 706
04/22/2014 8:24 PM
0 Replies and 771 Views PR85 - reopen void  771  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 771
04/22/2014 10:14 AM
1 Replies and 823 Views Location of GL40.1 attachment comment text  823  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 823
by  DonnaJump to last post
04/16/2014 10:52 AM
2 Replies and 1224 Views GL199 Company Values changing  1224  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 1224
by  AustinJump to last post
04/15/2014 2:46 PM
0 Replies and 619 Views Activity Group POP- RNI Interface  619  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 619
04/09/2014 2:30 PM
0 Replies and 651 Views BR120/130 not balancing  651  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 651
04/09/2014 1:51 PM
1 Replies and 1311 Views Using MS Excel Database Connection Wizard  1311  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 1311
by  AriJump to last post
04/07/2014 4:51 PM
1 Replies and 762 Views AR20 batch processed under wrong process level  762  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 762
by  BasiaJump to last post
03/28/2014 2:40 PM
3 Replies and 2500 Views GL90 csv export name  2500  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 2500
by  DebbieKJump to last post
03/27/2014 1:49 PM
4 Replies and 2253 Views DIFFERENCE B/W COST CENTER AND ACCOUNTING UNIT  2253  4 Started by  batmanprime Hello, I am new to Lawson , can anyone tell me what is DIFFERENCE Between COST CENTER AND ACCOUNTING UNIT
4 2253
by  Kat VJump to last post
03/24/2014 10:44 AM
0 Replies and 481 Views Discount with no Net Due  481  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 481
03/20/2014 7:54 AM
2 Replies and 892 Views GL double posting LP accruals  892  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 892
by  bernfc10Jump to last post
03/11/2014 1:02 PM
0 Replies and 1144 Views CB185 Cash code not found for bank  1144  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 1144
02/27/2014 2:28 PM
2 Replies and 936 Views Employer Medical Insurance Costs posted to GL  936  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 936
by  scuba80Jump to last post
02/26/2014 3:40 PM
0 Replies and 1184 Views Open Payables Report  1184  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 1184
02/22/2014 1:25 PM
0 Replies and 826 Views AP240  826  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 826
02/22/2014 1:20 PM
2 Replies and 1002 Views Best Practices for tracking Discounts on Purchase Orders  1002  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 1002
by  Kat VJump to last post
02/19/2014 3:58 PM
0 Replies and 1853 Views Journal Entry Data dump  1853  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 1853
02/19/2014 3:36 PM
2 Replies and 1374 Views Uploading Assets into Lawson Asset Management  1374  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 1374
by  AshJump to last post
02/19/2014 1:29 PM
2 Replies and 918 Views Nee help figuring out activity structure  918  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 918
by  BasiaJump to last post
02/19/2014 8:51 AM
1 Replies and 1074 Views PO20.1  1074  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 1074
by  Kat VJump to last post
02/14/2014 1:29 PM
3 Replies and 1516 Views Open A/P Invoices  1516  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 1516
by  BShortJump to last post
02/11/2014 7:54 AM
2 Replies and 1207 Views Lawson Financials S3 Archive/Purge Solutions?  1207  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 1207
by  R. LapierreJump to last post
02/07/2014 3:25 PM
0 Replies and 831 Views GL190 journal posting sort order  831  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 831
02/03/2014 4:22 PM
1 Replies and 3128 Views Functional user manuals for V 9.0.1  3128  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 3128
by  JimYJump to last post
02/02/2014 5:23 PM
1 Replies and 2161 Views AM 255 Depreciation Projection  2161  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 2161
by  EllenPJump to last post
01/27/2014 4:10 PM
4 Replies and 3128 Views Too Many Decimals  3128  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 3128
by  MChismJump to last post
01/23/2014 12:30 PM
0 Replies and 719 Views Financial Roll reporting  719  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 719
01/13/2014 3:49 PM
10 Replies and 12000 Views Budget Upload  12000  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 Lawson.com 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 12000
by  TesterJump to last post
01/07/2014 4:13 PM
5 Replies and 1973 Views PO230 Error  1973  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 1973
by  JonAJump to last post
12/27/2013 3:43 PM
4 Replies and 1073 Views Asset Transfer Load in AM30.1  1073  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 1073
by  IanJump to last post
12/23/2013 11:51 AM
5 Replies and 2715 Views Defaulted Payment Terms  2715  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 2715
by  dcaianiJump to last post
12/17/2013 8:30 AM
4 Replies and 1067 Views Company Status = Test  1067  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 1067
by  DeronJump to last post
12/12/2013 3:40 PM
1 Replies and 944 Views AR/BL from Lab Software to interface w Lawson  944  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 944
by  Ken UJump to last post
12/10/2013 6:13 PM
0 Replies and 841 Views LPA/IPA naming standards  841  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 841
12/06/2013 4:54 PM
0 Replies and 721 Views Invoice Matching Workfile Cleanup  721  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 721
12/04/2013 8:03 AM
0 Replies and 1374 Views Death notice of LACOBRTS  1374  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 1374
12/02/2013 12:55 PM
2 Replies and 859 Views Remove a displayed benefit in the add beneificiaries ESS  859  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 859
by  LisaJump to last post
11/25/2013 4:46 PM
1 Replies and 771 Views AP155 Payer Address on File  771  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 771
by  JeremyJump to last post
11/20/2013 4:55 PM
3 Replies and 741 Views Online Entries & Interface Source  741  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 741
by  John HenleyJump to last post
11/15/2013 12:28 PM
3 Replies and 5371 Views Infor’s Lawson Accounts Payable Invoice Automation system  5371  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 5371
by  John HenleyJump to last post
11/08/2013 1:07 PM
1 Replies and 1281 Views AP520 and One Time Vendor  1281  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 1281
by  brainetJump to last post
11/01/2013 9:22 AM
2 Replies and 729 Views Employer Issued Credit Cards - Where Maintained  729  2 Started by  BradF Is there anyone who does this
2 729
by  Greg MoellerJump to last post
10/31/2013 8:55 AM
8 Replies and 2157 Views Loading Fixed Assets into Lawson AM  2157  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 2157
by  Bob CanhamJump to last post
10/24/2013 2:34 PM
1 Replies and 965 Views Converted Assets Not Calculating Depreciation  965  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 965
by  IanJump to last post
10/23/2013 6:04 PM
1 Replies and 858 Views Restricted Funds  858  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 858
by  Bob CanhamJump to last post
10/22/2013 12:14 PM
0 Replies and 727 Views Audit Data? EFT/Banking Information in AR  727  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 727
10/21/2013 3:04 PM
0 Replies and 1162 Views Cost Allocation  1162  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 1162
10/21/2013 12:25 PM
0 Replies and 636 Views Merging Summary Accounts  636  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 636
10/14/2013 5:35 PM
0 Replies and 1023 Views Adding a new Data Area tonight  1023  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 1023
10/14/2013 2:02 PM
5 Replies and 1130 Views What Lawson form??  1130  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 1130
by  Greg MoellerJump to last post
10/11/2013 3:27 PM
2 Replies and 1186 Views List of forms to change GL information - Changing GL  1186  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 1186
by  OllertonJump to last post
10/09/2013 4:38 PM
2 Replies and 1338 Views Managing GL,AP, AR interface fallouts  1338  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 1338
by  John HenleyJump to last post
10/03/2013 5:04 PM
9 Replies and 1165 Views How to tell if a job posted successfully i.e. GL165  1165  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 1165
by  Greg MoellerJump to last post
10/03/2013 4:43 PM
1 Replies and 839 Views Track new accounts or new accounting units created during a period of time  839  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 839
by  Anna TianJump to last post
10/02/2013 2:18 PM
1 Replies and 981 Views Audit for Activities  981  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 981
by  LynneJump to last post
09/30/2013 7:57 AM
1 Replies and 1183 Views MA540 Vendor Payment Terms v. AP10 Vendor Payment Terms  1183  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 1183
by  JonAJump to last post
09/24/2013 9:23 AM
1 Replies and 988 Views GLTRANS field acct_amount  988  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 988
by  SNJump to last post
09/21/2013 9:47 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