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

RSS Feed Available