|
|
|
|
|
|
2 Replies and 1199 Views
New Payroll GL interface to Lawson Financials 1199 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 |
1199 |
by LauraPat 03/01/2020 2:06 PM |
|
3 Replies and 1141 Views
AR575 vs AR580 1141 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 |
1141 |
by Todd Mitchell02/21/2020 11:09 AM |
|
1 Replies and 509 Views
Credit Memo's tied back to PO's 509 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 |
509 |
by tgmc825002/12/2020 10:03 AM |
|
0 Replies and 440 Views
SQL query for GL-290 Report 440 0
Started by zammyC
hi All Has anyone used a SQL query fo run GL-290 Report from Lawson database Thanks Sam
|
|
|
|
0 |
440 |
01/29/2020 3:02 PM |
|
3 Replies and 1534 Views
Infor Lawson RW100 Saving Multiple Reports? 1534 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 |
1534 |
by Ragu Raghavan01/16/2020 11:28 AM |
|
0 Replies and 659 Views
AP invoices not flowing to Asset Management system 659 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 |
659 |
01/15/2020 4:35 PM |
|
2 Replies and 1273 Views
Process and/or tools for protected data 1273 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 |
1273 |
by Kat V01/03/2020 9:22 AM |
|
8 Replies and 1009 Views
AP Check Comment Tables 1009 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 |
1009 |
by Casy01/02/2020 3:38 PM |
|
14 Replies and 4549 Views
PO100-Purchase orders 4549 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 |
4549 |
by Kat V12/23/2019 2:22 PM |
|
0 Replies and 687 Views
CB10, CB10.3, CB10.4 Addin (self-contained) 687 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 |
687 |
12/04/2019 3:25 PM |
|
2 Replies and 451 Views
Needing to open mutiple accounts in GL20.2 451 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 |
451 |
by Ronnie11/15/2019 10:11 AM |
|
0 Replies and 448 Views
Lease Management - Operating Lease JE Timing 448 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 |
448 |
08/26/2019 1:10 PM |
|
0 Replies and 466 Views
How to completely remove journals using SQL 466 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 |
466 |
08/20/2019 2:23 PM |
|
2 Replies and 535 Views
EDI Freight Build 535 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 |
535 |
by Casy08/19/2019 2:56 PM |
|
2 Replies and 497 Views
Automate data import 497 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 |
497 |
by Wai Cheng08/13/2019 1:30 PM |
|
2 Replies and 559 Views
PO64 not accessible 559 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 |
559 |
by wat44408/09/2019 9:43 AM |
|
1 Replies and 589 Views
Issues with AP 161 generated file and ED501 translation for 820 589 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 |
589 |
by UD07/30/2019 10:19 AM |
|
2 Replies and 560 Views
EDI 810 Delay 560 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 |
560 |
by Alex Tsekhansky07/29/2019 1:32 PM |
|
4 Replies and 627 Views
Unique Identifer from GLTRANSREL to GLTRANS 627 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 |
627 |
by Sam Mathew07/26/2019 1:16 PM |
|
4 Replies and 8395 Views
Infor’s Lawson Accounts Payable Invoice Automation system 8395 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 |
8395 |
by BigEasyNO07/15/2019 1:32 PM |
|
1 Replies and 585 Views
GL Balance Rollover 585 1
Started by Anthony
How do you roll GL balances over from year to year Thank You
|
|
|
|
1 |
585 |
by RonT07/10/2019 9:49 AM |
|
1 Replies and 357 Views
Lawson ACTOR ID & LAWPROD10X & SSOP 357 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 |
357 |
by JimY07/08/2019 12:01 PM |
|
0 Replies and 499 Views
AR20 499 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 |
499 |
06/24/2019 9:41 AM |
|
3 Replies and 2760 Views
GTIN 2760 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 |
2760 |
by Marisol06/20/2019 3:02 PM |
|
3 Replies and 3855 Views
GL20-Accounting Unit/Account Code Combinations 3855 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 |
3855 |
by anu singh06/20/2019 11:52 AM |
|
0 Replies and 565 Views
AR30 Automation 565 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 |
565 |
06/04/2019 11:48 AM |
|
2 Replies and 821 Views
Sample EDI 810 maps 821 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 |
821 |
by jefriedman05/31/2019 5:13 PM |
|
1 Replies and 945 Views
Changing a Recurring Journal 945 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 |
945 |
by Carol S05/17/2019 1:26 PM |
|
5 Replies and 894 Views
Implementing EDI 810 894 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 |
894 |
by JonA05/14/2019 8:24 AM |
|
2 Replies and 4001 Views
Upgrade from V10 to V11 4001 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 |
4001 |
by Declan Bilyew05/10/2019 3:05 PM |
|
3 Replies and 871 Views
HotKey not working in IE 871 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 |
871 |
by Tim R04/26/2019 3:28 PM |
|
4 Replies and 1042 Views
general ledger posting dates 1042 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 |
1042 |
by Dan Guszregan04/24/2019 1:43 PM |
|
7 Replies and 4230 Views
Add-Ins Upload to AP20.1 & Need Comments 4230 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 |
4230 |
by Patricia Mane04/17/2019 1:12 PM |
|
0 Replies and 578 Views
Lease Compute Statements 578 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 |
578 |
04/10/2019 12:43 PM |
|
2 Replies and 1013 Views
New Company Setup in S3 1013 2
Started by Heath Davis
Does anyone have a project plan or checklist to use when defining a new company in Lawson S3
|
|
|
|
2 |
1013 |
by Lynnette04/05/2019 8:25 AM |
|
2 Replies and 645 Views
AM15.3 error 645 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 |
645 |
by RW03/27/2019 10:06 AM |
|
4 Replies and 2476 Views
1099 electronic file IRS interface 2476 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 |
2476 |
by JimY03/26/2019 5:57 AM |
|
1 Replies and 663 Views
Ways to hide GL codes from end users 663 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 |
663 |
by Kat V03/15/2019 9:24 AM |
|
0 Replies and 714 Views
GL ZONE 714 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 |
714 |
03/12/2019 5:07 PM |
|
3 Replies and 1154 Views
Lawson and accounts payable 1154 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 |
1154 |
by jrbledsoe03/06/2019 10:05 AM |
|
2 Replies and 718 Views
900-FIND-BEGRNG-CMT-PURCHORDER 718 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 |
718 |
by Ragu Raghavan02/28/2019 12:20 PM |
|
1 Replies and 866 Views
MA540 Fatal Error 866 1
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
|
|
|
|
1 |
866 |
by Jason Beard02/26/2019 7:07 AM |
|
5 Replies and 1316 Views
AP Query 1316 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 |
1316 |
by Boyd02/18/2019 9:22 AM |
|
4 Replies and 893 Views
AR Period Close error 893 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 |
893 |
by Jason Beard02/10/2019 7:23 AM |
|
1 Replies and 709 Views
Report Writer Question 709 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 |
709 |
by jrbledsoe02/08/2019 8:40 PM |
|
1 Replies and 834 Views
EDI and Wire Transfers 834 1
Started by JonA
Anyone processing invoices through MA540 and paying the vendor through wire transfer
|
|
|
|
1 |
834 |
by SWilkins01/23/2019 1:18 PM |
|
5 Replies and 3733 Views
RNI Report (PO135) cleanup and fix 3733 5
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...
|
|
|
|
5 |
3733 |
by Kelly01/17/2019 9:58 AM |
|
1 Replies and 695 Views
One invoice to multiple PO's 695 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 |
695 |
by JonA01/16/2019 1:24 PM |
|
1 Replies and 939 Views
How to set up new printer in LID on Windows 7 939 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 |
939 |
by JimY01/08/2019 6:07 AM |
|
1 Replies and 872 Views
PO Subsystem set up 872 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 |
872 |
by Kat V12/21/2018 1:54 PM |
|
17 Replies and 5453 Views
Ma540 sample 5453 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 |
5453 |
by Jeremy12/20/2018 2:39 PM |
|
2 Replies and 799 Views
PO135 already run in update mode 799 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 |
799 |
by Chesca12/20/2018 12:55 PM |
|
4 Replies and 899 Views
Accounts Payable Workload Metric for Lawson? 899 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 |
899 |
by O. Johnson12/17/2018 11:13 AM |
|
|
1 |
1351 |
by Kat V11/26/2018 12:40 PM |
|
0 Replies and 844 Views
Is there a way to run a MA540 Fatal Error Report that includes Buyer? 844 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 |
844 |
11/19/2018 1:42 PM |
|
1 Replies and 689 Views
MA540 Fatal Records Not Loading to MA54 689 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
|
|
|
|
1 |
689 |
by JonA11/19/2018 7:23 AM |
|
|
2 |
3595 |
by AndreaS411/02/2018 10:54 AM |
|
2 Replies and 1131 Views
Fiscal date mapping 1131 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 |
1131 |
by Chesca10/12/2018 2:29 PM |
|
1 Replies and 859 Views
Matching GLTrans to Invoices/PO 859 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 |
859 |
by Kat V10/09/2018 9:09 AM |
|
0 Replies and 1583 Views
Disc Date vs. Due Date 1583 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 |
1583 |
09/28/2018 1:12 PM |
|
0 Replies and 840 Views
MA60.3 - Filtering results 840 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 |
840 |
09/26/2018 10:05 AM |
|
3 Replies and 1030 Views
GLCHARTDTL description update 1030 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 |
1030 |
by Deron09/20/2018 3:31 PM |
|
1 Replies and 1010 Views
Required Fields 1010 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 |
1010 |
by Ragu Raghavan09/15/2018 9:54 AM |
|
2 Replies and 2131 Views
Cannot delete non-GL journal entries GL45 2131 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 |
2131 |
by Patricia Wilson09/11/2018 9:53 PM |
|
1 Replies and 867 Views
AP Distribution User Field 867 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 |
867 |
by Kelly09/11/2018 2:58 PM |
|
2 Replies and 1401 Views
Invoice Void Audit 1401 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 |
1401 |
by FrozenIT09/10/2018 7:59 PM |
|
1 Replies and 1063 Views
SOP for Procurement and AP on Vendor Return 1063 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 |
1063 |
by Jeremy09/05/2018 12:43 PM |
|
2 Replies and 20493 Views
Lawson manuals 20493 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 |
20493 |
by RussMul09/05/2018 10:48 AM |
|
2 Replies and 849 Views
Changing GL from 12 to 13 Periods 849 2
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 ...
|
|
|
|
2 |
849 |
by Ken U08/29/2018 1:50 AM |
|
0 Replies and 978 Views
Down Payment or Prepayment Process 978 0
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...
|
|
|
|
0 |
978 |
08/21/2018 4:01 PM |
|
1 Replies and 1353 Views
Lease Management Uploads 1353 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 |
1353 |
by Lynnette08/15/2018 12:41 PM |
|
0 Replies and 762 Views
Entering Invoice for Closed PO Line 762 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 |
762 |
08/14/2018 3:34 PM |
|
3 Replies and 2197 Views
GL monthly balances 2197 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 |
2197 |
by blong07/19/2018 10:25 AM |
|
0 Replies and 987 Views
Credit Memo for Service PO 987 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 |
987 |
07/13/2018 3:34 PM |
|
3 Replies and 1541 Views
Tables needed to view PO and financial activity 1541 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 |
1541 |
by Kat V07/09/2018 10:10 AM |
|
0 Replies and 838 Views
Statistical by day data 838 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 |
838 |
06/27/2018 9:52 AM |
|
5 Replies and 4908 Views
AP Invoice Report 4908 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 |
4908 |
by Chesca06/26/2018 2:12 PM |
|
2 Replies and 973 Views
Tables Needed to View Spend for Activity 973 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 |
973 |
by Chesca06/25/2018 8:17 AM |
|
1 Replies and 1585 Views
Cash Reconciliation 1585 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 |
1585 |
by Darrin Michael06/14/2018 10:36 AM |
|
0 Replies and 1308 Views
Extracting Detailed Journal Entries 1308 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 |
1308 |
06/11/2018 10:23 AM |
|
2 Replies and 955 Views
Understanding Inv Discrepancy Scenerios 955 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 |
955 |
by Casy06/11/2018 8:29 AM |
|
0 Replies and 852 Views
AP/PO System Setup 852 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 |
852 |
06/08/2018 12:11 PM |
|
1 Replies and 901 Views
AM135 error 901 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 |
901 |
by Bob Canham06/06/2018 3:29 PM |
|
1 Replies and 809 Views
Paying a vendor different from vendor on PO 809 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 |
809 |
by TWiese06/06/2018 9:23 AM |
|
1 Replies and 1012 Views
Adding new Item Type codes 1012 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 |
1012 |
by Kat V06/04/2018 3:51 PM |
|
2 Replies and 1436 Views
Accounts Receivable to sell products 1436 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 |
1436 |
by RussMul06/01/2018 9:05 AM |
|
1 Replies and 1133 Views
OnBase Expense Report interface to AP and Pay though PR 1133 1
Started by MattB
Hello all, We are looking to develop an OnBase form for entry and approval routing of expense reports. After submission the reports would sit in an audit queue until approved. After approval we would run a report and extract of 'approved pending payment' reports. We are working though option of import into Lawson. Since they will be paid through payroll that would be our preference but can't figure out how to have one payment code with multiple expense distribution lines. Our other t...
|
|
|
|
1 |
1133 |
by Kelly05/17/2018 4:05 PM |
|
6 Replies and 13840 Views
Patient Refund .CSV file 13840 6
Started by Deleted User
I have been tasked with providing Vendor= Epic with the field mapping for Patient Refund processing. I believe I need the APCINVOICE, APCDISTRIB, & APCPAYMENT tables - but, am not sure the best route to go for figuring out the proper mappings. They (Epic) did provide me with a Standard Extract guide, but was hoping someone could offer some advice
|
|
|
|
6 |
13840 |
by Kelly05/02/2018 11:39 AM |
|
1 Replies and 1439 Views
Duns Numbers for Vendors 1439 1
Started by Eviecat21
Is there a field where the DUNS number can be maintained for a vendor
|
|
|
|
1 |
1439 |
by Kat V04/25/2018 12:11 PM |
|
0 Replies and 1281 Views
Smart Reconciliation 1281 0
Started by Casy
We have read through the user guide but were hoping to find a training video or additional documentation to ensure we are using it correctly. I haven't seen any videos on Infor Campus related to this. Does anyone know of any resources we could use to train our end users Thank you!
|
|
|
|
0 |
1281 |
04/25/2018 12:06 PM |
|
1 Replies and 1640 Views
Messaging for Discrepant Invoices 1640 1
Started by Casy
Currently our buyers work messages on MA64 but we don't have a good way to send these messages back to Accounting when needed. We are considering building the AP Clerks as buyers so that they can view these messages OR building an AP buyer user that all AP Clerks can use to view their messages on this screen. Has anyone ever tried to do this before and if so, how did you achieve it Thank you!
|
|
|
|
1 |
1640 |
by Kat V04/03/2018 12:10 PM |
|
8 Replies and 1771 Views
Report of Completed Jobs 1771 8
Started by hussey1213
Does anyone know if there is a way to get a dump/report of Completed user jobs We're trying to perform some job analysis; determine run times, number of times users are running jobs, etc. In LID I can copy from Completed Jobs in jobschd manually but that's going to be time consuming. Any help would be greatly appreciated. Thank you.
|
|
|
|
8 |
1771 |
by hussey121303/28/2018 9:18 AM |
|
1 Replies and 1658 Views
GL65.5 Errors 1658 1
Started by J Haveman
I am using a Infor-provided IPA flow which drops a file into the /work/GL65CSV folder. It then attempts to execute a GL65.5 to import the CSV file. I get an error every time in the Work Unit log: File has already been processed. (I can also do this via Portal and get the same errors when executing GL65.5 directly without the IPA flow.) When I look at the LAPM log, I see different errors: 1) 'CSV Hdr Read Error: Fld Name A-N-Y--F-I-E-L-D--N-A-M-E Not Found' 2) File GL65CSV Al...
|
|
|
|
1 |
1658 |
by Jason Beard03/16/2018 9:20 AM |
|
1 Replies and 2214 Views
Portal Cannot Load because of SSO Compenent 2214 1
Started by alarson90187
Hello, We recently went through a system conversion to a different ERP and we were still using Lawson 9.0.4. Today the system is tossing the servlet call /ssoconfig/SSOCfgInfoServlet error and we can't connect through portal. I can RDP into the machine, connect to LID, and LDAP bind to our active directory. But I cannot figure out why this error is popping up now. I cannot access the Lawson RM or Lawson Security tools, i receive an SSO connection failure response. I know this is way ...
|
|
|
|
1 |
2214 |
by Jason Beard03/09/2018 3:18 PM |
|
1 Replies and 2390 Views
Vertex O series failure on v10 2390 1
Started by Big_Mike
So our issues have been going on for almost a year. As it turns out we are one of two clients on S3 version 10, on a windows platform, attempting to use the Vertex O series. We have multiple environments and have not had any success with configuring, patching, etc getting the systems to talk to each other correctly. Our other integration's, which number in the 100's, run flawlessly. The keep or toss moment is here as its' implementation is holding up several large initiatives and I was hopin...
|
|
|
|
1 |
2390 |
by Jeremy_T.Absolute!02/09/2018 11:26 AM |
|
4 Replies and 3071 Views
Remove items PO135 3071 4
Started by rhorn01
We are fairly new to Lawson/Infor . . . in reviewing the latest PO135 we have identified items that have been paid outside of the PO and items that need to be removed for other reasons. What is the best way to remove these items from the PO135 Do we manually close the PO I have seen some references to the MA180, but we had one consultant advise us not to run that report. Any specific information/screen names would be helpful. Any best practices in monitoring this report Thanks!
|
|
|
|
4 |
3071 |
by Kat V02/08/2018 3:42 PM |
|
0 Replies and 840 Views
SmartOffice Scripts not Saving to User Profile 840 0
Started by Marcus Santodonato
I have an issue in SmartOffice. After going to 'Tools > Personalization > Scripts > Add Script > Save', the script is not being retained in the user's profile settings after they log out. This particular script is supposed to add a couple of buttons to the PO20.1 screen. The buttons are added successfully at first but then when the user logs out and logs back in, the buttons are gone. We are running version 10.2.1
|
|
|
|
0 |
840 |
02/05/2018 9:47 AM |
|
0 Replies and 982 Views
Changing Pay Group on Company 982 0
Started by Deron
We want to change a company's pay group. When we type in the new pay group and press change on AP00.4, we receive the following error: 'Invoices entered; use AP101 to update pay group'. There are no unpaid invoices for this company. When we run AP101, we receive 'No Data in Report File - Check Report Parameters for Possible Error Message'. Any ideas
|
|
|
|
0 |
982 |
01/31/2018 5:36 PM |
|
8 Replies and 2399 Views
Huge error-rpt files created when report errors 2399 8
Started by Kert490
We have had several instances where our Lawson drive space was suddenly eaten up with no warnings, going from under 50 to over 95 and causing failures. We have found that the space is being taken up by error files in the users print directory. There are 2 files created: error-rpt (around 40 GB) and error_rpt.dtl (around 5 GB). These are much larger than the normal files that are created when a report errors. We can go through and delete the files and restore the space, but we would like...
|
|
|
|
8 |
2399 |
by Kwane McNeal01/30/2018 6:28 PM |
|
7 Replies and 4292 Views
PO120 EDI orders 4292 7
Started by Chesca
I want to be able to run a multistep job that will create and release POs, create EDI orders and then transmit all these POS at once to GHX. Does anybody know if this is possible or do I need to schedule a PO120 and an ED501 for each vendor PO100 for vendor A and location A and B, vendor B location A, Vendor C location D PO120 same as above ED501 - take all the EDI orders created by PO120 and transmit to GHX
|
|
|
|
7 |
4292 |
by darwin collins12/16/2017 5:11 PM |
|
0 Replies and 746 Views
AP30.2 and Missing PO from original distribution 746 0
Started by kcollins_jax
We often have to redistribute an expense that has already been paid. So we use AP3.02 to complete the redistribution. However, we are not able to include the PO associated with that purchase, and therefore the PO is no longer connected to the expense in it's new distribution. We're told this is by design, and the only way to change this would be to redo the entire AP process. Is there another way
|
|
|
|
0 |
746 |
12/11/2017 9:47 AM |
|
2 Replies and 2876 Views
Fiscal Year change to Calendar year 2876 2
Started by TWiese
Our organization just announced its being sponsored by another Healthcare Ministry. They currently run their financials on a calendar year. We closed FY17 in June. We started FY18 in July. I need ideas as to how others have worked with this type of situation(moving 6 months of data into a new FY) I have been given instructions to use GL500 but the logic does not make sense for our particular situation. What happens to the first 6 months that are also reflected in Flex Budgeting, AC/AM. H...
|
|
|
|
2 |
2876 |
by Len P12/01/2017 1:46 PM |
|
2 Replies and 2557 Views
Smart Reconciliation 2557 2
Started by Patricia Mane
Who out in the Lawson world is using Smart Reconciliation We have this product and of course like all others, the User Guide doesn't provide adequate instructions. Thanks Trish
|
|
|
|
2 |
2557 |
by Jeremy11/10/2017 1:15 PM |
|
7 Replies and 4571 Views
Processing Vendor Refunds 4571 7
Started by Radu
I am trying to figure out a way to recognize vendor refunds through the AP module so that, when I process 1099s, the amount paid to the vendor shows up correctly. Historically, we just booked the refunds manually in the GL module, but obviously this does not reduce the amount reported on 1099s. The subsequent process was to create offsetting credit and debit memos in AP and a cash transaction in CB, but again the offsetting credit and debit memos do not reduce the reported 1099 amount. Ultima...
|
|
|
|
7 |
4571 |
by Jeremy11/10/2017 7:38 AM |
|
3 Replies and 4342 Views
LID Commands 4342 3
Started by Evil Beagle
I've got a question in regards to LID commands. I've run help to get a list of commands for LID. What I'm trying to accomplish is, simply, listing the files within the currently selected folder. According to help, 'DIR' is the command. However, running DIR in any folder gives me 'dir: file not found'. Has anyone else run into this issue
|
|
|
|
3 |
4342 |
by Ray Juodis11/03/2017 9:23 AM |
|
2 Replies and 2208 Views
Status on Req in RQC compared to Shipment status on WH80 2208 2
Started by Bev Edwards
A req in RQC shows a req as Processed. A Shipment status on the same req number shows a status of Closed. On the example I have attached, there is a b/o or 10. Is the status on the WH80 for the shipment number to show the qty that was shipped is Complete It sounds as if the director thinks these two status messages should be reflecting the same thing, but when I look at them, that's not how I understand it.
|
|
|
|
2 |
2208 |
by Bev Edwards10/25/2017 3:13 PM |
|
1 Replies and 2318 Views
MX Attribute List maintenance 2318 1
Started by jrbledsoe
Does anyone know the best way to delete or purge attribute lists If you have automatic and manual attribute lists that you are no longer need or use, what's the best way to remove them Thanks for reading my post
|
|
|
|
1 |
2318 |
by Lynnette10/16/2017 4:36 PM |
|
0 Replies and 992 Views
Payroll posting to first open period 992 0
Started by Lynnette
We have an ongoing issue during the first 8 days of the month while we are working on month end. In the 8 days of the month that we do not have the calendar closed for the previous month, If the PR team makes a payroll adjustment for a previous month, the transactions post to the current open month. I always wondered why their wasn't a control on PR like there is on IC and AP. I was just curious on how others are handling these types of situations.
|
|
|
|
0 |
992 |
10/12/2017 4:14 PM |
|
0 Replies and 986 Views
Payroll Reconciliation to GL 986 0
Started by Lynnette
Does anyone know what table (on the PR side) the detail of the payroll accrual can be found in I'm trying to write a report for managers that ties the GL for the month back to Payroll. The one piece I'm missing is the system generated detail for the payroll accrual.
|
|
|
|
0 |
986 |
10/12/2017 4:06 PM |
|
1 Replies and 6283 Views
GL Maintenance 6283 1
Started by MChism
Hello all! We are restricting roughly a dozen GL accounts to only allow postings from the GL system. Primarily disallowing systems such as AP, PO IC to hit these GL's. We made these changes in GL00.1 - GL00.3 - GL00.4 and then GL03.5. My question is, do any of you have experience with making sure that these GL's are never opened back up Can we add comments or notes as to why we are closing these to only the GL system I fear that in a year or two we will have an invoice or requisition e...
|
|
|
|
1 |
6283 |
by Lynnette10/12/2017 3:51 PM |
|
0 Replies and 826 Views
Allocations to multiple companies/locations 826 0
Started by Tanya_D
I have a client that is new to Lawson allocations. She was left with no documentation on the allocations and is trying to rebuild for the new fiscal year. Her question is, Can an allocation be written say From Company 1 to Companies 2,3, & 4, along with multiple AUs on each company
|
|
|
|
0 |
826 |
10/11/2017 2:08 PM |
|
1 Replies and 2368 Views
how to extract different legder into excel 2368 1
Started by Sdcaqd
Hello, everyone! I'm new to Lawson and I have the following questions: 1.How to extract the whole general ledger into excel (not in PDF) 2.I'd like to see sales ledger based on customer name, e.g. all the sales invoices issued to customer A.How to generate that report 3.How to generate AP aging report 4.How to create accounts and sub accounts Thanks a lot !:)
|
|
|
|
1 |
2368 |
by rhorn0110/09/2017 12:04 PM |
|
0 Replies and 977 Views
AC298 - Activity Amount Column 977 0
Started by timbomom
What is the source of the Activity Amount Column in AC298 Thanks in advance! Patricia
|
|
|
|
0 |
977 |
09/22/2017 6:13 PM |
|
0 Replies and 1546 Views
Using AP230 to tie to AP GL account 1546 0
Started by Becky W
Our auditors wanted us to supply them with an Open Payables Report which tied to the AP GL account. When running the AP230, it did not tie to the GL. One reason I have determined is that invoices for which a messages exists appear on the AP230, but have not been posted to the GL yet. I need help thinking of why invoices would be posted to the GL, but not on the AP230. Any suggestions PS-I know the AP136 is the report that will tell us exactly what ties to the AP GL account but it does no...
|
|
|
|
0 |
1546 |
09/20/2017 9:45 AM |
|
1 Replies and 2023 Views
AC10 Audit Table? 2023 1
Started by PD
Does anyone know the audit table name for AC10 I would like to think that such a thing exist to be able to capture change(s) that take place.
If this is not the right forum for this question, please let me know.
Thanks,
|
|
|
|
1 |
2023 |
by John Henley09/18/2017 10:25 AM |
|
0 Replies and 1210 Views
AR zero or negative payment 1210 0
Started by Todd Mitchell
We are currently working on a project in which a customer has the ability to pay their invoices via credit card. On some occasions, the amount of credits could be the same or exceed the amount of invoices, resulting in a zero dollar payment or a negative payment. In the Lawson EFT world (AR115), Lawson creates a debit memo to offset the amount of the negative payment and then interjects a zero dollar payment into the payment table. Has anyone had to create a similar situation and if so, how...
|
|
|
|
0 |
1210 |
09/11/2017 2:30 PM |
|
0 Replies and 1042 Views
MA126 1042 0
Started by Patricia Mane
Good morning- Who has and is willing to share process related to working the MA126 Error Report We have had several changes in our AP Department and I am working to create simple Work Instructions so they new staff is able to do their jobs efficiently. Any help or guidance would be greatly appreciated. Thanks Trish
|
|
|
|
0 |
1042 |
09/01/2017 8:06 AM |
|
0 Replies and 874 Views
Asset Management (AM) system - Upload Adjustments 874 0
Started by NorthMemorial
We are in the process of using the Addins Upload Wizard for adding assets. Is there a way to use a uploader wizard for adjustments as well Any information would be great. Thank you.
|
|
|
|
0 |
874 |
08/24/2017 11:53 AM |
|
3 Replies and 2167 Views
AP10.2 Contact Account Number 2167 3
Started by pglibra
Hello, I am trying to write an Access query to pull the vendor's account number that can be found in AP10.2, Contact, Account Number. What tables do I need and how do I link them in Access Thank you
|
|
|
|
3 |
2167 |
by JimY08/22/2017 9:34 AM |
|
7 Replies and 3554 Views
GL Beginning Balance Not Updated at year end 3554 7
Started by Peter
HELP!!! :) We are on Fiscal Calendar and last month Did a Limited year end Close Option 'L' in GL199 but did not Run the 'N' Next Year beginning balance Option first. Now we are in the New Year but the beginning balances are not updated. Is there any way for me to update the balances for the current period.. I tried running GL199 again with a Last Year period 12 and 'N' option but it would not let me. Many Many Thanks I am desperate.
|
|
|
|
7 |
3554 |
by Mira Guirguis08/02/2017 3:30 PM |
|
2 Replies and 2449 Views
Note To Buyer field in RQ10 vendor drill down 2449 2
Started by clb393
I'm trying to query the Note to Buyer field, which resides in the RQ10 Vendor field drill down. Can anyone tell me what database table I can find that in Thanks, Chris
|
|
|
|
2 |
2449 |
by clb39307/31/2017 7:46 AM |
|
0 Replies and 1298 Views
Stale Date/Escheat a small group of checks 1298 0
Started by Bob Canham
We normally escheat our AP checks on a regular schedule. However, our patient accounting department has done due diligence on some of our patient refund checks and would like to escheat those early. We can't find an easy way to do this though as those payments come out of our main checking account. The only way I can see to do it is to stale date everything, manually escheat the patient refunds, and then manually reinstate all of the checks. Does anyone do this and know an easier way
|
|
|
|
0 |
1298 |
07/27/2017 9:03 AM |
|
0 Replies and 1098 Views
Budget Advisor/Kaufman Hall Reports 1098 0
Started by rhorn01
We converted to Infor/Lawson from PeopleSoft recently. In PS, we included PO line level in our Budget Advisor AP reports. Currently in Infor, we still include PO purchases in our month end AP BA reports; that current build summarizes PO data at the PO level for each GL account/AU (rather than PO line level detail). However, we have problems pulling in relevant description b/c the PO description available for us to use is not necessarily indicative of all the items purchased on the PO. This has...
|
|
|
|
0 |
1098 |
07/21/2017 4:08 PM |
|
0 Replies and 962 Views
CB10 Upload 962 0
Started by AnonymousEmployee
Good Morning, I am working on creating an MS Add-in upload template for manual deposits entered into CB10 (Cash Receipt Deposit). The upload needs to create the Deposit 'header' in CB10.1, populate the breakdown of the deposit for CB10.3 and allow for overwrite account details in CB10.4 as needed. My company does not utilize the Journal Book option. Attached is the working copy of my template. First tab loads CB10.1 (deposit header) loads perfectly. The second upload to attach the detail t...
|
|
|
|
0 |
962 |
07/17/2017 10:12 AM |
|
1 Replies and 2283 Views
AP90.1 portal screen 2283 1
Started by YEEXCE1
Hi, We just upgraded to Lawson v10 and are using IE 11. Has anyone encountered an issue in AP90.1 where after inquiring for a vendor, you hit next or previous and the whole screen doesn't refresh We have an end user who was inquiring a vendor invoice. She noticed that if a vendor has multiple invoices that takes up the whole screen and when she clicked on Next or Previous where the next vendor has one invoice, the rest of the screen is still showing the PL and User Field 1 data from t...
|
|
|
|
1 |
2283 |
by JimY07/14/2017 5:40 AM |
|
3 Replies and 2462 Views
AP Vendor Query Speed 2462 3
Started by StvG
Using just three criteria: COMPANY equal company number (just one) APVENMAST.VEN-CLASS equal class (just one) APPAYMENT.CHECK-DATE = greater than or equal too a given date Table is large and query runs for about an hour and a half. Didn't know if someone knew if there was an index I could select that might speed this up, at least a little bit. Currently no Index\Key Value set in query. Thanks!
|
|
|
|
3 |
2462 |
by StvG07/07/2017 8:34 AM |
|
4 Replies and 2615 Views
1099 Production 2615 4
Started by Bob Canham
We have used Convey to produce our 1099 forms in the past. This product is being sunset in the near future, so we're looking for other options. How are others producing their 1099 forms and IRS file Are you using Lawson with MHC Or are you using some other 3rd party
|
|
|
|
4 |
2615 |
by O. Johnson07/06/2017 11:05 AM |
|
7 Replies and 2826 Views
printing 1099's on sunset version 9.0.1 2826 7
Started by Russell Spreeman
Having become 'affiliated' with a larger company, we are moving away from our own Lawson system onto a corporate system but we are not there yet. We have discontinued our use of Lawson HR / payroll applications as of a year ago. Being on 9.0.1 our extended support is sunset as of the end of May 2017. We will not be ready to move off of our Lawson IC / AP system for a while yet. We have been quoted a very large sum to upgrade our system to v10 (or whatever is current) including migrating to Lawso...
|
|
|
|
7 |
2826 |
by Eric9906/20/2017 8:55 AM |
|
2 Replies and 2736 Views
Asset Management Mass Addition 2736 2
Started by Rhonda Cordes
We have quite a few assets that need to be added to our Lawson system before our fiscal year-end which is June 30. I have been told that AM500 may be our only options; however, that does not create the GL journal entries automatically and we would have to manually create them after loading the assets. Has anyone completed a mass addition of assets If so, what process did you use Any information on how to do this mass addition is greatly appreciated. Thanks, Rhonda
|
|
|
|
2 |
2736 |
by Kelly05/31/2017 4:19 PM |
|
2 Replies and 2346 Views
Print Manager/GL90 2346 2
Started by Jason Bobbin
Hello, I work with Infor daily and I have noticed that some screens such as the AC290 have a print manager button but others do not. Is there a way to add a print manager button to the GL90 instead of having to open a new tab and searching print manager
|
|
|
|
2 |
2346 |
by John Henley05/28/2017 3:43 PM |
|
0 Replies and 1916 Views
Positive Pay - Bank of America 1916 0
Started by LauraPat
Hi - thanks in advance for any feedback. We want to add Payee Name to our positive pay file to Bank of America for AP. Initially - it seemed as simple as taking the Legal Name from AP10 (APVENMAST) and putting it into the Payee Name in the CD0200R record for BofA. In our Lawson system - our AP staff also may put additional 'payee' information in the first couple of address lines and then have the last line for the actual address. Bank of America is failing all of these payments because they ...
|
|
|
|
0 |
1916 |
05/23/2017 2:22 PM |
|
0 Replies and 1274 Views
Select from data list 1274 0
Started by Diane G
We recently upgraded to Lawson 10. Somehow in the process, I lost the ability to just enter the first letter of a field, hit my down arrow and have the next item in the selection populate. For example, when entering a new asset, we have 40 locations. I could enter a P hit my down arrow once and Perry would populate. I have not been able to find a setting to change this. If I right click on a field it says - Select from data list Enter This is minor, but annoying.
|
|
|
|
0 |
1274 |
05/17/2017 3:55 PM |
|
0 Replies and 1324 Views
Smart Recon 1324 0
Started by brooke
Good Morning We recently upgraded to Smart Recon SMR_10000516 and Smart Recon is VERY slow. Has anyone else had this issue thanks brooke
|
|
|
|
0 |
1324 |
05/16/2017 10:20 AM |
|
0 Replies and 1040 Views
GL199-final closed periods back to limit-close 1040 0
Started by Chesca
My users accidentally final-closed periods FY17 periods 1-12 while. They try to run the GL199 but the system won't let them change the FY17 periods back to limit-close. I put a ticket with Lawson but unfortunately there is no way for the system to undo a Final Closed period. They suggested a resolution but it's out of their scope and will be use at our own discretion. Do you know another way to do this
|
|
|
|
0 |
1040 |
05/16/2017 7:48 AM |
|
1 Replies and 2516 Views
AP10 & AP10.5 - update through IPA - Lawson Transaction. 2516 1
Started by Bonde
I have been trying to figure out what will be the primary keys required to make a lawson query to pull information of the AP10.5 Form My understanding - 1)AP10 need the 1. VEN-VENGROUP AND 2. VEN-VENDOR to inquire the information of that form 2)AP10.5 needs 1.APX-VENDOR to inquire and change - Lawson query - _PDL=TEST&_TKN=AP10.5&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=I&APX-COMPANY=100&APX-TERM-CODE=&APX-VENDOR=56302&_DELIM=09&_OUT=XML&_EOT=TRUE I inte...
|
|
|
|
1 |
2516 |
by Bonde05/15/2017 1:10 PM |
|
5 Replies and 4332 Views
EDI and Credit Memos 4332 5
Started by JonA
How do you process a credit memo when it comes via EDI and is translated to the MA540CSV file Our AP departments says they error out and they just deleted them and request a paper credit memo from the vendor. The Infor/Lawson KB says that you can receive credit memos via EDI but doesn't say anything about how to process them with MA540.
|
|
|
|
5 |
4332 |
by Jeremy05/12/2017 9:33 AM |
|
3 Replies and 2487 Views
Sub Account vs Activities 2487 3
Started by Eddee
We are looking for the best way to report and track projects in our general ledger account for CIP. We are considering using either activities or subaccounts. Does anyone have any advice as to which would be the best option Does anyone have any general advice for using subaccounts Pros and cons Thanks, ED
|
|
|
|
3 |
2487 |
by Jeremy05/03/2017 1:22 PM |
|
8 Replies and 9197 Views
Activate account for all accounting units 9197 8
Started by Paul
I have a group of pre-existing accounts that are active in some accounting units and inactive in other accounting units.&160; I want to make these accounts active for all accounting units.&160; I have tried using GL 100 (Mass Chart Acct Change Delete) and GL 121 (Mass Account Addition).&160; Does anyone know how to do this
|
|
|
|
8 |
9197 |
by Mark F. Hardy03/31/2017 3:15 PM |
|
0 Replies and 1603 Views
Error while submitting Jobs in infor lawson 1603 0
Started by roogi
Hello All, Am facing an error while submitting jobs in INFOR Lawson... Here is the Error message....Can any one please help me out to fix this... JobSubmitter:handleError():Job Submit Failed, check your parameters. Details: com.lawson.ios.common.impl.CGIResponseException: JobSubmitter:handleError():Job Submit Failed, check your parameters. at com.lawson.ios.jobs.job.impl.JobSubmitter.handleError(JobSubmitter.java:308) at com.lawson.ios.jobs.job.impl.JobSubmitter.submitJob(Job...
|
|
|
|
0 |
1603 |
03/28/2017 3:17 AM |
|
2 Replies and 2378 Views
PO135 - AC 2378 2
Started by rhorn01
Currently when we run PO135, it doesn't appear that the POs that are coded to Activities (construction projects & fund accounting) are hitting AC. They are hitting the GL, causing a difference between the GL & AC. What is best practice - to leave these as reconciling items between AC & GL or load these POs into AC We have only been live with Lawson a short time so any input is appreciated. Thanks!
|
|
|
|
2 |
2378 |
by JonA03/16/2017 1:03 PM |
|
2 Replies and 2091 Views
Descriptions from CB Upload Template into GL 2091 2
Started by rhorn01
We use a CB deposit upload template to record various deposits throughout the organization. We use the description field of the upload to describe what the deposit relates to & load that into CB. However, once we post those transactions into the GL, the detailed description from the template does not show; rather, the JE is a 'summarized transaction' or 'misc GL deposit'. Is there a way to have these detailed descriptions to come over to the GL
|
|
|
|
2 |
2091 |
by rhorn0103/15/2017 3:21 PM |
|
3 Replies and 2413 Views
Cerner Millennium - Lawson GL 2413 3
Started by JasonP
Hi, any customers out there that use Cerner Millennium to Lawson GL s3
|
|
|
|
3 |
2413 |
by Keith Anetsberger03/03/2017 2:36 PM |
|
4 Replies and 5812 Views
Raiser’s Edge Fund Raising Software 5812 4
Started by Deleted User
Hi everybody, Has anyone integrated Lawson with Raiser’s Edge Fund Raising Software If so, in which Lawson modules are you interfacing Raiser’s Edge Fund Raising Software transactions Thanks for reading my post! Joanna
|
|
|
|
4 |
5812 |
by SWilkins03/02/2017 3:48 PM |
|
1 Replies and 2115 Views
MSCM Par counting Report-blank 2115 1
Started by Chesca
My MSCM screen is not working. I can log on but cannot see my reports in Par Counting. Two other users have reported the same problem. It's not happening to every user, which is so weird. I put a ticket with Lawson but they don't seem to know what is causing this issue.
|
|
|
|
1 |
2115 |
by JonA02/09/2017 8:21 AM |
|
3 Replies and 2758 Views
add one-time vendor 2758 3
Started by Russell Spreeman
We have a person who keys in patient refunds to our Lawson system. She needs to be able to create one-time vendors for this (as the patient becomes a vendor). However we don't want the person to have the ability to go into the Vendor screens and just add new vendors. Is there a way to allow for adding one-time vendors only We are on Applications v 9.0.1.9 and LAUA security at this point.
|
|
|
|
3 |
2758 |
by MattB02/03/2017 12:55 PM |
|
1 Replies and 2140 Views
GLTRANSREL 2140 1
Started by Chesca
Does anybody know if the GLTRANSREL table/layout was changed in Lawson 10
|
|
|
|
1 |
2140 |
by alexrs02/02/2017 10:24 AM |
|
2 Replies and 2267 Views
PO copy to requestor 2267 2
Started by HurricaneRax
Is there a way to automatically send a copy of a PO to the requestor on record Is that something that can be built in This would be in addition to sending out to vendor via EDI, Fax/Email, etc that is already populated on the PO. Thanks.
|
|
|
|
2 |
2267 |
by JimY01/31/2017 6:13 AM |
|
2 Replies and 2155 Views
EDI 10.0.5.8 2155 2
Started by Chesca
We are planning to upgrade from Lawson 9 to Lawson 10 and also upgrade EDI to the latest version. I have the release notes and EDI net change report and so far I only see changes to the POEDI data layout. Could somebody let me know if they encountered issues or if they know of other changes Thanks
|
|
|
|
2 |
2155 |
by Basia01/27/2017 12:57 PM |
|
2 Replies and 4154 Views
CB Mass Reconciliation upload template 4154 2
Started by harold_c
Hi, I am trying to create a CB reconciliation upload using form CB80 for the mass reconciliation I am currently doing via CB185, but encounters errors after the 1st line is successfully uploaded, and cannot figure out why, error is: This form action valid on open transactions only (_f51r0). Does anybody have a template/process they would like to share How do you do your reconciliation Thanks.
|
|
|
|
2 |
4154 |
by harold_c01/23/2017 12:30 PM |
|
2 Replies and 3001 Views
AP out of balance due to data error. 3001 2
Started by dorota34
Our AP has been out of balance with GL since 2013. I was able to identify old invoices back from 2013 that are matched , paid and journalized however they are not being picked up by AP reconciliation report. The problem is caused by mismatch between APINVOICE and APDISTRIB table. OBJ_id in AP Invoice table does not equal to api_obj_id in APDISTRIBUTION. All other tables ( match, gl etc) are correct ( they match Ap distribution table). I am assuming user somehow was able to delete invoice hea...
|
|
|
|
2 |
3001 |
by dorota3401/20/2017 8:14 AM |
|
0 Replies and 1395 Views
GL20 Posting account activation 1395 0
Started by Deleted User
Does anyone have an add-in upload that they will share to update GL20 posting accounts I thought one of the conversion programs allows you to mass add accounting unit account posting combinations. Is that GL167 Any input will be appreciated.
|
|
|
|
0 |
1395 |
01/17/2017 5:32 PM |
|
1 Replies and 2236 Views
Intercompany GL165 2236 1
Started by mcuser
Does anyone know how to load a multi-company journal to GL165 that will use Lawson GL25 Intercompany relationships
|
|
|
|
1 |
2236 |
by Deron01/13/2017 4:48 PM |
|
4 Replies and 3020 Views
MSCM Handhelds selection 3020 4
Started by Chesca
We are in the process of replacing MC70 HHs and Lawson provided us with a listing of MSCM compatible/supported versions. There are so many and we have short period of time to purchase and test the devices. Would anybody be willing to share their process on selecting devices or suggest what things to look for when selecting a new device
|
|
|
|
4 |
3020 |
by JonA01/11/2017 10:22 AM |
|
0 Replies and 926 Views
Company Close Out 926 0
Started by Boyd
In a prior year a Company that was set up in Lawson was sold to a third party. When the assets were sold, we removed the assets from the company and as liabilities were resolved we removed the liabilities from the books of this company. As of 12/31 we were left with only intercompany receivables and equity. Now our tax department wants us to zero out the intercompany receivable balance and equity. Although these accounts have balances they don't zero out. How can we remove these balances wi...
|
|
|
|
0 |
926 |
01/09/2017 3:22 PM |
|
2 Replies and 2647 Views
Spreadsheet Server 2647 2
Started by Boyd
We are installing Spreadsheet Server and I was looking to see if anyone has any tips or tricks for setting it up. We are looking forward to streamlining our monthly financial statement distribution process.
|
|
|
|
2 |
2647 |
by Boyd12/21/2016 2:09 PM |
|
0 Replies and 1371 Views
How to Post Gl65 Transactions with Different Journal Headers 1371 0
Started by emowry
We are currently using GL65 and GL165 to post transactions from our revenue system into lawson. The transactions are all imported into GL65 with descriptions but when we post the transactions through GL165 the GLTRANS description only says 'upload'. Is there a way to change this so it maintains the description from the original GL65 entry
|
|
|
|
0 |
1371 |
12/14/2016 10:12 AM |
|
|
1 |
2272 |
by John Henley12/05/2016 9:17 AM |
|
2 Replies and 2373 Views
Bank File 2373 2
Started by Bev Edwards
Where does the file reside on the Lawson server after the CB185 creates it and before the CB80 uploads it
|
|
|
|
2 |
2373 |
by JimY11/15/2016 5:18 AM |
|
0 Replies and 1138 Views
CB260 calculation 1138 0
Started by IrvinB
Im writing a report to have the same results as program CB260 using the CBTRANS , does anybody know how the calculation is for the calc fields, (Acctcurrencyissued-amt3, Void-amt-3, Net-effect-amt-3)
|
|
|
|
0 |
1138 |
10/20/2016 7:45 AM |
|
2 Replies and 2272 Views
GL165 errors exist 2272 2
Started by Chesca
I just got a call from a user that runs the GL165 in report mode. We are having a problem with an account where the cost center would not be accepted but it was. It shouldn't allow to post to any accounting unit other than X account. GL165 is not a customized program so where is this validated and is there a Lawson screen that maps these to valid cost centers
|
|
|
|
2 |
2272 |
by Chesca10/13/2016 3:41 PM |
|
0 Replies and 1098 Views
Matched In Summary - Link to PO Lines 1098 0
Started by Jeremy
Here's my issue: We are matching in summary so when we post to GL, there's no way to work our way back from a GL transaction to see which PO Lines were combined to make up that transaction. Has anyone been able to find a link through all the various tables (GLTRANS, MAINVDTL, APDISTRIB, etc...) to be able to create a report
|
|
|
|
0 |
1098 |
10/13/2016 2:36 PM |
|
0 Replies and 1267 Views
how we can differentiate Credit card and non credit card payments in AR..? 1267 0
Started by kencha
Hello All , Can any one tell me where we can set up '' pay types we set up for Payments and credit card payments '' ..in AR From ARPAYMENT table any ways to identify whether the payment received is from Credit card or non credit card payments If we need to define any pay codes for Credit card payments where we can define them in AR..
|
|
|
|
0 |
1267 |
10/13/2016 10:20 AM |
|
0 Replies and 1183 Views
Attributes for accounts 1183 0
Started by SM
Hi, We had a request to add new sub accounts for specific accounts in COA. Instead of adding new sub accounts, we were asked to create attributes for those specific gl accounts. They need these attributes to keep track of items that relate to a particular sub set of data. Ex: they have one cash account but they need attributes to that account so that they can track the data separately for cash reconciliation. Please advise how to accomplish this task and also what reports can I get for ...
|
|
|
|
0 |
1183 |
10/08/2016 10:57 AM |
|
0 Replies and 1053 Views
Attributes for accounts 1053 0
Started by SM
Hi, We had a request to add new sub accounts for specific accounts in COA. Instead of adding new sub accounts, we were asked to create attributes for those specific gl accounts. They need these attributes to keep track of items that relate to a particular sub set of data. Ex: they have one cash account but they need attributes to that account so that they can track the data separately for cash reconciliation. Please advise how to accomplish this task and also what reports can I get for ...
|
|
|
|
0 |
1053 |
10/08/2016 10:57 AM |
|
0 Replies and 1413 Views
MA540 Vendor Agreements 1413 0
Started by chadT
When entering Vendor Agreement Invoices manually into Lawson, you can add Line distribution detail on MA43.7 (from Ma43.6) by clicking the 'Enable' button. Is there a way to accomplish this through the MA540 interface adding multiple distributions with the same line number is not supported through MA540 so I was wondering if there was another way to override while also still matching against the PO25 Vendor Agreement through MA540. The use case is that there is a Vendor Agreement setup with...
|
|
|
|
0 |
1413 |
10/07/2016 12:55 PM |
|
3 Replies and 2284 Views
GL165 entries 2284 3
Started by Chesca
How do I get transactions to show in GL after posting transactions in GL165 Is there a batch program my user would need to run
|
|
|
|
3 |
2284 |
by harold_c10/06/2016 10:25 AM |
|
3 Replies and 2798 Views
856 Adv Ship notices 2798 3
Started by Chesca
This morning we got the 856 Adv Ship notices file from GHX and were received in with no errors. However, my users told me that 5 Pos, the back-orders weren't cancelled. I am assuming they are supposed to be cancelled by an automated job GHX has these PO's are partially shipped so some items shipped and the others are back orders. What program should have killed/cancelled these orders Any feedback or suggestions would be greatly appreciated, thanks in advance.
|
|
|
|
3 |
2798 |
by Kat V09/15/2016 9:08 AM |
|
2 Replies and 2629 Views
fill & kill order 2629 2
Started by Chesca
I noticed we send a PO to GHX on 8/23 that is still in waiting on confirmation status. The user says that it should not be because it was cancelled. It is a fill and kill order. Could someone please enlighten me of what this means Every time I ask this user, she tells me she knows nothing about our batch jobs.
|
|
|
|
2 |
2629 |
by Chesca09/12/2016 9:25 AM |
|
|
4 |
3410 |
by Sharri T09/01/2016 6:35 AM |
|
2 Replies and 2500 Views
Kill/cancel EDI orders 2500 2
Started by Chesca
We don't have a SME for shipping/receiving so it's hard to understand what jobs need to be changed. I got a call from a user that wants to change a job scheduled in recdef that automatically cancel/kill EDI bulk orders. I asked the user what job they are referring to and she has no idea. Any idea what to look for
|
|
|
|
2 |
2500 |
by JonA08/31/2016 8:19 AM |
|
|
0 |
1072 |
08/24/2016 1:09 PM |
|
3 Replies and 5370 Views
Bank Rec Interface 5370 3
Started by mcl
A Lawson newbie, so be easy, please.&160; Thought easiest interface to tackle would be flat file .txt from bank to Lawson Bank Rec.&160; On LSF9 so I see two options--CB185 flat file&160; and&160; CBSTMTREC database file.&160; Any suggestions&160;&160;&160; With importdb, do I list all fields in header record, comma separated, or just the fields I want to upload&160; Would Add-Ins be a better upload option&160; Thanks
|
|
|
|
3 |
5370 |
by SYED08/22/2016 3:22 PM |
|
1 Replies and 3044 Views
Data Export from Lawson 9.0.1 3044 1
Started by Lawson Beginner
We are trying to migrate to a new financial system and hence need to export master and transactional data from Lawson. Can any one help understand the best way to approach this
|
|
|
|
1 |
3044 |
by Lawson Beginner08/16/2016 1:22 PM |
|
1 Replies and 2372 Views
AP155-check payments file overwritten 2372 1
Started by Chesca
My user accidentally rerun AP155 so it overlaid the check file, is there a way she can get recreate the same file
|
|
|
|
1 |
2372 |
by Jimmy Chiu08/03/2016 4:08 PM |
|
0 Replies and 913 Views
Multiple EFT email recipients 913 0
Started by Todd Mitchell
We are often asked to add more than one e-mail address to receive the EFT payment notifications. I know in the past Lawson has said no. We are getting increased requests and customers are frustrated at the lack of technology and ease of use for the notifications. Has anyone dealt with this situation and/or know of any possible solutions
|
|
|
|
0 |
913 |
07/14/2016 7:10 AM |
|
4 Replies and 2511 Views
GL165 entries 2511 4
Started by Chesca
Does anybody knows if there is a Lawson program that can allow me to delete entries from GL165 to prevent double posting the entries There are about 150 transactions in GLTRANSREL.
|
|
|
|
4 |
2511 |
by Chesca07/12/2016 10:30 AM |
|
0 Replies and 970 Views
GL16.2 adding attributes 970 0
Started by L G
Might be a noob question. How does one add attributes in GL16.2. I mean how to setup attributes and how to navigate to GL16.2 to add them to individual accounts
|
|
|
|
0 |
970 |
07/05/2016 9:29 AM |
|
0 Replies and 1459 Views
Partial Period Depreciation 1459 0
Started by Ron Swanson
Client has iSeries 8.1 Lawson. With a transfer in investors a new company was created. The new company start date is mid period. They want to post Asset Depreciation for the partial period in the old company, and remaining in the new company and keep the Asset files and G/L in sync. Presently the Asset Period Calendar matches the Fiscal Calendar though they do not have to be. Tried changing the Asset Calendar would not let me with assets in place. Any ideas on how to handle this, sho...
|
|
|
|
0 |
1459 |
06/16/2016 3:58 PM |
|
5 Replies and 4159 Views
Credit Card Processes 4159 5
Started by toria1248
Hello, I was wondering if anyone had any suggestions on how to import credit card transactions We currently upload every credit card by month separately as a Journal Entry. And the more we grow, the more users receive credit cards and it came up in discussion - how do other companies handle their credit card purchases From what I've seen there's a P-card module We currently don't utilize it. How useful is the module Or does anyone use an external software to track their detail and up...
|
|
|
|
5 |
4159 |
by facendaa06/01/2016 7:34 AM |
|
2 Replies and 2618 Views
MHC for check viewing / W2 etc 2618 2
Started by Ronnie
I have been with two companies who used MHC for check printing / viewing / w2 etc. Are there any other vendors who work with lawson who also offer the same I have been asked to investigate alternatives, but I have honestly not heard of any others.
|
|
|
|
2 |
2618 |
by Kelly05/31/2016 3:07 PM |
|
2 Replies and 2263 Views
Who owns the MA60 screen? 2263 2
Started by Capital-Key
Currently in our Lawson security, AP owns the MA60 screen, but doesn't like to use it. They believe that all invoices should match in AP20 perfectly. However, when they don't, they will not go to MA60 to release the payment unless they are instructed by Supply Chain. Otherwise it sits on our exceptions database in SharePoint. So I asked them why should AP own it if Supply Chain has to tell them when to use it I'm just curious .... Who owns the MA60 screen at your place of business
|
|
|
|
2 |
2263 |
by JimY05/25/2016 11:30 AM |
|
0 Replies and 1231 Views
Intercompany Payment Transfer 1231 0
Started by Magus
' How to transfer UNASSGINED cash sitting in one company to a customer belongs to differnt company' Can any one please help me on this in detail.. I tried to link companies using GL25 and created a National Account relation using AR12.1 . But while doing Payment transfer using AR29.1 am getting an error like ' TO COMPANY DOES NOT EXIST' Please help me on this.. Thanks
|
|
|
|
0 |
1231 |
05/20/2016 1:35 AM |
|
4 Replies and 2913 Views
Vendor Payments 2913 4
Started by brupp
Hello - Let's say you have a multiple line PO, & when the invoice is applied, at least 1 line creates a PO cost message. Do you hold payment until the invoice can be paid in its entirety or do you pay on the matched lines per normal terms, then pay the discrepant line(s) at a later time once the cost message is resolved And is either direction dictated by a setting in Lawson Thanks.
|
|
|
|
4 |
2913 |
by brupp05/17/2016 10:29 AM |
|
3 Replies and 2503 Views
PO Summary 2503 3
Started by jaherb
What is the easiest way to enter the PO and see the overall payments and overall remaining balance (money left on the PO) User is currently using PO64, but thinks there must be a better way Thank you Jim
|
|
|
|
3 |
2503 |
by jaherb04/28/2016 5:02 PM |
|
2 Replies and 3343 Views
How to Kill a Job 3343 2
Started by pops
We are running Lawson 10 and have users who submit jobs & reports. Sometimes a user submits a job/report that runs for over a 1/2 hour. Is there a way in Lawson 10 to kill this job maybe through Print Manager or does it have to be done on the back end (maybe through LID) and what would be the command to do this. Thank you in advance! Allen
|
|
|
|
2 |
3343 |
by pbelsky04/27/2016 11:59 AM |
|
0 Replies and 1146 Views
Month end processes in AR..? 1146 0
Started by Magus
What are the steps we follow in month end for AR.. i.e End of the month (EOM) processes we do in Accounts receivables to begin a new month as well as to close out previous open months. Please suggest me some of the , • guidelines to create new accounting periods, as well as closing out older accounting periods. • and for proper allocation of payments, and adjustments to the appropriate accounting period. What are the jobs names and steps we need to follow..Please enlighten me on thi...
|
|
|
|
0 |
1146 |
04/22/2016 9:36 AM |
|
4 Replies and 1958 Views
SQL QUERY NODE outputData 1958 4
Started by Magus
Hello All, Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank.. Please anyone guide me to fetch the results of that query and send them to a directory..
|
|
|
|
4 |
1958 |
by Magus04/22/2016 3:31 AM |
|
1 Replies and 2653 Views
AP175 GLTRANS R_DATE 2653 1
Started by Randy
I'm looking at APDISTRIB records and their linked (GLT_OBJ_ID) GLTRANS records. The GLTRANS records have AP / AP175, as the interface. What populates the R_DATE of the GLTRANS I was trying to determine if any distributions hit a prior month after statements were issued. Also most transactions are 'summarized' so I'm getting more detail at the AP level. However I see future (Years away) R_DATE in the GLTRANS record. I'll see GL POSTING_DATE of 2/29/2016 which I expect. But R_DATE anywhere from ...
|
|
|
|
1 |
2653 |
by TracyO04/21/2016 3:20 PM |
|
8 Replies and 3008 Views
Essbase 11 3008 8
Started by brooke
We are on 9.0.1.10 and upgrading essbase to 11 - has anyone able to get the lawson api to work with 11 for the IA120 to still work
|
|
|
|
8 |
3008 |
by brooke04/12/2016 3:22 PM |
|
10 Replies and 6088 Views
Lawson Certification of Essbase 6088 10
Started by Vicki
We are finally upgrading Essbase from Version 7 to Version 11 and have been told by Oracle that Lawson has only certified to Essbase version 9.3. We are using Lawson Analytic Architecture to feed our cubes and it is working well for us. Has anyone else using Analytic Architecture upgraded to Essbase Version 11 and if so, are you having any issues Have you ignored the lack of certification
|
|
|
|
10 |
6088 |
by brooke04/12/2016 3:21 PM |
|
4 Replies and 2626 Views
Vendor Status PO Add Inactive 2626 4
Started by ckmiller
Our vendor master controller has inactivated a vendor due to a merger and now invoices coming in electronically are rejecting. I've seen other vendors with a status of PO Add Inactive, which I understand does not allow for new POs and that's all the definition I can find on it. Will this status allow invoices for POs already created to pass through electronically
|
|
|
|
4 |
2626 |
by JonA03/30/2016 12:44 PM |
|
1 Replies and 2229 Views
Asset Management using Attributes 2229 1
Started by Sami117
We have to complete several asset surveys each year. The surveys require us to group certain pieces of equipment in categories with ACES codes. These 3 digit codes are used to report out equipment like computers (code 311), Office equipment (312), medical equipment (317). In our old Sage Fixed Assets software we created a category that was required for each asset to be either NA (for building, land, leasehold improvements) or one of the 3 digit codes for moveable, fixed, and software. This w...
|
|
|
|
1 |
2229 |
by Display Name03/25/2016 8:22 AM |
|
1 Replies and 1785 Views
AP Report 1785 1
Started by Brad Wade
Is there an AP report that shows the expense distribution of invoices on a check run This would be similar to the AP150, but with the expense distributions for the invoices as well. We are trying to find the easiest way to track where the expenses posted for each check run in a single report or job. Thanks.
|
|
|
|
1 |
1785 |
by Display Name03/23/2016 9:53 AM |
|
0 Replies and 1397 Views
CB50 Upload 1397 0
Started by harold_c
Hi. I am trying to do CB50 upload for a transaction like this one below: dept A Sales Tax-Feb 500 dept B Sales Tax-Feb 200 Company 1 Sales Tax-Feb 700 When viewing in GL90, what field or fields should I use so that it would show in dept A account description as 'Dept A sales tax Feb', in dept b account description as 'dept b sales tax Feb', and on the corresponding cash account as 'Company 1 Sales Tax Feb' Thanks.
|
|
|
|
0 |
1397 |
03/18/2016 11:56 AM |
|
0 Replies and 1230 Views
Lawson Flat rate tax on certain income codes 1230 0
Started by dkester
How do I set up a flat withholding rate for a specific income code If an employee chooses a flat percentage rate on their W-4, how does that impact the calculation on income codes wtih a fixed rate
|
|
|
|
0 |
1230 |
03/10/2016 5:12 PM |
|
4 Replies and 1806 Views
Vendor's payments 1806 4
Started by Chesca
Could anybody help me out with writing an SQL statement to get total check amount for each vendor in a given period Here is my select statement but I still need to include vendor name, tax ID and address: select company,vendor, sum(check_chk_amt) from lawson.appayment where check_date BETWEEN to_date('1/1/15','MM/DD/YY') and to_date('12/31/15','MM/DD/YY') Group by company,vendor HAVING SUM(bank_chk_amt) >= 600.00 order by company,vendor;
|
|
|
|
4 |
1806 |
by Chesca03/04/2016 8:07 AM |
|
6 Replies and 2129 Views
L_HACV and L_DACV environment tables 2129 6
Started by Tom_gbmc
We have a request from a user to modify one of our crystal reports, reporting on activities, to include the comments from AC10. Infor told me that this information is stored in L_HACV and L_DACV and that these are environment tables and not accessed in the same way as a 'typical' database table. Has anyone had any experience using these tables and is there a reasonable way to be able to access them as well as the other AC tables in one report Thanks
|
|
|
|
6 |
2129 |
by John Henley02/29/2016 9:45 AM |
|
0 Replies and 1246 Views
linking external scheduler to infor lawson 1246 0
Started by UDAYKVM9
Hello All..I am new to INFOR Lawson.I have a requirement to link Infor Lawson scheduler with an external Quartz scheduler. Can any one let me know how to do this Please any one enlighten me of this process..Thanks much ! :)
|
|
|
|
0 |
1246 |
02/24/2016 7:42 AM |
|
0 Replies and 1122 Views
BL123 posting to multiple compaies 1122 0
Started by Brian Espe
We are creating invoices via the BL520 interface program. Based on a custom table we need to distribute to multiple GL Companies. We are thinking of modifying the BL123 to accomplish this. Has anybody done this, or do you have another suggestion.
|
|
|
|
0 |
1122 |
02/22/2016 3:52 PM |
|
5 Replies and 1642 Views
Multi-threading batch AR cash applications 1642 5
Started by Todd Mitchell
I am inquiring to see what solutions anyone has come up with for multi-threading batch AR Cash applications. We have been using AR575 (ARIPMT) for years and this has served us well. However, the larger we grow we are finding that the limitation to AR575 only allowing 1 user or 'process' at a time was becoming troublesome. We then went to using AR580 as well. In order for this to work I had to customize AR575 and AR580 because they were not addressing the Batch Nbr 'locking' correctly. This ...
|
|
|
|
5 |
1642 |
by John Henley02/16/2016 4:01 PM |