|
|
|
|
|
|
|
3 Replies and 74363 Views and 2 Subscribers
Lawson manuals
74363
3
2
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&160;manual on Lawson GL
|
|
|
|
3 |
74363 |
2 |
by Jay 12/7/2021 4:38 PM |
|
4 Replies and 57885 Views and 2 Subscribers
cancel matched invoice that is out of balance
57885
4
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
|
|
|
|
4 |
57885 |
2 |
by john445/4/2021 10:38 PM |
|
5 Replies and 33319 Views and 3 Subscribers
Extracting Received Not Invoiced (PO135) with SQL
33319
5
3
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 |
33319 |
3 |
by JonA6/15/2022 2:29 PM |
|
|
3 |
51831 |
2 |
by Jeremy6/8/2020 6:25 PM |
|
10 Replies and 52131 Views and 1 Subscribers
AP160 and AP161
52131
10
1
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 ...
|
|
|
|
10 |
52131 |
1 |
by Raymundo Romero8/26/2020 4:44 PM |
|
7 Replies and 52281 Views and 4 Subscribers
Upload Assets to AM Module
52281
7
4
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
|
|
|
|
7 |
52281 |
4 |
by BUSLAWSON12/8/2020 5:49 PM |
|
2 Replies and 29380 Views and 1 Subscribers
Migrating From Lawson To Oracle EBS GL
29380
2
1
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 |
29380 |
1 |
by Ashwin7/21/2022 1:31 PM |
|
1 Replies and 44191 Views and 0 Subscribers
Bad File status 3 5 on sortfile
44191
1
0
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 |
44191 |
0 |
by LauaLuau10/1/2021 4:45 PM |
|
4 Replies and 55125 Views and 2 Subscribers
Infor’s Lawson Accounts Payable Invoice Automation system
55125
4
2
Started by DougAB
I'm curious to know if anyone uses Infor’s Lawson Accounts Payable Invoice Automation system, or any invoice automated system. We deal with many suppliers that send their invoices via EDI, email, and csv files. We want a way to flow these invoices into Lawson and automate the matching process. We'd deal with the fallouts thereafter. Any help is appreciated. Thanks.
|
|
|
|
4 |
55125 |
2 |
by BigEasyNO7/15/2019 5:32 PM |
|
2 Replies and 42570 Views and 1 Subscribers
Cannot delete non-GL journal entries GL45
42570
2
1
Started by Ariel
I am trying to delete some old entries that are lingering in GL45. However, I am unable to delete those Journal Entries that are in an unreleased state. The error message that I receive is: 'Cannot delete non-GL journal entries'. Any insight on this is much appreciated. I've been carrying stuff forward for years now and would just like to get it out of there. Thanks, -Ariel
|
|
|
|
2 |
42570 |
1 |
by Patricia Wilson9/12/2018 1:53 AM |
|
4 Replies and 44290 Views and 1 Subscribers
1099 electronic file IRS interface
44290
4
1
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. http://www.irs.gov/pub/irs-pdf/p1220.pdf Contact the IRS 1-866-455-7438 1-304-263-8700 (International) ...
|
|
|
|
4 |
44290 |
1 |
by JimY3/26/2019 9:57 AM |
|
18 Replies and 51506 Views and 5 Subscribers
Ma540 sample
51506
18
5
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 |
51506 |
5 |
by Rani Ilapa3/2/2021 1:00 AM |
|
8 Replies and 49240 Views and 4 Subscribers
Add-Ins Upload to AP20.1 & Need Comments
49240
8
4
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 |
49240 |
4 |
by Cactus12/2/2022 1:25 PM |
|
3 Replies and 52315 Views and 2 Subscribers
GL20-Accounting Unit/Account Code Combinations
52315
3
2
Started by Sami117
We have several accounting units that are mapped to various GL Account codes per GL20.2. We have one accounting unit for balance sheet transactions, but we discovered several income statement accounts with exists as 'yes' on the GL20.2 for the balance sheet unit. We don't want individuals accidently coding transactions improperly so we need to turn the exists from 'yes' to 'no.' We have shut off dynamic account generation to prevent the exists from being turned automatically to 'yes' if someo...
|
|
|
|
3 |
52315 |
2 |
by anu singh6/20/2019 3:52 PM |
|
3 Replies and 50331 Views and 0 Subscribers
GTIN
50331
3
0
Started by Chesca
Is anybody already using GTIN If yes, could you please help me determine how these are assigned We are planning to start using GTIN's.
|
|
|
|
3 |
50331 |
0 |
by Marisol6/20/2019 7:02 PM |
|
14 Replies and 53903 Views and 4 Subscribers
PO100-Purchase orders
53903
14
4
Started by Chesca
For some strange reason, all of the sudden the PO100 auto job is now creating purchase orders intol 1 single PO for different ship to locations/Pyxis locations. We need to have 1 purchase order created for Each Separate Location. So if we have orders from Location 1X & 2X for example - these must each get their own PO number. They can not be combined into 1 Purchase Order. Up to RQ500 the settings/parameters were fine and it created individual source documents.. Once the PO100 ran - it took...
|
|
|
|
14 |
53903 |
4 |
by Kat V12/23/2019 7:22 PM |
|
2 Replies and 52339 Views and 2 Subscribers
Upgrade from V10 to V11
52339
2
2
Started by Michelle Hager
We are headed to the West Coast Mega Meeting in Newport Beach, CA in a few weeks and we would love to chat with someone who is in a healthcare setting who has gone through the upgrade from V10 to V11. Does anyone know of a company that has It doesn't necessarily have to be in a healthcare setting also. Thanks.
|
|
|
|
2 |
52339 |
2 |
by Declan Bilyew5/10/2019 7:05 PM |
|
1 Replies and 42097 Views and 2 Subscribers
SOP for Procurement and AP on Vendor Return
42097
1
2
Started by MChism
I'm struggling to find the accurate process for both purchasing and accounts payable to process a return. Our issue with our current process is that our purchasing team will process a return in PO31 for an item. The credit will then be processed by accounts payable and will keep the PO closed. When the replacement item comes in, AP attempt to match to the same PO as referenced on the invoice and they will receive an error that the credit can not be processed on a closed PO. I feel that there...
|
|
|
|
1 |
42097 |
2 |
by Jeremy9/5/2018 4:43 PM |
|
2 Replies and 44330 Views and 1 Subscribers
Duns Numbers for Vendors
44330
2
1
Started by Christina C
Is there a field where the DUNS number can be maintained for a vendor
|
|
|
|
2 |
44330 |
1 |
by Tim Alessi12/8/2020 10:45 PM |
|
2 Replies and 50385 Views and 1 Subscribers
Down Payment or Prepayment Process
50385
2
1
Started by Jeremy
Hi all. I seem to be striking out on my forum posts lately, but thought I'd try one more: In researching ways to improve our processing, the issue of what we call 'partial billing' or prepayments has come up. I was hoping to get insight into how others handle these situations. Here's what I'm talking about: We have a need to cut a PO to a vendor and the vendor is demanding a partial or down payment of 80 up front. Then, once the installation is done we will get another invoice for the rem...
|
|
|
|
2 |
50385 |
1 |
by Jeremy4/28/2020 7:41 PM |
|
3 Replies and 41055 Views and 3 Subscribers
Changing GL from 12 to 13 Periods
41055
3
3
Started by ksp
Our idea is to have the 13th period in order to post entries specific to year end such as inventory adjustments, audit adjustments, etc. We'd like the 13th period to be the last day of our fiscal year. I am concerned about: subsidiary modules such as AP, Asset Management, IC, AR, etc being somehow negatively impacted by the change. Also is it possible for the end of the 12th month to be 9/30/20xx and also have the 13th month begin and end date 9/30/20xx Has anyone else made this change ...
|
|
|
|
3 |
41055 |
3 |
by Boyd4/1/2020 6:51 PM |
|
2 Replies and 43887 Views and 0 Subscribers
Invoice Void Audit
43887
2
0
Started by FrozenIT
Hello Everyone. I'm trying to get a list of invoices that have been voided out of our system. Oftentimes they're rebuilt, and I can't get a good list from AP135, as the void process seems to wipe the change audit for that invoice number. I'm trying to find out who and why voided the invoice in the first place, but can't get any good information, either through reports or through the database. FYI, Cloud-hosted, v10, MS environment. Thanks very much for any ideas.
|
|
|
|
2 |
43887 |
0 |
by FrozenIT9/10/2018 11:59 PM |
|
1 Replies and 41166 Views and 0 Subscribers
AP Distribution User Field
41166
1
0
Started by Debra Jones
I'm new to Lawson and not sure of how the tables interact. I currently need help in creating a report which lists the invoice , date, amount and Distribution User Field 5 that's coming from the Ap22.5 form. Is there anyone that could direct me to the correct table joins
|
|
|
|
1 |
41166 |
0 |
by Kelly9/11/2018 6:58 PM |
|
1 Replies and 35175 Views and 0 Subscribers
Required Fields
35175
1
0
Started by Maria
Is it possible to make certain fields required in Lawson 9.01 We are integrating with a procurement company for our PO/Invoicing process. We will need to send them a supplier feed, but when setting up suppliers in the AP10.1 screen most fields are not required. Is there a way to make them so Thank you!
|
|
|
|
1 |
35175 |
0 |
by Ragu Raghavan9/15/2018 1:54 PM |
|
3 Replies and 45682 Views and 1 Subscribers
GLCHARTDTL description update
45682
3
1
Started by Chesca
Hello, the finance team asked IT to update some of the descriptions and we have no idea what Lawson GL screen update the GLCHARTDTL description update, could someone please tell me what screen updates the GLCHARTDTL or could we update the account descriptions
|
|
|
|
3 |
45682 |
1 |
by Deron9/20/2018 7:31 PM |
|
0 Replies and 2811 Views and 0 Subscribers
MA60.3 - Filtering results
2811
0
0
Started by Bev Edwards
When we navigate to MA60.3, we are seeing all lines for Invoice and PO., Is there a way to filter and only see the lines that need to be fixed instead of having to page through one by one
|
|
|
|
0 |
2811 |
0 |
9/26/2018 2:05 PM |
|
0 Replies and 6631 Views and 0 Subscribers
Disc Date vs. Due Date
6631
0
0
Started by Christina C
We have many of our terms set up with a discount and net due. For example, 2 10 days with Net due 30 days. However, we are finding that our payment runs are pulling invoices by the due date, not the discount date. How can we have the discount drive the payment date Thank you!
|
|
|
|
0 |
6631 |
0 |
9/28/2018 5:12 PM |
|
1 Replies and 46152 Views and 0 Subscribers
Matching GLTrans to Invoices/PO
46152
1
0
Started by DennisJMitchell
Is it possible to match information from a general ledger adjustment to a PO or Invoice I have dumbed every table I can think of to find something I can use to tie the GLTrans information to a PO or invoice. The system code for the adjustment I am looking for is IC (Inventory Control). Are there definitions available for the system codes (IC, OE, PO, WO, PH) so I can see if IC type system codes even tie back to an invoice or PO
|
|
|
|
1 |
46152 |
0 |
by Kat V10/9/2018 1:09 PM |
|
2 Replies and 35699 Views and 0 Subscribers
Fiscal date mapping
35699
2
0
Started by Chesca
I have a query that pulls Purchase orders from POLINE, PURCHORDER, and MMDIST. I having a hard time mapping the fiscal year, does someone know how to get the fiscal year for each po
|
|
|
|
2 |
35699 |
0 |
by Chesca10/12/2018 6:29 PM |
|
5 Replies and 50707 Views and 1 Subscribers
MA540 Fatal Records Not Loading to MA54
50707
5
1
Started by Jeremy
Hi. I'm seeing an issue where invoices that have a fatal error (many invoices that error out for us are after the closing control date) do not load to the MA54 for some reason. Once they encounter a fatal error, they just are 'skipped' and don't load into the MA54 tables at all. Has anyone seen this before Is it a setting Should they not at least load to MA54
|
|
|
|
5 |
50707 |
1 |
by Jeremy8/5/2020 3:05 PM |
|
|
1 |
39294 |
0 |
by Kat V11/26/2018 5:40 PM |
|
4 Replies and 45337 Views and 1 Subscribers
Accounts Payable Workload Metric for Lawson?
45337
4
1
Started by NBayless
Hello, I just joined the group today, so if this is in the wrong place I apologize. I'm a new Lawson user, and just got an AP Manager job a few months ago. I'm having problems getting any kind of report that can help measure AP workload, specifically how many invoices in a certain amount of time that each processor processes. This is probably even the most important AP metric there is. Right now I have no idea how to measure workload. I've been told by our Accounting Manager that this d...
|
|
|
|
4 |
45337 |
1 |
by O. Johnson12/17/2018 4:13 PM |
|
2 Replies and 44595 Views and 1 Subscribers
PO135 already run in update mode
44595
2
1
Started by Chesca
Is there a way we can figure out what user ran this program in update mode This program is usually run in report mode
|
|
|
|
2 |
44595 |
1 |
by Chesca12/20/2018 5:55 PM |
|
1 Replies and 40968 Views and 0 Subscribers
PO Subsystem set up
40968
1
0
Started by AndreaS4
Hello, We are adding a new hospital group. This is the first company I have had to add since we went live. I have not had an issue with most things, but I am not sure how to set up the PO subsystem. I will not be able to close on month end unless this is set up. Any and all help is appreciated. Thank you, Andrea
|
|
|
|
1 |
40968 |
0 |
by Kat V12/21/2018 6:54 PM |
|
6 Replies and 54178 Views and 0 Subscribers
RNI Report (PO135) cleanup and fix
54178
6
0
Started by rad206
Hi! Hoping someone might have some suggestions or help. After reviewing our PO135 report, we see there are a a lot of line items that are well over 6 months (some going back as far as 2017 even!). After doing a review, we can see several POs and vendors that were definitely paid, however, it appears our AP clerk forced a lot through the system without matching the invoice to a PO. Our PO135 reports is just over 5,000 line items large, and so far, we have identified close to 3,000 tha...
|
|
|
|
6 |
54178 |
0 |
by Russ8/5/2020 3:32 PM |
|
1 Replies and 49180 Views and 1 Subscribers
How to set up new printer in LID on Windows 7
49180
1
1
Started by mland
I am trying to set up a new printer in LID. When I log into Lawson test portal, the printer shows up in the dropdown list but I get the error 'Error occurred during printing'. Is there a step I am missing
|
|
|
|
1 |
49180 |
1 |
by JimY1/8/2019 11:07 AM |
|
1 Replies and 43945 Views and 0 Subscribers
One invoice to multiple PO's
43945
1
0
Started by pglibra
Good morning, I was asked to find out if anyone is applying one invoice to multiple PO's. If so, how is that setup in Lawson Thank you PG
|
|
|
|
1 |
43945 |
0 |
by JonA1/16/2019 6:24 PM |
|
1 Replies and 47273 Views and 0 Subscribers
EDI and Wire Transfers
47273
1
0
Started by JonA
Anyone processing invoices through MA540 and paying the vendor through wire transfer
|
|
|
|
1 |
47273 |
0 |
by SWilkins1/23/2019 6:18 PM |
|
5 Replies and 49989 Views and 1 Subscribers
AP Query
49989
5
1
Started by Boyd
I am looking to create a query that includes vendor , vendor description, payment and payment date. Any thoughts or help is appreciated.
|
|
|
|
5 |
49989 |
1 |
by Boyd2/18/2019 2:22 PM |
|
1 Replies and 48146 Views and 1 Subscribers
Report Writer Question
48146
1
1
Started by Okcard57
We are currently working on the implementation of S3. I've been tasked with creating all of our financial reports in Report Writer. Eventually we will implement Birst and move most reporting to Crystal, but initially we will be using the canned report writer within Lawson. My question is, is there a way to hide rows that return no data within RW10 I have the majority of the reports created, but am unable to figure out a way to hide these rows. It makes the reports look bad when ran for L...
|
|
|
|
1 |
48146 |
1 |
by jrbledsoe2/9/2019 1:40 AM |
|
4 Replies and 44493 Views and 2 Subscribers
AR Period Close error
44493
4
2
Started by Paul
Hi , In error we have closed the AR period before running the AR190 Report which pushes through all the periods transactions in to GL, there doesn't appear to be an option to reopen the period or to run retrospective. We are faced with having to go through every invoice batch and make manual journals in to the GL , is this really the only option, we really need to reopen the period if possible
|
|
|
|
4 |
44493 |
2 |
by Jason Beard2/10/2019 12:23 PM |
|
2 Replies and 45874 Views and 2 Subscribers
MA540 Fatal Error
45874
2
2
Started by apurdion
I have been sucessfully uploading invoices via MA540, but when I add an invoice that has a 'Location' specified I get the error 'Problem: Location 1 not defined for company 0001' The location is available and active. I can manually add an invoice via AP20 using said 'Location'. Any ideas
|
|
|
|
2 |
45874 |
2 |
by Joan at Stony Brook7/30/2020 5:16 PM |
|
2 Replies and 47573 Views and 1 Subscribers
900-FIND-BEGRNG-CMT-PURCHORDER
47573
2
1
Started by Chesca
Hello, I am viewing a custom program and came across this API 900-FIND-BEGRNG-CMT-PURCHORDER and have no idea what it does and can't find any documentation. Is this supposed to be a data file o database
|
|
|
|
2 |
47573 |
1 |
by Ragu Raghavan2/28/2019 5:20 PM |
|
3 Replies and 46367 Views and 1 Subscribers
Lawson and accounts payable
46367
3
1
Started by wat444
I'm new to this site and new to Lawson as well. I'm in accounts payable and to say that I'm confused would be an understatement! Beyond frustrated that at this point we pretty much only know how to scan and code non p.o invoices. Any basic information would be huge! How can I settle with statements that come in How can I view invoice status
|
|
|
|
3 |
46367 |
1 |
by jrbledsoe3/6/2019 3:05 PM |
|
0 Replies and 3242 Views and 0 Subscribers
GL ZONE
3242
0
0
Started by Raymundo Romero
Hi, I'm doing a research to create a new zone in our GL, but I would like to know if can iIdo it without the need to create a process Level. Thank you All for your help.
|
|
|
|
0 |
3242 |
0 |
3/12/2019 9:07 PM |
|
1 Replies and 47827 Views and 1 Subscribers
Ways to hide GL codes from end users
47827
1
1
Started by Erik G.
Good Afternoon all, Not sure if this belongs here or in the supply chain forum but I need to know if anyone knows of a way to limit what GL codes are visible for an account unit in version 10. We have a situation where one of my RQC users was doing a special order and used a patient charge code instead of a supply code. The GL code is valid and needs to remain active for the account unit but we are hoping to find a easy way of hiding them from our RQC users. Anyone have any ideas or sug...
|
|
|
|
1 |
47827 |
1 |
by Kat V3/15/2019 1:24 PM |
|
2 Replies and 47005 Views and 0 Subscribers
New Company Setup in S3
47005
2
0
Started by Heath Davis
Does anyone have a project plan or checklist to use when defining a new company in Lawson S3
|
|
|
|
2 |
47005 |
0 |
by Lynnette4/5/2019 12:25 PM |
|
2 Replies and 48321 Views and 0 Subscribers
AM15.3 error
48321
2
0
Started by RW
Hello, I am getting this error and can't figure out how to correct it. &91; 08:13:08 - AM15.3 &93; 011122000 is not included in account generation list Thanks for the help. Rene'
|
|
|
|
2 |
48321 |
0 |
by RW3/27/2019 2:06 PM |
|
0 Replies and 2823 Views and 1 Subscribers
Lease Compute Statements
2823
0
1
Started by Bob Canham
We are just starting to look at using Lawson's Lease Management module in order to track leases with the new regulations. We're coming up with various scenarios to see how they would work in the new system. One that I'm curious how people are using is compute statements for payments. As an example, we have a lease that has a Year 1 base amount and then increases annually at a percentage of the CPI index increase. I was looking at the computes, but we've really only used them with old rep...
|
|
|
|
0 |
2823 |
1 |
4/10/2019 4:43 PM |
|
4 Replies and 42419 Views and 0 Subscribers
general ledger posting dates
42419
4
0
Started by Dan Guszregan
After the closing of period 7 it was discovered that there were two PR entries in period seven with posting date for period 4 and period 6. We need to fix these dates into period 7. I have opened period 7 for back posting and tried to un-release the two entries so I could correct the dates but the system will not allow that. Is there a way to correct these dates Our concern is if we have to open up to say period six to do some correction then the one PR entry dated within that period will t...
|
|
|
|
4 |
42419 |
0 |
by Dan Guszregan4/24/2019 5:43 PM |
|
3 Replies and 48502 Views and 1 Subscribers
HotKey not working in IE
48502
3
1
Started by Seathreads
An S3 Financial user had been able to use this hotkey combo to see which table a particular field is being pulled from, CtrlShiftO. It no longer works. I have performed all of the normal IE troubleshooting steps to no avail. We have actually uninstalled the newest version of Java and installed and older version. I am not familiar with Lawson, I am the Help Desk Sup but our Lawson Expert prefers to put tickets in with Infor than to post on forums. I prefer the people's voi...
|
|
|
|
3 |
48502 |
1 |
by Tim R4/26/2019 7:28 PM |
|
1 Replies and 45264 Views and 0 Subscribers
Changing a Recurring Journal
45264
1
0
Started by jefriedman
We are looking for a way to secure recurring journals by having them go for reapproval if they are changed in terms of dollar amount, cost center, GL, etc. Right now, they get approved on the front end, but after that changes can be made without an additional approval needed. Does anyone have experience with this scenario Thanks, Jerry
|
|
|
|
1 |
45264 |
0 |
by Carol S5/17/2019 5:26 PM |
|
5 Replies and 45819 Views and 0 Subscribers
Implementing EDI 810
45819
5
0
Started by jefriedman
Hello All, We want to set up EDI 810 just for one vendor. All invoices will be against POs. I've been reading the EDI user guide and had some questions. Does ED502 have the ability to translate standard X12 built-in, or do we have to load some kind of field map What errors would prevent an invoice from being accepted into ED502 In this case would an error message go back to the vendor Do qty and price errors prevent an invoice from loading Our single trading partner w...
|
|
|
|
5 |
45819 |
0 |
by JonA5/14/2019 12:24 PM |
|
2 Replies and 47971 Views and 0 Subscribers
Sample EDI 810 maps
47971
2
0
Started by jefriedman
Hello All, We're trying to gather as much information as we can for a possible move to EDI (just 810 for invoices for now). Would anybody like to share the fields they use for EDI 810, as well as their mapping to MA540 We looking at office supplies, basic IT hardware, etc. No services. Thanks, Jerry
|
|
|
|
2 |
47971 |
0 |
by jefriedman5/31/2019 9:13 PM |
|
0 Replies and 2872 Views and 0 Subscribers
AR30 Automation
2872
0
0
Started by Anthony
My Finance team is trying to automate the process of selecting a invoice that gets paid on the check listed in the header section of AR30. What they do is: “We first add the payment in AR30.1 once the batch is created by giving it the batch number we created, adding the pmt number, paid amount on the check, and customer number with the date we received the money. Then hit add to add the payment. Then the manual work begins by having to put an A for add next to each invoice that gets paid...
|
|
|
|
0 |
2872 |
0 |
6/4/2019 3:48 PM |
|
0 Replies and 2551 Views and 1 Subscribers
AR20
2551
0
1
Started by Dennis Amory
I need to know who released a specific AR batch. I can see the operator that created the batch in AR20. Is there a way to determine who released that batch
|
|
|
|
0 |
2551 |
1 |
6/24/2019 1:41 PM |
|
1 Replies and 39145 Views and 0 Subscribers
Lawson ACTOR ID & LAWPROD10X & SSOP
39145
1
0
Started by ALW
We are migrating to a new Domain and to Lawson 11. I need to create a SQL Script to list out all the Lawson Actor ID's and their corresponding LAWPROD10x and SSOP settings. Example: ACTORID = somones.name LAWPROD10x = domain\somones.name SSOP = someones.namedomain.net I cannot find what table contains the LAWPROD10X and SSOP fields so I can list them. Can anyone please help me identify the table(s) that these two fields exist in Thank you in advance. Allen
|
|
|
|
1 |
39145 |
0 |
by JimY7/8/2019 4:01 PM |
|
1 Replies and 36324 Views and 0 Subscribers
GL Balance Rollover
36324
1
0
Started by Anthony
How do you roll GL balances over from year to year Thank You
|
|
|
|
1 |
36324 |
0 |
by RonT7/10/2019 1:49 PM |
|
2 Replies and 43630 Views and 0 Subscribers
EDI 810 Delay
43630
2
0
Started by Casy
We are looking for a way to delay the EDI 810's. The ED502 job is basic and doesn't have any date parameters so it just goes out to our GHX server and picks up all the files in the mmis_in folder. These get processed in and many of them fail on MA54 due to PO issues. We were wondering if there was a way to delay them by a few days so that it gives the PO's time to come in and be received. Anybody have a way to do this
|
|
|
|
2 |
43630 |
0 |
by Alex Tsekhansky7/29/2019 5:32 PM |
|
4 Replies and 48346 Views and 0 Subscribers
Unique Identifer from GLTRANSREL to GLTRANS
48346
4
0
Started by Sam Mathew
Hi Everyone, I am trying to uniquely pin point transactions from GLTRANSREL table to GLTRANS , how can we achieve this is there a column where you can add a unique identifier which gets populated in GLTRANS once journals are posted Thanks Sam
|
|
|
|
4 |
48346 |
0 |
by Sam Mathew7/26/2019 5:16 PM |
|
1 Replies and 42627 Views and 1 Subscribers
Issues with AP 161 generated file and ED501 translation for 820
42627
1
1
Started by UD
We are having issues getting the Lawson generated AP161 PAYMENT file to translate into an 820. There was no REMIT file generated. Is that an issue Or should we keep looking at trading partner setup In the AP161 flat file, where is the trading partner ID located, and would it make a difference if it was not found The error we get is simply, no data to be translated. Anyone have experience with an issue like that Not attaching the file for obvious reasons, but can answer questions about sp...
|
|
|
|
1 |
42627 |
1 |
by UD7/30/2019 2:19 PM |
|
2 Replies and 46885 Views and 0 Subscribers
PO64 not accessible
46885
2
0
Started by wat444
I currently don't have access to PO64 (still waiting a week after putting in a service now ticket). Is there another report I could use in the meantime that would give me similar information about matching and/or unreleased invoices
|
|
|
|
2 |
46885 |
0 |
by wat4448/9/2019 1:43 PM |
|
2 Replies and 42831 Views and 0 Subscribers
EDI Freight Build
42831
2
0
Started by Casy
We currently use GHX to interface our EDI messages from vendors. We have a record on ED40 for an Add-On cost of Freight. Since GHX sends the code 'G830' in the EDI message, that is how we currently have the ED40 record driven. We would like to somehow have the freight be disbursed based on Process Level of the Purchase Order instead of all Freight going to the 1 AOC code. Is this possible when interfacing with GHX Thank you!
|
|
|
|
2 |
42831 |
0 |
by Casy8/19/2019 6:56 PM |
|
2 Replies and 48286 Views and 0 Subscribers
Automate data import
48286
2
0
Started by Wai Cheng
I'm trying to Automate credit card transaction upload into lawson. The business has a uwf file that they use with the upload addins. What is the best way to do the upload M3 API is there a command line option for the upload addins I found these two links https://www.lawsonguru.com/forums/ux/office-addins/automating-excel-addin-je-import-with-vb/ https://m3ideas.org/tag/api/
|
|
|
|
2 |
48286 |
0 |
by Wai Cheng8/13/2019 5:30 PM |
|
0 Replies and 2500 Views and 0 Subscribers
How to completely remove journals using SQL
2500
0
0
Started by Sam Mathew
In Lawson General Ledger, How can we complete remove journals using SQL. I noticed the journals are still present even after deleting rows in GLTRANS How can i completely remove them without using GL146
|
|
|
|
0 |
2500 |
0 |
8/20/2019 6:23 PM |
|
0 Replies and 2451 Views and 0 Subscribers
Lease Management - Operating Lease JE Timing
2451
0
0
Started by Bob Canham
We are working on implementing Lease Management so we can support the new reporting requirements for Long Term Operating Leases. As we're working through testing, we're running up against a block trying to understand when the various journal entries should be hitting our general ledger. I'm hoping someone out here has done this and can point us in the right direction. The difficulty we're having is due to the payment timing. Most of our leases are due by the 1st of the month and are fo...
|
|
|
|
0 |
2451 |
0 |
8/26/2019 5:10 PM |
|
1 Replies and 48210 Views and 1 Subscribers
Credit Memo's tied back to PO's
48210
1
1
Started by Casy
The status of the return will not close if the credit amount does not match the return amount to the penny. We believe it will be on supply chain to review the difference between the credit amount and the return amount to determine if the difference is acceptable before they close the return. We need to come up with a process to close the Return Number when the credit memo and return value do not match to the penny. We need the Status to show Closed so we will know by looking at the list what...
|
|
|
|
1 |
48210 |
1 |
by tgmc82502/12/2020 3:03 PM |
|
2 Replies and 43481 Views and 0 Subscribers
Needing to open mutiple accounts in GL20.2
43481
2
0
Started by Ronnie
We have over 500 accounting units that we need to open a certain account for on GL20.2 Is there an easier way than going to each on GL20.1 and the accounts button and then opening the accounts from there one by one Is there a way to mass open an account for ALL of our accounting units I asked lawson support, but they only pointed me to GL222 which is just a report of which ones already have it open, but completely avoided my question of a way to mass open for all.
|
|
|
|
2 |
43481 |
0 |
by Ronnie11/15/2019 3:11 PM |
|
0 Replies and 2854 Views and 0 Subscribers
CB10, CB10.3, CB10.4 Addin (self-contained)
2854
0
0
Started by giesewendy
Does anyone have Addins for CB10, CB10.3, CB10.4 in a self-contained file Or even in split versions for header and then detail If you do an can share, thanks in advance. Thank you.
|
|
|
|
0 |
2854 |
0 |
12/4/2019 8:25 PM |
|
8 Replies and 50715 Views and 1 Subscribers
AP Check Comment Tables
50715
8
1
Started by Casy
I am working to query the check comments using SQL. I have located the comment tables L_D*** or L_H*** but am not able to locate the actual check comments. They are not located in any of the obvious L_HAP* or L_HCB* tables. Has anyone located them or found a way to decipher these L_ tables to know which apply to what part of the system Some are obvious, others not so much. Thank you!
|
|
|
|
8 |
50715 |
1 |
by Casy1/2/2020 8:38 PM |
|
2 Replies and 49081 Views and 0 Subscribers
Process and/or tools for protected data
49081
2
0
Started by Bruce Havelock
Is anyone dealing with protected data that comes across in requisitions, invoices, or GL We are looking to network and share best practices, as our compliance division has put our Infor systems under scrutiny for not having processes in place to protect sensitive data (in this case, Protected Health Information or PHI). Thanks! Bruce
|
|
|
|
2 |
49081 |
0 |
by Kat V1/3/2020 2:22 PM |
|
0 Replies and 2782 Views and 0 Subscribers
AP invoices not flowing to Asset Management system
2782
0
0
Started by alloret
Our system is supposed to allow AP invoices to flow through to the asset management system and create an asset automatically. We are coming across an issue where some of these are not flowing through. Nothing shows up on error reports that would give us a clue as to where the invoice is being held up, on our side we can see a variance but we can't figure out why an asset wasn't created for it. What troubleshooting options do we have at this point
|
|
|
|
0 |
2782 |
0 |
1/15/2020 9:35 PM |
|
3 Replies and 42935 Views and 1 Subscribers
Infor Lawson RW100 Saving Multiple Reports?
42935
3
1
Started by Kosmo
Hello, Going to try my luck here. Is there a way that I can save multiple reports in from the Print manager We typically use the RW100 to generate our financial reports. I know we can access our print manager folders to get the excel versions of reports that are generated, but it seems that PDF reports do not generate in the print manager folder until you open them up in lawson's print manager. Is there a way that we can save mass reports in PDF I have to manually open close to 300...
|
|
|
|
3 |
42935 |
1 |
by Ragu Raghavan1/16/2020 4:28 PM |
|
0 Replies and 2981 Views and 0 Subscribers
SQL query for GL-290 Report
2981
0
0
Started by zammyC
hi All Has anyone used a SQL query fo run GL-290 Report from Lawson database Thanks Sam
|
|
|
|
0 |
2981 |
0 |
1/29/2020 8:02 PM |
|
3 Replies and 49526 Views and 2 Subscribers
AR575 vs AR580
49526
3
2
Started by mikefortuna
We have been using AR575 for a while, but the AR580 file format is much simpler. It seems that AR575 contains a lot of parameters in the input file, while AR580 uses a lot of these as job parameters. What are the differences, if any, in using AR580 for cash application vs AR575
|
|
|
|
3 |
49526 |
2 |
by Todd Mitchell2/21/2020 4:09 PM |
|
2 Replies and 49373 Views and 2 Subscribers
New Payroll GL interface to Lawson Financials
49373
2
2
Started by Bonisick
Hi all. Could use some guidance and reference points on best practices and lessons learned re' integrating a payroll solution to Lawson financials. Anyone have advice or sample file specs, etc. they would share Thanks, Bill
|
|
|
|
2 |
49373 |
2 |
by LauraPat3/1/2020 7:06 PM |
|
0 Replies and 3036 Views and 0 Subscribers
AP30.3
3036
0
0
Started by Anthony
I made a mistake attempting to change an released invoice’s amount in AP30.3. Now the invoice states it is out balance with a P MESSAGE and does not let me cancel the invoice or change the invoice amount stating “payment record does not exist”. Does anyone have a solution
|
|
|
|
0 |
3036 |
0 |
4/23/2020 3:31 PM |
|
1 Replies and 44673 Views and 0 Subscribers
Vendor Discount Code
44673
1
0
Started by Elmer Madarang
If there is such a field where does it reside (Which form) and what the field name is thanks! Elmer Madarang
|
|
|
|
1 |
44673 |
0 |
by Ragu Raghavan6/11/2020 10:26 PM |
|
1 Replies and 40865 Views and 0 Subscribers
Cleaning up the Vendor Master File
40865
1
0
Started by NBayless
Hello, I have been in this position for almost 2 years and now it's time to clean up our vendor master file. The last time they did it here was 2015, and it was apparently a complete disaster, as many active vendors were inactivated. The query they used apparently was not accurate (maybe user error), I don't know. I can't find a query that can give me a list of active vendors and their last payment made. Does anyone have any thoughts or screen shots of a query that could help with this ...
|
|
|
|
1 |
40865 |
0 |
by dcaiani11/16/2020 3:13 PM |
|
3 Replies and 44570 Views and 0 Subscribers
Query to get Fixed assets in v10
44570
3
0
Started by Sreekanth
Can any one help me from which tables will get below fields: Asset Number Location Account Asset Class Fixed Asset Group 1 Fixed Asset Group 2 Fixed asset quantity on hand Fixed asset replacement cost Fixed asset fair value Fixed asset depreciable basis Fixed asset salvage value Fixed asset net book value Fixed asset accumulated depreciation Fixed asset useful life remaining
|
|
|
|
3 |
44570 |
0 |
by Ragu Raghavan10/6/2020 7:43 PM |
|
3 Replies and 39558 Views and 1 Subscribers
Please Advise: What after Lawson S3 V10
39558
3
1
Started by Lawsonlearn
Hi Lawson Experts: We updated to Lawson S3 financial V10 (on-prem) in 2015 from V9 and are currently on V10.0.9. We are not sure if we should upgrade to the next version. From what I have read: The next version after V10 for Lawson S3 financial is the Cloudsuite Financials. It does not seem like there will be a Lawson S3 V11. Is it true that that the cloudsuite financial technology stack is very different from S3 V10 and migrating to it will be a big lift If that is true we would...
|
|
|
|
3 |
39558 |
1 |
by Kat V11/9/2020 2:27 PM |
|
1 Replies and 48997 Views and 0 Subscribers
1099 NEC
48997
1
0
Started by dcaiani
1099 NEC (non employee compensation) is new for 2020. Does anyone know the Lawson implications We use FormFast to format our 1099s, checks, etc. Has anyone figured out what needs to be done to get it formatted correctly etc.
|
|
|
|
1 |
48997 |
0 |
by Kidd Kasper12/1/2020 3:08 PM |
|
0 Replies and 2533 Views and 0 Subscribers
Email invoices
2533
0
0
Started by Absolon
Has anyone found a way in the billing application to email invoices directly to the customer. I know we can create PDF's then attach to emails outside the application, but is there a way to do it all inside of Lawson
|
|
|
|
0 |
2533 |
0 |
12/2/2020 9:40 PM |
|
0 Replies and 1830 Views and 0 Subscribers
Mobile Financials and Mobile Assets
1830
0
0
Started by anirudhthota
Hello, I was looking for user guides or any other sort of documentation on Lawson Mobile Applications, specifically Financials and Asset Management for v10. Thank you in advance!
|
|
|
|
0 |
1830 |
0 |
12/7/2020 5:10 PM |
|
3 Replies and 42737 Views and 0 Subscribers
AP Open Invoice Report
42737
3
0
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 |
42737 |
0 |
by Rajashanmugam1/7/2021 10:48 PM |
|
1 Replies and 31898 Views and 1 Subscribers
Revenue Recognition from BL
31898
1
1
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 |
31898 |
1 |
by Ken U2/9/2022 12:09 AM |
|
1 Replies and 48977 Views and 0 Subscribers
GL01.4 flags
48977
1
0
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 |
48977 |
0 |
by Dennis Amory3/23/2021 6:48 PM |
|
0 Replies and 1613 Views and 1 Subscribers
Company Control
1613
0
1
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 |
1613 |
1 |
3/26/2021 3:08 PM |
|
0 Replies and 1691 Views and 0 Subscribers
Quarterly Payment Terms
1691
0
0
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 |
1691 |
0 |
4/21/2021 12:35 AM |
|
|
1 |
37556 |
0 |
by Ragu Raghavan4/30/2021 5:02 PM |
|
0 Replies and 2065 Views and 0 Subscribers
Posting to AP30.2 Error
2065
0
0
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 |
2065 |
0 |
7/30/2021 6:29 PM |
|
3 Replies and 33670 Views and 1 Subscribers
AP03.1 data issues
33670
3
1
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 |
33670 |
1 |
by John Henley12/27/2021 10:56 PM |
|
3 Replies and 29286 Views and 1 Subscribers
RW Reports and Acct Groups
29286
3
1
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 |
29286 |
1 |
by TMcAuley4/28/2022 9:07 PM |
|
0 Replies and 2240 Views and 0 Subscribers
MHC Invoice Images in Crystal Reports
2240
0
0
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 |
2240 |
0 |
4/18/2022 8:52 PM |
|
21 Replies and 52844 Views and 1 Subscribers
Extend Accounting Period End Date
52844
21
1
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 |
52844 |
1 |
by lawsonny4/29/2022 12:26 AM |
|
0 Replies and 1675 Views and 0 Subscribers
Foreign Currency Payments
1675
0
0
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 |
1675 |
0 |
9/20/2022 3:16 PM |
|
0 Replies and 1592 Views and 1 Subscribers
MA540 Fatal Error Report: Discount Rate Required
1592
0
1
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 |
1592 |
1 |
9/23/2022 2:57 PM |
|
0 Replies and 1679 Views and 0 Subscribers
AP20.1 Upload & MA43.1 Error
1679
0
0
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 |
1679 |
0 |
12/2/2022 1:36 PM |
|
0 Replies and 4372 Views and 1 Subscribers
AC/BR/GM in foreign company
4372
0
1
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 |
4372 |
1 |
3/7/2023 7:04 PM |
|
2 Replies and 13689 Views and 0 Subscribers
PO190 Last Run Audit
13689
2
0
Started by SSmith
Is there a way we can figure out what user ran last this program PO190
|
|
|
|
2 |
13689 |
0 |
by John Henley4/3/2023 3:14 PM |