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
0 Replies and 467 Views GL16.2 adding attributes  467  0 Started by  L G Might be a noob question. How does one add attributes in GL16.2. I mean how to setup attributes and how to navigate to GL16.2 to add them to individual accounts
0 467
07/05/2016 9:29 AM
0 Replies and 771 Views Partial Period Depreciation  771  0 Started by  Ron Swanson Client has iSeries 8.1 Lawson. With a transfer in investors a new company was created. The new company start date is mid period. They want to post Asset Depreciation for the partial period in the old company, and remaining in the new company and keep the Asset files and G/L in sync. Presently the Asset Period Calendar matches the Fiscal Calendar though they do not have to be. Tried changing the Asset Calendar would not let me with assets in place. Any ideas on how to handle this, sho...
0 771
06/16/2016 3:58 PM
5 Replies and 2996 Views Credit Card Processes  2996  5 Started by  toria1248 Hello, I was wondering if anyone had any suggestions on how to import credit card transactions We currently upload every credit card by month separately as a Journal Entry. And the more we grow, the more users receive credit cards and it came up in discussion - how do other companies handle their credit card purchases From what I've seen there's a P-card module We currently don't utilize it. How useful is the module Or does anyone use an external software to track their detail and up...
5 2996
by  facendaaJump to last post
06/01/2016 7:34 AM
2 Replies and 1772 Views MHC for check viewing / W2 etc  1772  2 Started by  Ronnie I have been with two companies who used MHC for check printing / viewing / w2 etc. Are there any other vendors who work with lawson who also offer the same I have been asked to investigate alternatives, but I have honestly not heard of any others.
2 1772
by  KellyJump to last post
05/31/2016 3:07 PM
2 Replies and 1630 Views Who owns the MA60 screen?  1630  2 Started by  Capital-Key Currently in our Lawson security, AP owns the MA60 screen, but doesn't like to use it. They believe that all invoices should match in AP20 perfectly. However, when they don't, they will not go to MA60 to release the payment unless they are instructed by Supply Chain. Otherwise it sits on our exceptions database in SharePoint. So I asked them why should AP own it if Supply Chain has to tell them when to use it I'm just curious .... Who owns the MA60 screen at your place of business
2 1630
by  JimYJump to last post
05/25/2016 11:30 AM
0 Replies and 662 Views Intercompany Payment Transfer  662  0 Started by  Magus ' How to transfer UNASSGINED cash sitting in one company to a customer belongs to differnt company' Can any one please help me on this in detail.. I tried to link companies using GL25 and created a National Account relation using AR12.1 . But while doing Payment transfer using AR29.1 am getting an error like ' TO COMPANY DOES NOT EXIST' Please help me on this.. Thanks
0 662
05/20/2016 1:35 AM
4 Replies and 1846 Views Vendor Payments  1846  4 Started by  brupp Hello - Let's say you have a multiple line PO, & when the invoice is applied, at least 1 line creates a PO cost message. Do you hold payment until the invoice can be paid in its entirety or do you pay on the matched lines per normal terms, then pay the discrepant line(s) at a later time once the cost message is resolved And is either direction dictated by a setting in Lawson Thanks.
4 1846
by  bruppJump to last post
05/17/2016 10:29 AM
3 Replies and 1705 Views PO Summary  1705  3 Started by  jaherb What is the easiest way to enter the PO and see the overall payments and overall remaining balance (money left on the PO) User is currently using PO64, but thinks there must be a better way Thank you Jim
3 1705
by  jaherbJump to last post
04/28/2016 5:02 PM
2 Replies and 1813 Views How to Kill a Job  1813  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 1813
by  pbelskyJump to last post
04/27/2016 11:59 AM
0 Replies and 628 Views Month end processes in AR..?  628  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 628
04/22/2016 9:36 AM
4 Replies and 1345 Views SQL QUERY NODE outputData  1345  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 1345
by  MagusJump to last post
04/22/2016 3:31 AM
1 Replies and 1431 Views AP175 GLTRANS R_DATE  1431  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 1431
by  TracyOJump to last post
04/21/2016 3:20 PM
8 Replies and 2164 Views Essbase 11  2164  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 2164
by  brookeJump to last post
04/12/2016 3:22 PM
10 Replies and 5222 Views Lawson Certification of Essbase  5222  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 5222
by  brookeJump to last post
04/12/2016 3:21 PM
4 Replies and 1628 Views Vendor Status PO Add Inactive  1628  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 1628
by  JonAJump to last post
03/30/2016 12:44 PM
1 Replies and 1226 Views Asset Management using Attributes  1226  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 1226
by  Display NameJump to last post
03/25/2016 8:22 AM
1 Replies and 1047 Views AP Report  1047  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 1047
by  Display NameJump to last post
03/23/2016 9:53 AM
0 Replies and 682 Views CB50 Upload  682  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 682
03/18/2016 11:56 AM
0 Replies and 707 Views Lawson Flat rate tax on certain income codes  707  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 707
03/10/2016 5:12 PM
4 Replies and 1133 Views Vendor's payments  1133  4 Started by  Chesca 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 1133
by  ChescaJump to last post
03/04/2016 8:07 AM
6 Replies and 1244 Views L_HACV and L_DACV environment tables  1244  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 1244
by  John HenleyJump to last post
02/29/2016 9:45 AM
0 Replies and 653 Views linking external scheduler to infor lawson  653  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 653
02/24/2016 7:42 AM
0 Replies and 565 Views BL123 posting to multiple compaies  565  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 565
02/22/2016 3:52 PM
5 Replies and 855 Views Multi-threading batch AR cash applications  855  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 855
by  John HenleyJump to last post
02/16/2016 4:01 PM
0 Replies and 918 Views Grant reporting?  918  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 918
02/16/2016 10:54 AM
2 Replies and 906 Views AP52 Process Level Incorrect from HR Payroll Garnishment  906  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 906
by  Gary RonsmanJump to last post
02/11/2016 4:47 PM
2 Replies and 1138 Views Ap90.5  1138  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 1138
by  SkippyScottJump to last post
02/11/2016 7:39 AM
1 Replies and 1057 Views AP10 Pay Terms vs Contract Pay Terms  1057  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 1057
by  JonAJump to last post
02/10/2016 12:10 PM
0 Replies and 524 Views Vendor Diversity  524  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 524
02/08/2016 5:37 PM
3 Replies and 1654 Views AP150  1654  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 1654
by  Mark F. HardyJump to last post
02/08/2016 11:22 AM
0 Replies and 632 Views GL Distributions  632  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 632
01/27/2016 12:37 PM
1 Replies and 1089 Views MHC Electronic Invoicing - OCR Performance  1089  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 1089
by  Jamie KJump to last post
01/25/2016 3:56 PM
4 Replies and 1730 Views Lawson Screen CSV Export  1730  4 Started by  Chesca 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 1730
by  ChescaJump to last post
01/25/2016 2:50 PM
2 Replies and 1436 Views 1099 electronic file IRS interface  1436  2 Started by  Chesca 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 1436
by  ChescaJump to last post
01/25/2016 2:48 PM
1 Replies and 976 Views AP155 Cannot run, AP150 has not been run for this Process Group  976  1 Started by  Chesca 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 976
by  dcaianiJump to last post
01/22/2016 11:34 AM
2 Replies and 1269 Views Add-in for invoice upload?  1269  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 1269
by  dcaianiJump to last post
01/22/2016 11:28 AM
1 Replies and 749 Views AR Payment Interface  749  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 749
by  Todd MitchellJump to last post
01/22/2016 7:47 AM
0 Replies and 851 Views AM20.4-Asset Book Does Not Exist  851  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 851
01/19/2016 1:25 PM
0 Replies and 675 Views Enter L_HWSC table  675  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 675
01/19/2016 10:41 AM
7 Replies and 1505 Views Tables referred by AP230  1505  7 Started by  Deleted User I'm trying to modify AP230 report. What all tables can I use
7 1505
by  pbelskyJump to last post
01/15/2016 12:14 PM
3 Replies and 1040 Views joining these 2 tables  1040  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 1040
by  John HenleyJump to last post
01/13/2016 7:26 AM
0 Replies and 883 Views Date payment applied - AR  883  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 883
12/15/2015 6:48 AM
3 Replies and 1597 Views AP45.3  1597  3 Started by  Chesca My users manually entered invoices using the AP45.3 screen, how could they verify the the amounts did not hit the GL
3 1597
by  Bob CanhamJump to last post
11/25/2015 2:37 PM
0 Replies and 793 Views Clearing Line 0 in MA236  793  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 793
11/24/2015 2:25 PM
0 Replies and 1042 Views import payments into Lawson  1042  0 Started by  Chesca 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 1042
11/19/2015 2:39 PM
0 Replies and 755 Views Disabled Veteran's business  755  0 Started by  Chesca 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 755
11/17/2015 9:05 AM
1 Replies and 983 Views MS-Addins CB50  983  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 983
by  The.Sam.GrovesJump to last post
11/12/2015 8:44 AM
0 Replies and 762 Views essbase api  762  0 Started by  brooke Does anyone have the essbase api for AIX
0 762
11/02/2015 9:49 AM
0 Replies and 720 Views Layouts/Tables  720  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 720
11/02/2015 7:04 AM
0 Replies and 586 Views GP to LAW AP migration  586  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 586
10/27/2015 11:46 AM
0 Replies and 744 Views Intercompany transaction descriptions  744  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 744
10/23/2015 7:29 PM
2 Replies and 1015 Views check numbers- CBTRANS FILE  1015  2 Started by  Chesca 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 1015
by  ChescaJump to last post
10/22/2015 9:40 AM
3 Replies and 1082 Views RQC - GL accounts  1082  3 Started by  Chesca 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 1082
by  ChescaJump to last post
10/20/2015 1:24 PM
1 Replies and 1106 Views Merged Vendors  1106  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 1106
by  SurvivorJump to last post
10/15/2015 12:55 PM
0 Replies and 1139 Views MA540 - Attempt to access item beyond bounds of memory Error  1139  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 1139
10/09/2015 1:52 PM
0 Replies and 787 Views How to mark Transactions as as (having been extracted for billing)from INFOR  787  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 787
10/03/2015 1:27 PM
1 Replies and 1185 Views Process Flow to take invoices off of hold  1185  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 1185
by  Tim CochraneJump to last post
09/25/2015 9:47 AM
5 Replies and 1837 Views IC527 - interface  1837  5 Started by  Chesca 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 1837
by  ChescaJump to last post
09/22/2015 2:05 PM
2 Replies and 892 Views AP155  892  2 Started by  Chesca 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 892
by  ChescaJump to last post
09/21/2015 2:39 PM
0 Replies and 670 Views MA00 & MA01 Setup  670  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 670
09/17/2015 6:33 PM
2 Replies and 1203 Views 1099's using the AP146  1203  2 Started by  Chesca 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 1203
by  ChescaJump to last post
09/14/2015 8:46 AM
0 Replies and 1198 Views Version 10X db Schema with relations (user text)  1198  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 1198
09/04/2015 12:17 PM
0 Replies and 857 Views RW100  857  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 857
09/02/2015 10:16 AM
0 Replies and 646 Views RW100  646  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 646
09/02/2015 10:16 AM
2 Replies and 1028 Views AROITEMS - Open Amount???  1028  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 1028
by  apalmer77Jump to last post
08/19/2015 2:49 PM
0 Replies and 716 Views Vendor Discounts  716  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 716
08/18/2015 5:39 PM
2 Replies and 1084 Views AP10 asterisk meaning  1084  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 1084
by  JonAJump to last post
08/10/2015 2:53 PM
3 Replies and 939 Views MA531CSV file- Receiving Batch Update  939  3 Started by  Chesca 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 939
by  JonAJump to last post
08/05/2015 7:27 AM
1 Replies and 960 Views Different Process Levels on a PO25 Service Agreement  960  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 960
by  JonAJump to last post
08/05/2015 7:23 AM
0 Replies and 1189 Views Account category ERROR(suspense) question  1189  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 1189
07/28/2015 10:30 AM
3 Replies and 1295 Views Contracts and Purchase Orders  1295  3 Started by  Chesca 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 1295
by  JonAJump to last post
07/06/2015 1:57 PM
4 Replies and 1381 Views AP vendors report  1381  4 Started by  Chesca 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 1381
by  ChescaJump to last post
07/03/2015 1:45 PM
6 Replies and 3900 Views Upload Assets to AM Module  3900  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 3900
by  Sal1988Jump to last post
06/30/2015 8:41 AM
4 Replies and 1583 Views IC99.2  1583  4 Started by  Chesca 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 1583
by  ChescaJump to last post
06/23/2015 5:11 PM
4 Replies and 1399 Views APINVOICE  1399  4 Started by  Chesca 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 1399
by  JonAJump to last post
06/22/2015 3:18 PM
2 Replies and 1292 Views Par Counts  1292  2 Started by  Chesca 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 1292
by  ChescaJump to last post
06/17/2015 8:39 AM
2 Replies and 14305 Views GLAMOUNTS VS GLTRANS  14305  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 14305
by  AndreaCibaJump to last post
06/12/2015 9:08 AM
0 Replies and 809 Views Match exceptions  809  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 809
06/11/2015 9:52 AM
0 Replies and 798 Views Match exceptions  798  0 Started by  Deleted User Does anybody has a document on how to work on MA126-Match exceptions Thanks
0 798
06/11/2015 9:52 AM
5 Replies and 1504 Views Posted transactions' time stamp  1504  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 1504
by  Lawson BeginnerJump to last post
06/09/2015 8:44 AM
1 Replies and 1066 Views GL Account Reconcilitation  1066  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 1066
by  TracyOJump to last post
06/08/2015 8:58 AM
0 Replies and 708 Views accrued expenses  708  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 708
06/04/2015 8:18 AM
0 Replies and 1007 Views Handling code on invoice  1007  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 1007
06/04/2015 7:57 AM
0 Replies and 942 Views Lawson EDI GTIN setup  942  0 Started by  Chesca 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 942
06/03/2015 8:31 AM
0 Replies and 1070 Views Smart Reconciliation  1070  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 1070
06/02/2015 1:49 PM
2 Replies and 1204 Views Req- operator ID  1204  2 Started by  Chesca 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 1204
by  ChescaJump to last post
05/28/2015 2:25 PM
2 Replies and 4483 Views cancel matched invoice that is out of balance  4483  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 4483
by  MaryannJump to last post
05/28/2015 11:42 AM
5 Replies and 1682 Views CB554  1682  5 Started by  Chesca 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 1682
by  Bob CanhamJump to last post
05/27/2015 3:59 PM
1 Replies and 754 Views How to find account balances?  754  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 754
by  gradtkeJump to last post
05/27/2015 2:05 PM
0 Replies and 907 Views $0 AP invoices  907  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 907
05/27/2015 1:41 PM
4 Replies and 1114 Views Need to find exists table (GL20.2)  1114  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 1114
by  DennisMJump to last post
05/20/2015 4:39 PM
2 Replies and 1245 Views Billing Distribution  1245  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 1245
by  NicoleGrassJump to last post
05/07/2015 12:35 PM
0 Replies and 887 Views Financials S3 integration - 3rd party software  887  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 887
04/10/2015 6:04 AM
0 Replies and 825 Views Posting Hours to General Ledger  825  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 825
04/09/2015 9:32 AM
9 Replies and 7700 Views AP160 and AP161  7700  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 7700
by  DebbieAmExJump to last post
04/08/2015 10:37 AM
0 Replies and 1263 Views New Company G/L Setup  1263  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 1263
03/27/2015 2:10 PM
5 Replies and 1541 Views 3rd Party Check Printing  1541  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 1541
by  Todd MitchellJump to last post
03/25/2015 12:02 PM
0 Replies and 812 Views How to upload/import an externally managed CoA for the GL  812  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 812
03/17/2015 10:55 AM
0 Replies and 596 Views AP160 to Pay State Withholding  596  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 596
03/16/2015 12:37 PM
6 Replies and 1533 Views AP270 Report  1533  6 Started by  Chesca 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 1533
by  ChescaJump to last post
03/09/2015 12:36 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