Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 912345 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 634 Views Revenue Recognition from BL  634  0 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
0 634
01/12/2021 5:20 PM
3 Replies and 1752 Views AP Open Invoice Report  1752  3 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 1752
by  RajashanmugamJump to last post
01/07/2021 5:48 PM
2 Replies and 2600 Views Duns Numbers for Vendors  2600  2 Started by  Eviecat21 Is there a field where the DUNS number can be maintained for a vendor
2 2600
by  Tim AlessiJump to last post
12/08/2020 5:45 PM
7 Replies and 5977 Views Upload Assets to AM Module  5977  7 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 5977
by  BUSLAWSONJump to last post
12/08/2020 12:49 PM
0 Replies and 301 Views Mobile Financials and Mobile Assets  301  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 301
12/07/2020 12:10 PM
0 Replies and 747 Views Email invoices  747  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 747
12/02/2020 4:40 PM
1 Replies and 1227 Views 1099 NEC  1227  1 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 1227
by  Kidd KasperJump to last post
12/01/2020 10:08 AM
1 Replies and 960 Views Cleaning up the Vendor Master File  960  1 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 960
by  dcaianiJump to last post
11/16/2020 10:13 AM
3 Replies and 2545 Views Please Advise: What after Lawson S3 V10  2545  3 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 2545
by  Kat VJump to last post
11/09/2020 9:27 AM
3 Replies and 1454 Views Query to get Fixed assets in v10  1454  3 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 1454
by  Ragu RaghavanJump to last post
10/06/2020 3:43 PM
10 Replies and 11493 Views AP160 and AP161  11493  10 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 11493
by  Raymundo RomeroJump to last post
08/26/2020 12:44 PM
6 Replies and 5711 Views RNI Report (PO135) cleanup and fix  5711  6 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 5711
by  RussJump to last post
08/05/2020 11:32 AM
5 Replies and 2251 Views MA540 Fatal Records Not Loading to MA54  2251  5 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 2251
by  JeremyJump to last post
08/05/2020 11:05 AM
2 Replies and 2206 Views MA540 Fatal Error  2206  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 2206
by  Joan at Stony BrookJump to last post
07/30/2020 1:16 PM
1 Replies and 2261 Views Vendor Discount Code  2261  1 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 2261
by  Ragu RaghavanJump to last post
06/11/2020 6:26 PM
3 Replies and 4847 Views How do I make a partial payment on an AP invoice?  4847  3 Started by  AD Hello, What steps do I have to take to process a partial payment on an AP invoice
3 4847
by  JeremyJump to last post
06/08/2020 2:25 PM
2 Replies and 2902 Views Down Payment or Prepayment Process  2902  2 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 2902
by  JeremyJump to last post
04/28/2020 3:41 PM
3 Replies and 7912 Views cancel matched invoice that is out of balance  7912  3 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
3 7912
by  AnthonyJump to last post
04/23/2020 12:27 PM
0 Replies and 1035 Views AP30.3  1035  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 1035
04/23/2020 11:31 AM
3 Replies and 2346 Views Changing GL from 12 to 13 Periods  2346  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 2346
by  BoydJump to last post
04/01/2020 2:51 PM
2 Replies and 2530 Views New Payroll GL interface to Lawson Financials  2530  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 2530
by  LauraPatJump to last post
03/01/2020 2:06 PM
3 Replies and 2494 Views AR575 vs AR580  2494  3 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 2494
by  Todd MitchellJump to last post
02/21/2020 11:09 AM
1 Replies and 1573 Views Credit Memo's tied back to PO's  1573  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 1573
by  tgmc8250Jump to last post
02/12/2020 10:03 AM
0 Replies and 1083 Views SQL query for GL-290 Report  1083  0 Started by  zammyC hi All Has anyone used a SQL query fo run GL-290 Report from Lawson database Thanks Sam
0 1083
01/29/2020 3:02 PM
3 Replies and 2697 Views Infor Lawson RW100 Saving Multiple Reports?  2697  3 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 2697
by  Ragu RaghavanJump to last post
01/16/2020 11:28 AM
0 Replies and 1258 Views AP invoices not flowing to Asset Management system  1258  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 1258
01/15/2020 4:35 PM
2 Replies and 2276 Views Process and/or tools for protected data  2276  2 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 2276
by  Kat VJump to last post
01/03/2020 9:22 AM
8 Replies and 2364 Views AP Check Comment Tables  2364  8 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 2364
by  CasyJump to last post
01/02/2020 3:38 PM
14 Replies and 5943 Views PO100-Purchase orders  5943  14 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 5943
by  Kat VJump to last post
12/23/2019 2:22 PM
0 Replies and 1308 Views CB10, CB10.3, CB10.4 Addin (self-contained)  1308  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 1308
12/04/2019 3:25 PM
2 Replies and 1339 Views Needing to open mutiple accounts in GL20.2  1339  2 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 1339
by  RonnieJump to last post
11/15/2019 10:11 AM
0 Replies and 933 Views Lease Management - Operating Lease JE Timing  933  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 933
08/26/2019 1:10 PM
0 Replies and 1006 Views How to completely remove journals using SQL  1006  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 1006
08/20/2019 2:23 PM
2 Replies and 1428 Views EDI Freight Build  1428  2 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 1428
by  CasyJump to last post
08/19/2019 2:56 PM
2 Replies and 1367 Views Automate data import  1367  2 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 1367
by  Wai ChengJump to last post
08/13/2019 1:30 PM
2 Replies and 1440 Views PO64 not accessible  1440  2 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 1440
by  wat444Jump to last post
08/09/2019 9:43 AM
1 Replies and 1437 Views Issues with AP 161 generated file and ED501 translation for 820  1437  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 1437
by  UDJump to last post
07/30/2019 10:19 AM
2 Replies and 1478 Views EDI 810 Delay  1478  2 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 1478
by  Alex TsekhanskyJump to last post
07/29/2019 1:32 PM
4 Replies and 1514 Views Unique Identifer from GLTRANSREL to GLTRANS  1514  4 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 1514
by  Sam MathewJump to last post
07/26/2019 1:16 PM
4 Replies and 9759 Views Infor’s Lawson Accounts Payable Invoice Automation system  9759  4 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 9759
by  BigEasyNOJump to last post
07/15/2019 1:32 PM
1 Replies and 1485 Views GL Balance Rollover  1485  1 Started by  Anthony How do you roll GL balances over from year to year Thank You
1 1485
by  RonTJump to last post
07/10/2019 9:49 AM
1 Replies and 1202 Views Lawson ACTOR ID & LAWPROD10X & SSOP  1202  1 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 1202
by  JimYJump to last post
07/08/2019 12:01 PM
0 Replies and 1035 Views AR20  1035  0 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 1035
06/24/2019 9:41 AM
3 Replies and 3768 Views GTIN  3768  3 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 3768
by  MarisolJump to last post
06/20/2019 3:02 PM
3 Replies and 5023 Views GL20-Accounting Unit/Account Code Combinations  5023  3 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 5023
by  anu singhJump to last post
06/20/2019 11:52 AM
0 Replies and 1139 Views AR30 Automation  1139  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 1139
06/04/2019 11:48 AM
2 Replies and 1873 Views Sample EDI 810 maps  1873  2 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 1873
by  jefriedmanJump to last post
05/31/2019 5:13 PM
1 Replies and 1814 Views Changing a Recurring Journal  1814  1 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 1814
by  Carol SJump to last post
05/17/2019 1:26 PM
5 Replies and 1878 Views Implementing EDI 810  1878  5 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 1878
by  JonAJump to last post
05/14/2019 8:24 AM
2 Replies and 5411 Views Upgrade from V10 to V11  5411  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 5411
by  Declan BilyewJump to last post
05/10/2019 3:05 PM
3 Replies and 1824 Views HotKey not working in IE  1824  3 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 1824
by  Tim RJump to last post
04/26/2019 3:28 PM
4 Replies and 2120 Views general ledger posting dates  2120  4 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 2120
by  Dan GuszreganJump to last post
04/24/2019 1:43 PM
7 Replies and 5392 Views Add-Ins Upload to AP20.1 & Need Comments  5392  7 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
7 5392
by  Patricia ManeJump to last post
04/17/2019 1:12 PM
0 Replies and 1078 Views Lease Compute Statements  1078  0 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 1078
04/10/2019 12:43 PM
2 Replies and 1877 Views New Company Setup in S3  1877  2 Started by  Heath Davis Does anyone have a project plan or checklist to use when defining a new company in Lawson S3
2 1877
by  LynnetteJump to last post
04/05/2019 8:25 AM
2 Replies and 1621 Views AM15.3 error  1621  2 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 1621
by  RWJump to last post
03/27/2019 10:06 AM
4 Replies and 3476 Views 1099 electronic file IRS interface  3476  4 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 3476
by  JimYJump to last post
03/26/2019 5:57 AM
1 Replies and 1466 Views Ways to hide GL codes from end users  1466  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 1466
by  Kat VJump to last post
03/15/2019 9:24 AM
0 Replies and 1263 Views GL ZONE  1263  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 1263
03/12/2019 5:07 PM
3 Replies and 2184 Views Lawson and accounts payable  2184  3 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 2184
by  jrbledsoeJump to last post
03/06/2019 10:05 AM
2 Replies and 1538 Views 900-FIND-BEGRNG-CMT-PURCHORDER  1538  2 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 1538
by  Ragu RaghavanJump to last post
02/28/2019 12:20 PM
5 Replies and 2419 Views AP Query  2419  5 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 2419
by  BoydJump to last post
02/18/2019 9:22 AM
4 Replies and 1955 Views AR Period Close error  1955  4 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 1955
by  Jason BeardJump to last post
02/10/2019 7:23 AM
1 Replies and 1659 Views Report Writer Question  1659  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 1659
by  jrbledsoeJump to last post
02/08/2019 8:40 PM
1 Replies and 1678 Views EDI and Wire Transfers  1678  1 Started by  JonA Anyone processing invoices through MA540 and paying the vendor through wire transfer
1 1678
by  SWilkinsJump to last post
01/23/2019 1:18 PM
1 Replies and 1549 Views One invoice to multiple PO's  1549  1 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 1549
by  JonAJump to last post
01/16/2019 1:24 PM
1 Replies and 1816 Views How to set up new printer in LID on Windows 7  1816  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 1816
by  JimYJump to last post
01/08/2019 6:07 AM
1 Replies and 1686 Views PO Subsystem set up  1686  1 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 1686
by  Kat VJump to last post
12/21/2018 1:54 PM
17 Replies and 6671 Views Ma540 sample  6671  17 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
17 6671
by  JeremyJump to last post
12/20/2018 2:39 PM
2 Replies and 1664 Views PO135 already run in update mode  1664  2 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 1664
by  ChescaJump to last post
12/20/2018 12:55 PM
4 Replies and 1840 Views Accounts Payable Workload Metric for Lawson?  1840  4 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 1840
by  O. JohnsonJump to last post
12/17/2018 11:13 AM
1 Replies and 2422 Views Infor/Lawson customers who use McKesson PMM for Supply Chain only, and Infor/Lawson for Accoun and Financialsts Payable  2422  1 Started by  mlspade Are their any Infor/Lawson customers who are using a different solution (McKesson for example) for their Supply Chain but have AP and Financials in Infor/Lawson
1 2422
by  Kat VJump to last post
11/26/2018 12:40 PM
0 Replies and 1365 Views Is there a way to run a MA540 Fatal Error Report that includes Buyer?  1365  0 Started by  Miguel Acevedo We have 5 buyers in our hospital and we get many items in MA54. I was wondering if there is a way to include buyer information so we can identify which buyers' PO get the most. Also, each buyer can be given the errors associated with their orders only. Thank you.
0 1365
11/19/2018 1:42 PM
2 Replies and 2016 Views Fiscal date mapping  2016  2 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 2016
by  ChescaJump to last post
10/12/2018 2:29 PM
1 Replies and 1745 Views Matching GLTrans to Invoices/PO  1745  1 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 1745
by  Kat VJump to last post
10/09/2018 9:09 AM
0 Replies and 2794 Views Disc Date vs. Due Date  2794  0 Started by  Eviecat21 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 2794
09/28/2018 1:12 PM
0 Replies and 1387 Views MA60.3 - Filtering results  1387  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 1387
09/26/2018 10:05 AM
3 Replies and 1891 Views GLCHARTDTL description update  1891  3 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 1891
by  DeronJump to last post
09/20/2018 3:31 PM
1 Replies and 1889 Views Required Fields  1889  1 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 1889
by  Ragu RaghavanJump to last post
09/15/2018 9:54 AM
2 Replies and 2984 Views Cannot delete non-GL journal entries GL45  2984  2 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 2984
by  Patricia WilsonJump to last post
09/11/2018 9:53 PM
1 Replies and 1751 Views AP Distribution User Field  1751  1 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 1751
by  KellyJump to last post
09/11/2018 2:58 PM
2 Replies and 2391 Views Invoice Void Audit  2391  2 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 2391
by  FrozenITJump to last post
09/10/2018 7:59 PM
1 Replies and 1892 Views SOP for Procurement and AP on Vendor Return  1892  1 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 1892
by  JeremyJump to last post
09/05/2018 12:43 PM
2 Replies and 23018 Views Lawson manuals  23018  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
2 23018
by  RussMulJump to last post
09/05/2018 10:48 AM
1 Replies and 2313 Views Lease Management Uploads  2313  1 Started by  itsjustme We are implementing Lease Management (LM) module and are wanting to upload them rather than key them in. Since we are new to this module, creating our own mapping we could miss some fields that we would need later etc so looking for someone who has done that already. Thanks Dave
1 2313
by  LynnetteJump to last post
08/15/2018 12:41 PM
0 Replies and 1245 Views Entering Invoice for Closed PO Line  1245  0 Started by  Jeremy We are reevaluating several of our practices and one that has come us is invoices for PO Lines that are closed. How do other handle these I'm not sure if there's a way or a setting that would allow the match screen (MA43) to display PO lines that are closed so we could enter the invoice for the PO line and let it trigger a buyer message or something like that. Is this possible How do others handle these types of invoices
0 1245
08/14/2018 3:34 PM
3 Replies and 3378 Views GL monthly balances  3378  3 Started by  Chesca I need to dump data from Lawson for budgeting analysis and need help with finding the right data fields/databases to pull from. Is there a Lawson screen/table that stores monthly activity for income statements accounts and ending balances for balance sheet accounts Any input would be greatly appreciated
3 3378
by  blongJump to last post
07/19/2018 10:25 AM
0 Replies and 1540 Views Credit Memo for Service PO  1540  0 Started by  Jeremy Here are the details of my example: PO with one amount-type service line for $1000. Invoice comes in for $1000 and is fully matched and paid. PO Line is now 'closed' but PO190 not yet ran, so header is still open. We should have only been invoiced partially, let's say for $500. Credit memo for $500 comes in. So, what I have done is entered the credit memo information, including the information on the Misc. tab, selecting the original invoice. Then, go to MA42.1 - Memo Line Detail - Purc...
0 1540
07/13/2018 3:34 PM
3 Replies and 2801 Views Tables needed to view PO and financial activity  2801  3 Started by  Chesca We are trying to extract AP and PO data for financial reporting and not sure what tables would give me purchase order info including accounting unit/account/sub account, fiscal year/month, number of units order, cost per item, invoice number, invoice date, invoice status, PO number, line number, line description, vendor code/name, check number, journal number, journal entry ID, line number, and check date/payment date Thanks in advance for your assistance
3 2801
by  Kat VJump to last post
07/09/2018 10:10 AM
0 Replies and 1378 Views Statistical by day data  1378  0 Started by  Chesca Hello, what Lawson tables would I need to join to create a crystal report showing company, unit cost center, account, sub account, start date, and amount I was thinking possibly the GLTRANS, thanks in advance for your assistance.
0 1378
06/27/2018 9:52 AM
5 Replies and 6083 Views AP Invoice Report  6083  5 Started by  Chesca Hello, does anybody know if there is a Lawson report to see how many invoices are processed by each A/P clerk
5 6083
by  ChescaJump to last post
06/26/2018 2:12 PM
2 Replies and 1848 Views Tables Needed to View Spend for Activity  1848  2 Started by  MChism My Director is requesting report that will show all spend for a particular activity. I can't look at a canned report as I need to pull data from our expense management system. I need to look at the fields on paid invoices as this will capture both Lawson data and Expense management data. What fields do I need to build a Crystal report for this
2 1848
by  ChescaJump to last post
06/25/2018 8:17 AM
1 Replies and 2507 Views Cash Reconciliation  2507  1 Started by  Boyd We are having trouble reconciling a CB bank account to GL. We have verified that all transactions are present in the bank account, CB and GL. Also, we verified that our beginning balance matches the ending balance from 12/31/17. We have run out of places to look. Any thoughts/tips/tricks are appreciated.
1 2507
by  Darrin MichaelJump to last post
06/14/2018 10:36 AM
0 Replies and 2068 Views Extracting Detailed Journal Entries  2068  0 Started by  Chesca I am trying to write an GL detail report in Crystal or SQL that should include the following data. I think I can get most of the information from GLTRANS. Lawson suggested I extract the data from GL90 but that seems very simple Company department code account code as assigned by client in their GL Sub account Fiscal Month Fiscal year amount Post date of the transaction line Item description of the transaction line Journal number Journal line...
0 2068
06/11/2018 10:23 AM
2 Replies and 1755 Views Understanding Inv Discrepancy Scenerios  1755  2 Started by  Casy We have noticed that sometimes quantity issues will appear on MA236 and sometimes they will go to MA64. We want to know the criteria that would cause a quantity issue to go to one or the other so we can better work our invoice discrepancies. Has anyone else experienced this
2 1755
by  CasyJump to last post
06/11/2018 8:29 AM
0 Replies and 1347 Views AP/PO System Setup  1347  0 Started by  Boyd We are in the process of setting up a new company in Lawson. Unfortunately, our most recent process narratives for AP, PO, MA and IC don't appear to be the latest and greatest. Therefore we can't seem to get MA and IC fully set up. Is someone willing to share set up process documentation for MA and IC We are on version 10.
0 1347
06/08/2018 12:11 PM
1 Replies and 1707 Views AM135 error  1707  1 Started by  Boyd We are trying to transfer assets in AM between companies. When we complete this on a line by line basis in AM, all seems to work fine. When we attempt to complete this using AM135 we receive the following error message: 'To-company accounting unit does not exist'. Any thoughts are appreciated.
1 1707
by  Bob CanhamJump to last post
06/06/2018 3:29 PM
1 Replies and 1555 Views Paying a vendor different from vendor on PO  1555  1 Started by  JonA St. Jude was purchased by Abbott last year. We updated the vendor on all open St. Jude POs in January. Some could not be changed due to previously matched invoices. We have an invoice for one of these POs that AP needs to pay to Abbott. I'm on the procurement side so I'm no that familiar with AP processing. Can AP match the PO and change the vendor on their side to pay to Abbott even though the PO vendor is St. Jude
1 1555
by  TWieseJump to last post
06/06/2018 9:23 AM
1 Replies and 1852 Views Adding new Item Type codes  1852  1 Started by  Brett Our finance department is creating requisitions with the Quantity field populated with the dollar amount and the unit cost field with 1 for PO's that are for services. They are also making all requisitions a special type and not using the service type when creating these. The reason being from what I have heard is you can't receive on Service PO's and there are no reports for viewing open Service PO's. One suggestion I had was to add another item type code to identify it as Special\Service or wh...
1 1852
by  Kat VJump to last post
06/04/2018 3:51 PM
2 Replies and 2265 Views Accounts Receivable to sell products  2265  2 Started by  Casy Is anyone using the AR system to key in product sales We are looking to do this but currently do not have the AR system set up at all so trying to see if this is an option for that part of the application.
2 2265
by  RussMulJump to last post
06/01/2018 9:05 AM
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 912345 > >>


RSS Feed Available