Forum: Lawson S3 Financials

 147 Subscribed to this forum
Page 10 of 37 << < 89101112 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

L_HACV and L_DACV environment tables    

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
4191 3
by  John HenleyJump to last post
2/29/2016 2:45 PM

linking external scheduler to infor lawson    

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
2827 0
2/24/2016 12:42 PM

BL123 posting to multiple compaies    

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 2758 1
2/22/2016 8:52 PM

Multi-threading batch AR cash applications    

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 3226 3
by  John HenleyJump to last post
2/16/2016 9:01 PM

Grant reporting?    

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 3772 2
2/16/2016 3:54 PM

AP52 Process Level Incorrect from HR Payroll Garnishment    

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 3378 0
by  Gary RonsmanJump to last post
2/11/2016 9:47 PM

Ap90.5    

Started by  SkippyScott
Is there a Lawson report similar to the AP90.5, where I could generate an export for an end user
2
3929 2
by  SkippyScottJump to last post
2/11/2016 12:39 PM

AP10 Pay Terms vs Contract Pay Terms    

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 4193 0
by  JonAJump to last post
2/10/2016 5:10 PM

Vendor Diversity    

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 2804 0
2/8/2016 10:37 PM

AP150    

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 4532 1
by  Mark F. HardyJump to last post
2/8/2016 4:22 PM

GL Distributions    

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 2664 0
1/27/2016 5:37 PM

MHC Electronic Invoicing - OCR Performance    

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 3640 1
by  Jamie KJump to last post
1/25/2016 8:56 PM

Lawson Screen CSV Export    

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
6259 0
by  ChescaJump to last post
1/25/2016 7:50 PM

AP155 Cannot run, AP150 has not been run for this Process Group    

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
3333 1
by  dcaianiJump to last post
1/22/2016 4:34 PM

Add-in for invoice upload?    

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 3972 2
by  dcaianiJump to last post
1/22/2016 4:28 PM

AR Payment Interface    

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 2682 2
by  Todd MitchellJump to last post
1/22/2016 12:47 PM

AM20.4-Asset Book Does Not Exist    

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
4131 0
1/19/2016 6:25 PM

Enter L_HWSC table    

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 3145 0
1/19/2016 3:41 PM

Tables referred by AP230    

Started by  Deleted User
I'm trying to modify AP230 report. What all tables can I use
7 3971 1
by  pbelskyJump to last post
1/15/2016 5:14 PM

joining these 2 tables    

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 3749 1
by  John HenleyJump to last post
1/13/2016 12:26 PM

Date payment applied - AR    

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 3253 0
12/15/2015 11:48 AM

AP45.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 4164 1
by  Bob CanhamJump to last post
11/25/2015 7:37 PM

Clearing Line 0 in MA236    

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 3261 0
11/24/2015 7:25 PM

import payments into Lawson    

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 3617 1
11/19/2015 7:39 PM

Disabled Veteran's business    

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 3252 1
11/17/2015 2:05 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 10 of 37 << < 89101112 > >>


RSS Feed Available