Search this forum:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 5 << < 12345 > >>
 Last Post
0 Replies and 985 Views Open A/P Invoices  985  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 985
02/12/2013 12:54 PM
0 Replies and 2375 Views PFI Workflow Failures  2375  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 2375
02/08/2013 8:03 AM
0 Replies and 1307 Views Vendor Payment Code  1307  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 1307
02/06/2013 7:07 AM
0 Replies and 1012 Views Multiple Orders; One Invoice  1012  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 1012
02/01/2013 9:34 AM
2 Replies and 1098 Views Attribute List (MX10)  1098  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 1098
by  Robert SpurrJump to last post
01/25/2013 4:17 PM
1 Replies and 1722 Views Aging Reports (AR251) - F.O.R.  1722  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 1722
by  John HenleyJump to last post
01/24/2013 4:13 PM
7 Replies and 6400 Views Journal Entry Processes  6400  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 6400
by  John HenleyJump to last post
01/18/2013 9:28 AM
2 Replies and 1205 Views GLTRANS ACCOUNT and sub_account details  1205  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 1205
by  dcaianiJump to last post
01/17/2013 3:33 PM
0 Replies and 900 Views Calculate Daily productivity in dollars which table  900  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 900
01/17/2013 4:43 AM
0 Replies and 1033 Views Workflow Process  1033  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 1033
01/11/2013 9:55 AM
0 Replies and 1003 Views Cell Phone Reimbursement AP vs PR  1003  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 1003
01/10/2013 12:10 PM
1 Replies and 951 Views Getting Attribute chgs from AC13.7 to AC13.1  951  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 951
by  johneJump to last post
01/08/2013 3:56 PM
1 Replies and 1600 Views Migrating From Lawson To Oracle EBS GL  1600  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 1600
by  AndyJump to last post
01/05/2013 4:30 PM
0 Replies and 2184 Views Paymode-X  2184  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 2184
01/04/2013 2:42 PM
0 Replies and 1272 Views New FACTA regulations for Foreign Vendors  1272  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 1272
01/04/2013 11:40 AM
0 Replies and 1166 Views Using Analytics for Medicare cost report calculations  1166  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 1166
01/02/2013 3:38 PM
0 Replies and 956 Views Calc previous month  956  0 Started by  Chesca Is there an API that I can call to calculate the previous month given the parameter current month
0 956
12/20/2012 12:25 PM
0 Replies and 1564 Views Attachments to journal entries  1564  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 1564
12/12/2012 7:53 AM
1 Replies and 1452 Views Replicate MA236 form in Crystal  1452  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 1452
by  Ruma MalhotraJump to last post
11/27/2012 1:48 PM
1 Replies and 1147 Views Table containing Reporting Currency Period Totals  1147  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 1147
by  John HenleyJump to last post
11/26/2012 3:31 PM
1 Replies and 1312 Views Asset Reports for Tax Return Preparation  1312  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 1312
by  Greg MoellerJump to last post
11/14/2012 4:23 PM
4 Replies and 1647 Views RW100 logon failure  1647  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 1647
by  ABGJump to last post
11/07/2012 8:38 AM
5 Replies and 7273 Views Hyperion Essbase - alternatives?  7273  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 7273
by  Wouter BornJump to last post
11/06/2012 7:55 AM
1 Replies and 2425 Views AP matching module  2425  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 2425
by  JimYJump to last post
10/23/2012 8:28 AM
2 Replies and 3749 Views AP90 Invoice Attachment URL Location Table  3749  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 3749
by  shashankJump to last post
10/18/2012 1:13 PM
3 Replies and 1930 Views APAUDIT Table  1930  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 1930
by  dcaianiJump to last post
10/16/2012 1:49 PM
8 Replies and 1754 Views AP160 FORMAT - ONE LONG RECORD STRING  1754  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 1754
by  JimYJump to last post
10/04/2012 11:44 AM
0 Replies and 1281 Views Actual and Budgeted Salary Dollars Report broken down by Job Class  1281  0 Started by  agersh My Finance department is requesting a crystal report that reports actual and budgeted salary dollars for a given bi-weekly pay period broken down by Job Class. Has anyone done anything like this
0 1281
10/04/2012 9:55 AM
0 Replies and 1487 Views CA10 Allocations Upload  1487  0 Started by  Stephanie Boles If your attempting to complete a large change to your current allocation structure, this may be of some help to you. Please remember that the files attached are specific to my company. You will need to comb through your CA20, to see if there are fields that you are using that I may not be. You will also need to amend your columns to include the data that you will require on both the Query Wizard and the Upload Templete. I suggest you complete this upload in a test environment first, in ord...
0 1487
10/01/2012 5:44 PM
1 Replies and 1315 Views Invoice detail upload  1315  1 Started by  TA Can someone tell me if there is a way to use a Lawson upload to do accounts payable invoice changes TA
1 1315
by  MichelleJump to last post
09/27/2012 11:26 AM
13 Replies and 11485 Views AP - Wells Fargo Payment Manager Service  11485  13 Started by  blong I am looking into utilizing the Wells Fargo Payment Manager service pay our AP vendors in Lawson. The service accepts a single file with several different payment types such as check, ACH, P-Card via Mastercard gateway, etc. Wells Fargo processes the data file and pays each vendor according to the payment type specified. I support our Lawson system from a technical aspect. I'm trying to determine how to best pull the data from Lawson so that it can be manipulated into the Wells Fargo format...
13 11485
by  blongJump to last post
09/27/2012 7:48 AM
0 Replies and 1104 Views Library routine  1104  0 Started by  Chesca Could I write a file/report off a library I am writing custom code in a library LPCUSTOMPD and would like to be able to write to a file. I am new to Lawson.
0 1104
09/25/2012 3:02 PM
6 Replies and 1810 Views ERDs for Newest Version  1810  6 Started by  Erin Does anyone know if there is a set of ERDs on the newest software version (or at least what has changed between the the current and latest versions) Were there a lot of changes
6 1810
by  ErinJump to last post
09/21/2012 3:14 PM
2 Replies and 2449 Views Inbound EDI 810's and multiple vendor locations  2449  2 Started by  Brent Hello. We are attempting to set up to process EDI 810’s in Lawson, using GHX. We have an issue regarding Trading Partner setups and how we configured our Vendor Locations in AP10.2. We have multiple facilities that have their own Trading Partner ISA ID’s. We have created a Vendor Location for each of our facility locations per each actual Vendor Location in order to have the proper account number in the AP10.2 form for each of our facilities. All of our Vendor Locations are set ...
2 2449
by  BrentJump to last post
09/20/2012 10:56 AM
2 Replies and 1934 Views Return number of days  1934  2 Started by  Chesca Hello, I was wondering if there is a function/API that calculates the difference between two dates and returns a number I coded but I don't think it is calculating correctly. Any help would be greatly appeciated, thanks! Here is my code: MOVE LPC-PRM-THRU-PROC-DATE TO WSDR-FR-DATE. PERFORM 900-DATE-TO-JULIAN. MOVE WSDR-JULIAN-DAYS TO WS-SYS-JULDATE. *===CONVERT EMP ADJ HIRE DATE TO JULIAN DATE MOVE EMP-ADJ-HIRE...
2 1934
by  TracyOJump to last post
09/19/2012 1:17 PM
6 Replies and 1813 Views ACTRANS has OBJ-ID = 0  1813  6 Started by  Lisa In our ACTRANS table, there are many rows where the required key OBJ-ID has a value of 0, but other rows have a value that we can then link to the GLTRANS table. Why is this value sometimes 0, and what process updates it to a valid value Thanks -
6 1813
by  LisaJump to last post
08/31/2012 4:15 PM
0 Replies and 2990 Views Lawson training or navigational guides  2990  0 Started by  DougAB Hi, I was wondering if anyone would be willing to share their Lawson training or navigational guides. We're going to be starting end user training in October and would like some ideas, etc. Thanks, D
0 2990
08/31/2012 10:22 AM
2 Replies and 1655 Views ARITRANS  1655  2 Started by  DougAB I believe the ARITRANS table is a temporary table to interface records to (er, so I'm told). What the corresponding permanent table for ARITRANS after running the AR560 program There is a field called, AIT-USR-FLD-03, in ARITRANS that I'm curious where it gets mapped to after running the AR560. Is there any documentation, in general, where temp table fields get mapped to on permanent tables Thanks in advance, Doug
2 1655
by  DougABJump to last post
08/27/2012 4:25 PM
5 Replies and 5260 Views PO64.1 PO Line Item History Report?  5260  5 Started by  Dave McGown We use PO64.1 a lot to view activity on PO lines. We have been looking but cannot find a report that would print out this same information so we could dump it to excel. Does one exist We would like to be able to look at the PO Line Item History for all our open Capital PO's. (Note we do not have Add-Ins but I do use Crystal Reports). Thanks! Dave
5 5260
by  Dave McGownJump to last post
08/03/2012 10:24 AM
3 Replies and 2394 Views Suggestions for check printing solutions?  2394  3 Started by  DougAB Hi, I'm looking for inexpensive solutions or vendors for check printing solutions. We don't print that many checks per month and wanted to see if anyone has any good, yet inexpensive solutions, or use any 3rd party products, to print their checks. Any help is appreciated!!
3 2394
by  DougABJump to last post
07/31/2012 3:58 PM
0 Replies and 1784 Views 457 Plan - Company Match  1784  0 Started by  Lance Kelley We have existing pre-tax EE contribution 457 plans but now our company is offering a company match to some EEs. I've researched the PR05 and BN15 forms, user manuals, KB, etc. but the information on how to set the company match up seems piecemeal to me. I can't connect the dots yet. If anyone has a 'how-to' helper guide or form names and screenshots as to how you set it up, I'd be very grateful to see anything you might offer. For what it's worth, our company match is defin...
0 1784
07/26/2012 5:22 PM
0 Replies and 1226 Views Comments not attached to invoices  1226  0 Started by  Frank I am new to this, so please forgive me on this question, when users run ap520 there are no errors but a message appears that is saying comments not attached to invoices. Anyone have a clue to this Thanks for any help Frank
0 1226
07/17/2012 11:59 AM
11 Replies and 2782 Views GHX and email copies of 810's  2782  11 Started by  Greg Moeller Recently GHX stopped sending us return email copies of the 810 invoice records. Being in contact with GHX, the email functionality has not been supported for some years, so it will not be reinstated. We've come to rely on the email copy to scan into our ImageNow application and tie to Lawson. Anyone have any suggestions on what they are doing Specifically to appease the auditors that like to see a 'pretty' version of the invoice, and not have to rely on reading an archived version of th...
11 2782
by  Greg MoellerJump to last post
07/17/2012 9:13 AM
0 Replies and 1706 Views Security On GL298  1706  0 Started by  Dennis Amory I am trying to secure the data generated by GL298 so that the user sees only accounts/data related to a particular Process Level.Does anyone know which table(s) the rules should be written on Any other idea of a solution to this Thanks, Dennis
0 1706
07/02/2012 4:27 PM
1 Replies and 1717 Views AC07 criteria include/exclude au's  1717  1 Started by  Sherry Shimek We use AC07.1 Account Assignment to restrict the company, accounting unit, account and subaccount combinations that are allowed to post to activities within an activity group. We would like to further restrict the current AC07.1 for one activity group currently as follows: Company Include 8800 8800 1 AU Include 6622827 6994827 1 Account Include 400000 899999 1 SubAcct Include 0 9999 1 Company Include 8800 8800 2 AU Include 9200837 9299847 2 Account Include 400000 899999 2 SubAcct Incl...
1 1717
by  JeremyJump to last post
07/02/2012 6:55 AM
1 Replies and 1640 Views Merging many vendors  1640  1 Started by  CamM Hi, we have many one time vendors that we need to merge into permanent vendors. Normally we would run AP115, but this can only be run for a single vendor at a time. Is there an easy way to merge a large amount We have hundreds. Thanks! Cam
1 1640
by  Ragu RaghavanJump to last post
06/28/2012 3:11 PM
5 Replies and 2184 Views Fax Integrator 9..0.1.1 install time frame  2184  5 Started by  cindy MHSIL Hello, We are currently using fax integrator and it is stable and supported but we're wanting to upgrade to current version to position ourselves better for 10. Anyone with experiance upgrading to please reply with time frame examples and any lessons learned they experianced. I searched for any patches to the Sept 2011 release and found none on KB. Thank you all in advance for your replies Cindy
5 2184
by  cindy MHSILJump to last post
06/25/2012 12:30 PM
0 Replies and 1262 Views How do i get a Payment proposal into Lawson  1262  0 Started by  Matt D I want to get Payment Proposals from suppliers into Lawson, which form should I be using Using Payment proposals suppliers request early settlements by agreeing to an offer and enables you to pay suppliers early in exchange for discounts
0 1262
06/20/2012 11:18 AM
6 Replies and 2493 Views CA10 Add Ins  2493  6 Started by  Joseph Carfagno I need to add over 100 lines to an allocation. Rather than key everything in, I think it would be easier (and less risky) to create an upload Add In. Does anyone have an upload template they can share Does anyone know of a better way to add many lines to an allocation
6 2493
by  SherryBJump to last post
06/13/2012 1:40 PM
0 Replies and 2223 Views Check Printing/Formatting Solutions  2223  0 Started by  DougAB Hi, We are looking for alternative ways to print checks w/o going with a 3rd party solution vendor, like MHC, etc. We only print a few AP checks per month (~200). Has anyone used a different approach/solution Has anyone used, or know of anyone, who uses Crystal Reports to format their checks out of Lawson Thank you, Doug
0 2223
06/11/2012 2:59 PM
1 Replies and 1726 Views AM223 to CSV  1726  1 Started by  Melissa McGuire Has anyone had an issue in AM module where they've run an AM223 and the report is fine but when sent to CSV something throw it off so the excel sheet is unusable I've attached one....I think there may be a character throwing it off somewhere...but not sure.
1 1726
by  JonAJump to last post
06/07/2012 2:22 PM
4 Replies and 2258 Views Determine AR Customer Balance - As At Point-In-Time  2258  4 Started by  Garth Gerwing Wouild like to hear from anyone who either knows how to reference in Lawson AR - or has developed their own SQL to be able to determine an AR Customers balance as at a point-in-time in the past. EX: Derive Customer Balance as per 5 days ago Any feedback/commentary would be most appreciated - thanks.
4 2258
by  Garth GerwingJump to last post
06/06/2012 2:27 PM
2 Replies and 2386 Views How to Cancel on MA40/MA40.5  2386  2 Started by  jbertoli We have had staff changes and the person that has done this process is gone and of course there is no documentation. We are on an old version of Lawson - 7.2.4. For our Bank Wires, they are entered into MA40 with MA40.5 done to create the payment record. After this, AP26 (release), AP170 (closing), AP175 (Distribution) are all done. We had a payment done incorrectly and need to back it out. We are not sure if we are doing things correctly to back out the payment because when we are done, the ...
2 2386
by  jbertoliJump to last post
05/24/2012 4:32 PM
0 Replies and 1249 Views mobile inbasket - issue with custom form  1249  0 Started by  chris I am trying to get a response from a custom html form within the mobile inbasket. When I use the xmlhttp object with the open and send functions but instead of getting the response I would expect I keep getting a response for the login page. I am passing in proper credentials in the open command and I have double checked the url I am passing is correct as well. Any suggestions or examples would be very much appreciated.
0 1249
05/09/2012 9:30 AM
5 Replies and 3158 Views Chart of Acct query  3158  5 Started by  Don Hi There, I am totally new to lawson. I just start to look at the tables on GLs, and try to build chart of account hierachy, for top to detail GL. I look at two tables, GLCHARTDTL and GLCHARTSUM and I knnow ChartName, so here is my query: SELECT S.CHART_NAME, D.SUMRY_ACCT_ID, D.CHART_SECTION, D.ACCOUNT, D.SUB_ACCOUNT,D.ACCOUNT_DESC, S.SUMMARY_ACCT,S.ACCOUNT_DESC, S.TOTAL_DESC,S.PARENT_OBJ_ID FROM dbo.GLCHARTDTL D inner JOIN GLCHARTSUM S ON D.SUMRY_ACCT_ID = S.SUMRY_ACCT_ID ...
5 3158
by  amynelsonJump to last post
05/07/2012 10:50 AM
1 Replies and 1750 Views Adding field to AM260 Report  1750  1 Started by  Jeanne Boitano How do we go about adding the account number to be pulled in on the AM260 report Thanks ! Jeanne
1 1750
by  Ruma MalhotraJump to last post
05/03/2012 11:53 AM
0 Replies and 1806 Views PD10.3 upload?  1806  0 Started by  JCardillo Hello, We have Excel add-in uploads for user setup in PD10.1 and PD10.2, but PD10.3 seems to allude us, probably because you can only get to PD10.3 via PD10.2. However, in the UWF maker, PD10.3 is a choice. So, I was wondering if anyone out there has been able to defeat the system on this The PD10.3 setup is the most cumbersome and an upload would be very beneficial. Thanks.
0 1806
05/03/2012 8:14 AM
7 Replies and 3053 Views Need to create a consolidating company in Lawson 9.0 but I have no idea how to start  3053  7 Started by  TeresaE We are just looking at creating consolidating financials in Lawson 9.0 this year rather than continue creating them manually in Excel. I am wondering if anyone could point me toward any good articles, instructions on how to go about setting up the consolidating companies because I don't have a clue where to begin.
7 3053
by  TeresaEJump to last post
04/27/2012 1:51 PM
0 Replies and 1539 Views Alternative for 'delement'  1539  0 Started by  sarahula Lawson Masters, I was declaring some new elements on dbdef, I was supposed to specify them as 'strings'. But as a newbie, I used AlphaLower. Now I want to change them to derived 'strings' but it seems to be imposible. I think the element needs to be deleted. I found this tool called 'delement' but when it deletes elements it does it per product line and it deletes all of the unused elements. I want to delete only those that I created by mistake. Please give me some idea on how to do it...
0 1539
04/26/2012 11:39 AM
2 Replies and 4566 Views Invoice Distribution from AP Payment  4566  2 Started by  G. Monaghan I am trying to write a report of cash by activity. The activity is attached to the invoice on AP invoice distribution table (apdistrib) and posts to GL via AP175. When the check is written the entry to GL to cash just clears AP via AP170. There appears to be no way to tie the entry from the AP175 to the corresponding payment done via AP170. Has anyone found a way to accomplish this
2 4566
by  G. MonaghanJump to last post
04/25/2012 2:05 PM
1 Replies and 2991 Views AR Bank Reconciliation - How To Organize?  2991  1 Started by  Garth Gerwing I would very much appreciate to hear from anyone who has had experience setting-up CB/AR in support of reconciling bank account deposits to AR-sourced payment entries in CBTRANS. I've looked extensively at the 'Bank Reconciliation' functionality in the Cash Management (CB) module - and it would appear to be more slanted to AP-related reconciliation. I'm kind of leaning to using the 'Enhanced' reconciliation constructs (CB185-Run option 'R', CB81, CB82). AR submits records to CB upon the re...
1 2991
by  jjcyeshuaJump to last post
04/24/2012 6:23 PM
0 Replies and 1498 Views AP20 Vendor select security  1498  0 Started by  Daksha Desai I hope anyone can help. I am creating a customized AP20.1 form in design studio. Some else handles Security set up so I do not know much about it. The user needs to see Vendors based on the Accounting Unit they enter or are assigned to for Security. How should any security be set up. Is there something I need to add in the form
0 1498
04/23/2012 2:09 PM
0 Replies and 2331 Views CB55.1 Payment  2331  0 Started by  dj I am trying to enter a patient refund in CB55.1. I recently learned of this option rather than continually creating one-time vendors in my AP vendor master. When I try to add the payment in CB55.1, I am prompted to provide the vendor bank information 'Bank ID and Acct require for electronic payments' The issue is that I am using a transaction code of SYS to create a check, not an electronic payment. My Patient Refund vendor is setup with a Payment Code of SYS (cash payment). Finally, my...
0 2331
04/20/2012 11:38 AM
5 Replies and 8927 Views WHAT IS NEW LAWSON 9.0.1 FINACE APPLICATIONS  8927  5 Started by  fdflanig I have a training documentation need to know of any form changes or process changes in 9.0.1 before I update my 9.0 fincae training material. Lawson 9.0.1 is on my horizon. Is 9.0.1 from 9.0 change information available
5 8927
by  jjcyeshuaJump to last post
04/18/2012 4:59 PM
3 Replies and 2880 Views Retail Calendar and 13th Period  2880  3 Started by  Adam We are trying to deal with this 53rd week and we know GL can handle a 13th period, but when we contacted Lawson and they advised us not to turn on the 13th period, but offered no other suggestions to deal with it. I was wondering if there were any retail clients dealing with a 13th period or a 53rd week in Lawson
3 2880
by  AdamJump to last post
04/05/2012 12:36 PM
1 Replies and 1615 Views secure invoice number interface from payroll  1615  1 Started by  heather Currently the interfaced garnishments from payroll have the employee number They want to block it out on the ap90 screens. I wrote a rule to block it out operator ap520 to apinvoice. did not work In pr05 you summarize it -but that is not waht they want. I have blocked out the garnishment comments successfully Trying to figure the blocking the invoice as well. Any suggestions/
1 1615
by  Jimmy ChiuJump to last post
04/03/2012 2:27 PM
0 Replies and 1573 Views ACBR billing  1573  0 Started by  cindi Is there anyone using ACBR to do minimum type billings For example - bill a customer a minimum of $1500 per month but if number of different cases times different rate per case equals more than 1500 - then customer is billed the cases charge Thanks!
0 1573
03/28/2012 10:54 AM
0 Replies and 1148 Views turning on remoteglt  1148  0 Started by  Deleted User Any ramifications if I turn on the flag to create the remoteglt file at any point, as opposed to the beginning of a fiscal/calendar/legislative/whatever year One of our payrolls has never used any type of an automated financial interface, and we'd like to start, sooner rather than later. We don't use Lawson financials here - As a severely GL Challenged individual, I welcome any suggestions!! Thank you!
0 1148
03/28/2012 5:02 AM
0 Replies and 1569 Views Void PD Invoice  1569  0 Started by  Boyd I am having trouble voiding an invoice that was created using PD 570. Is there something that I am missing Surely we can void this type of AP invoice.
0 1569
03/26/2012 5:19 PM
0 Replies and 1689 Views AR Lockbox  1689  0 Started by  MG44 Anyone utilizing the AR Lockbox feature with 9.01 Financials We are looking to utilize and are looking for any information or tips. We use US Bank and have the file format from them. Any info is appreciated. Thanks.
0 1689
03/22/2012 10:15 AM
3 Replies and 1804 Views LP Custom calculation routine  1804  3 Started by  Chesca Our Lawson consultant suggested we add logic to calculate LP vacation accruals. I was provided with this logic but I have no idea what it means or how to code it. I would greatly appreciate any feedback or suggestions with this issue. Thanks! I defined the LP ACR HOURS in WS as whole number. Would I need a compute statement to calculate the ACR Hours Logic: ACR HOURS = If TASERVICE_SERVICE-CODE is included in ACR TASERVICE _SERVICE-CLASS and status <> 9 and SERVICE CODE DATE is ...
3 1804
by  ChescaJump to last post
03/12/2012 1:22 PM
0 Replies and 1473 Views DB inquiry processing  1473  0 Started by  Chesca I want to retrieve a record off the TAEMPSERV and the TASERVICE files. I have populated the set keys (840-FIND-TESSET1). This is my first exposure to custom 4GL code. Does an 860-FIND-INDEX must proceed a find next routine I would appreciate any feedback or suggestions with this issue. Thank you in advance. Here is my custom code: INITIALIZE DB-TES-OBJ-ID. MOVE LPMST-TEM-COMPANY TO DB-COMPANY. MOVE LPMST-TEM-EMPLOYEE ...
0 1473
03/12/2012 9:35 AM
0 Replies and 1283 Views Crystal-Units issue at the AU level  1283  0 Started by  BShort I have been trouble shooting this for the past few days as a note. I am pulling units that I have setup in the Stats area for the GL, for us accounts 9xxxx I am using the following tables and started over today to try and figure out where the issues happen: GLUNITS, GLCONSOL, and GLSYSTEM. Some items I noticed is that the Var.level does not have everything listed on the GLUNITS as it is missing the main level at 010000000000 but has the department level, where as the GLCONSOL does not h...
0 1283
03/08/2012 7:35 PM
1 Replies and 3727 Views PP&E rollforward  3727  1 Started by  Boyd Does anyone know if Lawson has a system report that rolls forward PPE activity from one period to the next I am interested in Beginning balanceadditionsincreases to WIP-disposals etc. Any thoughts are appreciated.
1 3727
by  mark.cookJump to last post
03/07/2012 7:01 AM
3 Replies and 2897 Views Check reissue report?  2897  3 Started by  StephanieL Is there a report I can run that shows a listing of checks reissued over a period of time Thank you.
3 2897
by  StephanieLJump to last post
02/22/2012 12:16 PM
2 Replies and 1828 Views AP Productivity Query  1828  2 Started by  Billi We are looking for a query that can pull how many invoices and lines have been keyed by employee for a given time period. I am having a bit of a hard time trying to figure out fields I can pull to get this information Any thought Thanks.
2 1828
by  Robert SpurrJump to last post
02/17/2012 1:28 PM
0 Replies and 2005 Views Question about Sub Accounts  2005  0 Started by  Saurabh Hi All, We currently only have the Detail Accounts setup without any Sub Accounts. e.g our accounts are setup as 01700 01701 etc We would now like to add some sub accounts so for e.g 01700 - 001 01700 - 002 As far as i can ascertain these seem to be created as New Detail accounts and also seem to be coming up as separate entries in the GL291 (instead of 1 entry for the main 01700 account) Is there a report which i can run to see the combined posting of the account (i.e 01700,0170...
0 2005
02/17/2012 10:32 AM
1 Replies and 1551 Views What Table are CB Comment stored in  1551  1 Started by  Jeff Pratte I created a comment from CB55. Thanks to a post from Jim on the site 'What I Learned Today' I found the Header for the comment in L_HCBM (Header table). But when I looked in the table L_DCBM (Detail table), it was empty. Does anybody know where the rest of my comment is Thanks, Jeff
1 1551
by  John HenleyJump to last post
02/16/2012 2:37 PM
6 Replies and 3108 Views AP20 Comments  3108  6 Started by  Steve Datish We are using addin's to add several invoices to AP20 and would like to add comments to the completed invoice. Is there a way to do this using addin's or another tool Currently we are adding the comment to each individual invoice. Thanks.
6 3108
by  Bob CanhamJump to last post
02/10/2012 10:03 AM
2 Replies and 6005 Views GL40.1 Upload Template  6005  2 Started by  RAKESH DESAI How can I build template to upload journal entry (40.1)from Excel.
2 6005
by  dcaianiJump to last post
02/09/2012 9:09 AM
0 Replies and 1663 Views Reverse PO Entry  1663  0 Started by  RAKESH DESAI I am trying reverse the PO ENtry. I went to GL40.1 and tried to copy & add as reverse value. But it didn't allow me. Anybody has a better idea
0 1663
02/03/2012 3:15 PM
0 Replies and 1619 Views Wire Payment entry  1619  0 Started by  RAKESH DESAI How can I book wire payment entry without matching the invoice. I know I can use the credit memo. But I wan't to show as a payment in vendor's account but I don't want to match invoice.Is that possible
0 1619
02/03/2012 2:54 PM
0 Replies and 2195 Views HELP - PO Matching/Pre-Paid Invoice  2195  0 Started by  soleary I partically prepaid a PO Matching invoice (50 paid, 50 on hold) and it has been received but it still showing up in the PO135. I can't seem to find anywhere in Lawson to match this pre-paid invoice and since it has been received I thought the system automatically matches it. Can anyone help
0 2195
02/03/2012 10:14 AM
6 Replies and 3540 Views Cost Center Level  3540  6 Started by  RAKESH DESAI How Can I change or add cost center level in GL20 I need to add cost center level.
6 3540
by  RAKESH DESAIJump to last post
02/01/2012 11:32 AM
2 Replies and 2088 Views Invoices for void check  2088  2 Started by  Ludy If I need to know what invoices are associated with a void check, what table/s should I look into
2 2088
by  LudyJump to last post
01/30/2012 7:51 AM
0 Replies and 2143 Views Add in for GL20 and AP AM set up programs  2143  0 Started by  Joseph Carfagno Our financials group will soon have to load hundreds of new locations into Lawson. We'd like to use add ins rather than GL161, etc to perform the uploads so that we can use Excel to copy the values we need for accounting units, level groups, attributes etc from our source system and upload them to Lawson. I'd appreciate any sample templates that are out there.
0 2143
01/26/2012 11:04 AM
4 Replies and 3802 Views Invoice Dist Out of Balance Error AP520  3802  4 Started by  Deleted User I'll begin by saying I know virtually NOTHING about AP, except it really isn't (or shouldn't be) a convoluted process.... We're in the final stages of upgrading from v8.1 apps to 9.0.1 and we're having a problem with AP520 for one particular deduction. It's a simple of pay, however, in the new app, this is the only deduction that we receive the above error - distribution out of balance - and we then can't create an AP check. There is no error on the 197, no errors on the 198, and the amo...
4 3802
by  Deleted UserJump to last post
01/26/2012 4:24 AM
0 Replies and 1357 Views AR converted transactions  1357  0 Started by  cindi Outstanding transactions were converted into AR using AR502. Finance Charge invoices were loaded as invoices not as debit memos. Now when running AR137 to apply finance charges, it is including the previous finance charges in the balance to calculate finance charges on. Any ideas how to resolve
0 1357
01/24/2012 12:46 PM
1 Replies and 3259 Views Freight and MA540  3259  1 Started by  bnelson Good morning, I would like to know if anyone processes invoiced Freight in Lawson as AOC Spread (add on cost, spread to each PO line) in an EDI 810 invoice transaction. If so, can you tell me where the Freigth elements go in the MA 540 record lay out so it processes successfully, IE without fataling out. Thank you Bob Nelson
1 3259
by  Robert SpurrJump to last post
01/19/2012 1:44 PM
2 Replies and 2908 Views Query or Crystal report for AP136  2908  2 Started by  JCardillo I'm trying to find the easiest way to create the AP136 in a Crystal Report. I have the APINVOICE and APDISTRIB tables already, but once I connect the APPAYMENT table, the report goes all haywire. But, I'm assuming the APPAYMENT is necessary. Any hints or has anyone done this Thanks.
2 2908
by  JCardilloJump to last post
01/11/2012 12:14 PM
1 Replies and 2598 Views Asset Transfer Upload  2598  1 Started by  TDB I am trying to create an upload that will transfer over 1,100 assets. I tried to make one for the AM30.1 and mapped each column. When I run the upload this error message is displayed 'To-company books are in different periods or years'. Does anyone know how to solve this issue Any help would be appreciated
1 2598
by  John HenleyJump to last post
01/09/2012 2:20 PM
1 Replies and 2643 Views lawappinstall failure when installing any CTP in any mode  2643  1 Started by  gzucker Hey all, I am running into endless frustration with Lawson Support, so I am hoping that this community may be able to assist in some way. I am trying to install the 2011 end of year CTP (although this issue would apply to any CTP). The command fails with the following error: ERROR - 'tar xf D:/PROD/patch_staging/patch.tar' command failed. I have tried running the lawappinstall command both in LID and directly from the command prompt on my server and I get the same error. I am using ...
1 2643
by  troelofsJump to last post
01/06/2012 3:31 PM
3 Replies and 2356 Views Backposting entry  2356  3 Started by  RAKESH DESAI Why my system does not allow to backout the journal entry eventhough I opned the period for backposting allowed
3 2356
by  Ruma MalhotraJump to last post
01/05/2012 1:44 PM
0 Replies and 1181 Views Internal Services Cost Transfers  1181  0 Started by  crichard How do the hospital users out there handle internal transfers from department to department We have many internal services that get requested by our PIs that we then need to perform a cost transfer from the service department to the PI. Our service departments would be similar to many service departments at a hospital (Histology, Radiology, Pharmacy, etc.). The issue that we are faced is that many of these transfers happen monthly and we want to streamline the process while capturing transac...
0 1181
01/05/2012 12:43 PM
0 Replies and 1284 Views Moving RW100 from 8.03 to 9.01  1284  0 Started by  Joe O'Toole We will be upgrading our applications from 8.03 to 9.01 over the next few months and were wondering about migration issues with some of our critical reports written in RW100. Has anyone had trouble porting their 8.03 RW100 reports to 9.01 Thanks.
0 1284
01/04/2012 4:05 PM
1 Replies and 2640 Views Help on how to create cash flow statement  2640  1 Started by  john Looking for direction on how to structure Lawson to create cash flow statement to go along with Balance Sheet and Income Statement. Help!!!
1 2640
by  johnJump to last post
01/04/2012 12:43 PM
0 Replies and 1850 Views MSP 7  1850  0 Started by  Mark Larochelle Is/has anyone applied the MSP 7 patch
0 1850
01/04/2012 9:14 AM
0 Replies and 1630 Views CB186 error report  1630  0 Started by  Jim Howerton Have several entries on error report. Cannot stale-date xxx xxx checknumber Adjustment exists How is this error addressed
0 1630
12/28/2011 2:25 PM
1 Replies and 3704 Views 1099 Validation report  3704  1 Started by  Jeremy AP145 appears to have a problem when aggregated by TIN. If the same TIN is used on more than one vendor the vendors are aggragated to one. However we have found that the information for a giving vendor number isn't always upto date. I have written a report that identifies TIN's with multi vendors however I have not found any rhyme or reason as to with vendors information gets printed for a giving TIN Does anyone have a report or know the criteria.
1 3704
by  Greg MoellerJump to last post
12/13/2011 3:47 PM
0 Replies and 1692 Views AR - Support Both Pre-Authorized Debit & Credit?  1692  0 Started by  Garth Gerwing Lawson AR has EFT capabilities - that are targeted toward a 'Pre-authorized Debit' scenario - I.E. maintains customer bank account data in support of EFT. We will be engaging a credit card 3rd-party vendor in support of processing pre-authorized credit card transactions as well. In effect - pre-auth debit/credit amount to the same general requirements - although the resulting file TX's will need to be distributed to 2 seperate financial institutions: pre-auth debit->bank, pre-auth-credit-&...
0 1692
12/08/2011 4:02 PM
2 Replies and 2142 Views GL221 export to csv  2142  2 Started by  Tammy Guidry I need to run a report for auditors to see when accounts were set up. I ran GL221 which was 22,492 pages and exported to csv. It is stopping around excel line 637,500 and is incomplete. Lawson Support can't offer any suggestions. Does anyone have any ideas Thanks so much!
2 2142
by  Tammy GuidryJump to last post
12/05/2011 11:29 AM
2 Replies and 2367 Views .cfg files  2367  2 Started by  johne Can anyone point me towards a Lawson document, or a listing that someone may have posted, that explains what variables I might expect to see in the &91;ProgramName&93;.cfg files and what those variables do for the program I see some .cfg files for batch job programs (five character program name) and a couple for on-line jobs (BRIP.cfg specifically). I've searched here & on Lawson's Knowledge Base screens and have not had much luck finding anything that explains in detail what th...
2 2367
by  johneJump to last post
12/01/2011 1:59 PM
0 Replies and 1493 Views Reinstate check batch  1493  0 Started by  Boyd Does anyone know if there is a way to reinstate an electronic payment batch that was voided in error
0 1493
12/01/2011 8:52 AM
2 Replies and 3432 Views Putting Invoices on hold  3432  2 Started by  lmckenn I use AP40 to put an invoice on Temp Hold. We now need to put many invoices on hold each day (not at the vendor level and not a permanent hold) It seems tedious to enter each invoice individually on the AP40 - does anybody know a way to achieve this more efficiently -- is there a mass hold or bulk hold -- Thank you!
2 3432
by  lmckennJump to last post
11/22/2011 5:21 PM
5 Replies and 1960 Views Hide inactive accounts in user drop down lists  1960  5 Started by  Sherry Shimek Is there a way to hide inactive accounts in the user drop-down account lists in portal for GL, AP, RQ, and PO, for example We changed our supply general ledger accounts and prefer that the users do not see the old inactive accounts in their account drop down lists. We are hoping to prevent time wasted when users choose inactive accounts prior to being stopped by the 'inactive account' error. Because they have been used in the last fiscal year, we cannot delete these accounts. We have ...
5 1960
by  John HenleyJump to last post
11/16/2011 7:57 PM
4 Replies and 15336 Views Printing 1099 misc income  15336  4 Started by  Deleted User Does anyone know how to 1)Print the 1099 report 2)Adjust the form alignment so the numbers fit exactly in the boxes 3)Change the print orientation to portrait Thanks Nigel Jones
4 15336
by  JimYJump to last post
11/15/2011 10:01 AM
1 Replies and 2407 Views Report Writer  2407  1 Started by  Karen M I am trying to get the data that I have typed in the Row of my RW report to populate on the the report. I have tried using 'row name' under the format of the column and it will not that me use that item. Any advice is appreciated!!! thank you!
1 2407
by  Gail GudgelJump to last post
11/10/2011 1:06 PM
3 Replies and 2028 Views Current year Balance rebuild after post closing entry  2028  3 Started by  RAKESH DESAI How Do I change my current year Balance after the post closing entry in last year Does only GL199 will change it
3 2028
by  Greg MoellerJump to last post
11/07/2011 11:58 AM
0 Replies and 2926 Views Purchasing month end closing process  2926  0 Started by  RAKESH DESAI Does anyone has purchasing closing process or schedule
0 2926
11/01/2011 8:36 AM
1 Replies and 1561 Views Process Documents  1561  1 Started by  New User Gurus, Can anybody tell me where i will get S3 process documents for A/P, A/R, Payroll etc. I need to uderstand step by step process how to create view documents. (e.g. how to create PO) Thanks
1 1561
by  JimYJump to last post
10/14/2011 7:16 AM
1 Replies and 1818 Views How to create new vendor in S3?  1818  1 Started by  New User Hi Iam not able to create new vendor in S3. Iam using AP10 form ID for vendor creation. i fill up all the datails and click on add button i get error saying 'Error occured while performing the transaction' Pls check attached screenshot of error Pls let me know if iam following wrong process for creating new vendor
1 1818
by  Ragu RaghavanJump to last post
10/12/2011 7:32 AM
1 Replies and 2196 Views AP160 ACH Batch Number  2196  1 Started by  wrig We are creating a NACHA ACH file out of AP160. However, the file keeps getting rejected b/c Record Type 5 is 1 character too short. Specifically, the Batch Number field is showing as '000000' when it should be, for example, '0000001.' A look in the specs for this file says that 'Batch Number Assigned in Ascending Order, Hard Coded in Source.' Any ideas why it is showing up as '00000' (1 digit short)
1 2196
by  JillFJump to last post
10/10/2011 3:54 PM
1 Replies and 2012 Views Lawson Approval Codes  2012  1 Started by  Brett Townsend In getting ready for this year’s audit, I’ve run the approval codes report and I’ve noticed that some approval codes are different. Should they all be the same For Example: Approval Code DIMEB Can Lower Levels be Skipped – NO Printed Copy Required – NO Approval Code EESVC & CBWTO Can Lower Levels be Skipped – YES Printed Copy Required – NO What is the difference between the 2 Should they be the same &91;IMAGE:432&93;
1 2012
by  Jimmy ChiuJump to last post
10/05/2011 1:02 PM
1 Replies and 1552 Views Moving banks  1552  1 Started by  Brett Townsend We are in the process of changing banks and I have a AP Supervisor who is asking if there is anywhere in Lawson that she needs to make changes to reflect the bank information. I'm pretty sure that she only deals with AP. Thanks for anyone who helps.
1 1552
by  Mark F. HardyJump to last post
09/26/2011 12:31 PM
0 Replies and 1470 Views access restrict  1470  0 Started by  Deleted User Hi I want to restrict the user access in LID. but when i delete the user access. in lid it is not updating in VALID FCs and even the user still able to access the GL45. is any one tell me the steps how to restrict the user access in LID.. even i after making changes in the form secuirity i rebuild secuirity dictionary. my id- Thanks to lawson forum.
0 1470
09/26/2011 9:41 AM
9 Replies and 6403 Views Can't Open Period for Backposting  6403  9 Started by  RAKESH DESAI Hi, I am trying to change the entry in period 7 which was closed. But I can't reopen the period
9 6403
by  RAKESH DESAIJump to last post
09/21/2011 8:47 PM
3 Replies and 2791 Views AP 1-time Vendor numbering - 999000001 series  2791  3 Started by  RajR Hello All, Can anyone tell me whether is it possible to change the one-time Vendor number format from 999000001 to 990000001 I understand that Lawson stores the Last-One-Time Vendor in APVENGROUP table Is the prefix 999 hardcoded somewhere in the code or database I also understand that it looks at the Vendor Class to make a determination whether the vendor should be a one time vendor. I understand that if we find a way to change the one time vendor number ...
3 2791
by  Ragu RaghavanJump to last post
09/19/2011 7:10 PM
1 Replies and 2016 Views Subsystem Journal Descriptions  2016  1 Started by  BMAE We recently went live with Lawson payroll and are wondering how the description of journals posted from subsystems can be changed to be more informative. For example, the bi-weekly payroll posting entry has a description of 'expense accrual' for each entry posted. We would prefer to change the description to something like 'Payroll PPE 08132011' so that review in GL90 would differntiate the various entries.
1 2016
by  Ragu RaghavanJump to last post
09/15/2011 12:08 PM
0 Replies and 2705 Views Any Functional Difference: AR Invoice vs Debit Memo?  2705  0 Started by  Garth Gerwing Can anyone provide any feedback RE whether or not there are any functional differences between an AR 'Invoice' and an AR 'Debit Memo' For all intense purposes - these appear to be 'TX Types' - and possibly as a means to organize/track transactions in AR. Granted - you may also have seperate distributions assigned to each. But, beyond that, is there any deviations between these two 'TX Types' by which Lawson AR will treat them differently from a functionality/data perspective Any feedback...
0 2705
09/14/2011 10:28 AM
2 Replies and 1875 Views Custom Reporting Confusion  1875  2 Started by  Jeremy Holovacs I'll apologize first because I don't even know if this is the appropriate place to ask this. I come from a pretty heave database and development background, but this is the first time I've had to get in deep with Lawson. My boss has asked for a report of active AP vendors with information like payment terms and invoice history. I thought it would be relatively straightforward to locate this information, but I was not counting on the data organization in the Lawson DB being so... non-intuiti...
2 1875
by  Jeremy HolovacsJump to last post
09/12/2011 11:29 AM
2 Replies and 3051 Views JE Approval Process Flow  3051  2 Started by  Gordon I have made a custom GL41 for use in the JE Approval PF. The page with the form does not populate. Has anyone experienced the same problem. I did not find a delivered htm to use for default display like we have for RSS. RSS delivered recsum.htm as the approval screen. I had to create an approval form for JE Approval. Does anyone have the default htm that suppossedly comes with JE Approval we can try
2 3051
by  LisaNJump to last post
08/29/2011 10:12 AM
1 Replies and 1607 Views Invoice data  1607  1 Started by  Maique I'm writing reports agains s3 AP Invoice Data, but users are cancelling (deleting) invoices via AP20.1 and I do not know the criteria to not to show them in my report.
1 1607
by  John HenleyJump to last post
08/24/2011 12:05 PM
1 Replies and 2152 Views Automation Needs?  2152  1 Started by  Paper_AP Hi everyone. Currently I work full time in AP for a high end retailer who uses Lawson Desktop 9 for financials and HR management. I am a part time software developer and have come to know Lawson very well over the past 2 years. I have developed a suite of 3rd party applications that 'sit' on top of the Lawson interface and allow for all types of automation that require very little support and are easy for the general user to understand. The applications use the Lawson forms to interact and th...
1 2152
by  jcapoJump to last post
08/02/2011 6:47 PM
2 Replies and 2223 Views Base Currency is a Foreign Currency  2223  2 Started by  Boyd I am in the process of setting up a company in Lawson with a Base currency of Brazilian Reals. This will be my first venture into setting up a company with a base currency other USD. Does anyone have any thoughts on setup or issues that may arise in processing AR or AP in this company. Any thoughts are appreciated.
2 2223
by  CarlinoJump to last post
07/01/2011 9:04 AM
2 Replies and 1629 Views AR115 - EFT Files and Required Permissions  1629  2 Started by  Garth Gerwing We are attempting to test the AR EFT process(s) - and are running into an issue whereby the EFT payment file(s) are being created - but are empty (0KB) where there should be data written. We setup the 3 required directories under productline\work\ - as the job required these be present before exeucting. Upon closer inspection of the job log - we noted a 'Security Violation' line being written. Anyone have any ideas as to what might be the issue here
2 1629
by  Garth GerwingJump to last post
06/22/2011 11:27 AM
0 Replies and 1565 Views A/R EFT Setup/Process Questions  1565  0 Started by  Garth Gerwing With regards to the setup and processing options for A/R EFT - I have the following questions: 1) Is there any way of creating a 'minimum threshhold' for EFT generation I.E. any debit balances < a given $ amount get ignored 2) Credit Balances: it would appear that the EFT process will pick up any credit balances for EFT customers and create a 'credit EFT' transaction - whereby the customer's account will be credited (as opposed to being debited). Is there any way to turn this off ...
0 1565
06/16/2011 3:10 PM
0 Replies and 1891 Views Asset Insurance Information - AM20.4  1891  0 Started by  LauraSantos We charge auto liability insurance to each of our locations based on the number of company vehicles they use. Right now, it is a manual process where someone will extract asset information from the AM module, group the vehicles by location and then create a spreadsheet to calculate the total liability insurance per location. They then upload the total using excel add-ins into a journal entry to charge the locations for the insurance. This is something they have to do each month. Can anyone...
0 1891
06/14/2011 5:10 PM
4 Replies and 4516 Views Researching Invoice Scanning, OCR, Workflow solutions  4516  4 Started by  RMc We are looking at possible solutions to scan our invoices, use OCR and workflow technology to route them and then interface into Lawson. I'm wondering if anyone is doing this today, what software solutions were chosen, what the experience has been, etc. Any information would be greatly appreciated! Thanks in advance! Reed
4 4516
by  Gail GudgelJump to last post
06/01/2011 10:16 AM
3 Replies and 1905 Views RW assistance  1905  3 Started by  Boyd I am a RW novice and need assistance creating a report. The report (a standard income statement) I would like to create is for a certain level group that I created. I would like the report to show only the information from the level group and at the same time consolidate the results of like accounting units into one on the report. So far the only luck I have had is to either show one of the accounting units or the consolidated group. As of now I am using a style 1 report. Any thoughts are...
3 1905
by  Gail GudgelJump to last post
06/01/2011 10:11 AM
3 Replies and 1935 Views Activity Management Upload Utility  1935  3 Started by  AD Hello, What are the steps needed to design an uplod utility for activities instead of manually adding them in using AC10.1
3 1935
by  tdosalJump to last post
06/01/2011 8:46 AM
0 Replies and 1727 Views Period of Performance (POP)  1727  0 Started by  tdosal We are exploring the option of implementing the POP functionality to prevent users from entering requisitions and PO's on the last day right before a grant ends (our grants our tracked using Lawson activities). How and why does your organization use this functionality Tina Dosal Moffitt Cancer Center
0 1727
06/01/2011 8:42 AM
5 Replies and 2339 Views adding comment to asset numbers in the report  2339  5 Started by  Vijay S I need to add comments on Asset numbers in the report via using Lawson API for comments. I just figured out that the table used for comments for Asset is L_HAST and L_DAST. Has anyone done it before I am bit confused as notb sure from where to start it. Could anyone suggest.
5 2339
by  Vijay SJump to last post
05/27/2011 2:11 AM
4 Replies and 2172 Views Creating Assets from AP invoices using AM115  2172  4 Started by  Saurabh Hi This is on 8.1 MSP5. Am trying to create an asset from an AP invoice using the AM115 session but keep getting message 'Account not defined'.&91;00999/8020&93; The AP invoice is linked to a PO which has the asset item (which was linked to an asset template) The PO line is against a Bal Sheet AU &91;00999&93; and Bal Sheet Account The 8020 Account is a P&L account which seems to be coming from AM06 (see screenshot for more info on setup) Does anyone use this routine to convert...
4 2172
by  SaurabhJump to last post
05/21/2011 8:21 AM
2 Replies and 2687 Views PO31.1 Vendor Return  2687  2 Started by  mikekask I'm trying to do an SQL extract of data related to the PO31 form and PO231 report. In particular, the Reason code. I'm not just talking about a list of Reason codes, but the data associated with this form; like Company, Return number, Vendor, Reason Code. I'm looking to isolate the records with a Reason code of 'WCR'. I need the table locations of this data. Any help would be greatly appreciated. Thank you.
2 2687
by  mikekaskJump to last post
05/12/2011 3:10 PM
3 Replies and 2651 Views Change Import GL journal Sequence Number  2651  3 Started by  AD Hello, How do I go about changing the sequence number of the next GL journal number used through GL165 process
3 2651
by  Ruma MalhotraJump to last post
05/06/2011 12:51 PM
4 Replies and 4187 Views Changing Activity Required field in (GL20.3) Using AddInns  4187  4 Started by  Saurabh Hi All, Apologies if this is not the right forum. I have around 150 accounts which i need to set the Activity flag to be Yes (in GL20.3) Trying to use the Addinns to make the change , the message after update says 'Window Changed - Update Form To Save' and the change does not seem to have been made Regards Saurabh
4 4187
by  SaurabhJump to last post
04/27/2011 3:44 PM
1 Replies and 1950 Views AM221 and AM270 Reports are out of Sync  1950  1 Started by  MicheleW It appears that in our last months AM work some transactions made it through to AM20.5 and were processed successfully. However, where ever the data is for the AM221 report these transactions are missing to AM221 and AM270 no longer balance. Does anyone know where the transactions come from for these reports, as it appears they are not the same. We're on and using Portal as our interface. Thanks.
1 1950
by  Kevin HaganJump to last post
04/25/2011 9:46 AM
2 Replies and 1790 Views Blank Line  1790  2 Started by  TommyT How do I add some blank spaces between the last line of the format and the first detail line on an RW100 report
2 1790
by  Gail GudgelJump to last post
04/20/2011 12:24 PM
1 Replies and 1709 Views ARCUSTOMER.Search_Name Too Short...  1709  1 Started by  Garth Gerwing Customer name in AR appears to have a maximum length of 30 characters - of which, is a tad limiting (based on existing enterprise customer name usage/definition). Am I missing something - or - does anyone have any tips/techniques as to how to expand upon the size here I am assuming that: - Changing the attribute definition at the DB level - would cause a ripple-effect of possible form and reporting changes down the line (ideally - we want no customization that is required to be maintained)...
1 1709
by  AlJump to last post
04/19/2011 12:56 PM
1 Replies and 2274 Views L_HAPI.L_INDEX creation logic  2274  1 Started by  Travis HI, I work for an EPP solutions company and my client is using Lawson 8.3 database. I am working on an interface that stores invoice image URLs. They are linked using the L_INDEX column to our system. From my understanding, Lawson starts with the L_INDEX of ZZZZ and goes down alphabetically. My questions is, what would happen if an L_INDEXes existed that started with YZZZ - YAAA Would Lawson keep going down until it found an un-used index or would it replace the index that is alread...
1 2274
by  Angela CollinsJump to last post
04/15/2011 4:13 PM
4 Replies and 2317 Views Activity Budget/Date Edits  2317  4 Started by  tdosal For as long as i can remember we have used both date and budget edits for our activities within the other Lawson modules (PO, AP, GL). We have always struggled with these edits because our current business process requires us to contantly manually override these edits. If you are currently using the budget/date edits within Lawson AC, how do you maintain them, so that there is not so much manual intervention
4 2317
by  NickJump to last post
04/10/2011 12:58 PM
4 Replies and 2240 Views Financials Audit Reports  2240  4 Started by  Wade-T We have been looking over the audit reports for BN/HR/PA/PR to see who changed what and when, but have had trouble finding corresponding reports in the finance area. We are most interested in CB/AR/AM/GL. I saw some posts stating that the financial audits are not so good unless you are running Lawson Security and Portal. We are running the environment, apps, and have most of our users in LSF. Only 12-15 LID users remain (also the ones with widest access). What type of repo...
4 2240
by  Wade-TJump to last post
04/01/2011 7:38 AM
2 Replies and 3210 Views SQL Extract of vendor 1099 indicator and payment code  3210  2 Started by  mikekask Hi, I am writing an SQL extract program to get this information. I am trying to find on what table the vendor 1099 indicator is located. I was told the INCOME_CODE can be used for this but nothing there. I am also looking for the table where the Vendor Payment Code field (from the AP10.5 form) is located. Mike
2 3210
by  Vijay SJump to last post
03/22/2011 2:22 AM
9 Replies and 7377 Views Asset Management Module - General feedback  7377  9 Started by  Saurabh Hi All, I work in Not for profit Healthcare charity Organisation using Lawson S3. We are looking at using the Asset Management module. Was wondering if people had any feedback on the module and things to be aware of when implementing this module. Also any fedback on standard reports which come with the module Regards Saurabh
9 7377
by  Ruma MalhotraJump to last post
03/11/2011 2:29 PM
1 Replies and 1544 Views ARCUSTOMER integration  1544  1 Started by  Todd Mitchell I am wondering if anyone has developed a best practice for continuous integration with customer related information. We are integrating from another system that is and will continue to be the owner of the data. We need to interface with this data and using deltas (for both adds and changes) update Lawson. Right now we are developing a process to use ARICST and AR550 as an ongoing integration point. My main question is if anyone has developed a better ongoing process
1 1544
by  John HenleyJump to last post
03/08/2011 11:22 AM
4 Replies and 2109 Views Purging PRDISTRIB Records?  2109  4 Started by  Deleted User Can anyone tell me the ramifications of purging some past years prdistrib records Our file is getting enormous, and it's almost impossible to research anything at this point. Thanks for any input! Stephanie
4 2109
by  Deleted UserJump to last post
03/01/2011 4:22 AM
1 Replies and 1902 Views Report Writer - Multiple Levels  1902  1 Started by  Josh I need to build a report that captures activity for all levels of the following company ranges: Co 1200-1299 Co 1500-1599 Co 1600-1699 And level one = 100 and level two = 0-99 for company 1100. Does the question make sense Somewhat of a novice on report writer so any potential responses can be 'dumbed' down as much as possible. Thanks!
1 1902
by  mark.cookJump to last post
02/25/2011 1:53 PM
0 Replies and 1578 Views Cash Ledger deposits  1578  0 Started by  SK Has anyone tried to bring in credit card payments into the CB module as deposits How would the same transaction number be assigned to CB, credit card processor data, and get transferred to the bank Thx.
0 1578
02/21/2011 10:52 AM
6 Replies and 2406 Views Asset Management - old assets  2406  6 Started by  cynthia My company has implemented AM with new assets acquired beginning Sept. We uploaded 'old' assets in our test environment and ran the reports to verify the results with our GL balances. When the conversion files were uploaded we called the book OLDCAPS. We indicated it as Non-Posting because the assets were already recorded in GL as fixed assets, as well as their corresponding depreciation exp and accumulated depreciation. These conversion files covered all assets prior to Sept 2010. My questi...
6 2406
by  cynthiaJump to last post
02/15/2011 1:48 PM
0 Replies and 1732 Views Lawson and DSS  1732  0 Started by  JonA Our current DSS uses the CDM to analyze supply cost data. But we in Materials are a little wary of this because we have no interface between Lawson Procurement and the CDM. So how does finance get accurate supply cost data Is anyone out there interfacing Lawson to a DSS Our vision for a DSS would give us the ability to slice and dice data down to the cost per procedure (DRG), per physician, per vendor, per implant, etc.
0 1732
02/10/2011 3:26 PM
1 Replies and 1598 Views AC 130 goes into recovery  1598  1 Started by  Kishan hi guys I ran AC130 for allocation group the other day and it went into recovery with message 'storeDBRec error is Record not locked (8)' ALLOC-NAME = XXXXXX I ran AC130 again today it completed successfully. I cant even debug as AC130 is not going into recovery. Lawson 8.0.3 Any idea why such unpredictable behaviour
1 1598
by  mark.cookJump to last post
02/08/2011 7:33 AM
2 Replies and 1484 Views Vendor Master Management re: Insurance Carriers  1484  2 Started by  Sheila My organization recently started accepting payments from Medicare and other third-party insurance companies. Our current policies and procedures for maintaining the vendor master files require us to obtain a W-9 from the vendor in order to properly identify them using their Federal TIN. We also verify that the vendor is not on any excluded/debarred lists from participation in federal health care programs. In the case of insurance companies, we don't pay them for goods or services, but ...
2 1484
by  SheilaJump to last post
02/07/2011 12:29 PM
0 Replies and 1491 Views AC10 error when trying to delete; Old Lawson version  1491  0 Started by  jbertoli First I am on an old Lawson version - 7.2.4. I have used the Activity move process (AC11, AC110, AC10.5, AC120) to move activities from one group to another in order to clean up some keystroke error when a level was originally set up. Now when I try to delete the dummy level 2 activity I create for the interim move, the AC10 screen gives me the message 'Cannot delete; subordinates exist in pending changes'. Where are these pending changes Joanne
0 1491
02/04/2011 11:41 AM
0 Replies and 1841 Views Multi-Ledger  1841  0 Started by  Bill Hi all- I work for a County government which uses Lawson Multi-Ledger to map multi-companies with different fiscal year end dates to the same December year end for financial reporting. Since we upgraded a year ago to 9.0 we have had to work around problems which we have encountered. Now we are experiencing a mission critical problem. General ledger balances (of a new company added throughout 2010) are NOT pulling through to the Multi-Ledger. The company has been added, mapped to our Multi-le...
0 1841
02/03/2011 9:45 AM
0 Replies and 1591 Views APINVOICE-AUTH-CODE or User for AP Invoice Release?  1591  0 Started by  Gary Is there a way to pull what user Released an AP Invoice The APINVOICE-AUTH-CODE captures who entered an invoice. I also need who Released the AP Invoice.
0 1591
01/27/2011 10:38 AM
5 Replies and 2495 Views AP Year End Issues  2495  5 Started by  mark.cook In case you guys have not run into this yet, the AP year end patches have caused two issues we have found so far that I want to make sure you know about. There are at least 2 patches out after the year end updates came out to fix issues. AP10 Tax ID field gets blanked out on Add/Change (CTP 75438 to correct) IC141 is bringing over the requisition without an account number (JT198761 /CTP 75784 available yesterday on website)
5 2495
by  Sherry S.Jump to last post
01/26/2011 4:26 PM
4 Replies and 2736 Views Need to Post entry or Adjust Year End balance (HELP!)  2736  4 Started by  jjcyeshua Hi All, I'm hoping that a guru in here will be able to give me an insight on how to fix our problem.... recently we closed our Fiscal Year 2009. (so now, GL10 shows Current year as 2011, Last Year 2010). but after reviewing our Statements, it showed that there was a incorrect posting that's affecting our FY09 ending balance. Is there a way to fix this I read the Financial Conversion Guide, but realized that running GL65 is not possible because our calendar year is not open for Fiscal y...
4 2736
by  D_HumpJump to last post
01/26/2011 8:56 AM
2 Replies and 1483 Views Null file name  1483  2 Started by  Kishan I am getting an error 'Null file name used in a file operation'. Pls let me know why such an error is arising...
2 1483
by  KishanJump to last post
01/13/2011 7:19 AM
3 Replies and 1707 Views Attaching specific account categories to an activity  1707  3 Started by  Saurabh This is on MSP8.1 (SQL backend). We have recently started to use activity management for tracking our refurbishment projects. To enable us to do this tracking we have have created a number of account categories. Would like to know if there is a way wherein i can restrict certain accnt categories to an activity. e.g Posting Activity - CONSTRUCTION I have number of categories e.g MRKTNG,CLNG,ARCHI,PKG1,PKG2,PKG3 What i would like to do is to set a link between CONSTRUCTION and PKG1,PKG2...
3 1707
by  jbertoliJump to last post
12/22/2010 5:08 PM
2 Replies and 3644 Views AP161 Remittance File Format  3644  2 Started by  Stewart Bond We are trying to identify the proper specs for the AP161ELECTREM file generated by AP161. The specs in the Lawson documentation do not match the format we see in the data file that is generated. If anyone has the proper specifications, please forward them. Thank you.
2 3644
by  jbertoliJump to last post
12/22/2010 5:03 PM
1 Replies and 1473 Views MAINDTL on Header Level Match  1473  1 Started by  Randall Hi all, We're trying to investigate whether or not when an invoice matches at the header level, if the values in MAINVDTL populate with the PO Line information. We've entered in several invoices without line detail and matched within tolerance. When drilling on the invoice, you see invoice line detail. It appears to all be the PO line information, but needed to verify. Also, I would assume, that the MAINVDTL populates with the invoice detail when there is a detail level match We'r...
1 1473
by  RobinLuceJump to last post
12/20/2010 4:45 PM
1 Replies and 1816 Views Invoice Discount Amounts  1816  1 Started by  Randall Hi all, I'll be the first to admin I have a little bit of functional knowledge in the financial arena, but by no means an expert. I have a question that I haven't been able to track down the resolution. We're undertaking an initiative to take the correct discounts on our invoices based on certain scenarios. After the calculation, we're attempting to change the amount of the discount on the AP22.3 screen (from the discount button on the main tab of AP20). After this is done and the inv...
1 1816
by  RandallJump to last post
12/07/2010 4:19 PM
3 Replies and 1835 Views GL291 Trial Balances Recreation with SQL  1835  3 Started by  Deleted User We are running GL291 with just Individual Reporting set to Company. Type set to 'A' and Report Sequence set to Level... Has anyone recreated this report with SQL If so I would be interested in seeing it. Thanks.
3 1835
by  DeronJump to last post
11/23/2010 2:40 PM
3 Replies and 1801 Views Relationships between ACTRANS AND MAPOINV or PURCHORDER  1801  3 Started by  Deleted User I'm trying to get a PO_NUMBER or INVOICE from ACTRANS. What's the key relation between ACTRANS and ( MAPOINV or PURCHORDER ) And also what's the REFERENCE in ACTRANS I thought it is PO_NUMBER or INVOICE when the transaction is 'AP'.
3 1801
by  Vijay SJump to last post
11/06/2010 10:28 AM
3 Replies and 2653 Views Project And Activity Accounting  2653  3 Started by  Nadyne Does anyone use project and activity accounting to track their funds activities
3 2653
by  NadyneJump to last post
11/02/2010 9:25 AM
0 Replies and 1409 Views Lawson C routines  1409  0 Started by  Kishan Can anyone tell me where I can find the 'C' rountines in Lawson sytem
0 1409
10/22/2010 5:42 AM
8 Replies and 2222 Views Report giving details of Actual and Commitments for an Activity  2222  8 Started by  Saurabh Hi All This is on LSF9.0.0.4, 8.1 MSP5. I am looking for a report which gives breakdown of 'Actual' and 'Commitment' for an Activity Group/Activity. I am able to get details of Commitments via AC298 but can't seem to find anything for Actuals. Any ideas Regards Saurabh
8 2222
by  SaurabhJump to last post
10/20/2010 4:36 PM
1 Replies and 1370 Views US Deposits in foreign country  1370  1 Started by  Greg Wiklund We have operations in a foreign country and have a bank account where we are storing USD. When I run my RW100's to consolidate, I want that dollar amount to appear; not a converted amount. Any time I want that money back, $20,000, I will get the $20,000 back, not a converted amount, so it should be on my books as $20,000, regardless of the base currency in that other country/company. Does anyone else conduct their operations this way
1 1370
by  Greg WiklundJump to last post
10/14/2010 2:31 PM
9 Replies and 2347 Views INTERFACING INVOICES AND PAYMENTS FROM A 3RD PARTY SYSTEM  2347  9 Started by  Barry Ghotra I have a situation where I need to electronically bring invoices from another system or a 3rd party provider that handles reimbursement expenses. Some times these payments need to be processed from Lawson but in certain cases the payment might have been posted as a direct deposit by the 3rd party provider. I understand that I can load the data into APCINVOIC APCDISTRIB and then run the AP520 to populate the application tables etc. But what about the pre-paid invoices. I also noticed the CVI-R...
9 2347
by  Ruma MalhotraJump to last post
10/13/2010 3:26 PM
6 Replies and 2386 Views 3rd party Order-to-Pay To Lawson Interface  2386  6 Started by  RajR Is there a way where we can interface our 3rd part software Order-to-Pay system and interface it to Lawson for Electronic payment The idea is to pay electronically using our Order-to-Pay system and send over the transaction to Lawson AP for record purposes Also I should be able to send info of Discount Codes from the Order-to-Pay system to Lawson. There won't be any transaction happening in Lawson, but I should be able to pull up the info in Lawson, if I have to see what electronic payme...
6 2386
by  Barry GhotraJump to last post
10/13/2010 9:52 AM
0 Replies and 2107 Views Wire Payments through Lawson  2107  0 Started by  Eddie Smith Our Treasury department does a lot of wire payments through their banks, both domestically and internationally (USD as well as other currencies)and then give us the information and we enter thme into Lawson as manual 'MAN' AP payments. We would like to have Lawson create the wire payments and eliminate the double keying that exists today. If anyone is doing wires via Lawson we would appreciate any help on how to set this process up in Lawson.
0 2107
09/29/2010 12:04 PM
2 Replies and 1636 Views Associate an Employee with APDISTRIB table?  1636  2 Started by  Bidur I am trying to figure out how to relate an Employee with APDISTRIB Table or AP Transactions. Any input will be appreciated! Thanks.
2 1636
by  Ruma MalhotraJump to last post
09/29/2010 10:10 AM
0 Replies and 1305 Views Getting Details of Commitments and Actual  1305  0 Started by  Saurabh Hi This is on LSF, Apps 8.1 MSP5 When running the AC295 (Activity Summary) it shows both the Committed and Actual Separately. However the AC298 (Commitment details) only seem to be showing details for Commitment, no information for Actuals. Am i missing something or is there another report which will show both (incl Actual amnt entered directly in AC modules) Regards Saurabh
0 1305
09/23/2010 5:16 PM
4 Replies and 2483 Views move accounting units between zones  2483  4 Started by  chaprob Our finance department has decided to restructure so that a group - but not all - of accounting units that currently exist in one facility (Company 100 - Corp 001) are moved to another (Company 100 - Corp 002). Looking for ideas on how best to move accounting units (GL20) but leave history intact in the old facility. AR and HR need the accounting units to stay the same on both corps, however Lawson support says all of the accounting unit's history moves when the acctg unit is moved. Our admin...
4 2483
by  chaprobJump to last post
09/22/2010 11:08 AM
3 Replies and 1755 Views Migrating accounts payable from LID to Portal in 9.0 release  1755  3 Started by  Deleted User We are currently testing portal for a/p. Are there any major teaching hospitals currently using portal for accounts payable, that can share their experience with that conversion with us. We have several major concerns, including substantial increased a/p processing time
3 1755
by  JillFJump to last post
09/20/2010 3:19 PM
1 Replies and 2360 Views AP300 Vendor Purge  2360  1 Started by  Deleted User Can anyone tell me the pro's & con's of running this job.
1 2360
by  DebEJump to last post
09/17/2010 5:21 PM
1 Replies and 2391 Views Currency Exchange Rate Provider  2391  1 Started by  BrianP Can anyone suggest an exchange rate service provider We are researching muli-currency for 9.0.0x and would like to incorporate an exchange rate interface. Does anyone have experience with services provided by OANDA
1 2391
by  John HenleyJump to last post
09/16/2010 4:16 PM
1 Replies and 1638 Views AC41.4 Resource Time Entry Upload  1638  1 Started by  MEllis We are trying to create an ac41.4 upload template. Each time we run the upload the GL Offset accounting unit changes to something other than what we are specifying. What could cause this
1 1638
by  BobCJump to last post
09/15/2010 4:10 PM
0 Replies and 1384 Views Vertex 3.3 and LSF 901 Technology  1384  0 Started by  Deleted User I've recently done an upgrade of our Vertex software and database files from version 2 to version 3.3. We are required to do this upgrade before the end of the year. The database files are still in the version 3.1 ISAM format. When I tried to use TX40 after the migration of the database files, I got the following error message: 'Quantum Err: Open failed.' How can I fix this
0 1384
09/07/2010 4:49 PM
1 Replies and 2731 Views Activity Commitment Detail Report link to PO Line Detail  2731  1 Started by  Carl Gifford I am trying to write an AC Committment Detail report in Crystal (using SQL) and would like to be able to reference the specific PO Line (POLINE) record. Is this possible. I am using the ACCOMMITX table and can find the PO from this table, but I cannot seem to find a link to the specific PO Line. Is this possible Thanks,
1 2731
by  Eddie SmithJump to last post
08/24/2010 7:04 AM
1 Replies and 1664 Views Auto load GL22.2  1664  1 Started by  Matthew Nye What is the best way to go about loading large amounts of rows for a manual account list Thanks, Matt
1 1664
by  Brad SchauerJump to last post
08/13/2010 3:05 PM
0 Replies and 2138 Views Double entry for Credit memos in AR  2138  0 Started by  Deleted User Hello colleagues, I would like to get some details on what GL account codes are hit when a credit memo is created in AR42 and it is applied to an open invoice.I ask this because there is a client who raised credit memos in AR42 and then applied these to open invoices and therafter these memos were released and was followed up by Application closing and distribution closing but there was no effect on 12001 account in GL even if GL190 was also run.The double entry seemed to have not taken place...
0 2138
08/09/2010 1:32 PM
13 Replies and 13964 Views Accounts Payable Aging Report  13964  13 Started by  Katfra Hello, First of all, is there a report in Lawson that i could run that shows me an AP Aging Currently I use AP136 to show me what my AP for the month is. Secondly, I'm attempting to create an aging report in Crytal since i wasn't sure if Lawson had one but having trouble with what table to use to pull the amount that shows up in my AP136. I'm currently using APDISTRIB as well as APINVOICE. Can anyone assist me in this Thanks, Frank
13 13964
by  KatfraJump to last post
08/09/2010 1:02 PM
6 Replies and 1922 Views AC410 in Crystal Reports  1922  6 Started by  ErikaS Good Morning, My organization is new to Lawson (implementing) and I'm wondering if anyone has been able to recreate the AC410 report using Crystal Reports (not through LBI). Thanks, Erika
6 1922
by  Kevin HaganJump to last post
08/05/2010 12:10 PM
3 Replies and 3418 Views AP: Number of Check Runs  3418  3 Started by  Deleted User Is there a way to find out how many check runs, or in Lawson terms how many times AP150, AP155, or AP170 has been run for a given time frame I can build a report if needed, but I don't know if there is a table that houses that info.
3 3418
by  SeanJump to last post
08/03/2010 6:47 PM
1 Replies and 1410 Views Commitments transferred from non-Lawson system  1410  1 Started by  Margaret Has anyone had any experience with commitments and how to handle at go live We currently use an encumbrance system and are trying to determine how to treat open POs in our old system at go live and whether we should convert the POs to Lawson and pay from Lawson or somehow continue to use the current(old) system and either use reports out of both systems and pay out the open POs in the old system or what We are implementing GL, AP, PO, AC, HR/PR, CB, AM, LM...I think that's it...and go l...
1 1410
by  Ruma MalhotraJump to last post
08/03/2010 6:00 PM
0 Replies and 3257 Views Manual controls around ACH/EFT payments in Lawson AP  3257  0 Started by  Deleted User We are beginning to implement electronic payments out of Lawson AP, but would like some guidance around setting up manual controls. What do others do to ensure the right vendors are being paid the proper amounts when paying electronically
0 3257
08/02/2010 12:33 PM
0 Replies and 1367 Views Renumber Account Utility?  1367  0 Started by  Jeff N Are there any utilities that allow you to renumber a Lawson account so the account detail is available in the new account I need to move some investment accounts to a different part of the balance sheet and would like the history to go with them. I used to work with MAS200 and there was a utility to do this. Thanks Jeff
0 1367
07/20/2010 10:23 AM
7 Replies and 3659 Views APDISTRIB Entry/Create Date?  3659  7 Started by  Gary I'm trying to report AP transactions by the date they were actually entered. I'm not finding that date anywhere. There's an APINVOICE create date - not the same thing. There's a GLTRANS R_DATE which does not appear to be the correct thing and isn't useful for this report as it is not created until the transaction is posted. I figured it would be in the APAPDHIST file but I'm not finding it anywhere. If nothing else, isn't there a transaction history file somewhere that would have it THANK...
7 3659
by  GaryJump to last post
07/20/2010 7:39 AM
6 Replies and 1687 Views RW Row files  1687  6 Started by  Matthew Nye Im creating a row file in RW10.4. It seems the description is limited to 30 characters. Is there any other display options for row description that would allow for more characters Thanks, Matt
6 1687
by  Ruma MalhotraJump to last post
07/16/2010 4:58 PM
1 Replies and 1835 Views Moving Lawson databse from DB2 z/OS to DB2 AIX  1835  1 Started by  nicks New to the Lawson world and am trying to find documentaiton on the steps necessary and utilities provided to move the underlying Lawson Financials database from DB2 z/OS to DB2 on AIX. I understand there are databse definition and data movement utilities provided but am looking for a source of information that maps out the high level steps necessary. The DB2 AIX software installation/configuration is done already.
1 1835
by  Vijay SJump to last post
07/14/2010 8:33 AM
3 Replies and 1593 Views Sharing Posting Activities within an Activity Group  1593  3 Started by  Saurabh Hi All This is on 8.1 0 MSP5 on LSF9.0.0.4 We have just recently started using the Activity module. The initial setup had been very simple and works fine. We would now like to track certain complex projects (like Major Refurbishment projects etc). When trying to setup the various Activities I find that I am not able to use Activities across the summary level.(see attached document for an example setup we would like to be done.) e.g We are having to dup...
3 1593
by  Ruma MalhotraJump to last post
07/12/2010 3:04 PM
1 Replies and 2251 Views Upload Wizard Login Server Name  2251  1 Started by  Jodi Hi, Some users of the Lawson Upload Wizard have to keep typing the server name in the login box where others have the server name in their drop down box. I can't figure out how to change it so everyone has the server name in the login box. Does anyone have any ideas Thanks, Jodi
1 2251
by  SaurabhJump to last post
07/09/2010 6:58 AM
0 Replies and 1222 Views Daily Exchange Rate vs Single Monthly Exchange Rate  1222  0 Started by  Melissa McGuire Does anyone have any dealings with these Any pros or cons you can share
0 1222
07/07/2010 10:37 AM
2 Replies and 2312 Views Lawson 8.03 in 9.01 environment  2312  2 Started by  Deleted User I have the financial application in lawson 8.03 that we use as historical. Few users still go there to check on the history, However we upgraded to 9.01 env last month and now I need to think about that application and copy the product line over to our new environment. Does anybody knows if I am going to encounter any problems in the new environment. I do not want to convert all of the programs to the new lawson App version 9.01. Any comment will be appreciated.
2 2312
by  Deleted UserJump to last post
07/02/2010 8:31 AM
7 Replies and 2470 Views Index which table??????????  2470  7 Started by  Vijay S I have only acess to LID(No portal access, no query wizard access and no database access). I want to know that which index belongs to which table!!!!!!!!!!! I mean to say is there any trick (or utility) to know which index belongs to which table:
7 2470
by  Vijay SJump to last post
07/01/2010 11:31 AM
2 Replies and 1690 Views Terms Code Description  1690  2 Started by  Deleted User What table can I find the terms code description. I am building a MSaddins query and can include the terms code but it is a meaningless number with out the definition. Can someone tell me what table I might find the terms code definition Thanks.
2 1690
by  Deleted UserJump to last post
07/01/2010 11:17 AM
3 Replies and 1540 Views Transferring Activity commitment  1540  3 Started by  Saurabh Hi All This is for Apps 8.1 0 MSP5. We currently use the AC module to track some of our IT projects. Unfortunately I had to create a Purchase order (via requisition) using a dummy activity code. The PO has just been released and issued (not received or matched) Now that i have setup the correct activity i have gone into PO20 and changed the Activity and Account Group to be the correct value. Reissued and Released the PO and was expecting the commitment to now show up againt this new Activity....
3 1540
by  Ruma MalhotraJump to last post
07/01/2010 10:30 AM
3 Replies and 1843 Views Adding new levels to AU Hierarchy  1843  3 Started by  Deron We currently have 3 levels defined for our accounting units: Line of Bus - 3 Department - 3 Cost Center - 4 leaving 2 unused levels. Our reporting requirements are changing and the current hierarchy does not give us the level of detail we need. Is it possible to expand our hierarchy to include the 2 unused levels, making my hierarchy look like this: Line of Bus - 3 Department - 3 New Hierarchy 1 - 4 New Hierarchy 2 - 4 Cost Center - 4 Thanks for any ...
3 1843
by  Ruma MalhotraJump to last post
07/01/2010 8:01 AM
1 Replies and 2804 Views Round cost allocation to allocate all costs  2804  1 Started by  Sherry Shimek A user allocates benefits costs from the Benefits Accounting unit to the department accounting units using Cost Allocation. Is there a way to round the amounts so the Benefits Accounting Unit is reduced to zero automatically for each account instead of leaving a few pennies presumably due to rounding
1 2804
by  Gail GudgelJump to last post
06/28/2010 3:30 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 5 << < 12345 > >>

RSS Feed Available