Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Sytelineuser
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5198
People Online:
Visitors:
191
Members:
0
Total:
191
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1369
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
Financial Management
Forum:
Lawson S3 Financials
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.
Search this forum:
149
Subscribed to this forum
Page 1 of 37
1
2
3
4
5
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
PO Matched Dollars and Matched Quantity
Started By
Ann
Can anyone share the Lawson calculation to determine Purchase Order * Matched Dollars and * Matched Quantity Thank you,
0
3286
0
5/10/2024 6:51 PM
PO190 Last Run Audit
Started By
SSmith
Is there a way we can figure out what user ran last this program PO190
2
15289
0
by
John Henley
4/3/2023 3:14 PM
AC/BR/GM in foreign company
Started By
Joe Carfagno
We currently use AC, BR, and GM in one company that is USD. Our Sponsors are in the US. We are thinking of setting up AC, BR, and GM in other companies that use different currencies (GBP and Euros). Does anyone have experience using multiple currencies for Grants and billing in US. Any advice would be appreciated.
0
5534
1
3/7/2023 7:04 PM
AP20.1 Upload & MA43.1 Error
Started By
Cactus
Successfully uploaded in invoice to AP20.1 with an add-in. The message from the add-in was, 'Add complete - Voucher 767533'. So that was successful. But when the accountant goes to MA43.1 for the match, we get an error. Does anyone know if I can simultaneously upload to MA43.1 on the AP20.1 add-in What would be the solution to this. Thank You in advance.
0
2888
0
12/2/2022 1:36 PM
Add-Ins Upload to AP20.1 & Need Comments
Started By
Kris
We are mass uploading invoices to AP20.1 and would like to include Check Comments in the upload to get printed on the Cheques. Has anyone been successful in doing this Found this post, but don't know if anyone has been successful. https://www.lawsonguru.com/forums/financial/s3-financials/ap20-comments/ Any help would be greatly appreciated! Thanks Kris
8
50623
4
by
Cactus
12/2/2022 1:25 PM
MA540 Fatal Error Report: Discount Rate Required
Started By
SSmith
Need help in fixing fatal error: Discount rate required on MA540 fatal error report. MA54 shows the Discount Date but the Discount Rate and Amount fields are blank. The vendor in particular do not receive discounts. We setup the following substitution table but, still receiving error. Does anyone have any suggestions on how this can be corrected List name: L1_MAP_INV_TERMS Lawson Value: N External Value: Tpid
0
2750
1
9/23/2022 2:57 PM
Foreign Currency Payments
Started By
Boyd
Currently we are reconciling foreign currency payments using a two step process. We reconcile the USD amount in CB80. This results in a difference from what was processed in Lawson that is resolved in CB30. Is there a one step process to reconcile these payments All of the differences from CB30 are posted to the same realized Gain/Loss account.
0
2802
0
9/20/2022 3:16 PM
Migrating From Lawson To Oracle EBS GL
Started By
Andy
Can someone please help with the migration path from Lawson to Oracle Financials GL. More specifically, what do i need to do on the functional side. ThanksVery Much, Andy
2
30597
1
by
Ashwin
7/21/2022 1:31 PM
Extracting Received Not Invoiced (PO135) with SQL
Started By
mikekask
I am trying to automate the data gathering for an AP Scorecard report in Excel. Part of the info I need is the Received Date and the Current Amount for PO's that are received but not invoiced. This info prints on the PO135 report, but I would like to get the data directly with an SQL query through an Oracle Client. This can all be done with a VBA macro in Excel. I need to know what fields and tables to get the data from. I'm not sure if this type of thing is discussed in this forum or on this si...
5
34523
3
by
JonA
6/15/2022 2:29 PM
Extend Accounting Period End Date
Started By
lawsonny
Hello, I am new to Lawson and function as an administrator and I have a bit of a problem. I don't know how this happened, nor did my director explain it to me, but the current accounting period we are in is ending to early. It should end next week Saturday and I was told by Infor support that any transactions within the current period have to be reposted to another open period to initiate a change to an end date. To add another layer of complexity, we have assorted transaction in varying stat...
21
54452
1
by
lawsonny
4/29/2022 12:26 AM
RW Reports and Acct Groups
Started By
TMcAuley
I just added several new accounts to our GL. We have a large selection of reports in RW and a lot of them use Account Groups. I have three Account Groups that might need these new accounts included, but I can't tell what reports are using them in order to see the purpose for the grouping. What I was hoping to find was a report that would list all of the report names that use each of these account groups.
3
30633
1
by
TMcAuley
4/28/2022 9:07 PM
MHC Invoice Images in Crystal Reports
Started By
dcaiani
We are using MHC Ix Entry I need some help getting image links in Crystal Reports that will reside on LBI. Is anyone else out there doing the same Please help!
0
3477
0
4/18/2022 8:52 PM
Revenue Recognition from BL
Started By
Carol S
Is it possible to add an invoice in BL and still do revenue recognition If so, how do you set up the activity to do revenue recognition only
1
32851
1
by
Ken U
2/9/2022 12:09 AM
AP03.1 data issues
Started By
Chris Willhoite
Our AP team uses attributes on the vendors, and the data that displays in the AP03.1 screen does not match the data in the APVNMXVAL table. This is causing issues with integrations with other applications and reports. As a test I updated the data in AP03.1 and the database does not update. Is there another table that AP03.1 may be linked to or another reason that the data is not the same between Lawson and the database
3
34771
1
by
John Henley
12/27/2021 10:56 PM
Lawson manuals
Started By
Deleted User
I am new to Lawson and my company does not have any manuals for the GL package. Is there anywhere I can get a good manual on Lawson GL
3
76249
2
by
Jay
12/7/2021 4:38 PM
Bad File status 3 5 on sortfile
Started By
Vijay S
I got an error Bad File status 3 5 on sortfile in IC130(General Ledger Interface) and job went to needs recovery state. Again Submitted the job, It completed successfully . What could have been the most probable reason(s) for its failure Regards, Vijay
1
45553
0
by
LauaLuau
10/1/2021 4:45 PM
Posting to AP30.2 Error
Started By
Ruchika
Help!! Anyone know how to solve this problem. When we enter PO invoices in AP20.2 some don't post to AP in AP30.2 form. We cannot figure out why or how to fix it. They are all random invoices so no commonality. This started with the recent upgrade. Any suggestions
0
3148
0
7/30/2021 6:29 PM
cancel matched invoice that is out of balance
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'. I show no payments associated with this invoice. Thank you, Kenny Brewer
4
59172
2
by
john44
5/4/2021 10:38 PM
v10 Audit (AC, AP, AM, GM...) Tables
Started By
Dave K
Does anyone have a list of tables and their fields
1
38662
0
by
Ragu Raghavan
4/30/2021 5:02 PM
Quarterly Payment Terms
Started By
lvlawson
A/P Manager is requesting to pay a supplier quarterly at the end of each quarter for all invoices in that quarter. Sounds like a proxy term but not seeing an option to build a proxy term for anything but monthly. I was able to gather all invoices for a single month and push payment out two months but that is not the desired outcome. Are quarterly proxy terms possible (I.e. all Jan, Feb, Mar invoices due Apr 1)
0
2747
0
4/21/2021 12:35 AM
Company Control
Started By
bobc
We have numerous companies in Lawson for our Finance users and we have moved from LAUA security to Lawson security. I haven't been able to figure out how to restrict security classes to certain companies. I was able to restrict access by process levels with this element: if(user.attributeContains('ProcessLevelControl',PROCESS_LEVEL)) 'ALL_ACCESS' else 'NO_ACCESS' and entering the process levels in the ProcessLevelControl field in the user's profile but it doesn't seem to work with ...
0
2701
1
3/26/2021 3:08 PM
GL01.4 flags
Started By
Dennis Amory
The flags on our GL01.4 screen have been mysteriously reset. That has messed up the commits and encumbrances of our PO's. Based on our data backups we could tell those flags were set correctly as recently as 2 weeks ago. Is there an audit screen or tool I could use to determine when the flags were reset/cleared, and by whom Grateful for any assistance.
1
49971
0
by
Dennis Amory
3/23/2021 6:48 PM
Ma540 sample
Started By
Peter Griffen
Hi everyone Does anyone have a sample ma540 file that would work for a three way match I'm am having some issues with the match and am having a hard time tracing the problem. Thanks
18
52709
5
by
Rani Ilapa
3/2/2021 1:00 AM
AP Open Invoice Report
Started By
Rajashanmugam
Open Invoice Report. Need to create one. My Manager wants to see the combination of AP150 and AP136 before running AP150. They want to run this report on demand and decide which invoice is to be paid and which one is not to be. Researched and looked into AP20 and AP30 screens along with AP150 and AP136's table list here in LawsonGuru.com. The list is long. Started with APINVOICE, looking into APDISTRIB, but stuck here. Business users are not as much help as they also do not know how to h...
3
44101
0
by
Rajashanmugam
1/7/2021 10:48 PM
Duns Numbers for Vendors
Started By
Christina C
Is there a field where the DUNS number can be maintained for a vendor
2
45351
1
by
Tim Alessi
12/8/2020 10:45 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 1 of 37
1
2
3
4
5
>
>>
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
Lawson Design Studio
--Lawson Smart Office
Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft Office
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PSA/SA)
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operations
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/Reporting/Crystal
Smart Notification
--Lawson M3 Business Performance Warehouse
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support