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 2 of 9 << < 12345 > >>
 Last Post
2 Replies and 1610 Views How to Kill a Job  1610  2 Started by  pops We are running Lawson 10 and have users who submit jobs & reports. Sometimes a user submits a job/report that runs for over a 1/2 hour. Is there a way in Lawson 10 to kill this job maybe through Print Manager or does it have to be done on the back end (maybe through LID) and what would be the command to do this. Thank you in advance! Allen
2 1610
by  pbelskyJump to last post
04/27/2016 11:59 AM
0 Replies and 577 Views Month end processes in AR..?  577  0 Started by  Magus What are the steps we follow in month end for AR.. i.e End of the month (EOM) processes we do in Accounts receivables to begin a new month as well as to close out previous open months. Please suggest me some of the , • guidelines to create new accounting periods, as well as closing out older accounting periods. • and for proper allocation of payments, and adjustments to the appropriate accounting period. What are the jobs names and steps we need to follow..Please enlighten me on thi...
0 577
04/22/2016 9:36 AM
4 Replies and 1277 Views SQL QUERY NODE outputData  1277  4 Started by  Magus Hello All, Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank.. Please anyone guide me to fetch the results of that query and send them to a directory..
4 1277
by  MagusJump to last post
04/22/2016 3:31 AM
1 Replies and 1318 Views AP175 GLTRANS R_DATE  1318  1 Started by  Randy I'm looking at APDISTRIB records and their linked (GLT_OBJ_ID) GLTRANS records. The GLTRANS records have AP / AP175, as the interface. What populates the R_DATE of the GLTRANS I was trying to determine if any distributions hit a prior month after statements were issued. Also most transactions are 'summarized' so I'm getting more detail at the AP level. However I see future (Years away) R_DATE in the GLTRANS record. I'll see GL POSTING_DATE of 2/29/2016 which I expect. But R_DATE anywhere from ...
1 1318
by  TracyOJump to last post
04/21/2016 3:20 PM
8 Replies and 2093 Views Essbase 11  2093  8 Started by  brooke We are on and upgrading essbase to 11 - has anyone able to get the lawson api to work with 11 for the IA120 to still work
8 2093
by  brookeJump to last post
04/12/2016 3:22 PM
10 Replies and 5135 Views Lawson Certification of Essbase  5135  10 Started by  Vicki We are finally upgrading Essbase from Version 7 to Version 11 and have been told by Oracle that Lawson has only certified to Essbase version 9.3. We are using Lawson Analytic Architecture to feed our cubes and it is working well for us. Has anyone else using Analytic Architecture upgraded to Essbase Version 11 and if so, are you having any issues Have you ignored the lack of certification
10 5135
by  brookeJump to last post
04/12/2016 3:21 PM
4 Replies and 1546 Views Vendor Status PO Add Inactive  1546  4 Started by  ckmiller Our vendor master controller has inactivated a vendor due to a merger and now invoices coming in electronically are rejecting. I've seen other vendors with a status of PO Add Inactive, which I understand does not allow for new POs and that's all the definition I can find on it. Will this status allow invoices for POs already created to pass through electronically
4 1546
by  JonAJump to last post
03/30/2016 12:44 PM
1 Replies and 1163 Views Asset Management using Attributes  1163  1 Started by  Sami117 We have to complete several asset surveys each year. The surveys require us to group certain pieces of equipment in categories with ACES codes. These 3 digit codes are used to report out equipment like computers (code 311), Office equipment (312), medical equipment (317). In our old Sage Fixed Assets software we created a category that was required for each asset to be either NA (for building, land, leasehold improvements) or one of the 3 digit codes for moveable, fixed, and software. This w...
1 1163
by  Display NameJump to last post
03/25/2016 8:22 AM
1 Replies and 986 Views AP Report  986  1 Started by  Brad Wade Is there an AP report that shows the expense distribution of invoices on a check run This would be similar to the AP150, but with the expense distributions for the invoices as well. We are trying to find the easiest way to track where the expenses posted for each check run in a single report or job. Thanks.
1 986
by  Display NameJump to last post
03/23/2016 9:53 AM
0 Replies and 611 Views CB50 Upload  611  0 Started by  harold_c Hi. I am trying to do CB50 upload for a transaction like this one below: dept A Sales Tax-Feb 500 dept B Sales Tax-Feb 200 Company 1 Sales Tax-Feb 700 When viewing in GL90, what field or fields should I use so that it would show in dept A account description as 'Dept A sales tax Feb', in dept b account description as 'dept b sales tax Feb', and on the corresponding cash account as 'Company 1 Sales Tax Feb' Thanks.
0 611
03/18/2016 11:56 AM
0 Replies and 640 Views Lawson Flat rate tax on certain income codes  640  0 Started by  dkester How do I set up a flat withholding rate for a specific income code If an employee chooses a flat percentage rate on their W-4, how does that impact the calculation on income codes wtih a fixed rate
0 640
03/10/2016 5:12 PM
4 Replies and 1075 Views Vendor's payments  1075  4 Started by  bernfc10 Could anybody help me out with writing an SQL statement to get total check amount for each vendor in a given period Here is my select statement but I still need to include vendor name, tax ID and address: select company,vendor, sum(check_chk_amt) from lawson.appayment where check_date BETWEEN to_date('1/1/15','MM/DD/YY') and to_date('12/31/15','MM/DD/YY') Group by company,vendor HAVING SUM(bank_chk_amt) >= 600.00 order by company,vendor;
4 1075
by  bernfc10Jump to last post
03/04/2016 8:07 AM
6 Replies and 1168 Views L_HACV and L_DACV environment tables  1168  6 Started by  Tom_gbmc We have a request from a user to modify one of our crystal reports, reporting on activities, to include the comments from AC10. Infor told me that this information is stored in L_HACV and L_DACV and that these are environment tables and not accessed in the same way as a 'typical' database table. Has anyone had any experience using these tables and is there a reasonable way to be able to access them as well as the other AC tables in one report Thanks
6 1168
by  John HenleyJump to last post
02/29/2016 9:45 AM
0 Replies and 596 Views linking external scheduler to infor lawson  596  0 Started by  UDAYKVM9 Hello All..I am new to INFOR Lawson.I have a requirement to link Infor Lawson scheduler with an external Quartz scheduler. Can any one let me know how to do this Please any one enlighten me of this process..Thanks much ! :)
0 596
02/24/2016 7:42 AM
0 Replies and 502 Views BL123 posting to multiple compaies  502  0 Started by  Brian Espe We are creating invoices via the BL520 interface program. Based on a custom table we need to distribute to multiple GL Companies. We are thinking of modifying the BL123 to accomplish this. Has anybody done this, or do you have another suggestion.
0 502
02/22/2016 3:52 PM
5 Replies and 792 Views Multi-threading batch AR cash applications  792  5 Started by  Todd Mitchell I am inquiring to see what solutions anyone has come up with for multi-threading batch AR Cash applications. We have been using AR575 (ARIPMT) for years and this has served us well. However, the larger we grow we are finding that the limitation to AR575 only allowing 1 user or 'process' at a time was becoming troublesome. We then went to using AR580 as well. In order for this to work I had to customize AR575 and AR580 because they were not addressing the Batch Nbr 'locking' correctly. This ...
5 792
by  John HenleyJump to last post
02/16/2016 4:01 PM
0 Replies and 841 Views Grant reporting?  841  0 Started by  JoeH …… Over the past year we have learned a lot of grant accounting and the audits that come with grant accounting. One thing we discovered that we are not doing is we are not accumulating all expenses and revenues associated with a grant in one dept. We have started doing this but have found it to be very difficult since sometimes the expenses fall into different service lines. We thought about using the activity module to achieve this requirement by assigning an activity number to each grant. ...
0 841
02/16/2016 10:54 AM
2 Replies and 838 Views AP52 Process Level Incorrect from HR Payroll Garnishment  838  2 Started by  Gary Ronsman Employee Garnishments are setup in PR26 within HR/Payroll. When PR198 General Ledger Closing is performed invoices are created in AP52 for these garnishments. The problem is the Process Level in AP52 is always the default process level from AP00.4. I read the AP User Guide and can not find a way to set the process level based on the employee's HR11 screen. PR26 does not have a process level so I'm hoping to pull it from HR11. The same issue exits for deductions, like union dues, that do n...
2 838
by  Gary RonsmanJump to last post
02/11/2016 4:47 PM
2 Replies and 1046 Views Ap90.5  1046  2 Started by  SkippyScott Is there a Lawson report similar to the AP90.5, where I could generate an export for an end user
2 1046
by  SkippyScottJump to last post
02/11/2016 7:39 AM
1 Replies and 873 Views AP10 Pay Terms vs Contract Pay Terms  873  1 Started by  ckmiller Hello, Our Purchasing Director is asking about the hierarchy of the pay terms. For example: Vendor A has pay terms of 30 days on their profile on AP10, but we have a contract with them and some items on that contract have a pay term of 15 days. If a mix of items with pay terms of 15 days and other items that are not on contract are put onto a PO and an invoice comes in for all the items, what pay terms are used for calculating when the payment is made Is there a hierarchy somewhere in Laws...
1 873
by  JonAJump to last post
02/10/2016 12:10 PM
0 Replies and 466 Views Vendor Diversity  466  0 Started by  Boyd I am looking for a report that includes vendor diversity code and coding (a/u and accounting) for transactions in a given year. I can't seem to find a report that would provide this information.
0 466
02/08/2016 5:37 PM
3 Replies and 1482 Views AP150  1482  3 Started by  Deleted User Hi , I 'm looking for query to pull out data from AP150 Report. I want to create Custom report for AP150 to include Invoice Date. Thanks
3 1482
by  Mark F. HardyJump to last post
02/08/2016 11:22 AM
0 Replies and 583 Views GL Distributions  583  0 Started by  Margie Gyurisin We have many, many PR23 records for every pay code and deduction code for each employee who needs to be distributed. I am wondering if there is a similar form in GL where they could say all transactions going to Dist co = 10 acctg unit 762 - distribute 10 to 10 762, 80 to 30 762 and 5 to 20 762 and 5 to 40 700 It would need to distribute both the hours and dollars that are being sent over from payroll. I appreciate any direction you can point me.
0 583
01/27/2016 12:37 PM
1 Replies and 1002 Views MHC Electronic Invoicing - OCR Performance  1002  1 Started by  Bob Canham We are working on implementing MHC's Image Express system to automate our AP processes. This uses an OCR product to start the process out. One hang-up we are having is with the performance of the OCR process. There is a database view that is used to live-validate the purchase order number during the verification step. This seems to take a very long time for us because it is checking for some of the line contents as well. Has anyone done this implementation and run into something similar
1 1002
by  Jamie KJump to last post
01/25/2016 3:56 PM
4 Replies and 1575 Views Lawson Screen CSV Export  1575  4 Started by  bernfc10 Our users do not have access to LID but they have an option on the GL90 screen to create a csv export that goes to /print/user/. I am able to see the csv because I do have LID access, I can probably ftp the file but is there another way the user can access this directory
4 1575
by  bernfc10Jump to last post
01/25/2016 2:50 PM
2 Replies and 1343 Views 1099 electronic file IRS interface  1343  2 Started by  bernfc10 My user wants to run AP146 to produce the 1099 electronic file and send to the IRS to insure that the files meet their standards. Does anybody run AP146 and send the file to IRS Do you FTP the file or upload it manually Is there a specific development department we should contact for testing the file I googled form 4419 and I think I got my answer. Contact the IRS 1-866-455-7438 1-304-263-8700 (International) ...
2 1343
by  bernfc10Jump to last post
01/25/2016 2:48 PM
1 Replies and 896 Views AP155 Cannot run, AP150 has not been run for this Process Group  896  1 Started by  bernfc10 AP155(Payment Forms Creation) job has an error of Cannot run, AP150 has not been run for this process group and I don't know what would cause this. We ran the report in update mode We voided checks this morning but they were voided before the 150 was run.
1 896
by  dcaianiJump to last post
01/22/2016 11:34 AM
2 Replies and 1134 Views Add-in for invoice upload?  1134  2 Started by  Donna Simkovic Has anyone had any success with building an add-in for uploading invoices I built a successful add-in for AP20, so I can build the invoice headers, but when it comes to MA43.1, I can't figure out what to do because the user has to click 'special actions - Create Detail'. So, I'm stumped because I don't know how to do that step with an add-in. Thanks in advance.
2 1134
by  dcaianiJump to last post
01/22/2016 11:28 AM
1 Replies and 693 Views AR Payment Interface  693  1 Started by  hybrid Hi, I'm looking for information regarding the Lawson AR570, AR575 & AR580 programs. Would love to hear stories on past lessons learned and what program everyone is using. We are looking at a lockbox interface so thinking AR570. Hybrid
1 693
by  Todd MitchellJump to last post
01/22/2016 7:47 AM
0 Replies and 771 Views AM20.4-Asset Book Does Not Exist  771  0 Started by  Sami117 We just started capitalizing assets from AC to AM. We had an activity project for a land purchase. The project was finished and we were able to process land through AC160 and AM115. It's now sitting in AM with an asset number. When we review the information on AM20.2, AM20.3 and AM20.4 the information appears identical to other 'land' we have recorded. Note that the other land was added as an upload to AM in July when we went live with the system. AM20.5 doesn't show any journal entry to r...
0 771
01/19/2016 1:25 PM
0 Replies and 617 Views Enter L_HWSC table  617  0 Started by  Tedd Nugent After running a verify found that I am missing L_HWSC table. What utility allows me to setup this table.
0 617
01/19/2016 10:41 AM
7 Replies and 1437 Views Tables referred by AP230  1437  7 Started by  Deleted User I'm trying to modify AP230 report. What all tables can I use
7 1437
by  pbelskyJump to last post
01/15/2016 12:14 PM
3 Replies and 969 Views joining these 2 tables  969  3 Started by  wally I am trying to join two tables, APINVOICE and APDISTRIB. Can you please help me understand the following below which is posted on Scroll down to the 'one to many relationships' then to the APDISTRIB part. Is that saying I need to join API-OBJ-ID to both APD-API-OBJ-ID and APD-DIST-SEQ-NBR or is it saying I have a choice between the two
3 969
by  John HenleyJump to last post
01/13/2016 7:26 AM
0 Replies and 813 Views Date payment applied - AR  813  0 Started by  AnnePep Hello, I am working on a report that I want to show the date an invoice was paid or 'applied'. Is there any system time stamp anywhere in Lawson with this information The only dates I see are deposit_date and gl_date on the ARAPPLIED record. These are driven by user input I believe. We wanted to create a metric using the date an invoice was acutally marked 'Paid' in the system (order to cash KPI) Has anyone created this What tables are you using Thank you for any help in advance! Anne
0 813
12/15/2015 6:48 AM
3 Replies and 1471 Views AP45.3  1471  3 Started by  bernfc10 My users manually entered invoices using the AP45.3 screen, how could they verify the the amounts did not hit the GL
3 1471
by  Bob CanhamJump to last post
11/25/2015 2:37 PM
0 Replies and 733 Views Clearing Line 0 in MA236  733  0 Started by  Donna Simkovic Our AP staff is entering lines on AP20.4 when they find something on an invoice that does not appear or does not match the PO. These lines show up on the MA236 report as Line 0. The buyers then work the MA236 report and have to let AP know when the line has been manually added to the PO, or if that line matches an existing line on the PO. Then the AP staff has to delete that line and re-enter it. This is how I understand the process so far. For example: Vendor item 12345 is ordered on ...
0 733
11/24/2015 2:25 PM
0 Replies and 976 Views import payments into Lawson  976  0 Started by  bernfc10 We have made some payments to vendors via wire transfer that we normally pay out of Lawson with a check. We need to find out how we can get the payment made via wire transfer into Lawson so that we can issue a 1099 for the amount that we normally paid out of Lawson via check and for the amount we paid via wire combined. Basically is there a way to manually put into Lawson the wire payment
0 976
11/19/2015 2:39 PM
0 Replies and 700 Views Disabled Veteran's business  700  0 Started by  bernfc10 The Division of Service-Disabled Veterans' Business Development (DSDVBD) have requested us to submit activity quarterly. Is anybody currently reporting this or planning to build a process Did you write custom code or a crystals to report Veteran Business activity The purchase manager wants to use a user field to flag Veteran's business, I am not sure what user field he is referring to as I am not familiar with purchasing tables, any feedback and ideas would be greatly appreciated.
0 700
11/17/2015 9:05 AM
1 Replies and 915 Views MS-Addins CB50  915  1 Started by  Tedd Nugent I keep reviewing the required fields and have linked them in my script but I keep getting Field is required and not knowing which field is miissing.
1 915
by  The.Sam.GrovesJump to last post
11/12/2015 8:44 AM
0 Replies and 706 Views essbase api  706  0 Started by  brooke Does anyone have the essbase api for AIX
0 706
11/02/2015 9:49 AM
0 Replies and 659 Views Layouts/Tables  659  0 Started by  bharathi Hello All, I need to pass the Account Receivables information from INFOR to another Billing Engine.. What are the Table names or Layouts to get the information for BAL-CURR BAL-PAST-DUE LAST-PMT-DT LAST-PMT-AMT TOT-PMT-ON-ACCT -AR-TRAN-POST-DT ADJ-REFRNCE-NBR
0 659
11/02/2015 7:04 AM
0 Replies and 527 Views GP to LAW AP migration  527  0 Started by  Mark F. Hardy We are migrating our Great Plains AP to Lawson AP. Our Great Plains check print process uses MEKORMA MICR to format and print checks. But our Lawson check printing process uses Formspartner. The business is wondering if we can port the Lawson AP155 Check file over to MEKORMA MICR and use the already setup Check Templates in MEKORMA. Anyone encounter or hear of doing this before Thanks!
0 527
10/27/2015 11:46 AM
0 Replies and 680 Views Intercompany transaction descriptions  680  0 Started by  Chris Mackley My company has quite a few intercompany relationships defined within Lawson. Is there any way to provide visibility to the originating transaction description The auditors do not like seeing 'auto offset from...' and our accountants don't enjoy hunting down the original JE's for them... So we're trying to create a report that breaks down the intercompany transactions and pairs them with the original transaction's description. Thanks!
0 680
10/23/2015 7:29 PM
2 Replies and 942 Views check numbers- CBTRANS FILE  942  2 Started by  bernfc10 My GL user is testing a program and comparing the results to production results. The check number/transaction numbers are different in test/live. I am thinking this is a data issue or a missing step. I ran a query against the CBTRANS file and all the details match except for the check number. What would the check be different in each system though
2 942
by  bernfc10Jump to last post
10/22/2015 9:40 AM
3 Replies and 1021 Views RQC - GL accounts  1021  3 Started by  bernfc10 Does anybody know how to customize rqc 10.6 so that the GL accounts displayed are limited to a certain range When you are searching, it should only show a limited range. RQC Shopping Accounting tab Account sub Account
3 1021
by  bernfc10Jump to last post
10/20/2015 1:24 PM
1 Replies and 1039 Views Merged Vendors  1039  1 Started by  lmckenn We have an issue with AP170 producing incorrect postings to the GL for payments written. We are told by our IT that is has something to do with 'Merged Vendors' and they are asking us to produce a report to show all Merged Vendors - does anyone know which report either from A/P itself or a qwery wizard - Thank you,
1 1039
by  SurvivorACJump to last post
10/15/2015 12:55 PM
0 Replies and 1077 Views MA540 - Attempt to access item beyond bounds of memory Error  1077  0 Started by  Rabie K Hi all, I have a scenario where our Job MA540 fails and goes into 'Needs Recovery' when we do the matching on an Invoice that has taxes in MA54 and try to run MA540 it goes to 'Needs Recovery' with the following Generic Cobol message : \n Execution error : file 'D:\lawlsf\apps\lsfprod\obj\MA540.gnt' \n error code: 114, pc=0, call=1, seg=0 114 Attempt to access item beyond bounds of memory (Signal 11) I recompiled the program with trace on, and I see that it fails at th...
0 1077
10/09/2015 1:52 PM
0 Replies and 739 Views How to mark Transactions as as (having been extracted for billing)from INFOR  739  0 Started by  karanbk • What field would be best suited for marking the transactions as (having been extracted for billing)from AROITEMS , ARAPPLIED so that they are not extracted again this month..
0 739
10/03/2015 1:27 PM
1 Replies and 1124 Views Process Flow to take invoices off of hold  1124  1 Started by  AnnePep Anyone have any experience with a process flow to take invoices off of hold Would we automate the AGS call to ap30.1 Can we simply remove the record from APHLDINV Any help is appreciated - thanks!
1 1124
by  Tim CochraneJump to last post
09/25/2015 9:47 AM
5 Replies and 1746 Views IC527 - interface  1746  5 Started by  bernfc10 We are having such as difficult understanding understanding the IC527 interface program. Our users think the item cost is incorrect for certain items so they want me to customize the program. According to Lawson, The LAST-REC-COST on the ITEMLOC file is updated upon Match and is what the Lawson System will use for Last Cost defaulting for N items. Does “Match” mean match between item receipt and invoice or does Match mean match between PO and PO receipt Essentially, my users want the cost ...
5 1746
by  bernfc10Jump to last post
09/22/2015 2:05 PM
2 Replies and 826 Views AP155  826  2 Started by  bernfc10 My users are doing some testing and need to test if they can cut checks out of Document Express. Does AP155 creates an output file and if yes, where is this file located
2 826
by  bernfc10Jump to last post
09/21/2015 2:39 PM
0 Replies and 627 Views MA00 & MA01 Setup  627  0 Started by  jj2020 Can anyone share their set up of MA00 & MA01 with me I am working with the Reconciliation Message portion to help with Matched Not Received and PO135 issues. I am hoping to see how others are set up in this area. Thanks in advance!
0 627
09/17/2015 6:33 PM
2 Replies and 1126 Views 1099's using the AP146  1126  2 Started by  bernfc10 My users would like to process our 1099's this year using the AP146 (1099 tape creation) instead of the AP145(1099 forms creation) that we have used in previous years. I am not familiar with this process and what we need to do to prepare to do it this way. Do you know what we would need to process the 1099’s this way Any information that you could give me would be much appreciated. Thank You
2 1126
by  bernfc10Jump to last post
09/14/2015 8:46 AM
0 Replies and 1110 Views Version 10X db Schema with relations (user text)  1110  0 Started by  ttredwell I was able to pull our table definitions via the following lid cmds: dburf -pw -d D:\LSF\law\prod10\usertext PROD10 (PROD10 is my productline name) This will take a while once complete type in CD D:\LSF\law\prod10\usertext (remember your drive and prod line will be different) next enter the following commands one by one dbdoc -pw PROD10 AC dbdoc -pw PROD10 AD dbdoc -pw PROD10 AM dbdoc -pw PROD10 AP dbdoc -pw PROD10 AR dbdoc -pw PROD10 BL dbdoc -pw P...
0 1110
09/04/2015 12:17 PM
0 Replies and 800 Views RW100  800  0 Started by  Boyd We recently upgraded from V9 to v10 and several of our RW reports are running slow. In v9 the run time for the report in question would be 15-20 min. Now with new larger, faster servers the same report is taking about 45 min to complete. Just wondering if anyone has a tips or tricks that would reduce the completion time of the report. Lawson support has not been any help.
0 800
09/02/2015 10:16 AM
0 Replies and 605 Views RW100  605  0 Started by  Boyd We recently upgraded from V9 to v10 and several of our RW reports are running slow. In v9 the run time for the report in question would be 15-20 min. Now with new larger, faster servers the same report is taking about 45 min to complete. Just wondering if anyone has a tips or tricks that would reduce the completion time of the report.
0 605
09/02/2015 10:16 AM
2 Replies and 969 Views AROITEMS - Open Amount???  969  2 Started by  apalmer77 Could someone provide some insight on if whether or not the AROITEM_OPEN_AMOUNT derived field can still be used for calculation purposes, even though this field may not be viewable from within a Lawson Production Database I completely understand that no data is stored in this field. What is the purpose of this field being referenced on the LawsonGuru site and there is no way to reference or leverage it for invoice open amount identification purposes. :confused::confused: Any insight ...
2 969
by  apalmer77Jump to last post
08/19/2015 2:49 PM
0 Replies and 672 Views Vendor Discounts  672  0 Started by  Boyd We are looking for a report that will show us vendor discounts taken and lost during the AP/Cash Disbursement process. Is there a report that will show this information Any help is appreciated.
0 672
08/18/2015 5:39 PM
2 Replies and 1020 Views AP10 asterisk meaning  1020  2 Started by  lars Can someone tell me what generates an asterisk in the 'PO Vendor' and 'Location' fields in AP10.1 Thank you.
2 1020
by  JonAJump to last post
08/10/2015 2:53 PM
3 Replies and 874 Views MA531CSV file- Receiving Batch Update  874  3 Started by  bernfc10 The MA531 is getting a CSV file not found error. I am not sure how the CSV input file is created, but I checked in the directory and the file is not in there so it seems like we are not getting the EDI file in the directory. Any idea how to fix this Error Log: ** Creating .prt and .dtl files Processing MA531 - Receiving Batch Update *** MA531CSV file not found in MA531CSV directory*** *** No Records Found For Company 0010
3 874
by  JonAJump to last post
08/05/2015 7:27 AM
1 Replies and 903 Views Different Process Levels on a PO25 Service Agreement  903  1 Started by  lars Our A/P department receives a paper invoice from the vendor. The invoice is sent to the end-user where accounting information is entered on a label, the label is affixed to the invoice and approved by the manager. A/P receives the invoices, enters coding against a PO25 Service Agreement at the line level. The paper invoices are then forwarded to internal auditors for review online.. The paper invoices are then approved by the audit team, sent back to A/P, then A/P performs the match...
1 903
by  JonAJump to last post
08/05/2015 7:23 AM
0 Replies and 1096 Views Account category ERROR(suspense) question  1096  0 Started by  IrvinB Ive been having this activities transactions end up with the account category error (suspense) and then hit a particular account, is there any place where an activity group is tied up to where (GL account) to post this ERROR category , Ive notice this varies from activity group to group. second, it supposed that this account category error is made when activity groups are set up to edit option 3(substitute-suspense), but I have em in option 4, but I still get transactions coming from B...
0 1096
07/28/2015 10:30 AM
3 Replies and 1222 Views Contracts and Purchase Orders  1222  3 Started by  bernfc10 Hello, hope someone can help me. NYS is requesting contracts and POs executed from x date to x date, what Lawson tables can I pull this data from Thanks in advance for your help!
3 1222
by  JonAJump to last post
07/06/2015 1:57 PM
4 Replies and 1296 Views AP vendors report  1296  4 Started by  bernfc10 I am trying to create a list of vendors including name, tax id, diverse code, phone number, class, and address. I joined the APVENMAST AND APVENADDR but I am getting multiple address per vendor. I think I'd like to get the maximum date or most current vendor's address from the file and I don't know how to. Any help would be greatly appreciated. Example: Vendor 1 MED PO box 1235 1/18/11 Vendor 1 MED PO box 3953 3/26/12
4 1296
by  bernfc10Jump to last post
07/03/2015 1:45 PM
6 Replies and 3766 Views Upload Assets to AM Module  3766  6 Started by  Melissa McGuire I am curious if we can do a mass upload of Asset information into Lawson, there was suppose to be a template on an invoice but it got matched, now we're left with manually entering all information in AM20.2
6 3766
by  Sal1988Jump to last post
06/30/2015 8:41 AM
4 Replies and 1516 Views IC99.2  1516  4 Started by  bernfc10 We upgraded the environment this weekend and we are seeing some weird data in IC99.2. We are fine in LID but not portal. I have attached an screenshot.
4 1516
by  bernfc10Jump to last post
06/23/2015 5:11 PM
4 Replies and 1329 Views APINVOICE  1329  4 Started by  bernfc10 How do I get a list of all invoices that have been paid from certain date I need to provide auditors with a crystal report
4 1329
by  JonAJump to last post
06/22/2015 3:18 PM
2 Replies and 1236 Views Par Counts  1236  2 Started by  bernfc10 Does anybody know what job on the MSCM side (MSCM9_TASK table) uploads/sends the counts to MSCM Is it the outboundscheduler job I am trying to figure out how and when the HH orders get uploaded into MSCM
2 1236
by  bernfc10Jump to last post
06/17/2015 8:39 AM
2 Replies and 14217 Views GLAMOUNTS VS GLTRANS  14217  2 Started by  Deleted User I am writing an extract of GL account balances from Lawson and I am trying to find out which table to use for this. Historically, I have used GLAMOUNTS to gather all the data from the most recently closed period in Lawson. However, the Lawson users report GL amounts from GL95.1, which uses GLTRANS as the source. Can someone provide a description of what each one is supposed to be for and which one is more accurate for the closed period. I have found about a 3.5 difference between th...
2 14217
by  AndreaCibaJump to last post
06/12/2015 9:08 AM
0 Replies and 760 Views Match exceptions  760  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 760
06/11/2015 9:52 AM
0 Replies and 760 Views Match exceptions  760  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 760
06/11/2015 9:52 AM
5 Replies and 1447 Views Posted transactions' time stamp  1447  5 Started by  Lawson Beginner Hi, We needed to send some GL update reports on a daily basis to a few third party vendors. In order to avoid duplication of the records sent, we ideally liked to filter the GL transactions in the DB based on the posted time stamp and schedule a job to run once a day. However, we developed a circuitous work-around to meet this requirement. Currently, we are trying to eliminate the work-around and send the list of GL transactions based on the posted time stamp (please note that it is not ...
5 1447
by  Lawson BeginnerJump to last post
06/09/2015 8:44 AM
1 Replies and 1018 Views GL Account Reconcilitation  1018  1 Started by  MichiganMan22 I've recently been given a lot more job duties so I'm looking to make my account reconciliation process more efficient to save time. I currently run a GL 290 and use that information to complete account rec schedules. What are your best practices for reconciling accounts What reports do you pull from Lawson to streamline the process
1 1018
by  TracyOJump to last post
06/08/2015 8:58 AM
0 Replies and 670 Views accrued expenses  670  0 Started by  wally How do I find what has accrued for specific accounts Is there a screen or a table I can reference thanks
0 670
06/04/2015 8:18 AM
0 Replies and 965 Views Handling code on invoice  965  0 Started by  Deleted User We use PO code for PO. Based on the PO codes,AP decides which handling code to select. Now our operations want to get rid of PO code. Anyone have input on how to handle this at AP side so they don't have to select a handling code
0 965
06/04/2015 7:57 AM
0 Replies and 893 Views Lawson EDI GTIN setup  893  0 Started by  bernfc10 We are getting ready to use the Lawson EDI GTIN and I (IT) am being asked to give a guesstimate on how much time would take to implement. I was wondering if anyone is using the GTIN and can provide any feedback. Is it a simple/complex setup Would the users or IT be doing the setup and loads We are on ESP 13 and MSP 9, Lawson 9 technology.
0 893
06/03/2015 8:31 AM
0 Replies and 1001 Views Smart Reconciliation  1001  0 Started by  BarbB Anyone using Smart Reconciliation that is willing to share their setup/best practice in regards to who works what Currently our buyers work the MA64 and MA60. When we went live in 2004 'Matching' was listing in the Procurement suite and assigned to the buyers. As we have been testing Smart Reconciliation we are wondering if AP should be more involved in this function. Thanks in advance for your help with this project.
0 1001
06/02/2015 1:49 PM
2 Replies and 1117 Views Req- operator ID  1117  2 Started by  bernfc10 We are having an issue with some Reqs that are being created with an unknown operator ID= 'essuser'. We looked in security and there isn't such user. The requester is a Handheld device and header source is Upgrade. I have attached a screenshot.
2 1117
by  bernfc10Jump to last post
05/28/2015 2:25 PM
2 Replies and 4220 Views cancel matched invoice that is out of balance  4220  2 Started by  Kenny B I have a matched invoice that I would like to cancel. The catch is that is will not let me cancel, because the system has it marked payment out of balance. Would anyone happen to know why the system will not let me cancel in MA75.1 The error received is 'cannot cancel; payments out of balance'. &160; I show no payments associated with this invoice. &160; Thank you, Kenny Brewer
2 4220
by  MaryannJump to last post
05/28/2015 11:42 AM
5 Replies and 1582 Views CB554  1582  5 Started by  bernfc10 Would anybody have an idea how the CBPMTLOAD table is loaded or why it would be empty My user is getting an error when submitting the CB554 job and the error suggest there was not any data to process for that run group. I ran a query and indeed there is nothing in this file.
5 1582
by  Bob CanhamJump to last post
05/27/2015 3:59 PM
1 Replies and 697 Views How to find account balances?  697  1 Started by  wally Is there a screen where I can see an accounting unit and all the accounts with their current balances Also which table can I pull this information from. Thank you!
1 697
by  gradtkeJump to last post
05/27/2015 2:05 PM
0 Replies and 838 Views $0 AP invoices  838  0 Started by  gradtke We prepay many of our vendors, so we don't get invoices from least not invoices that we enter into Lawson. Back in Lawson 7, we could enter $0 AP invoices and match them to the PO receipt. As of Lawson 8, we could no longer enter $0 AP invoices into we would create $.01 AP invoices. This just floods our AP with $.01 invoices. MA80 and MA180 just don't seem to be the type of solution that our accounting group is looking for. Does anyone else have a solution they are wil...
0 838
05/27/2015 1:41 PM
4 Replies and 1016 Views Need to find exists table (GL20.2)  1016  4 Started by  wally I need to use addin's to pull information regarding Accounting Units and accounts that have a the relationship say yes it exists (GL20.2). I don't know what table the 'exists' field lives. Anyone know
4 1016
by  DennisMJump to last post
05/20/2015 4:39 PM
2 Replies and 1175 Views Billing Distribution  1175  2 Started by  Loger98 Hey Guy's, Just joined a new company that does monthly billing by emailing invoices on a per partner basis after being released and printed(by the print manger). Imagine sending out 500 emails to different partners. Is there a way to automate this (we use the excel add on to upload/creating the invoices) I am just wondering what other company's do in such matter. I can also provide more information if needed. Thanks.
2 1175
by  NicoleGrassJump to last post
05/07/2015 12:35 PM
0 Replies and 808 Views Financials S3 integration - 3rd party software  808  0 Started by  kal800 Hi, Our company is a developer of Account Receivables suite (invoice distribution, outstanding monitoring, dispute workflow, collection workflow, etc). We have done integrations with many ERP systems - SAP, Oracle, Axapta, etc. As a matter of fact, our potential customer is using Lawson Financials Suite S3 and asks us about the posibility to get integrated. We are doing integration in three areas: 1. Issued invoices - in case of SAP we are fetching iDoc messages using webservice 2. Custo...
0 808
04/10/2015 6:04 AM
0 Replies and 761 Views Posting Hours to General Ledger  761  0 Started by  Nicole M How do you separate shift differential hours or on call hours from posting to the general ledger We need the dollars posting but not the hours because these are not paid hours to calculate FTEs. I see a flag called Post Hours in prtime table. What does this do
0 761
04/09/2015 9:32 AM
9 Replies and 7467 Views AP160 and AP161  7467  9 Started by  Carlotta McCormick You've probably all hashed this to death, but I need assistance. We are using the AP160 currently for our ACH transmission to the bank. We want to use the Remit file to send electronic remittances using MHC's e-Remit software. Our problem is that the Remit file doesn't include vendor location information so that I can link to the databases to pull email information. Example: We have a vendor on AP10.1 that gets checks, but one of their locations on AP10.2 gets ACH. The AP160 Remit doesn't ...
9 7467
by  DebbieAmExJump to last post
04/08/2015 10:37 AM
0 Replies and 1215 Views New Company G/L Setup  1215  0 Started by  Ron Swanson The company I am supporting created a new company in FY 2014 after declaring bankruptcy and closing the old company number. The new company actually stated in Period 03 of FY 2014. It appears the person that set up the new company put the equivalent of Beginning Balance Amounts in the DB or CR fields for Period 03. From there, JE's posted to the accounts through the remainder of the year. At the end of the FY 2014 some issues came up with balances and the rollover to 2015. I think...
0 1215
03/27/2015 2:10 PM
5 Replies and 1435 Views 3rd Party Check Printing  1435  5 Started by  gradtke We are looking for some ideas related to 3rd party check printing. How secure they are etc... How are people pulling the check file from Lawson after they run AP155.
5 1435
by  Todd MitchellJump to last post
03/25/2015 12:02 PM
0 Replies and 754 Views How to upload/import an externally managed CoA for the GL  754  0 Started by  LawsonIntegration To preface, I'm new to inbound Lawson GL technical integrations. I've sourced from it plenty of times but never wrote into it. We are looking to upload an externally managed Chart of Accounts to Lawson as a regular business process to keep various GL systems (not all Lawson) in synch with corporate mandated 'common CoA'. We can create pretty much any format, parent/child, generational, xml, etc but can't find any documentation of how this is done for Lawson GL. Is it as simple as just writ...
0 754
03/17/2015 10:55 AM
0 Replies and 551 Views AP160 to Pay State Withholding  551  0 Started by  Deleted User Good afternoon - not a lot of AP info available..... Is anyone using AP160's NACHA format to pay state withholding taxes Hoping I may be able to pick your brain! We're currently using AP161 and a custom program to reformat that file, but would rather use out of the box if possible. Thanks!!
0 551
03/16/2015 12:37 PM
6 Replies and 1446 Views AP270 Report  1446  6 Started by  bernfc10 Hello, I am looking for the information on the AP270, if possible to get the cost center and the expense account, which table should I pull from Any help would be great.
6 1446
by  bernfc10Jump to last post
03/09/2015 12:36 PM
3 Replies and 1342 Views AP Vendor's payment address  1342  3 Started by  bernfc10 Hello, hope some can help me out here. We have a custom program that creates a vendor's payment history report. It reports vendors ID, name, tax ID, invoice amt, Net Payment Amount, class, and address. The only problem is the some of the address are incorrect because they want to see not the main address but the transaction address. So if a vendor's main address is in IL, but they did the transaction in WNY, the it should report the WNY address. I don't know where this address would be store ot...
3 1342
by  jjcyeshuaJump to last post
03/05/2015 5:27 PM
0 Replies and 868 Views AL tax payments  868  0 Started by  Deleted User Good afternoon - looking for some information regarding paying the state of Alabama withholding taxes via ACH with AP161. According to our users, they have to go to the AL website, and file a report prior to sending the dollars. When the report is filed, they receive a confirmation number, and they have to re-enter this when paying the tax via ACH Doesn't make a lot of sense to me.... So, if you use standard Lawson/Infor AP and pay AL state withholding via AP161, would you share your process...
0 868
02/24/2015 2:56 PM
1 Replies and 1254 Views 1099 State income/tax reporting  1254  1 Started by  Kimm We just found out that Lawson does not support our state's requirement of reporting income and taxes withheld on 1099 forms/filing. This year we can file manually with the State but going forward, we're wondring if anyone has solutions for housing and reporting the state income and tax withheld for both printing and electronic filing We can use the combined State/IRS filing but we still need to report the state data directly. Thanks for your help!
1 1254
by  jjcyeshuaJump to last post
02/10/2015 5:08 PM
2 Replies and 929 Views Customer Comments in AR  929  2 Started by  aphillips Our AR dept has requested a place where they can record conversations with customers. They need to be able to recap their discussions for future reference. The only place I see is AR17.1 but this does not look like it will be easy to use. Can anyone share what they do to record comments and actions
2 929
by  Todd MitchellJump to last post
02/05/2015 9:30 AM
2 Replies and 1193 Views Asset Managment - 8.1  1193  2 Started by  Ron Swanson The user believes that the Current Period Depreciation on an AM260 report is an accumulated to date figure, for the current period and will change any time she runs it. I am certain the CP Depr shows up after AM180 is run. And when AM190 is run I assume the CP Depr is cleared and the YTD, LTD is updated. Can someone verify this sequence for me These are folks on 8.1 with no on site staff who were ever trained on Lawson. I am just trying to look at manuals and help. Thanks.
2 1193
by  Ron SwansonJump to last post
01/15/2015 2:28 PM
1 Replies and 1348 Views APINVOICE OPERATOR  1348  1 Started by  Donna We have a new AP employee who started as a vendor and was given an appropriate Vendor user ID in for AD and Lawson. Now that she is an employee we have assigned a different login for AD and Lawson but the original vendor user is still populating the APINVOICE file. It appears that her new user ID has no impact on populating the value in the APINVOICE OPERATOR field. I tried to find a screen that allows the entry of the Operator ID for any AP table and did not find one. We have a Crysta...
1 1348
by  John HenleyJump to last post
01/05/2015 4:11 PM
0 Replies and 785 Views AR199 Year End Close Mistake  785  0 Started by  zjs5029 Hello Everyone, I ran AR199 without the 'Year End' option clicked to yes. Is there anyway to go back and change the close to year end now
0 785
01/05/2015 1:10 PM
1 Replies and 1117 Views Inactivating a company  1117  1 Started by  dcaiani We have 3 GL companies that are no longer active. Is there a way in Lawson to make them inactive so that nothing can be accidentally posted to them from AP or IN etc. There is a status field in GL10, but it doesn't seem to be where I would accomplish inactivating a company. Any thoughts as to what my best plan of action would be Thanks Dave
1 1117
by  Jimmy ChiuJump to last post
12/17/2014 2:34 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 2 of 9 << < 12345 > >>

RSS Feed Available