|
|
|
|
|
0 Replies and 676 Views
Merging Summary Accounts 676 0
Started by Dixon
How do you merge summary accounts in mass efficiently, without going through the painstaking process of moving accounts individually account by account. Some of our summary accounts have a large number of individual GL accounts within them, and we'd like to merge them into one summary account. Thank you.
|
|
|
|
0 |
676 |
10/14/2013 5:35 PM |
|
0 Replies and 1074 Views
Adding a new Data Area tonight 1074 0
Started by Nathan E
We are adding a new data area to the production product line tonight. We are working with a very experienced consultant to do the work with us but I wanted to see if any of you had been through this and have any lessons learned you'd like to pass on. Things to look out for Pre-game preparations Post-create procedures Backstory: HR wants to create a new data area and make a copy of Production so they can use it as a historical archive. Create it, copy the data, secure it and lock it from c...
|
|
|
|
0 |
1074 |
10/14/2013 2:02 PM |
|
5 Replies and 1175 Views
What Lawson form?? 1175 5
Started by Bev Edwards
We have moved to LS9 Security (no more laua). Most of the forms we had access to were removed and now we are piece mealing them back. My director used to have access to an AP form that provided a snap shot of all AP Vendor payments. He also said he was able to compare one fiscal year to another using this form, but cannot remember which one it was. Our IT department is also not able to tell us. We looked in the Excel Add in list since that is our only window to all Lawson forms under eve...
|
|
|
|
5 |
1175 |
by Greg Moeller 10/11/2013 3:27 PM |
|
2 |
1228 |
by Ollerton 10/09/2013 4:38 PM |
|
2 Replies and 1378 Views
Managing GL,AP, AR interface fallouts 1378 2
Started by DougAB
We are interfacing transactions over from our OMS system to Lawson every 5 mins. There, of course, will be fallouts from either the importdb's or the interface programs themselves - AR550, AR560, AP510, AP520 and GL165. We are planning to gather all of the log files (.prt's) that have errors in them and put them in a central repository so we can easily identify the issue and resolve them. Couple of questions here: 1) are the output files from either the importdb's or the interface progr...
|
|
|
|
2 |
1378 |
by John Henley 10/03/2013 5:04 PM |
|
9 Replies and 1210 Views
How to tell if a job posted successfully i.e. GL165 1210 9
Started by Frank
I am trying to find out if a user for example runs GL165 in update mode, that it posted successfully I can't seem to find any information like this Thanks Frank
|
|
|
|
9 |
1210 |
by Greg Moeller 10/03/2013 4:43 PM |
|
1 Replies and 891 Views
Track new accounts or new accounting units created during a period of time 891 1
Started by Anna Tian
Hi, Everyone, We are asked to provide a list of new accounts & new accounting units created during a period of time. However, we do not have auditing features turned on. Is there any way to obtain this list without the auditing feature Does Lawson stores creation date or update date for Accounts/Accounting units in any tables (other than auditing tables) Also, I would like to know if you do not have auditing features turned on, do you use any controls to track creation or changes of new ...
|
|
|
|
1 |
891 |
by Anna Tian 10/02/2013 2:18 PM |
|
1 Replies and 1048 Views
Audit for Activities 1048 1
Started by Lynne
Hi, We are trying to see if the budget amount on an activity was changed. Is there an audit table for activities I have been unable to find any history. I looked at GL01.4 and when I select the AC line, the 'Audit' button does not display. We are on 9.0.1. Thanks!
|
|
|
|
1 |
1048 |
by Lynne 09/30/2013 7:57 AM |
|
1 Replies and 1262 Views
MA540 Vendor Payment Terms v. AP10 Vendor Payment Terms 1262 1
Started by Shannon R
Has anyone else run across this We use GHX for our MA540 files. On one specific vendor, the payment terms coming in through MA540 (payment terms are N30) are over-riding the Vendor Terms set up in AP10 for that specific vendor (N1). We need to pay this vendor at N1. We manually have to go change the date on each invoice or all of the invoices pay late. I can ask the vendor to change the terms on our account to N1, but this doesn't solve the root problem. Why is the MA540 file data over-...
|
|
|
|
1 |
1262 |
by JonA 09/24/2013 9:23 AM |
|
1 Replies and 1034 Views
GLTRANS field acct_amount 1034 1
Started by SN
Hi, Please help me understand where does the acct-amount from gltrans get its value from. also shouldn't base-amount and acct-amount have same values I have 2-3 scenarios where the base amount doesn't equal to the acct-amount.
|
|
|
|
1 |
1034 |
by SN 09/21/2013 9:47 PM |
|
15 Replies and 11162 Views
EDI 810 Invoices 11162 15
Started by Deleted User
Hi, Anyone have any tips and lessons learned about interfacing drop ship or expense type invoices into MA540 An example would be pharmacy, food, or office suppies. We're in healthcare and use O&M and GHX EDI 810s for for inventory, non-stocks and specials. We are looking for ways to take the data entry load off our AP staff for non receiving type purchase orders. Please post or e-mail to joanna.bledsoejhsmh.org. Looking forward to networking with you.
|
|
|
|
15 |
11162 |
by Shannon R 09/20/2013 10:07 AM |
|
0 Replies and 772 Views
Merging with another company 772 0
Started by Brenda
We are merging with another company and need to come up with a way that we can report as company X up until the merger and as company Y the day after the merger. We do not yet know if we will be staying with Lawson or moving to the finanical system they have, right now we just need to figure out a way to have a clean cut off between the two companies and report as Y company going forward. We currently have 23 active companies and we have subsystems and external systems that interface into our ...
|
|
|
|
0 |
772 |
09/18/2013 5:11 PM |
|
3 Replies and 1954 Views
Vendor Mergers and Acquisitions 1954 3
Started by JonA
How are vendor mergers and acquisitions handled within your organization If a vendor with active contracts and POs is acquired by another that is not in your vendor master do you add a new vendor and create new contracts/POs or do you change the name on the existing vendor
|
|
|
|
3 |
1954 |
by JonA 09/06/2013 3:05 PM |
|
4 Replies and 1224 Views
Report job to csv 1224 4
Started by Justin R
I have an AR250 job. Is there a way I can automically ouput that as a csv file
|
|
|
|
4 |
1224 |
by Greg Moeller 08/27/2013 1:57 PM |
|
2 Replies and 2150 Views
BR120 output, need an invoice in a format readable by Crystal Reports 2150 2
Started by johne
when i run br120 now i get the following viewable output files: BR120.prt ... the report showing what was processed/produced custom5 ... a format of the invoice that uses the tilde (~) character to designate the trailing value; e.g. ~STARTHEADER ~field Invoice Number IN 00000001 00000000 ~field Invoice Date ... ... ~ENDHEADER ... invoice1 ... text version of a printable invoice invoice1.pdf ... pdf version of the invoice i'd like to get an invo...
|
|
|
|
2 |
2150 |
by Baloy 08/27/2013 1:28 PM |
|
1 Replies and 1566 Views
Change Cash Code on Unpaid Invoices in AP 1566 1
Started by Ariel
Hello, Am on Lawson S3, V9. I would like to mass update any unpaid invoices that are sitting in the AP so that a new cash code overrides the existing cash code that was entered when the initial invoice was created. Now that we have changed bank accounts I would like to an easy automated way to pay old, unpaid invoices from our new account without having to manually change the cash code in AP30.3. Does anyone know of an automated process for this Much Thanks, -Ariel
|
|
|
|
1 |
1566 |
by Bob Canham 08/20/2013 2:40 PM |
|
0 Replies and 1365 Views
Accounts Payable Merging of 2 Vendor Groups 1365 0
Started by JamesB
I've got two companies that are going to merge and I've got both of them in AP as two separate vendor groups. They currently have separate bank accounts, separate check numbering systems, separate vendors, etc. They will soon be sharing a bank account and checks when they merge but they will still enter invoices and other data separately, while coordinating on the check numbers. There doesn't seem to be any precedent for this. Infor has nothing to offer with regard to this and I didn't see an...
|
|
|
|
0 |
1365 |
08/09/2013 1:34 PM |
|
2 Replies and 1876 Views
remittance notice for ACH payments 1876 2
Started by Maynard F.
Does anyone have a solution for the automatic sending of remittance notices electronically to vendors who are paid electronically I have considered using process flow or writing a custom program which would run daily. Please send me your suggestions. Thank you.
|
|
|
|
2 |
1876 |
by Maynard F. 08/07/2013 10:59 AM |
|
1 Replies and 811 Views
lp01 drop-down menu 811 1
Started by Chesca
My users can't see the drop-down menu for some reason in Portal. I am able to see it with no problem. Would this be a security issue, any idea what could be the issue
|
|
|
|
1 |
811 |
by Greg Moeller 08/06/2013 2:29 PM |
|
0 Replies and 753 Views
Matching in AP55 753 0
Started by DougAB
Here's our scenario: Some of our suppliers charge our corporate credit card immediately when an item is ordered from them. (we provide some of our suppliers our CC b/c we get $ back on purchases). Once our CC statement is available, these charges only show who the supplier is, but does not reference any PO number that we sent them (nor Invoice they sent us). We are trying to find a way to match these charges to the invoices. I spoke with a Lawson business consultant and she said the b...
|
|
|
|
0 |
753 |
08/06/2013 8:43 AM |
|
9 Replies and 2009 Views
Interfacing into a Surgical Information System 2009 9
Started by Bill Timmis
We are thinking about creating an interface out of Lawson in to the SIS system. The canned HL7 format reports just don't give us what we need since they are designed to pass Item Master data which is more than is needed by SIS. We are concerned however with an interface about how to account for passing only low unit of measure. Notoriously Purchasing will only have a box available to buy which is the only UOM in the system, but items get expensed by the each. Has anyone done anything similar ...
|
|
|
|
9 |
2009 |
by Greg Moeller 08/05/2013 9:13 AM |
|
1 Replies and 1208 Views
AP155 report format limitations 1208 1
Started by CharlotteM
Lawson’s AP155 is only printing 15 characters of the data typed in the Description field from the options tab of AP20.1 (API_Description|ID=_F122) when the field itself is 30 characters long. Can this be changed so the AP155 captures all 30 characters Our check writing program will accept and print them on our check remittance stubs if they were present on the AP155.
|
|
|
|
1 |
1208 |
by Ragu Raghavan 08/03/2013 9:05 AM |
|
4 Replies and 2522 Views
What is the best way to create an elimination company? 2522 4
Started by Deleted User
I would like to create an elimination company. I believe I can use the GL110 to do a company copy over and change the company status to 'E' in GL10.0.&160;
However, I would like to keep the elimination company simple with less Accounting Units set up, etc. Is there another method Is there anything that I should be&160;aware of
Thanks
Liz
|
|
|
|
4 |
2522 |
by Melissa 07/27/2013 8:14 PM |
|
0 Replies and 952 Views
Binding Billing API (BLOEL71PD) RPGLE 952 0
Started by Cory
Hi, Has anyone done a custom interface that generates next invoice number via the BLOEL71PD module We attempted to use this module as suggested in the Lawson documentation, however, this module has multiple links that we cannot find causing compile errors due to undefined symbols. Please share the code if you did. Thanks
|
|
|
|
0 |
952 |
07/25/2013 4:59 PM |
|
2 Replies and 1755 Views
Question on Purging Vendors 1755 2
Started by Bob Canham
We are currently evaluating the AP300 for purging one-time vendors. Based on what we have tested so far, everything seems to be working great to purge these based on a cutoff date. However, we are going to want to purge our regular vendors in the future as well based on a cutoff date. However, from the documentation we've read, the AP300 defines a 'No Activity Vendor' as a vendor who doesn't have a balance in APVENBAL for the current or previous year (Lawson KB 81692). That sounds like it...
|
|
|
|
2 |
1755 |
by Bob Canham 07/25/2013 10:57 AM |
|
0 Replies and 763 Views
How to get copy invoices from M3 in an electronic format 763 0
Started by Smerrick
Hello,I am new to this and have only basic knowledge. Is there a way to retrieve invoices via M3 in electronic format e.g. pdf, csv, etc I know that I can get copy invoices via OIS680 but how do I get these into an electonic format Addins etc cannot be included Any help would be greatly received.Thank youclear
|
|
|
|
0 |
763 |
07/25/2013 6:21 AM |
|
1 Replies and 1116 Views
Audit tracking on GL20.2 1116 1
Started by Melissa
I've found the account and accounting unit audit reports, but neither of these tell me who added an account at the AU level in GL20.2. Does anyone know how I can see who made accounts 'exist' for an AU
|
|
|
|
1 |
1116 |
by John Henley 07/19/2013 10:43 AM |
|
1 Replies and 807 Views
Percent Complete Calculation - AC165 and BR165 807 1
Started by Khristine
Is there any difference in percent complete processing between AC165 and BR165 Reason I ask is I used both and nothing seems different in terms of how both update ACPERCCMPL and ACPERCCMPLX and BR130 seems to be updating revenue transactions correctly for contracts Percent Complete. How do I know which one to use Thanks.
|
|
|
|
1 |
807 |
by John Henley 07/09/2013 6:51 AM |
|
11 Replies and 1769 Views
GLAMOUNTS and GLUNITS Tables 1769 11
Started by BShort
I am using Crystal and have used these two tables independently. Now i am joining the tables as the report I am writing needs both sets of information at the department level. Here is my problem: If an AU has both the amount accounts and the units accounts attached for example Salary accounts can have both amounts and units, I can get one or the other to pull correctly but not both when I play with joins. In the one report I have going, my salaried are tripple what they should be. I know it...
|
|
|
|
11 |
1769 |
by Deron 07/02/2013 2:40 PM |
|
1 Replies and 1167 Views
Reporting 1167 1
Started by RitaM
My healthcare organization is going live with Lawson in two days and I am looking for a comprehensive list of standard GL reports. Can anyone tell me where I can find this
|
|
|
|
1 |
1167 |
by Tony Conway 07/01/2013 4:25 AM |
|
3 Replies and 1802 Views
Invoice Line item detail 1802 3
Started by Parx400
I am working on a project where I have most of the Lawson tables extracted and put into ACL(Audit tool). I have Invoice numbers for invoices that were paid in 2011 and 2012 after running APPAYMENT and APINVOICE. I need to know the line item detail of these invoices so I can see what the paid price was fro each item. I have aprox 2.3 mil line items associated with the PO numbers found in APINVOICE. I need to be able to join the POlines that have PO pricing to the actual price paid on the invoice ...
|
|
|
|
3 |
1802 |
by Bob Canham 06/28/2013 10:34 AM |
|
1 Replies and 2153 Views
Cost Center hierarchy 2153 1
Started by Dichotomy
Can cost centers be linked to another 'higher' cost center where each cost center allows posting, and when reports are run for the higher cost center it includes all data from the cost centers linked to it Or would a company have to have a different reporting grouping category and have an extra cost center that represents the higher level expenses In other words, can more than one level have posting capabilities
|
|
|
|
1 |
2153 |
by Rich Bendickson 06/24/2013 2:55 PM |
|
2 Replies and 1350 Views
GL192 1350 2
Started by Rose Evans
Hi all, I work in the government sector and it is very important that we retain a view to our committments/encumbrances at the end of a fiscal year as well as maintaining a view historically month to month. I just discovered GL192 which takes a snapshot of your encumbrances/commitments at year end prior to running GL197 (rolls encumbrances/commitments to the next fiscal year). While I understand that this takes a snapshot year end, is GL192 a process that should be run at every month end t...
|
|
|
|
2 |
1350 |
by Terry Wier 06/24/2013 2:36 PM |
|
1 Replies and 1168 Views
copy/paste functionality from LID vs portal with LSF9 1168 1
Started by Deleted User
We are in the process of converting from LID to portal because of the upgrade to LSF9 security. One major function we seem to be losing is the copy/paste of data say from a GL95 inquiry. The create csv does not seem to adequately replace the copy/paste function. We are looking for any tips that would help us with this. Thank you.
|
|
|
|
1 |
1168 |
by John Henley 06/11/2013 3:39 PM |
|
2 Replies and 1576 Views
Crystal Report-Financial Ratios Chart/Graph 1576 2
Started by BShort
Good day all, I was not sure where to post this topic, so thought here. I have finanial ratios developed and have passed them to a subreport. I need to graph the ratio such as Total Margin now on a graph. In all of the google and reseach so far, the only way to do this in crystal is to send it to a subreport. I 'see' the shared variable now in the subreport, but can not get it to graph. I get an error message 'A print time formula that modifies variables is used in a chart or map detail'. ...
|
|
|
|
2 |
1576 |
by Donna 06/10/2013 3:35 PM |
|
1 Replies and 1429 Views
Adding Vendor Class to AP20.1 1429 1
Started by Paula @ CSU
Our users would like to see vendor class displayed in the same area where vendor name and address now appear on the AP20.1 screen (basic invoice entry). This field was not available in design studio to simply be added - so I took a look at the PD and WS and .scr - as well as the APIN70 library PD & WS and added the vendor class fields and moves where I thought appropriate based on what seemed to be happening with vendor name. I still do not see the field appearing even after successful compi...
|
|
|
|
1 |
1429 |
by Ragu Raghavan 05/29/2013 1:18 PM |
|
1 Replies and 1198 Views
Break up details- GL90.1 1198 1
Started by Suhas
HI can anyone please let me know how to obtain the break up details for transaction present in Transaction Analysis(GL90.1). Thanks.
|
|
|
|
1 |
1198 |
by mark.cook 05/21/2013 8:00 AM |
|
2 Replies and 1445 Views
Info Browser 1445 2
Started by Diane G
I just set up an Info Browser to get the current balance of one balance sheet account using the CYDAMT field. Why am I getting 10 different amounts The last one IS the current balance, which I need. I don't need to see the other 9. We are on Smart Office version 10.0.5.1
|
|
|
|
2 |
1445 |
by Diane G 05/17/2013 10:08 AM |
|
5 Replies and 1460 Views
mx10 interface 1460 5
Started by Matt
We're currently trying to mockup creating an org hierarchy using attributes on accounting units. Our levels are all messed up in GLNAMES and we aren't going to be fixing that anytime soon. So my question is, can we somehow externally interface with mx10 to either create a manual or dynamic list Update that list I'm not seeing anything out of the box that allows such interaction. Am I missing anything
|
|
|
|
5 |
1460 |
by John Henley 05/16/2013 12:48 PM |
|
0 Replies and 835 Views
customer process level and (revenue) account 835 0
Started by Justin R
I am posting invoices to the interface tables ARITRANS and ARIDISTRIB. How do I get to the process level and (revenue) account for a given customer
|
|
|
|
0 |
835 |
05/16/2013 11:54 AM |
|
1 Replies and 1185 Views
AP 20.2 Alowing invoice to post over Activity Budget 1185 1
Started by Chad T
We have recently set up a new company. In our previous company setup if we try to process a PO invoice over budget it gives a 'Cost Budget Exceeded' error message. Activities set up under the new company are allowing invoices to post over the activity budget - Where are these parameters managed
|
|
|
|
1 |
1185 |
by Laura 05/16/2013 7:38 AM |
|
0 Replies and 787 Views
AM20.3 Add-ins upload to add serial number 787 0
Started by Laura
I moved this to the Add-Ins forum - that's where I intended to post it originally. But if you have an answer, feel free to let me know! --------------------------- We need to be able to add serial numbers to specific line items on an asset in AM20.3. Does anyone know how to do this with add-ins since the field name for serial is always row0 We have assets that can have up to 100 line items and each one needs its own serial number. I haven't tried it yet but the user did and was unsucc...
|
|
|
|
0 |
787 |
05/15/2013 10:18 AM |
|
0 Replies and 2715 Views
Bad File status 3 5 on sortfile 2715 0
Started by Vijay S
I got an error Bad File status 3 5 on sortfile in IC130(General Ledger Interface) and job went to needs recovery state. Again Submitted the job, It completed successfully . What could have been the most probable reason(s) for its failure Regards, Vijay
|
|
|
|
0 |
2715 |
05/15/2013 9:56 AM |
|
0 Replies and 818 Views
Reopen Year End 818 0
Started by Ronald
We accidently ran AM195 (Year End Close) instead of AM190 (Month End Close) and in doing so we ran different AM190's and deleted the process. How can we reopen the year
|
|
|
|
0 |
818 |
05/14/2013 9:00 AM |
|
0 Replies and 870 Views
RW 100-Ratios 870 0
Started by BShort
Good day everyone. I have my Income Statement in RW and it is working great, now we want to add some items to it at the bottomw to create a manager type of dashboard for a better term. I have our statistics loaded in the 9xxxx series so have IP Stat, OP Stat, ER Stat. On RW, I have these showing up great after the my income statement. Now I want to do a ratio of Total Revenue per Total Stat for each department that may have the information. This is where I am stuck. I created another...
|
|
|
|
0 |
870 |
05/13/2013 2:23 PM |
|
3 Replies and 933 Views
Where would i find start time end time for daily productivity report 933 3
Started by Healthcare User
I need every employees start time and end time, to produce a daily productivity report. What time they are starting and ending. Labor productivity report. In which table the above information can be found. Thank you very much for the helpful info.
|
|
|
|
3 |
933 |
by Ruma Malhotra 05/13/2013 12:21 PM |
|
3 Replies and 2008 Views
AP30.2 Distribution changes post 9.0.1 Upgrade 2008 3
Started by Margaret
We have a Service PO invoice that we entered prior to our upgrade to version 9.0.1 that needs a distribution change. When we try to change the coding in AP30.2, we get an error message 'Cannot add distribution, invoice is unmatched'. Prior to the upgrade our service invoices did not require matching. Does anyone know how to change these types of distributions. I can't find anything useful in the Knowledge Base. Worse case is we can do a journal entry, but we like to keep the AP invoice coding ch...
|
|
|
|
3 |
2008 |
by KarenBCI 05/09/2013 5:04 PM |
|
2 Replies and 2144 Views
Grant Tracking: Accounting Units vs. Activities 2144 2
Started by Michael Grace
We are seeing a large increase in our grants volume and would like others opinions on why it is better to use accounting units vs. activities or vica versa. More than likely we are not going to use Lawson Grant Module so that shouldn't be a constraint. Any thoughts are appreciated.
|
|
|
|
2 |
2144 |
by Michael Grace 05/09/2013 12:09 PM |
|
0 Replies and 818 Views
Bulk Load of EFT Setup Data? 818 0
Started by Garth Gerwing
We are going to be collecting numerous of customers EFT setup data to support pre-authorized debit payments. Upon discussing with a Lawson Engineer - it was suggested: 1) At Conversion Time: Use AR501 (Customer Conversion) - uses staging table ARCCUST - this wil work nicely (and I've tested) - just include EFT setup data with the rest of the customer data conversion. 2) Post Go-Live: was suggested to use AR550 (Customer Interface) - uses staging table ARICST - I DO ...
|
|
|
|
0 |
818 |
05/06/2013 1:59 PM |
|
2 Replies and 1597 Views
How to Require Activity & Account Category 1597 2
Started by Gary
AC07 lets you limit an Activity and/or Account Category to specific GL Company, Accounting Unit, etc. but it doesn't appear to stop a user from entering no Activity/Account Category at all. Any way to require the entry of Activity and Account Category
|
|
|
|
2 |
1597 |
by Cindy 05/02/2013 10:21 AM |
|
0 Replies and 863 Views
AC500 - report showing duplicated lines.. 863 0
Started by johne
and if so, have you searched / found a patch to correct the problem.. QA person is testing against a 9.0.1.8 version of AC500. appears to have the report duplicating the last line of information on the 'Valid Records Listing' section when there is an 'Error Records Listing' section that follows. does not occur when there is not an error record group. I'm not finding anything in any of the Lawson KB areas & was just wanting to see if anyone else is seeing the same issue. header o...
|
|
|
|
0 |
863 |
04/29/2013 3:45 PM |
|
2 Replies and 934 Views
GL40 Status Message Account Category Required 934 2
Started by Ken Carley
Does anyone have any ideas why this may be the return message S3 9.0.1 Portal status message reads 'Account Category Required' when selecting &91;Change&93; for a two line entry. Each line's 'FC' is set to 'A'. Thanks for your time! I know this is wrong but I would like to know if anyone has seen it before. :crazy: Regards, Ken
|
|
|
|
2 |
934 |
by Ken Carley 04/29/2013 1:19 PM |
|
2 Replies and 1391 Views
Lawson Excell Add-Ins 1391 2
Started by Jeff Pratte
We have a MS Excel Add-in that has the Lawson server URL hard-coded into the Lawson Add-Ins login screen. How do we change that server address Thanks, Jeff
|
|
|
|
2 |
1391 |
by John Henley 04/29/2013 8:44 AM |
|
3 Replies and 1162 Views
GL security classes for LSF9 security 1162 3
Started by Deleted User
We are in the process of switching to LSF9 security. We are in the early stages of defining the security classes for the General Ledger group and are just wanting to know what items we need to look out for in the set ups. Thank you.
|
|
|
|
3 |
1162 |
by Georgette 04/25/2013 11:08 AM |
|
1 Replies and 943 Views
Colliding Allocations CA190 GL190 943 1
Started by Joseph Carfagno
Lawson will not process an allocation for a company if a GL190 is running. We normally run the CA190 for company groups. This can leave some allocations in a group processed and others in a released or processed state. This can get very confusing at month end. Both GL190 and CA190 are compiled as non-concurrent for us but I'd like for there to be a way to prevent CA190s from running when a GL190 is running and vice versa. Our Finance people are in muliple locations so coordination of work i...
|
|
|
|
1 |
943 |
by Barbara 04/14/2013 8:53 AM |
|
0 Replies and 762 Views
I need last updated column details on tables 762 0
Started by Healthcare User
Working on a client task to extract delta from all tables now chose 120 tables, Can someone please kindly if you have last updated date column details, which keeps track of record last updated dates. Please i am working on a task, to extract day to day data, based on dates preferably. I see some tables has created dates, which is only kee&91;ping teh created date info. But not updated dates. Does any one has any details on last update details of table rows, i would...
|
|
|
|
0 |
762 |
04/11/2013 8:14 PM |
|
0 Replies and 701 Views
PTO GL Questions (XPosted) 701 0
Started by Kelly H
Does your system pass the PTO from the LP to the GL side as the PTO is earned or is the bank balance calculated at the end of the month How often is the LP198 ran
|
|
|
|
0 |
701 |
04/08/2013 10:09 AM |
|
3 Replies and 1226 Views
Laser Check Printing File Security 1226 3
Started by Brian
We had a problem with check fraud when an A/P clerk edited the AP161 electronic payment flat file. I cannot lock down the A/P users folder rights because our laser printing software will crash when removing the file after importing. How do others handle this security hole Thanks, Brian
|
|
|
|
3 |
1226 |
by Brian 03/31/2013 12:40 PM |
|
3 Replies and 1163 Views
AP270 invoice detail? 1163 3
Started by clb393
To perform a reconciliation I need to find the employee detail that populated the invoice amount on the AP270. Any idea how i would get there Example - on the AP270 for Vendor 2611xx Invoice 500113030812513xxxx there is a payment amount of $54.00 to United Way. Where would i look to find the employee detail that populated that $54.00 Or should i look within the Voucher Is so, where should i look for that Thanks, Chris
|
|
|
|
3 |
1163 |
by Greg Moeller 03/28/2013 9:24 AM |
|
4 Replies and 834 Views
Report over PO 834 4
Started by sgoins
I am trying to find a way to run AP report that provides both invoice as well as PO. Just wondering if anybody had any suggestions on the best way to do this Any help would be appreciated. Thanks!
|
|
|
|
4 |
834 |
by Greg Moeller 03/27/2013 1:07 PM |
|
0 Replies and 932 Views
Asset Management S3 932 0
Started by Leo Montaos
If i have an Asset type 'Equipment' and under that type I have 2 assets, 1 asset should allocate the depreciation to multiple cost center and the 2nd asset under this type should not be allocated, how can this be done If i add allocation in AM06.6 this allocation will get assigned on the TYPE level therefore the 2nd asset will also get allocated which is i dont want to happen.. thanks
|
|
|
|
0 |
932 |
03/14/2013 4:09 PM |
|
0 Replies and 1173 Views
Asset Management 1173 0
Started by Leo Montaos
Dear Lawson Gurus, Is it Possible to processed a Leased assets in Lawson without using the Leased management In the user guide the last step is LM121 or LM21 is this mandatory Also, i would really appreciate if you could provide to me the best practices in lawson for Asset Management. Thank you..
|
|
|
|
0 |
1173 |
03/14/2013 3:48 PM |
|
1 Replies and 906 Views
need help with benchmarking 906 1
Started by DougAB
I am looking for a benchmark as to how long uploading 9000 records would/should take into the AR550 program. I would really appreciate it if someone was willing to upload the attached file that I am providing, or just do one with your own data, and let me know how long it takes for the AR550 to complete. I'm sure you already know, but you would first have to do an 'importdb', then do the AR550. For the 'importdb' - the Options field should be 'ad'; and the DB File Name field should be 'A...
|
|
|
|
1 |
906 |
by DougAB 03/12/2013 3:57 PM |
|
0 Replies and 710 Views
Prior year reqs 710 0
Started by TerryL
I ran RQ140 and found some old Unreleased reqs and a few that are in Needs Approval status from a prior year that is closed. What is the best way to get rid of those reqs out of the system
|
|
|
|
0 |
710 |
03/11/2013 7:46 PM |
|
2 Replies and 1098 Views
How do I create a new ATN-OBJ-ID? 1098 2
Started by Donna
I need to populate forms GL76 and AC46 directly from SQL. We are pulling from a different system and do not want to use Add-Ins. I know that I will need to have an ATN-OBJ-ID and a new GLT-OBJ-ID for the rows that will be inserted into ACCOMMITX and GLCOMMITX. Which table would have the last number used for these fields Are these calculated bases on data in a particular table
|
|
|
|
2 |
1098 |
by Donna 03/07/2013 5:13 PM |
|
7 Replies and 1193 Views
Vendor file read 1193 7
Started by slm4
I have never tried to read or use the vendor file before. I have been ask to create a file of all of the vendors for export. I need to know the coding to read file sequentially and any checks I would need to do in order to create that. Thanks.
|
|
|
|
7 |
1193 |
by slm4 03/04/2013 2:30 PM |
|
0 Replies and 844 Views
Physical 2 Virtual converstion 844 0
Started by Chad
We have a problem with our physical server that every time that we have to reboot it, it becomes unstable and unusable for users. Infor support can not come up with why this is happening and frankly has not been getting a good direction for a fix from any of the logs. In order to try and get a copy of the physical server, separated from our production server, so that it can be further trouble shoot I did a p2v conversion using vmware standalone converter tool. Everything went well but I can n...
|
|
|
|
0 |
844 |
02/27/2013 12:05 PM |
|
1 Replies and 1308 Views
Reconciling A/P to G/L 1308 1
Started by martyzoet
How does one go about reconciling A/P to the General Ledger. In the simplist form of the question, wouldn't the open invoice total equal the G/L A/P account balance If I run AP230, that will give me open invoices as of the run date. But I need open invoices as of year end date (putting the cut-off date in only looks at invoices with that date or prior, not OPEN invoices as of that date). It would seem to be a simple task but I'm unable to determine how to go about it.
|
|
|
|
1 |
1308 |
by martyzoet 02/25/2013 3:18 PM |
|
2 Replies and 1435 Views
Consolidation company 1435 2
Started by Display Name
Would be consolidating 2 live companies with the same chart/levels/currency. Both live companies use zone balancing and have intercompany relationships set up. Do I need to set up zone balancing in my elimination or consolidation company Does the elimination company need intercompany relationships to the live companies more to follow, let's start here first... Thank you
|
|
|
|
2 |
1435 |
by Display Name 02/24/2013 7:39 AM |
|
4 Replies and 1130 Views
Lawson Monitor 1130 4
Started by RickyY
Hello All, I was wondering if anyone out there have use anything software that monitor Lawson to show performance, connection issue, send out alerts if system is down or performing slower than it should, etc Thanks. ricky
|
|
|
|
4 |
1130 |
by RickyY 02/22/2013 6:21 PM |
|
1 Replies and 2875 Views
GL - Reopen Final Close Period 2875 1
Started by LauraSantos
We need to reopen a GL period that was accidentally closed with a Final Close status. I have a ticket open with Lawson support but they have not provided much help. Can anyone confirm if the steps below are correct 1. Create a quick paint utility of GLSYSTEM 2. Update the PER-END-CODE field from F (Final) to L (Limited) for the last period of 2012 (12/31/12). 3. I assume the user will then be able to use the Backpost option to reopen the period to add additional journal entries. 4. ...
|
|
|
|
1 |
2875 |
by John Henley 02/19/2013 10:42 AM |
|
3 Replies and 1340 Views
Accounts payable processing 1340 3
Started by jwhip
I'm looking for some information on how other companies using Lawson upload AP files for National/Large vendors as opposed to keying them in manually or manipulating electronic files from the vendor to load Thanks!!
|
|
|
|
3 |
1340 |
by Kat V 02/18/2013 4:00 PM |
|
0 Replies and 1048 Views
User Audit Trail? - AR82.1 - Returned Payment 1048 0
Started by Garth Gerwing
In evaluating the results of AR82.1 - Returned Payment - I am not seeing anything relating to a user/login audit trail on the resulting Debit Memo It would appear that Lawson is ignoring/breaking some of it's own data architecture rules in creating these results: - does not enforce/write a Debit Memo Reason Code (even though this is a required value for any debit memos being entered into AR) - does not write a corresponding TX Batch occurrence (BLINVHDR) - even though the Debit Memo is ...
|
|
|
|
0 |
1048 |
02/15/2013 2:18 PM |
|
0 Replies and 910 Views
Open A/P Invoices 910 0
Started by martyzoet
How do I get a list of all open A/P invoices that were open as of a certain date
|
|
|
|
0 |
910 |
02/12/2013 12:54 PM |
|
0 Replies and 2194 Views
PFI Workflow Failures 2194 0
Started by b.rain
I'm going to start by apologizing. Not only am I new to Lawson, but I am also new to the company that I'm currently working for. We are having a problem with Lawson which nobody here has been able to track down. Here is a rundown of the issue, as summed up by one of the application owners. ---------------------------------------------------------- 'We have been experiencing several incidents with Lawson ProcessFlow Integrator workflow units not executing. This is causing significant ...
|
|
|
|
0 |
2194 |
02/08/2013 8:03 AM |
|
0 Replies and 1158 Views
Vendor Payment Code 1158 0
Started by nhaines
I am looking for best practice in regards to the default setting for vendor payment codes in AP10. Our default setting is set to SYS. We have some vendors set up with a payment code of ACH on AP10 that have multiple remits (locations). These remits will pull as ACH and not SYS because of how the vendor is set up on the main screen in AP10. Idealy we want the system default setting to drive the payment code and not have to override it in the remit (location) forms. Any input or thought is we...
|
|
|
|
0 |
1158 |
02/06/2013 7:07 AM |
|
0 Replies and 911 Views
Multiple Orders; One Invoice 911 0
Started by Michelle
Does anyone know if it is possible to merge orders together to create one invoice. I saw that you can merge shipments in the Warehouse, however, the documentation specifially talks about doing this when the ship-to location is the same on both shipments. We have orders that we want to combine on an invoice that have different ship-to locations. What we are looking for is the ability to combine more than one order, possbily for more than one ship-to location, on one system invoice to the custo...
|
|
|
|
0 |
911 |
02/01/2013 9:34 AM |
|
2 Replies and 984 Views
Attribute List (MX10) 984 2
Started by Robert Spurr
Has anyone come across the following: (Version 9.0.1) We have lists built in MX10 which suddenly fail to produce data. If we replicate the list and making no other changes the new list works. What I found was that the sequence number was missing on the old list (MXLISTDR - Table) So I did a change on the lines of the list, previewed (returned data again) and validated the sequence numbers now existed. We are trying to figure out why this would have happen and any insight would be appreciat...
|
|
|
|
2 |
984 |
by Robert Spurr 01/25/2013 4:17 PM |
|
1 Replies and 1479 Views
Aging Reports (AR251) - F.O.R. 1479 1
Started by BErnewayn
When looking at an Aging Report (AR251), what does F.O.R. stand for at the bottom of each client summary and overall total I believe the term is comparable to the term DSO (Days Sales Outstanding). Thanks.
|
|
|
|
1 |
1479 |
by John Henley 01/24/2013 4:13 PM |
|
7 Replies and 5653 Views
Journal Entry Processes 5653 7
Started by Greg Wiklund
With internal controls, it would not be uncommon for a JE that a staff member creates to have six touch points as it goes from creation to entry (signatures, someone keys, someone reviews in Lawson). Currently, any JE that needs to be keyed into GL40 is on paper to get the necessary signatures. Has anyone had someone design a better way for JE's to get into Lawson, perhaps using process flow We use GL165 for larger imports, but I've envisioned someone creating a spreadsheet, approvals are ca...
|
|
|
|
7 |
5653 |
by John Henley 01/18/2013 9:28 AM |
|
2 Replies and 1097 Views
GLTRANS ACCOUNT and sub_account details 1097 2
Started by Healthcare User
Where can i find descriptions for Account and sub_account fields under GLTRANS table. Thank you very much for the helpful info.
|
|
|
|
2 |
1097 |
by dcaiani 01/17/2013 3:33 PM |
|
0 Replies and 796 Views
Calculate Daily productivity in dollars which table 796 0
Started by Healthcare User
I am working in a healthcare on ETL tools, now a requirement assigned to me, is to calculate the daily productivity on each day basis dollar amount. Could you please provide some details on tables. I am currently looking at GLTRANS table based on fiscal year, account, sub_account. But acct_amount and trans_amount fields are showing values zeros mostly and Units_amount has values. which field value should i sum to calculate daily productivity select fiscal_year, acct_period, account, ...
|
|
|
|
0 |
796 |
01/17/2013 4:43 AM |
|
0 Replies and 947 Views
Workflow Process 947 0
Started by Erin
We are new to Lawson and some of the staff will be attending Workflow training. For those of you who are experts, what can we do to be best prepared for the training (to maximize learning). Are their certain skill sets required Secondly, Once training is complete, what would be the estimated time someone out of training would take for creating low to max-complexity workflows Thanks!
|
|
|
|
0 |
947 |
01/11/2013 9:55 AM |
|
0 Replies and 921 Views
Cell Phone Reimbursement AP vs PR 921 0
Started by DavidV
Given IRC changes in cell phone policies. How are Lawson users handling cell phone reimbursement Are you still using stipends through PR or are you using AP My understanding of the IRC is that cell phone reimbursement is no longer taxable as long as there's a business need. If use PR how are you preventing it from being taxed or are you supplementing the amount to account for tax Any feedback would be appreciated. We are looking to setup a process flow to automate the request and impl...
|
|
|
|
0 |
921 |
01/10/2013 12:10 PM |
|
1 Replies and 829 Views
Getting Attribute chgs from AC13.7 to AC13.1 829 1
Started by johne
I'm loading new activity attributes into ACIFATTR for existing activities that have an attribute already assigned for the matrix category being used in the ACIFATTR records. I'm using today as the effective date. Using AC510, the records are found, brought into the system and removed from ACIFATTR. Run AC10 to view the activity, click on the Attributes button to access AC13.1 and I see that the attributes still contain the 'old' values. The 'Eff Date' button now has a...
|
|
|
|
1 |
829 |
by johne 01/08/2013 3:56 PM |
|
1 Replies and 1387 Views
Migrating From Lawson To Oracle EBS GL 1387 1
Started by Andy
Can someone please help with the migration path from Lawson to Oracle Financials GL. More specifically, what do i need to do on the functional side. ThanksVery Much, Andy
|
|
|
|
1 |
1387 |
by Andy 01/05/2013 4:30 PM |
|
0 Replies and 1998 Views
Paymode-X 1998 0
Started by dcaiani
I'm looking for Lawson customers that are using Paymode-X (Bottomline Technologies) to make electronic payments. The issues that we are facing are: • Paymode-X assigns each vendor a 20 digit identifier that needs to be entered somewhere in AP10 (APVENMAST). There are a couple of non-critical fields that can house a number of that size. Email, which we currently use. URL, which we currently use. • Are have 8 GL and 8 AP companies and 2 Vendor Groups. We are not planning on having all ...
|
|
|
|
0 |
1998 |
01/04/2013 2:42 PM |
|
0 Replies and 1144 Views
New FACTA regulations for Foreign Vendors 1144 0
Started by JoeD
We have to start reporting and withdrawing a percentage of money before paying foriegn vendors.Then we have to submit that money to the IRS. New FACTA regulation also known as 1042. Currently we just created another income code, 1042, and setting vendors up with that. But we need to have a field so we know how much of a percentage to keep and then it would be nice to have it somewhere in the invoice. Anyone else been doing this
|
|
|
|
0 |
1144 |
01/04/2013 11:40 AM |
|
0 Replies and 1045 Views
Using Analytics for Medicare cost report calculations 1045 0
Started by Jbergstrom
Trying to find out if anyone is using Lawson Analytics to integrate patient accounting data and finance data to perform the cost allocations and patient revenue allocations necessary for preparing data for Medicare cost reports.
|
|
|
|
0 |
1045 |
01/02/2013 3:38 PM |
|
0 Replies and 864 Views
Calc previous month 864 0
Started by Chesca
Is there an API that I can call to calculate the previous month given the parameter current month
|
|
|
|
0 |
864 |
12/20/2012 12:25 PM |
|
0 Replies and 1411 Views
Attachments to journal entries 1411 0
Started by lawsonuser2012
Hello - is there a way to attach journal entry support within lawson, specifically on GL40 screen I'd like to be able to pull up a JE and view the support for it within Lawson. I believe there is a module that allows this - has anyone utilized it and how does it work
|
|
|
|
0 |
1411 |
12/12/2012 7:53 AM |
|
1 Replies and 1236 Views
Replicate MA236 form in Crystal 1236 1
Started by imty
Hello All, I am trying to replicate the MA236 form 'PO received but not invoiced' using Crystal since we need an additional field (invoice date) to be added to the report and is currently not included in the report Lawson produces. I have identified the tables that I would need to create the report but I am not sure how to link them properly. I have identified the following tables: APVENMAST APINVOICE POLINE MMDIST I like to know what the proper relationship is between these tables ...
|
|
|
|
1 |
1236 |
by Ruma Malhotra 11/27/2012 1:48 PM |
|
1 Replies and 1026 Views
Table containing Reporting Currency Period Totals 1026 1
Started by darren
Is there a table similar to the GLAMOUNTS table which contains the reporting currency period totals instead of the Base Amount totals contained in the GLAMOUNTS table Does that exist For example: When running a GL95 with Type = R Reporting & Currency = USD (in our case), is the begging balance amount stored in a Lawson table for the specifiied account(s) or is the beginning balance calculated at the time of the retrieval Thanks!
|
|
|
|
1 |
1026 |
by John Henley 11/26/2012 3:31 PM |
|
1 Replies and 1175 Views
Asset Reports for Tax Return Preparation 1175 1
Started by Sabrina Hoppe
Our tax accountant is wondering which reports other companies use to get to year-end tax information on assets. We currently run a bunch of different reports that she uses (AM255, AM260, AM280, AM290) to essentially verify that Lawson matches all of her manual Excel tracking. Is there a way to make Lawson the source of truth / avoid all the manual Excel work / just have Lawson kick out the numbers needed for form 4562 Or does anyone have a Crystal or Query Wizard report built that does t...
|
|
|
|
1 |
1175 |
by Greg Moeller 11/14/2012 4:23 PM |
|
4 Replies and 1473 Views
RW100 logon failure 1473 4
Started by ABG
We are receiving a logon failure: unknown user name or bad password when running RW100 - we are running 9.0.1. Anyone else running into this
|
|
|
|
4 |
1473 |
by ABG 11/07/2012 8:38 AM |
|
5 Replies and 6727 Views
Hyperion Essbase - alternatives? 6727 5
Started by blong
Our accountants currently use Hyperion Essbase on a daily basis to pull financial (GL summary) information via Excel. We use Hyperion Reports for period close reports - P&L's, Revenue/Expense, etc. The financial cube is reloaded periodically via a scheduled Analytic Architect job several times a day to provide timely data. We are due to upgrade our Hyperion products but it is very expensive. I've heard of Cognos and Microsoft has an OLAP product that may work with Analytic Architect also...
|
|
|
|
5 |
6727 |
by Wouter Born 11/06/2012 7:55 AM |
|
1 Replies and 2223 Views
AP matching module 2223 1
Started by Erin
Hi everyone, We have the Lawson Financials but have not installed the AP matching module. We currently use inhouse written Matching, Purchasing and Inventorysystems. We will continue to use the inhouse Purchasing and Inventory systems for now but are considering moving to the AP matching module. I am sure once we get the system we will get the tech docs but we would like to find out what minimum fields are needed for 3 way matching from our inhouse systems as soon as we can so we...
|
|
|
|
1 |
2223 |
by JimY 10/23/2012 8:28 AM |
|
2 Replies and 3243 Views
AP90 Invoice Attachment URL Location Table 3243 2
Started by shashank
See the attachment for reference. On AP 90, if you drill down for an invoice, you get a pop-up page called 'Drill Around'. There is a list of options on the left section of this page. The first option in the list is 'Invoice URL Attachment'. Expanding this option gives you a link to the invoice image. When you click on the Invoice Image link, you see the Title and the Url on the right section of the page. Which Lawson table holds this title and URL I'm assuming each URL is tied to the ...
|
|
|
|
2 |
3243 |
by shashank 10/18/2012 1:13 PM |
|
3 Replies and 1810 Views
APAUDIT Table 1810 3
Started by rpripstein
I'm building a report using the APAUDIT table and in looking in the data dictionary at the Field ID values I'm noticing a bunch of them are blank and a few that my report is pulling are not even on the list. Is there a table in Lawson that would list the Field IDs and a descriptiondefinition Are the missing ones custom and possibly unique to our org Thanks in advance to any advice.
|
|
|
|
3 |
1810 |
by dcaiani 10/16/2012 1:49 PM |
|
8 Replies and 1631 Views
AP160 FORMAT - ONE LONG RECORD STRING 1631 8
Started by JPurvis
We are attemping to setup a NACHA file format using AP160. Our file currently is outputting a file that puts the data in one long string. We wanted to get this type of format below. Basically the normal NACHA looking format....any help or thoughts Where are we missing a flag or parameter to get the output to look like this Thanks! 1 data 5 data 8 data 9 data
|
|
|
|
8 |
1631 |
by JimY 10/04/2012 11:44 AM |