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 2 of 8 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
4 Replies and 1036 Views Vendor's payments  1036  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 1036
by  bernfc10Jump to last post
03/04/2016 8:07 AM
6 Replies and 1071 Views L_HACV and L_DACV environment tables  1071  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 1071
by  John HenleyJump to last post
02/29/2016 9:45 AM
0 Replies and 561 Views linking external scheduler to infor lawson  561  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 561
02/24/2016 7:42 AM
0 Replies and 465 Views BL123 posting to multiple compaies  465  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 465
02/22/2016 3:52 PM
5 Replies and 754 Views Multi-threading batch AR cash applications  754  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 754
by  John HenleyJump to last post
02/16/2016 4:01 PM
0 Replies and 792 Views Grant reporting?  792  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 792
02/16/2016 10:54 AM
2 Replies and 804 Views AP52 Process Level Incorrect from HR Payroll Garnishment  804  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 804
by  Gary RonsmanJump to last post
02/11/2016 4:47 PM
2 Replies and 999 Views Ap90.5  999  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 999
by  SkippyScottJump to last post
02/11/2016 7:39 AM
1 Replies and 759 Views AP10 Pay Terms vs Contract Pay Terms  759  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 759
by  JonAJump to last post
02/10/2016 12:10 PM
0 Replies and 421 Views Vendor Diversity  421  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 421
02/08/2016 5:37 PM
3 Replies and 1358 Views AP150  1358  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 1358
by  Mark F. HardyJump to last post
02/08/2016 11:22 AM
0 Replies and 548 Views Vertex O series failure on v10  548  0 Started by  Big_Mike So our issues have been going on for almost a year. As it turns out we are one of two clients on S3 version 10, on a windows platform, attempting to use the Vertex O series. We have multiple environments and have not had any success with configuring, patching, etc getting the systems to talk to each other correctly. Our other integration's, which number in the 100's, run flawlessly. The keep or toss moment is here as its' implementation is holding up several large initiatives and I was hopin...
0 548
02/02/2016 10:04 AM
0 Replies and 542 Views GL Distributions  542  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 542
01/27/2016 12:37 PM
1 Replies and 953 Views MHC Electronic Invoicing - OCR Performance  953  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 953
by  Jamie KJump to last post
01/25/2016 3:56 PM
4 Replies and 1490 Views Lawson Screen CSV Export  1490  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 1490
by  bernfc10Jump to last post
01/25/2016 2:50 PM
2 Replies and 1279 Views 1099 electronic file IRS interface  1279  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. http://www.irs.gov/pub/irs-pdf/p1220.pdf Contact the IRS 1-866-455-7438 1-304-263-8700 (International) ...
2 1279
by  bernfc10Jump to last post
01/25/2016 2:48 PM
1 Replies and 832 Views AP155 Cannot run, AP150 has not been run for this Process Group  832  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 832
by  dcaianiJump to last post
01/22/2016 11:34 AM
2 Replies and 1020 Views Add-in for invoice upload?  1020  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 1020
by  dcaianiJump to last post
01/22/2016 11:28 AM
1 Replies and 663 Views AR Payment Interface  663  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 663
by  Todd MitchellJump to last post
01/22/2016 7:47 AM
0 Replies and 723 Views AM20.4-Asset Book Does Not Exist  723  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 723
01/19/2016 1:25 PM
0 Replies and 574 Views Enter L_HWSC table  574  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 574
01/19/2016 10:41 AM
7 Replies and 1388 Views Tables referred by AP230  1388  7 Started by  Deleted User I'm trying to modify AP230 report. What all tables can I use
7 1388
by  pbelskyJump to last post
01/15/2016 12:14 PM
3 Replies and 900 Views joining these 2 tables  900  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 https://www.lawsonguru.com/gurucontent/datadict/801/tables/APINVOICE.html 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 900
by  John HenleyJump to last post
01/13/2016 7:26 AM
0 Replies and 753 Views Date payment applied - AR  753  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 753
12/15/2015 6:48 AM
3 Replies and 1371 Views AP45.3  1371  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 1371
by  Bob CanhamJump to last post
11/25/2015 2:37 PM
0 Replies and 689 Views Clearing Line 0 in MA236  689  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 689
11/24/2015 2:25 PM
0 Replies and 897 Views import payments into Lawson  897  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 897
11/19/2015 2:39 PM
0 Replies and 650 Views Disabled Veteran's business  650  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 650
11/17/2015 9:05 AM
1 Replies and 852 Views MS-Addins CB50  852  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 852
by  The.Sam.GrovesJump to last post
11/12/2015 8:44 AM
0 Replies and 659 Views essbase api  659  0 Started by  brooke Does anyone have the essbase api for AIX
0 659
11/02/2015 9:49 AM
0 Replies and 606 Views Layouts/Tables  606  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 606
11/02/2015 7:04 AM
0 Replies and 485 Views GP to LAW AP migration  485  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 485
10/27/2015 11:46 AM
0 Replies and 629 Views Intercompany transaction descriptions  629  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 629
10/23/2015 7:29 PM
2 Replies and 896 Views check numbers- CBTRANS FILE  896  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 896
by  bernfc10Jump to last post
10/22/2015 9:40 AM
3 Replies and 965 Views RQC - GL accounts  965  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 965
by  bernfc10Jump to last post
10/20/2015 1:24 PM
1 Replies and 971 Views Merged Vendors  971  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 971
by  SurvivorACJump to last post
10/15/2015 12:55 PM
0 Replies and 1024 Views MA540 - Attempt to access item beyond bounds of memory Error  1024  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 1024
10/09/2015 1:52 PM
0 Replies and 694 Views How to mark Transactions as as (having been extracted for billing)from INFOR  694  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 694
10/03/2015 1:27 PM
1 Replies and 1083 Views Process Flow to take invoices off of hold  1083  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 1083
by  Tim CochraneJump to last post
09/25/2015 9:47 AM
5 Replies and 1669 Views IC527 - interface  1669  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 1669
by  bernfc10Jump to last post
09/22/2015 2:05 PM
2 Replies and 780 Views AP155  780  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 780
by  bernfc10Jump to last post
09/21/2015 2:39 PM
0 Replies and 601 Views MA00 & MA01 Setup  601  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 601
09/17/2015 6:33 PM
2 Replies and 1078 Views 1099's using the AP146  1078  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 1078
by  bernfc10Jump to last post
09/14/2015 8:46 AM
0 Replies and 1030 Views Version 10X db Schema with relations (user text)  1030  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 1030
09/04/2015 12:17 PM
0 Replies and 756 Views RW100  756  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 756
09/02/2015 10:16 AM
0 Replies and 572 Views RW100  572  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 572
09/02/2015 10:16 AM
2 Replies and 928 Views AROITEMS - Open Amount???  928  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 928
by  apalmer77Jump to last post
08/19/2015 2:49 PM
0 Replies and 644 Views Vendor Discounts  644  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 644
08/18/2015 5:39 PM
2 Replies and 969 Views AP10 asterisk meaning  969  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 969
by  JonAJump to last post
08/10/2015 2:53 PM
3 Replies and 841 Views MA531CSV file- Receiving Batch Update  841  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 841
by  JonAJump to last post
08/05/2015 7:27 AM
1 Replies and 856 Views Different Process Levels on a PO25 Service Agreement  856  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 856
by  JonAJump to last post
08/05/2015 7:23 AM
0 Replies and 1057 Views Account category ERROR(suspense) question  1057  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 1057
07/28/2015 10:30 AM
3 Replies and 1173 Views Contracts and Purchase Orders  1173  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 1173
by  JonAJump to last post
07/06/2015 1:57 PM
4 Replies and 1234 Views AP vendors report  1234  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 1234
by  bernfc10Jump to last post
07/03/2015 1:45 PM
6 Replies and 3671 Views Upload Assets to AM Module  3671  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 3671
by  Sal1988Jump to last post
06/30/2015 8:41 AM
4 Replies and 1462 Views IC99.2  1462  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 1462
by  bernfc10Jump to last post
06/23/2015 5:11 PM
4 Replies and 1279 Views APINVOICE  1279  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 1279
by  JonAJump to last post
06/22/2015 3:18 PM
2 Replies and 1202 Views Par Counts  1202  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 1202
by  bernfc10Jump to last post
06/17/2015 8:39 AM
2 Replies and 14148 Views GLAMOUNTS VS GLTRANS  14148  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 14148
by  AndreaCibaJump to last post
06/12/2015 9:08 AM
0 Replies and 719 Views Match exceptions  719  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 719
06/11/2015 9:52 AM
0 Replies and 734 Views Match exceptions  734  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 734
06/11/2015 9:52 AM
5 Replies and 1399 Views Posted transactions' time stamp  1399  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 1399
by  Lawson BeginnerJump to last post
06/09/2015 8:44 AM
1 Replies and 971 Views GL Account Reconcilitation  971  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 971
by  TracyOJump to last post
06/08/2015 8:58 AM
0 Replies and 656 Views accrued expenses  656  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 656
06/04/2015 8:18 AM
0 Replies and 943 Views Handling code on invoice  943  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 943
06/04/2015 7:57 AM
0 Replies and 859 Views Lawson EDI GTIN setup  859  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 859
06/03/2015 8:31 AM
0 Replies and 954 Views Smart Reconciliation  954  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 954
06/02/2015 1:49 PM
2 Replies and 1059 Views Req- operator ID  1059  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 1059
by  bernfc10Jump to last post
05/28/2015 2:25 PM
2 Replies and 4055 Views cancel matched invoice that is out of balance  4055  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 4055
by  MaryannJump to last post
05/28/2015 11:42 AM
5 Replies and 1480 Views CB554  1480  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 1480
by  Bob CanhamJump to last post
05/27/2015 3:59 PM
1 Replies and 655 Views How to find account balances?  655  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 655
by  gradtkeJump to last post
05/27/2015 2:05 PM
0 Replies and 771 Views $0 AP invoices  771  0 Started by  gradtke We prepay many of our vendors, so we don't get invoices from them...at 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 Lawson...so 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 771
05/27/2015 1:41 PM
4 Replies and 944 Views Need to find exists table (GL20.2)  944  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 944
by  DennisMJump to last post
05/20/2015 4:39 PM
2 Replies and 1140 Views Billing Distribution  1140  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 1140
by  NicoleGrassJump to last post
05/07/2015 12:35 PM
0 Replies and 734 Views Financials S3 integration - 3rd party software  734  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 734
04/10/2015 6:04 AM
0 Replies and 726 Views Posting Hours to General Ledger  726  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 726
04/09/2015 9:32 AM
9 Replies and 7327 Views AP160 and AP161  7327  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 7327
by  DebbieAmExJump to last post
04/08/2015 10:37 AM
0 Replies and 1182 Views New Company G/L Setup  1182  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 1182
03/27/2015 2:10 PM
5 Replies and 1354 Views 3rd Party Check Printing  1354  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 1354
by  Todd MitchellJump to last post
03/25/2015 12:02 PM
0 Replies and 714 Views How to upload/import an externally managed CoA for the GL  714  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 714
03/17/2015 10:55 AM
0 Replies and 516 Views AP160 to Pay State Withholding  516  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 516
03/16/2015 12:37 PM
6 Replies and 1366 Views AP270 Report  1366  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 1366
by  bernfc10Jump to last post
03/09/2015 12:36 PM
3 Replies and 1275 Views AP Vendor's payment address  1275  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 1275
by  jjcyeshuaJump to last post
03/05/2015 5:27 PM
0 Replies and 799 Views AL tax payments  799  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 799
02/24/2015 2:56 PM
1 Replies and 1185 Views 1099 State income/tax reporting  1185  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 1185
by  jjcyeshuaJump to last post
02/10/2015 5:08 PM
2 Replies and 891 Views Customer Comments in AR  891  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 891
by  Todd MitchellJump to last post
02/05/2015 9:30 AM
2 Replies and 1098 Views Asset Managment - 8.1  1098  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 1098
by  Ron SwansonJump to last post
01/15/2015 2:28 PM
1 Replies and 1286 Views APINVOICE OPERATOR  1286  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 1286
by  John HenleyJump to last post
01/05/2015 4:11 PM
0 Replies and 728 Views AR199 Year End Close Mistake  728  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 728
01/05/2015 1:10 PM
1 Replies and 1056 Views Inactivating a company  1056  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 1056
by  Jimmy ChiuJump to last post
12/17/2014 2:34 PM
0 Replies and 843 Views Aging Reports (AR251) I.P.A.  843  0 Started by  BErnewayn On an aging report (AR251), does I.P.A. stand for Invoice Payment Average Is this closer to a DSO average or is the F.O.R. - Funds Outstanding Ratio closer in measurement to the DSO
0 843
12/15/2014 3:48 PM
0 Replies and 679 Views Asset Managment  679  0 Started by  symfny I'm pretty sure I know the answer to this question... but has anyone used Lawson Asset Management for managing 'physical' assets and tracking its location and any potential related inventory I know Lawson AM manages depreciation and its integration with GL, but the request is simpler than that. We have internal customers wanting to manage equipment which is on a trial, loan, demonstration or evaluation from a vendor. If so, how did you do it Thanks.
0 679
12/15/2014 12:50 PM
2 Replies and 1022 Views Process Level Restriction  1022  2 Started by  Dee Hardy I'm not sure I's posting this problem in the right location. I wrote rules to restrict users by process levels, which works, but it doesn't allow for Drill Around access. For example, I can restrict a user to process level using the rule which looks at ProcessLevelControl and AccountingUnitControl in RMID, but no information is displayed when the users tries to use Drill Around. There should be a way to make this work. Does anyone have any experience with process level restriction and access to ...
2 1022
by  Dee HardyJump to last post
12/09/2014 1:19 PM
1 Replies and 931 Views G/L Date Error  931  1 Started by  bernfc10 Payroll processed the PR197 on Friday 10/17/14 with the G/L Date of 10/08/2014 instead of 10/22/2014. I was hoping that there is a way to back it out and re-post it to the correct date. Does anyone have any ideas for me
1 931
by  dcaianiJump to last post
12/05/2014 2:40 PM
1 Replies and 1042 Views PO25 Contract Agreements  1042  1 Started by  lars Is there a screen or report that will list all PO20's that used against items in a PO25.6 Vendor Agreement/Contract Or another way of saying it.... We have a PO25.6 Contract in place for copy paper, 4 items to be exact. Our audit team want to see if the Contract items are being used. Th audit team wants to see a list of PO20's that were issued using the 4 items in the contract. Thanks.
1 1042
by  JonAJump to last post
11/26/2014 1:39 PM
1 Replies and 915 Views ERP Selection  915  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 915
by  alexrsJump to last post
11/18/2014 6:34 AM
0 Replies and 706 Views Staging table for AP comments  706  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 706
11/17/2014 10:36 PM
1 Replies and 1049 Views AP14.5 TIN Type Change with Add-Ins  1049  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 1049
by  jjcyeshuaJump to last post
11/13/2014 6:49 PM
2 Replies and 869 Views Writing an Income Statement in crystal  869  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 869
by  jjcyeshuaJump to last post
11/12/2014 2:29 PM
5 Replies and 1150 Views Non-AR Backout  1150  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 1150
by  Ken UJump to last post
11/06/2014 2:59 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 8 << < 12345 > >>


RSS Feed Available