Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 8 << < 23456 > >>
Topics
 Replies
 Views
 Last Post
1 Replies and 1472 Views Change Cash Code on Unpaid Invoices in AP  1472  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 1472
by  Bob CanhamJump to last post
08/20/2013 2:40 PM
0 Replies and 1315 Views Accounts Payable Merging of 2 Vendor Groups  1315  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 1315
08/09/2013 1:34 PM
2 Replies and 1782 Views remittance notice for ACH payments  1782  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 1782
by  Maynard F.Jump to last post
08/07/2013 10:59 AM
1 Replies and 756 Views lp01 drop-down menu  756  1 Started by  bernfc10 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 756
by  Greg MoellerJump to last post
08/06/2013 2:29 PM
0 Replies and 702 Views Matching in AP55  702  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 702
08/06/2013 8:43 AM
9 Replies and 1940 Views Interfacing into a Surgical Information System  1940  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 1940
by  Greg MoellerJump to last post
08/05/2013 9:13 AM
1 Replies and 1143 Views AP155 report format limitations  1143  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 1143
by  Ragu RaghavanJump to last post
08/03/2013 9:05 AM
4 Replies and 2445 Views What is the best way to create an elimination company?  2445  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 2445
by  MelissaJump to last post
07/27/2013 8:14 PM
0 Replies and 901 Views Binding Billing API (BLOEL71PD) RPGLE  901  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 901
07/25/2013 4:59 PM
2 Replies and 1693 Views Question on Purging Vendors  1693  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 1693
by  Bob CanhamJump to last post
07/25/2013 10:57 AM
0 Replies and 708 Views How to get copy invoices from M3 in an electronic format  708  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 708
07/25/2013 6:21 AM
1 Replies and 1038 Views Audit tracking on GL20.2  1038  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 1038
by  John HenleyJump to last post
07/19/2013 10:43 AM
1 Replies and 722 Views Percent Complete Calculation - AC165 and BR165  722  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 722
by  John HenleyJump to last post
07/09/2013 6:51 AM
11 Replies and 1679 Views GLAMOUNTS and GLUNITS Tables  1679  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 1679
by  DeronJump to last post
07/02/2013 2:40 PM
1 Replies and 1115 Views Reporting  1115  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 1115
by  Tony ConwayJump to last post
07/01/2013 4:25 AM
3 Replies and 1581 Views Invoice Line item detail  1581  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 1581
by  Bob CanhamJump to last post
06/28/2013 10:34 AM
1 Replies and 1982 Views Cost Center hierarchy  1982  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 1982
by  Rich BendicksonJump to last post
06/24/2013 2:55 PM
2 Replies and 1289 Views GL192  1289  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 1289
by  Terry WierJump to last post
06/24/2013 2:36 PM
1 Replies and 1076 Views copy/paste functionality from LID vs portal with LSF9  1076  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 1076
by  John HenleyJump to last post
06/11/2013 3:39 PM
2 Replies and 1475 Views Crystal Report-Financial Ratios Chart/Graph  1475  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 1475
by  DonnaJump to last post
06/10/2013 3:35 PM
1 Replies and 1339 Views Adding Vendor Class to AP20.1  1339  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 1339
by  Ragu RaghavanJump to last post
05/29/2013 1:18 PM
1 Replies and 1075 Views Break up details- GL90.1  1075  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 1075
by  mark.cookJump to last post
05/21/2013 8:00 AM
2 Replies and 1335 Views Info Browser  1335  2 Started by  Diane G I just set up an Info Browser to get the current balance of one balance sheet account using the CYDAMT field. Why am I getting 10 different amounts The last one IS the current balance, which I need. I don't need to see the other 9. We are on Smart Office version 10.0.5.1
2 1335
by  Diane GJump to last post
05/17/2013 10:08 AM
5 Replies and 1378 Views mx10 interface  1378  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 1378
by  John HenleyJump to last post
05/16/2013 12:48 PM
0 Replies and 789 Views customer process level and (revenue) account  789  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 789
05/16/2013 11:54 AM
1 Replies and 1121 Views AP 20.2 Alowing invoice to post over Activity Budget  1121  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 1121
by  LauraJump to last post
05/16/2013 7:38 AM
0 Replies and 739 Views AM20.3 Add-ins upload to add serial number  739  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 739
05/15/2013 10:18 AM
0 Replies and 2489 Views Bad File status 3 5 on sortfile  2489  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 2489
05/15/2013 9:56 AM
0 Replies and 780 Views Reopen Year End  780  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 780
05/14/2013 9:00 AM
0 Replies and 827 Views RW 100-Ratios  827  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 827
05/13/2013 2:23 PM
3 Replies and 879 Views Where would i find start time end time for daily productivity report  879  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 879
by  Ruma MalhotraJump to last post
05/13/2013 12:21 PM
3 Replies and 1911 Views AP30.2 Distribution changes post 9.0.1 Upgrade  1911  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 1911
by  KarenBCIJump to last post
05/09/2013 5:04 PM
2 Replies and 2027 Views Grant Tracking: Accounting Units vs. Activities  2027  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 2027
by  Michael GraceJump to last post
05/09/2013 12:09 PM
0 Replies and 765 Views Bulk Load of EFT Setup Data?  765  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 765
05/06/2013 1:59 PM
2 Replies and 1495 Views How to Require Activity & Account Category  1495  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 1495
by  CindyJump to last post
05/02/2013 10:21 AM
0 Replies and 814 Views AC500 - report showing duplicated lines..  814  0 Started by  johne and if so, have you searched / found a patch to correct the problem.. QA person is testing against a 9.0.1.8 version of AC500. appears to have the report duplicating the last line of information on the 'Valid Records Listing' section when there is an 'Error Records Listing' section that follows. does not occur when there is not an error record group. I'm not finding anything in any of the Lawson KB areas & was just wanting to see if anyone else is seeing the same issue. header o...
0 814
04/29/2013 3:45 PM
2 Replies and 881 Views GL40 Status Message Account Category Required  881  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 881
by  Ken CarleyJump to last post
04/29/2013 1:19 PM
2 Replies and 1312 Views Lawson Excell Add-Ins  1312  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 1312
by  John HenleyJump to last post
04/29/2013 8:44 AM
3 Replies and 1103 Views GL security classes for LSF9 security  1103  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 1103
by  GeorgetteJump to last post
04/25/2013 11:08 AM
1 Replies and 887 Views Colliding Allocations CA190 GL190  887  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 887
by  BarbaraJump to last post
04/14/2013 8:53 AM
0 Replies and 718 Views I need last updated column details on tables  718  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 718
04/11/2013 8:14 PM
0 Replies and 652 Views PTO GL Questions (XPosted)  652  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 652
04/08/2013 10:09 AM
3 Replies and 1156 Views Laser Check Printing File Security  1156  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 1156
by  BrianJump to last post
03/31/2013 12:40 PM
3 Replies and 1111 Views AP270 invoice detail?  1111  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 1111
by  Greg MoellerJump to last post
03/28/2013 9:24 AM
4 Replies and 794 Views Report over PO  794  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 794
by  Greg MoellerJump to last post
03/27/2013 1:07 PM
0 Replies and 897 Views Asset Management S3  897  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 897
03/14/2013 4:09 PM
0 Replies and 1128 Views Asset Management  1128  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 1128
03/14/2013 3:48 PM
1 Replies and 854 Views need help with benchmarking  854  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 854
by  DougABJump to last post
03/12/2013 3:57 PM
0 Replies and 670 Views Prior year reqs  670  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 670
03/11/2013 7:46 PM
2 Replies and 1035 Views How do I create a new ATN-OBJ-ID?  1035  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 1035
by  DonnaJump to last post
03/07/2013 5:13 PM
7 Replies and 1135 Views Vendor file read  1135  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 1135
by  slm4Jump to last post
03/04/2013 2:30 PM
0 Replies and 806 Views Physical 2 Virtual converstion  806  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 806
02/27/2013 12:05 PM
1 Replies and 1224 Views Reconciling A/P to G/L  1224  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 1224
by  martyzoetJump to last post
02/25/2013 3:18 PM
2 Replies and 1378 Views Consolidation company  1378  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 1378
by  Display NameJump to last post
02/24/2013 7:39 AM
4 Replies and 1078 Views Lawson Monitor  1078  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 1078
by  RickyYJump to last post
02/22/2013 6:21 PM
1 Replies and 2644 Views GL - Reopen Final Close Period  2644  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 2644
by  John HenleyJump to last post
02/19/2013 10:42 AM
3 Replies and 1289 Views Accounts payable processing  1289  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 1289
by  Kat VJump to last post
02/18/2013 4:00 PM
0 Replies and 958 Views User Audit Trail? - AR82.1 - Returned Payment  958  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 958
02/15/2013 2:18 PM
0 Replies and 877 Views Open A/P Invoices  877  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 877
02/12/2013 12:54 PM
0 Replies and 2119 Views PFI Workflow Failures  2119  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 2119
02/08/2013 8:03 AM
0 Replies and 1103 Views Vendor Payment Code  1103  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 1103
02/06/2013 7:07 AM
0 Replies and 862 Views Multiple Orders; One Invoice  862  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 862
02/01/2013 9:34 AM
2 Replies and 946 Views Attribute List (MX10)  946  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 946
by  Robert SpurrJump to last post
01/25/2013 4:17 PM
1 Replies and 1399 Views Aging Reports (AR251) - F.O.R.  1399  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 1399
by  John HenleyJump to last post
01/24/2013 4:13 PM
7 Replies and 5313 Views Journal Entry Processes  5313  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 5313
by  John HenleyJump to last post
01/18/2013 9:28 AM
2 Replies and 1062 Views GLTRANS ACCOUNT and sub_account details  1062  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 1062
by  dcaianiJump to last post
01/17/2013 3:33 PM
0 Replies and 757 Views Calculate Daily productivity in dollars which table  757  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 757
01/17/2013 4:43 AM
0 Replies and 913 Views Workflow Process  913  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 913
01/11/2013 9:55 AM
0 Replies and 879 Views Cell Phone Reimbursement AP vs PR  879  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 879
01/10/2013 12:10 PM
1 Replies and 805 Views Getting Attribute chgs from AC13.7 to AC13.1  805  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 805
by  johneJump to last post
01/08/2013 3:56 PM
1 Replies and 1326 Views Migrating From Lawson To Oracle EBS GL  1326  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 1326
by  AndyJump to last post
01/05/2013 4:30 PM
0 Replies and 1907 Views Paymode-X  1907  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 1907
01/04/2013 2:42 PM
0 Replies and 1094 Views New FACTA regulations for Foreign Vendors  1094  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 1094
01/04/2013 11:40 AM
0 Replies and 991 Views Using Analytics for Medicare cost report calculations  991  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 991
01/02/2013 3:38 PM
0 Replies and 824 Views Calc previous month  824  0 Started by  bernfc10 Is there an API that I can call to calculate the previous month given the parameter current month
0 824
12/20/2012 12:25 PM
0 Replies and 1313 Views Attachments to journal entries  1313  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 1313
12/12/2012 7:53 AM
1 Replies and 1161 Views Replicate MA236 form in Crystal  1161  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 1161
by  Ruma MalhotraJump to last post
11/27/2012 1:48 PM
1 Replies and 975 Views Table containing Reporting Currency Period Totals  975  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 975
by  John HenleyJump to last post
11/26/2012 3:31 PM
1 Replies and 1120 Views Asset Reports for Tax Return Preparation  1120  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 1120
by  Greg MoellerJump to last post
11/14/2012 4:23 PM
4 Replies and 1431 Views RW100 logon failure  1431  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 1431
by  ABGJump to last post
11/07/2012 8:38 AM
5 Replies and 6529 Views Hyperion Essbase - alternatives?  6529  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 6529
by  Wouter BornJump to last post
11/06/2012 7:55 AM
1 Replies and 2141 Views AP matching module  2141  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 2141
by  JimYJump to last post
10/23/2012 8:28 AM
2 Replies and 3014 Views AP90 Invoice Attachment URL Location Table  3014  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 3014
by  shashankJump to last post
10/18/2012 1:13 PM
3 Replies and 1748 Views APAUDIT Table  1748  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 1748
by  dcaianiJump to last post
10/16/2012 1:49 PM
8 Replies and 1590 Views AP160 FORMAT - ONE LONG RECORD STRING  1590  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 1590
by  JimYJump to last post
10/04/2012 11:44 AM
0 Replies and 1115 Views Actual and Budgeted Salary Dollars Report broken down by Job Class  1115  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 1115
10/04/2012 9:55 AM
0 Replies and 1346 Views CA10 Allocations Upload  1346  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 1346
10/01/2012 5:44 PM
1 Replies and 1140 Views Invoice detail upload  1140  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 1140
by  MichelleJump to last post
09/27/2012 11:26 AM
13 Replies and 10518 Views AP - Wells Fargo Payment Manager Service  10518  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 10518
by  blongJump to last post
09/27/2012 7:48 AM
0 Replies and 929 Views Library routine  929  0 Started by  bernfc10 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 929
09/25/2012 3:02 PM
6 Replies and 1541 Views ERDs for Newest Version  1541  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 1541
by  ErinJump to last post
09/21/2012 3:14 PM
2 Replies and 2129 Views Inbound EDI 810's and multiple vendor locations  2129  2 Started by  Brent Hello. We are attempting to set up to process EDI 810’s in Lawson 9.0.1.5.768, 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 2129
by  BrentJump to last post
09/20/2012 10:56 AM
2 Replies and 1665 Views Return number of days  1665  2 Started by  bernfc10 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 1665
by  TracyOJump to last post
09/19/2012 1:17 PM
6 Replies and 1573 Views ACTRANS has OBJ-ID = 0  1573  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 1573
by  LisaJump to last post
08/31/2012 4:15 PM
0 Replies and 2304 Views Lawson training or navigational guides  2304  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 2304
08/31/2012 10:22 AM
2 Replies and 1408 Views ARITRANS  1408  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 1408
by  DougABJump to last post
08/27/2012 4:25 PM
5 Replies and 4664 Views PO64.1 PO Line Item History Report?  4664  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 4664
by  Dave McGownJump to last post
08/03/2012 10:24 AM
3 Replies and 2182 Views Suggestions for check printing solutions?  2182  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 2182
by  DougABJump to last post
07/31/2012 3:58 PM
0 Replies and 1577 Views 457 Plan - Company Match  1577  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 1577
07/26/2012 5:22 PM
0 Replies and 1063 Views Comments not attached to invoices  1063  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 1063
07/17/2012 11:59 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 8 << < 23456 > >>


RSS Feed Available