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 1 of 812345 > >>
Topics
 Replies
 Views
 Last Post
2 Replies and 325 Views Remove items PO135  325  2 Started by  rhorn01 We are fairly new to Lawson/Infor . . . in reviewing the latest PO135 we have identified items that have been paid outside of the PO and items that need to be removed for other reasons. What is the best way to remove these items from the PO135 Do we manually close the PO I have seen some references to the MA180, but we had one consultant advise us not to run that report. Any specific information/screen names would be helpful. Any best practices in monitoring this report Thanks!
2 325
by  Kat VJump to last post
11/10/2017 2:19 PM
2 Replies and 360 Views Smart Reconciliation  360  2 Started by  Patricia Mane Who out in the Lawson world is using Smart Reconciliation We have this product and of course like all others, the User Guide doesn't provide adequate instructions. Thanks Trish
2 360
by  JeremyJump to last post
11/10/2017 1:15 PM
7 Replies and 1515 Views Processing Vendor Refunds  1515  7 Started by  Radu I am trying to figure out a way to recognize vendor refunds through the AP module so that, when I process 1099s, the amount paid to the vendor shows up correctly. Historically, we just booked the refunds manually in the GL module, but obviously this does not reduce the amount reported on 1099s. The subsequent process was to create offsetting credit and debit memos in AP and a cash transaction in CB, but again the offsetting credit and debit memos do not reduce the reported 1099 amount. Ultima...
7 1515
by  JeremyJump to last post
11/10/2017 7:38 AM
3 Replies and 505 Views LID Commands  505  3 Started by  Evil Beagle I've got a question in regards to LID commands. I've run help to get a list of commands for LID. What I'm trying to accomplish is, simply, listing the files within the currently selected folder. According to help, 'DIR' is the command. However, running DIR in any folder gives me 'dir: file not found'. Has anyone else run into this issue
3 505
by  Ray JuodisJump to last post
11/03/2017 9:23 AM
2 Replies and 334 Views Status on Req in RQC compared to Shipment status on WH80  334  2 Started by  Bev Edwards A req in RQC shows a req as Processed. A Shipment status on the same req number shows a status of Closed. On the example I have attached, there is a b/o or 10. Is the status on the WH80 for the shipment number to show the qty that was shipped is Complete It sounds as if the director thinks these two status messages should be reflecting the same thing, but when I look at them, that's not how I understand it.
2 334
by  Bev EdwardsJump to last post
10/25/2017 3:13 PM
1 Replies and 449 Views MX Attribute List maintenance  449  1 Started by  jrbledsoe Does anyone know the best way to delete or purge attribute lists If you have automatic and manual attribute lists that you are no longer need or use, what's the best way to remove them Thanks for reading my post
1 449
by  LynnetteJump to last post
10/16/2017 4:36 PM
0 Replies and 113 Views Payroll posting to first open period  113  0 Started by  Lynnette We have an ongoing issue during the first 8 days of the month while we are working on month end. In the 8 days of the month that we do not have the calendar closed for the previous month, If the PR team makes a payroll adjustment for a previous month, the transactions post to the current open month. I always wondered why their wasn't a control on PR like there is on IC and AP. I was just curious on how others are handling these types of situations.
0 113
10/12/2017 4:14 PM
0 Replies and 106 Views Payroll Reconciliation to GL  106  0 Started by  Lynnette Does anyone know what table (on the PR side) the detail of the payroll accrual can be found in I'm trying to write a report for managers that ties the GL for the month back to Payroll. The one piece I'm missing is the system generated detail for the payroll accrual.
0 106
10/12/2017 4:06 PM
1 Replies and 292 Views GL Maintenance  292  1 Started by  MChism Hello all! We are restricting roughly a dozen GL accounts to only allow postings from the GL system. Primarily disallowing systems such as AP, PO IC to hit these GL's. We made these changes in GL00.1 - GL00.3 - GL00.4 and then GL03.5. My question is, do any of you have experience with making sure that these GL's are never opened back up Can we add comments or notes as to why we are closing these to only the GL system I fear that in a year or two we will have an invoice or requisition e...
1 292
by  LynnetteJump to last post
10/12/2017 3:51 PM
0 Replies and 108 Views Allocations to multiple companies/locations  108  0 Started by  Tanya_D I have a client that is new to Lawson allocations. She was left with no documentation on the allocations and is trying to rebuild for the new fiscal year. Her question is, Can an allocation be written say From Company 1 to Companies 2,3, & 4, along with multiple AUs on each company
0 108
10/11/2017 2:08 PM
1 Replies and 299 Views how to extract different legder into excel  299  1 Started by  Sdcaqd Hello, everyone! I'm new to Lawson and I have the following questions: 1.How to extract the whole general ledger into excel (not in PDF) 2.I'd like to see sales ledger based on customer name, e.g. all the sales invoices issued to customer A.How to generate that report 3.How to generate AP aging report 4.How to create accounts and sub accounts Thanks a lot !:)
1 299
by  rhorn01Jump to last post
10/09/2017 12:04 PM
0 Replies and 119 Views AC298 - Activity Amount Column  119  0 Started by  timbomom What is the source of the Activity Amount Column in AC298 Thanks in advance! Patricia
0 119
09/22/2017 6:13 PM
0 Replies and 149 Views Using AP230 to tie to AP GL account  149  0 Started by  Becky W Our auditors wanted us to supply them with an Open Payables Report which tied to the AP GL account. When running the AP230, it did not tie to the GL. One reason I have determined is that invoices for which a messages exists appear on the AP230, but have not been posted to the GL yet. I need help thinking of why invoices would be posted to the GL, but not on the AP230. Any suggestions PS-I know the AP136 is the report that will tell us exactly what ties to the AP GL account but it does no...
0 149
09/20/2017 9:45 AM
1 Replies and 317 Views AC10 Audit Table?  317  1 Started by  PD Does anyone know the audit table name for AC10 I would like to think that such a thing exist to be able to capture change(s) that take place. If this is not the right forum for this question, please let me know. Thanks,
1 317
by  John HenleyJump to last post
09/18/2017 10:25 AM
0 Replies and 160 Views AR zero or negative payment  160  0 Started by  Todd Mitchell We are currently working on a project in which a customer has the ability to pay their invoices via credit card. On some occasions, the amount of credits could be the same or exceed the amount of invoices, resulting in a zero dollar payment or a negative payment. In the Lawson EFT world (AR115), Lawson creates a debit memo to offset the amount of the negative payment and then interjects a zero dollar payment into the payment table. Has anyone had to create a similar situation and if so, how...
0 160
09/11/2017 2:30 PM
0 Replies and 144 Views MA126  144  0 Started by  Patricia Mane Good morning- Who has and is willing to share process related to working the MA126 Error Report We have had several changes in our AP Department and I am working to create simple Work Instructions so they new staff is able to do their jobs efficiently. Any help or guidance would be greatly appreciated. Thanks Trish
0 144
09/01/2017 8:06 AM
10 Replies and 625 Views PO100-Purchase orders  625  10 Started by  bernfc10 For some strange reason, all of the sudden the PO100 auto job is now creating purchase orders intol 1 single PO for different ship to locations/Pyxis locations. We need to have 1 purchase order created for Each Separate Location. So if we have orders from Location 1X & 2X for example - these must each get their own PO number. They can not be combined into 1 Purchase Order. Up to RQ500 the settings/parameters were fine and it created individual source documents.. Once the PO100 ran - it took...
10 625
by  bernfc10Jump to last post
08/29/2017 2:50 PM
0 Replies and 118 Views Asset Management (AM) system - Upload Adjustments  118  0 Started by  NorthMemorial We are in the process of using the Addins Upload Wizard for adding assets. Is there a way to use a uploader wizard for adjustments as well Any information would be great. Thank you.
0 118
08/24/2017 11:53 AM
4 Replies and 1407 Views AP Invoice Report  1407  4 Started by  bernfc10 Hello, does anybody know if there is a Lawson report to see how many invoices are processed by each A/P clerk
4 1407
by  tkminnJump to last post
08/22/2017 12:11 PM
3 Replies and 295 Views AP10.2 Contact Account Number  295  3 Started by  pglibra Hello, I am trying to write an Access query to pull the vendor's account number that can be found in AP10.2, Contact, Account Number. What tables do I need and how do I link them in Access Thank you
3 295
by  JimYJump to last post
08/22/2017 9:34 AM
7 Replies and 828 Views GL Beginning Balance Not Updated at year end  828  7 Started by  Peter HELP!!! :) We are on Fiscal Calendar and last month Did a Limited year end Close Option 'L' in GL199 but did not Run the 'N' Next Year beginning balance Option first. Now we are in the New Year but the beginning balances are not updated. Is there any way for me to update the balances for the current period.. I tried running GL199 again with a Last Year period 12 and 'N' option but it would not let me. Many Many Thanks I am desperate.
7 828
by  Mira GuirguisJump to last post
08/02/2017 3:30 PM
2 Replies and 454 Views Note To Buyer field in RQ10 vendor drill down  454  2 Started by  clb393 I'm trying to query the Note to Buyer field, which resides in the RQ10 Vendor field drill down. Can anyone tell me what database table I can find that in Thanks, Chris
2 454
by  clb393Jump to last post
07/31/2017 7:46 AM
0 Replies and 125 Views Stale Date/Escheat a small group of checks  125  0 Started by  Bob Canham We normally escheat our AP checks on a regular schedule. However, our patient accounting department has done due diligence on some of our patient refund checks and would like to escheat those early. We can't find an easy way to do this though as those payments come out of our main checking account. The only way I can see to do it is to stale date everything, manually escheat the patient refunds, and then manually reinstate all of the checks. Does anyone do this and know an easier way
0 125
07/27/2017 9:03 AM
0 Replies and 151 Views Budget Advisor/Kaufman Hall Reports  151  0 Started by  rhorn01 We converted to Infor/Lawson from PeopleSoft recently. In PS, we included PO line level in our Budget Advisor AP reports. Currently in Infor, we still include PO purchases in our month end AP BA reports; that current build summarizes PO data at the PO level for each GL account/AU (rather than PO line level detail). However, we have problems pulling in relevant description b/c the PO description available for us to use is not necessarily indicative of all the items purchased on the PO. This has...
0 151
07/21/2017 4:08 PM
0 Replies and 165 Views CB10 Upload  165  0 Started by  AnonymousEmployee Good Morning, I am working on creating an MS Add-in upload template for manual deposits entered into CB10 (Cash Receipt Deposit). The upload needs to create the Deposit 'header' in CB10.1, populate the breakdown of the deposit for CB10.3 and allow for overwrite account details in CB10.4 as needed. My company does not utilize the Journal Book option. Attached is the working copy of my template. First tab loads CB10.1 (deposit header) loads perfectly. The second upload to attach the detail t...
0 165
07/17/2017 10:12 AM
1 Replies and 365 Views AP90.1 portal screen  365  1 Started by  YEEXCE1 Hi, We just upgraded to Lawson v10 and are using IE 11. Has anyone encountered an issue in AP90.1 where after inquiring for a vendor, you hit next or previous and the whole screen doesn't refresh We have an end user who was inquiring a vendor invoice. She noticed that if a vendor has multiple invoices that takes up the whole screen and when she clicked on Next or Previous where the next vendor has one invoice, the rest of the screen is still showing the PL and User Field 1 data from t...
1 365
by  JimYJump to last post
07/14/2017 5:40 AM
3 Replies and 416 Views AP Vendor Query Speed  416  3 Started by  StvG Using just three criteria: COMPANY equal company number (just one) APVENMAST.VEN-CLASS equal class (just one) APPAYMENT.CHECK-DATE = greater than or equal too a given date Table is large and query runs for about an hour and a half. Didn't know if someone knew if there was an index I could select that might speed this up, at least a little bit. Currently no Index\Key Value set in query. Thanks!
3 416
by  StvGJump to last post
07/07/2017 8:34 AM
4 Replies and 353 Views 1099 Production  353  4 Started by  Bob Canham We have used Convey to produce our 1099 forms in the past. This product is being sunset in the near future, so we're looking for other options. How are others producing their 1099 forms and IRS file Are you using Lawson with MHC Or are you using some other 3rd party
4 353
by  O. JohnsonJump to last post
07/06/2017 11:05 AM
7 Replies and 621 Views printing 1099's on sunset version 9.0.1  621  7 Started by  Russell Spreeman Having become 'affiliated' with a larger company, we are moving away from our own Lawson system onto a corporate system but we are not there yet. We have discontinued our use of Lawson HR / payroll applications as of a year ago. Being on 9.0.1 our extended support is sunset as of the end of May 2017. We will not be ready to move off of our Lawson IC / AP system for a while yet. We have been quoted a very large sum to upgrade our system to v10 (or whatever is current) including migrating to Lawso...
7 621
by  Eric99Jump to last post
06/20/2017 8:55 AM
2 Replies and 403 Views Asset Management Mass Addition  403  2 Started by  Rhonda Cordes We have quite a few assets that need to be added to our Lawson system before our fiscal year-end which is June 30. I have been told that AM500 may be our only options; however, that does not create the GL journal entries automatically and we would have to manually create them after loading the assets. Has anyone completed a mass addition of assets If so, what process did you use Any information on how to do this mass addition is greatly appreciated. Thanks, Rhonda
2 403
by  KellyJump to last post
05/31/2017 4:19 PM
0 Replies and 331 Views Positive Pay - Bank of America  331  0 Started by  LauraPat Hi - thanks in advance for any feedback. We want to add Payee Name to our positive pay file to Bank of America for AP. Initially - it seemed as simple as taking the Legal Name from AP10 (APVENMAST) and putting it into the Payee Name in the CD0200R record for BofA. In our Lawson system - our AP staff also may put additional 'payee' information in the first couple of address lines and then have the last line for the actual address. Bank of America is failing all of these payments because they ...
0 331
05/23/2017 2:22 PM
0 Replies and 236 Views Select from data list  236  0 Started by  Diane G We recently upgraded to Lawson 10. Somehow in the process, I lost the ability to just enter the first letter of a field, hit my down arrow and have the next item in the selection populate. For example, when entering a new asset, we have 40 locations. I could enter a P hit my down arrow once and Perry would populate. I have not been able to find a setting to change this. If I right click on a field it says - Select from data list Enter This is minor, but annoying.
0 236
05/17/2017 3:55 PM
0 Replies and 308 Views Smart Recon  308  0 Started by  brooke Good Morning We recently upgraded to Smart Recon SMR_10000516 and Smart Recon is VERY slow. Has anyone else had this issue thanks brooke
0 308
05/16/2017 10:20 AM
0 Replies and 224 Views GL199-final closed periods back to limit-close  224  0 Started by  bernfc10 My users accidentally final-closed periods FY17 periods 1-12 while. They try to run the GL199 but the system won't let them change the FY17 periods back to limit-close. I put a ticket with Lawson but unfortunately there is no way for the system to undo a Final Closed period. They suggested a resolution but it's out of their scope and will be use at our own discretion. Do you know another way to do this
0 224
05/16/2017 7:48 AM
1 Replies and 415 Views AP10 & AP10.5 - update through IPA - Lawson Transaction.  415  1 Started by  Bonde I have been trying to figure out what will be the primary keys required to make a lawson query to pull information of the AP10.5 Form My understanding - 1)AP10 need the 1. VEN-VENGROUP AND 2. VEN-VENDOR to inquire the information of that form 2)AP10.5 needs 1.APX-VENDOR to inquire and change - Lawson query - _PDL=TEST&_TKN=AP10.5&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=I&APX-COMPANY=100&APX-TERM-CODE=&APX-VENDOR=56302&_DELIM=09&_OUT=XML&_EOT=TRUE I inte...
1 415
by  BondeJump to last post
05/15/2017 1:10 PM
5 Replies and 1655 Views EDI and Credit Memos  1655  5 Started by  JonA How do you process a credit memo when it comes via EDI and is translated to the MA540CSV file Our AP departments says they error out and they just deleted them and request a paper credit memo from the vendor. The Infor/Lawson KB says that you can receive credit memos via EDI but doesn't say anything about how to process them with MA540.
5 1655
by  JeremyJump to last post
05/12/2017 9:33 AM
3 Replies and 465 Views Sub Account vs Activities  465  3 Started by  Eddee We are looking for the best way to report and track projects in our general ledger account for CIP. We are considering using either activities or subaccounts. Does anyone have any advice as to which would be the best option Does anyone have any general advice for using subaccounts Pros and cons Thanks, ED
3 465
by  JeremyJump to last post
05/03/2017 1:22 PM
8 Replies and 5216 Views Activate account for all accounting units  5216  8 Started by  Paul I have a group of pre-existing accounts that are active in some accounting units and inactive in other accounting units.&160; I want to make these accounts active for all accounting units.&160; I have tried using GL 100 (Mass Chart Acct Change Delete) and GL 121 (Mass Account Addition).&160; Does anyone know how to do this
8 5216
by  Mark F. HardyJump to last post
03/31/2017 3:15 PM
0 Replies and 329 Views Error while submitting Jobs in infor lawson  329  0 Started by  roogi Hello All, Am facing an error while submitting jobs in INFOR Lawson... Here is the Error message....Can any one please help me out to fix this... JobSubmitter:handleError():Job Submit Failed, check your parameters. Details: com.lawson.ios.common.impl.CGIResponseException: JobSubmitter:handleError():Job Submit Failed, check your parameters. at com.lawson.ios.jobs.job.impl.JobSubmitter.handleError(JobSubmitter.java:308) at com.lawson.ios.jobs.job.impl.JobSubmitter.submitJob(Job...
0 329
03/28/2017 3:17 AM
2 Replies and 487 Views PO135 - AC  487  2 Started by  rhorn01 Currently when we run PO135, it doesn't appear that the POs that are coded to Activities (construction projects & fund accounting) are hitting AC. They are hitting the GL, causing a difference between the GL & AC. What is best practice - to leave these as reconciling items between AC & GL or load these POs into AC We have only been live with Lawson a short time so any input is appreciated. Thanks!
2 487
by  JonAJump to last post
03/16/2017 1:03 PM
2 Replies and 350 Views Descriptions from CB Upload Template into GL  350  2 Started by  rhorn01 We use a CB deposit upload template to record various deposits throughout the organization. We use the description field of the upload to describe what the deposit relates to & load that into CB. However, once we post those transactions into the GL, the detailed description from the template does not show; rather, the JE is a 'summarized transaction' or 'misc GL deposit'. Is there a way to have these detailed descriptions to come over to the GL
2 350
by  rhorn01Jump to last post
03/15/2017 3:21 PM
3 Replies and 578 Views Cerner Millennium - Lawson GL  578  3 Started by  JasonP Hi, any customers out there that use Cerner Millennium to Lawson GL s3
3 578
by  Keith AnetsbergerJump to last post
03/03/2017 2:36 PM
4 Replies and 1224 Views Raiser’s Edge Fund Raising Software  1224  4 Started by  Deleted User Hi everybody, Has anyone integrated Lawson with Raiser’s Edge Fund Raising Software If so, in which Lawson modules are you interfacing Raiser’s Edge Fund Raising Software transactions Thanks for reading my post! Joanna
4 1224
by  SWilkinsJump to last post
03/02/2017 3:48 PM
1 Replies and 382 Views MSCM Par counting Report-blank  382  1 Started by  bernfc10 My MSCM screen is not working. I can log on but cannot see my reports in Par Counting. Two other users have reported the same problem. It's not happening to every user, which is so weird. I put a ticket with Lawson but they don't seem to know what is causing this issue.
1 382
by  JonAJump to last post
02/09/2017 8:21 AM
3 Replies and 483 Views add one-time vendor  483  3 Started by  Russell Spreeman We have a person who keys in patient refunds to our Lawson system. She needs to be able to create one-time vendors for this (as the patient becomes a vendor). However we don't want the person to have the ability to go into the Vendor screens and just add new vendors. Is there a way to allow for adding one-time vendors only We are on Applications v 9.0.1.9 and LAUA security at this point.
3 483
by  MattBJump to last post
02/03/2017 12:55 PM
1 Replies and 373 Views GLTRANSREL  373  1 Started by  bernfc10 Does anybody know if the GLTRANSREL table/layout was changed in Lawson 10
1 373
by  alexrsJump to last post
02/02/2017 10:24 AM
2 Replies and 454 Views PO copy to requestor  454  2 Started by  HurricaneRax Is there a way to automatically send a copy of a PO to the requestor on record Is that something that can be built in This would be in addition to sending out to vendor via EDI, Fax/Email, etc that is already populated on the PO. Thanks.
2 454
by  JimYJump to last post
01/31/2017 6:13 AM
2 Replies and 419 Views EDI 10.0.5.8  419  2 Started by  bernfc10 We are planning to upgrade from Lawson 9 to Lawson 10 and also upgrade EDI to the latest version. I have the release notes and EDI net change report and so far I only see changes to the POEDI data layout. Could somebody let me know if they encountered issues or if they know of other changes Thanks
2 419
by  BasiaJump to last post
01/27/2017 12:57 PM
2 Replies and 872 Views CB Mass Reconciliation upload template  872  2 Started by  harold_c Hi, I am trying to create a CB reconciliation upload using form CB80 for the mass reconciliation I am currently doing via CB185, but encounters errors after the 1st line is successfully uploaded, and cannot figure out why, error is: This form action valid on open transactions only (_f51r0). Does anybody have a template/process they would like to share How do you do your reconciliation Thanks.
2 872
by  harold_cJump to last post
01/23/2017 12:30 PM
2 Replies and 967 Views AP out of balance due to data error.  967  2 Started by  dorota34 Our AP has been out of balance with GL since 2013. I was able to identify old invoices back from 2013 that are matched , paid and journalized however they are not being picked up by AP reconciliation report. The problem is caused by mismatch between APINVOICE and APDISTRIB table. OBJ_id in AP Invoice table does not equal to api_obj_id in APDISTRIBUTION. All other tables ( match, gl etc) are correct ( they match Ap distribution table). I am assuming user somehow was able to delete invoice hea...
2 967
by  dorota34Jump to last post
01/20/2017 8:14 AM
0 Replies and 412 Views GL20 Posting account activation  412  0 Started by  Deleted User Does anyone have an add-in upload that they will share to update GL20 posting accounts I thought one of the conversion programs allows you to mass add accounting unit account posting combinations. Is that GL167 Any input will be appreciated.
0 412
01/17/2017 5:32 PM
1 Replies and 438 Views Intercompany GL165  438  1 Started by  mcuser Does anyone know how to load a multi-company journal to GL165 that will use Lawson GL25 Intercompany relationships
1 438
by  DeronJump to last post
01/13/2017 4:48 PM
4 Replies and 695 Views MSCM Handhelds selection  695  4 Started by  bernfc10 We are in the process of replacing MC70 HHs and Lawson provided us with a listing of MSCM compatible/supported versions. There are so many and we have short period of time to purchase and test the devices. Would anybody be willing to share their process on selecting devices or suggest what things to look for when selecting a new device
4 695
by  JonAJump to last post
01/11/2017 10:22 AM
0 Replies and 237 Views Company Close Out  237  0 Started by  Boyd In a prior year a Company that was set up in Lawson was sold to a third party. When the assets were sold, we removed the assets from the company and as liabilities were resolved we removed the liabilities from the books of this company. As of 12/31 we were left with only intercompany receivables and equity. Now our tax department wants us to zero out the intercompany receivable balance and equity. Although these accounts have balances they don't zero out. How can we remove these balances wi...
0 237
01/09/2017 3:22 PM
2 Replies and 696 Views Spreadsheet Server  696  2 Started by  Boyd We are installing Spreadsheet Server and I was looking to see if anyone has any tips or tricks for setting it up. We are looking forward to streamlining our monthly financial statement distribution process.
2 696
by  BoydJump to last post
12/21/2016 2:09 PM
0 Replies and 503 Views How to Post Gl65 Transactions with Different Journal Headers  503  0 Started by  emowry We are currently using GL65 and GL165 to post transactions from our revenue system into lawson. The transactions are all imported into GL65 with descriptions but when we post the transactions through GL165 the GLTRANS description only says 'upload'. Is there a way to change this so it maintains the description from the original GL65 entry
0 503
12/14/2016 10:12 AM
1 Replies and 555 Views Who set up customer account?? (AR)  555  1 Started by  jmihall Hi, where can I find who set up customer account. Or who update it etc.
1 555
by  John HenleyJump to last post
12/05/2016 9:17 AM
2 Replies and 632 Views Bank File  632  2 Started by  Bev Edwards Where does the file reside on the Lawson server after the CB185 creates it and before the CB80 uploads it
2 632
by  JimYJump to last post
11/15/2016 5:18 AM
2 Replies and 1089 Views GL20-Accounting Unit/Account Code Combinations  1089  2 Started by  Sami117 We have several accounting units that are mapped to various GL Account codes per GL20.2. We have one accounting unit for balance sheet transactions, but we discovered several income statement accounts with exists as 'yes' on the GL20.2 for the balance sheet unit. We don't want individuals accidently coding transactions improperly so we need to turn the exists from 'yes' to 'no.' We have shut off dynamic account generation to prevent the exists from being turned automatically to 'yes' if someo...
2 1089
by  Sami117Jump to last post
10/27/2016 11:19 AM
0 Replies and 403 Views CB260 calculation  403  0 Started by  IrvinB Im writing a report to have the same results as program CB260 using the CBTRANS , does anybody know how the calculation is for the calc fields, (Acctcurrencyissued-amt3, Void-amt-3, Net-effect-amt-3)
0 403
10/20/2016 7:45 AM
14 Replies and 2077 Views Ma540 sample  2077  14 Started by  Peter Griffen Hi everyone Does anyone have a sample ma540 file that would work for a three way match I'm am having some issues with the match and am having a hard time tracing the problem. Thanks
14 2077
by  Brian VeldhouseJump to last post
10/14/2016 10:06 AM
2 Replies and 655 Views GL165 errors exist  655  2 Started by  bernfc10 I just got a call from a user that runs the GL165 in report mode. We are having a problem with an account where the cost center would not be accepted but it was. It shouldn't allow to post to any accounting unit other than X account. GL165 is not a customized program so where is this validated and is there a Lawson screen that maps these to valid cost centers
2 655
by  bernfc10Jump to last post
10/13/2016 3:41 PM
0 Replies and 488 Views Matched In Summary - Link to PO Lines  488  0 Started by  Jeremy Here's my issue: We are matching in summary so when we post to GL, there's no way to work our way back from a GL transaction to see which PO Lines were combined to make up that transaction. Has anyone been able to find a link through all the various tables (GLTRANS, MAINVDTL, APDISTRIB, etc...) to be able to create a report
0 488
10/13/2016 2:36 PM
0 Replies and 386 Views how we can differentiate Credit card and non credit card payments in AR..?  386  0 Started by  kencha Hello All , Can any one tell me where we can set up '' pay types we set up for Payments and credit card payments '' ..in AR From ARPAYMENT table any ways to identify whether the payment received is from Credit card or non credit card payments If we need to define any pay codes for Credit card payments where we can define them in AR..
0 386
10/13/2016 10:20 AM
0 Replies and 497 Views Attributes for accounts  497  0 Started by  SM Hi, We had a request to add new sub accounts for specific accounts in COA. Instead of adding new sub accounts, we were asked to create attributes for those specific gl accounts. They need these attributes to keep track of items that relate to a particular sub set of data. Ex: they have one cash account but they need attributes to that account so that they can track the data separately for cash reconciliation. Please advise how to accomplish this task and also what reports can I get for ...
0 497
10/08/2016 10:57 AM
0 Replies and 388 Views Attributes for accounts  388  0 Started by  SM Hi, We had a request to add new sub accounts for specific accounts in COA. Instead of adding new sub accounts, we were asked to create attributes for those specific gl accounts. They need these attributes to keep track of items that relate to a particular sub set of data. Ex: they have one cash account but they need attributes to that account so that they can track the data separately for cash reconciliation. Please advise how to accomplish this task and also what reports can I get for ...
0 388
10/08/2016 10:57 AM
0 Replies and 479 Views MA540 Vendor Agreements  479  0 Started by  chadT When entering Vendor Agreement Invoices manually into Lawson, you can add Line distribution detail on MA43.7 (from Ma43.6) by clicking the 'Enable' button. Is there a way to accomplish this through the MA540 interface adding multiple distributions with the same line number is not supported through MA540 so I was wondering if there was another way to override while also still matching against the PO25 Vendor Agreement through MA540. The use case is that there is a Vendor Agreement setup with...
0 479
10/07/2016 12:55 PM
3 Replies and 588 Views GL165 entries  588  3 Started by  bernfc10 How do I get transactions to show in GL after posting transactions in GL165 Is there a batch program my user would need to run
3 588
by  harold_cJump to last post
10/06/2016 10:25 AM
3 Replies and 836 Views 856 Adv Ship notices  836  3 Started by  bernfc10 This morning we got the 856 Adv Ship notices file from GHX and were received in with no errors. However, my users told me that 5 Pos, the back-orders weren't cancelled. I am assuming they are supposed to be cancelled by an automated job GHX has these PO's are partially shipped so some items shipped and the others are back orders. What program should have killed/cancelled these orders Any feedback or suggestions would be greatly appreciated, thanks in advance.
3 836
by  Kat VJump to last post
09/15/2016 9:08 AM
2 Replies and 767 Views GTIN  767  2 Started by  bernfc10 Is anybody already using GTIN If yes, could you please help me determine how these are assigned We are planning to start using GTIN's.
2 767
by  bernfc10Jump to last post
09/13/2016 4:06 PM
2 Replies and 731 Views fill & kill order  731  2 Started by  bernfc10 I noticed we send a PO to GHX on 8/23 that is still in waiting on confirmation status. The user says that it should not be because it was cancelled. It is a fill and kill order. Could someone please enlighten me of what this means Every time I ask this user, she tells me she knows nothing about our batch jobs.
2 731
by  bernfc10Jump to last post
09/12/2016 9:25 AM
4 Replies and 1339 Views How do I create a payment for an invoice without a vendor ID  1339  4 Started by  Celia Morris Obviously we don't want to set up all patients as vendors but that scenario potentially exists. How do others handle this
4 1339
by  Sharri TJump to last post
09/01/2016 6:35 AM
2 Replies and 631 Views Kill/cancel EDI orders  631  2 Started by  bernfc10 We don't have a SME for shipping/receiving so it's hard to understand what jobs need to be changed. I got a call from a user that wants to change a job scheduled in recdef that automatically cancel/kill EDI bulk orders. I asked the user what job they are referring to and she has no idea. Any idea what to look for
2 631
by  JonAJump to last post
08/31/2016 8:19 AM
0 Replies and 367 Views Move RW reports from One PL to another  367  0 Started by  xxxxxttysfh I was able to to upload all the required Files ,but I still do not see reports on RW100
0 367
08/24/2016 1:09 PM
3 Replies and 3416 Views Bank Rec Interface  3416  3 Started by  mcl A Lawson newbie, so be easy, please.&160; Thought easiest interface to tackle would be flat file .txt from bank to Lawson Bank Rec.&160; On LSF9 so I see two options--CB185 flat file&160; and&160; CBSTMTREC database file.&160; Any suggestions&160;&160;&160; With importdb, do I list all fields in header record, comma separated, or just the fields I want to upload&160; Would Add-Ins be a better upload option&160; Thanks
3 3416
by  SYEDJump to last post
08/22/2016 3:22 PM
1 Replies and 897 Views Data Export from Lawson 9.0.1  897  1 Started by  Lawson Beginner We are trying to migrate to a new financial system and hence need to export master and transactional data from Lawson. Can any one help understand the best way to approach this
1 897
by  Lawson BeginnerJump to last post
08/16/2016 1:22 PM
1 Replies and 585 Views AP155-check payments file overwritten  585  1 Started by  bernfc10 My user accidentally rerun AP155 so it overlaid the check file, is there a way she can get recreate the same file
1 585
by  Jimmy ChiuJump to last post
08/03/2016 4:08 PM
3 Replies and 1227 Views Add-Ins Upload to AP20.1 & Need Comments  1227  3 Started by  Kris We are mass uploading invoices to AP20.1 and would like to include Check Comments in the upload to get printed on the Cheques. Has anyone been successful in doing this Found this post, but don't know if anyone has been successful. https://www.lawsonguru.com/forums/financial/s3-financials/ap20-comments/ Any help would be greatly appreciated! Thanks Kris
3 1227
by  KrisJump to last post
07/21/2016 1:30 PM
0 Replies and 351 Views Multiple EFT email recipients  351  0 Started by  Todd Mitchell We are often asked to add more than one e-mail address to receive the EFT payment notifications. I know in the past Lawson has said no. We are getting increased requests and customers are frustrated at the lack of technology and ease of use for the notifications. Has anyone dealt with this situation and/or know of any possible solutions
0 351
07/14/2016 7:10 AM
4 Replies and 850 Views GL165 entries  850  4 Started by  bernfc10 Does anybody knows if there is a Lawson program that can allow me to delete entries from GL165 to prevent double posting the entries There are about 150 transactions in GLTRANSREL.
4 850
by  bernfc10Jump to last post
07/12/2016 10:30 AM
0 Replies and 366 Views GL16.2 adding attributes  366  0 Started by  L G Might be a noob question. How does one add attributes in GL16.2. I mean how to setup attributes and how to navigate to GL16.2 to add them to individual accounts
0 366
07/05/2016 9:29 AM
0 Replies and 580 Views Partial Period Depreciation  580  0 Started by  Ron Swanson Client has iSeries 8.1 Lawson. With a transfer in investors a new company was created. The new company start date is mid period. They want to post Asset Depreciation for the partial period in the old company, and remaining in the new company and keep the Asset files and G/L in sync. Presently the Asset Period Calendar matches the Fiscal Calendar though they do not have to be. Tried changing the Asset Calendar would not let me with assets in place. Any ideas on how to handle this, sho...
0 580
06/16/2016 3:58 PM
5 Replies and 2041 Views Credit Card Processes  2041  5 Started by  toria1248 Hello, I was wondering if anyone had any suggestions on how to import credit card transactions We currently upload every credit card by month separately as a Journal Entry. And the more we grow, the more users receive credit cards and it came up in discussion - how do other companies handle their credit card purchases From what I've seen there's a P-card module We currently don't utilize it. How useful is the module Or does anyone use an external software to track their detail and up...
5 2041
by  facendaaJump to last post
06/01/2016 7:34 AM
2 Replies and 906 Views MHC for check viewing / W2 etc  906  2 Started by  Ronnie I have been with two companies who used MHC for check printing / viewing / w2 etc. Are there any other vendors who work with lawson who also offer the same I have been asked to investigate alternatives, but I have honestly not heard of any others.
2 906
by  KellyJump to last post
05/31/2016 3:07 PM
2 Replies and 822 Views Who owns the MA60 screen?  822  2 Started by  Capital-Key Currently in our Lawson security, AP owns the MA60 screen, but doesn't like to use it. They believe that all invoices should match in AP20 perfectly. However, when they don't, they will not go to MA60 to release the payment unless they are instructed by Supply Chain. Otherwise it sits on our exceptions database in SharePoint. So I asked them why should AP own it if Supply Chain has to tell them when to use it I'm just curious .... Who owns the MA60 screen at your place of business
2 822
by  JimYJump to last post
05/25/2016 11:30 AM
0 Replies and 520 Views Intercompany Payment Transfer  520  0 Started by  Magus ' How to transfer UNASSGINED cash sitting in one company to a customer belongs to differnt company' Can any one please help me on this in detail.. I tried to link companies using GL25 and created a National Account relation using AR12.1 . But while doing Payment transfer using AR29.1 am getting an error like ' TO COMPANY DOES NOT EXIST' Please help me on this.. Thanks
0 520
05/20/2016 1:35 AM
4 Replies and 1121 Views Vendor Payments  1121  4 Started by  brupp Hello - Let's say you have a multiple line PO, & when the invoice is applied, at least 1 line creates a PO cost message. Do you hold payment until the invoice can be paid in its entirety or do you pay on the matched lines per normal terms, then pay the discrepant line(s) at a later time once the cost message is resolved And is either direction dictated by a setting in Lawson Thanks.
4 1121
by  bruppJump to last post
05/17/2016 10:29 AM
6 Replies and 1673 Views PO120 EDI orders  1673  6 Started by  bernfc10 I want to be able to run a multistep job that will create and release POs, create EDI orders and then transmit all these POS at once to GHX. Does anybody know if this is possible or do I need to schedule a PO120 and an ED501 for each vendor PO100 for vendor A and location A and B, vendor B location A, Vendor C location D PO120 same as above ED501 - take all the EDI orders created by PO120 and transmit to GHX
6 1673
by  JonAJump to last post
05/02/2016 7:23 AM
3 Replies and 1036 Views PO Summary  1036  3 Started by  jaherb What is the easiest way to enter the PO and see the overall payments and overall remaining balance (money left on the PO) User is currently using PO64, but thinks there must be a better way Thank you Jim
3 1036
by  jaherbJump to last post
04/28/2016 5:02 PM
2 Replies and 1155 Views How to Kill a Job  1155  2 Started by  pops We are running Lawson 10 and have users who submit jobs & reports. Sometimes a user submits a job/report that runs for over a 1/2 hour. Is there a way in Lawson 10 to kill this job maybe through Print Manager or does it have to be done on the back end (maybe through LID) and what would be the command to do this. Thank you in advance! Allen
2 1155
by  pbelskyJump to last post
04/27/2016 11:59 AM
0 Replies and 516 Views Month end processes in AR..?  516  0 Started by  Magus What are the steps we follow in month end for AR.. i.e End of the month (EOM) processes we do in Accounts receivables to begin a new month as well as to close out previous open months. Please suggest me some of the , • guidelines to create new accounting periods, as well as closing out older accounting periods. • and for proper allocation of payments, and adjustments to the appropriate accounting period. What are the jobs names and steps we need to follow..Please enlighten me on thi...
0 516
04/22/2016 9:36 AM
4 Replies and 910 Views SQL QUERY NODE outputData  910  4 Started by  Magus Hello All, Am using a SQL QUERY NODE to query a table..But, the SQL QUERY NODE _ outputData is blank.. Please anyone guide me to fetch the results of that query and send them to a directory..
4 910
by  MagusJump to last post
04/22/2016 3:31 AM
1 Replies and 912 Views AP175 GLTRANS R_DATE  912  1 Started by  Randy I'm looking at APDISTRIB records and their linked (GLT_OBJ_ID) GLTRANS records. The GLTRANS records have AP / AP175, as the interface. What populates the R_DATE of the GLTRANS I was trying to determine if any distributions hit a prior month after statements were issued. Also most transactions are 'summarized' so I'm getting more detail at the AP level. However I see future (Years away) R_DATE in the GLTRANS record. I'll see GL POSTING_DATE of 2/29/2016 which I expect. But R_DATE anywhere from ...
1 912
by  TracyOJump to last post
04/21/2016 3:20 PM
8 Replies and 1739 Views Essbase 11  1739  8 Started by  brooke We are on 9.0.1.10 and upgrading essbase to 11 - has anyone able to get the lawson api to work with 11 for the IA120 to still work
8 1739
by  brookeJump to last post
04/12/2016 3:22 PM
10 Replies and 4795 Views Lawson Certification of Essbase  4795  10 Started by  Vicki We are finally upgrading Essbase from Version 7 to Version 11 and have been told by Oracle that Lawson has only certified to Essbase version 9.3. We are using Lawson Analytic Architecture to feed our cubes and it is working well for us. Has anyone else using Analytic Architecture upgraded to Essbase Version 11 and if so, are you having any issues Have you ignored the lack of certification
10 4795
by  brookeJump to last post
04/12/2016 3:21 PM
4 Replies and 1235 Views Vendor Status PO Add Inactive  1235  4 Started by  ckmiller Our vendor master controller has inactivated a vendor due to a merger and now invoices coming in electronically are rejecting. I've seen other vendors with a status of PO Add Inactive, which I understand does not allow for new POs and that's all the definition I can find on it. Will this status allow invoices for POs already created to pass through electronically
4 1235
by  JonAJump to last post
03/30/2016 12:44 PM
1 Replies and 902 Views Asset Management using Attributes  902  1 Started by  Sami117 We have to complete several asset surveys each year. The surveys require us to group certain pieces of equipment in categories with ACES codes. These 3 digit codes are used to report out equipment like computers (code 311), Office equipment (312), medical equipment (317). In our old Sage Fixed Assets software we created a category that was required for each asset to be either NA (for building, land, leasehold improvements) or one of the 3 digit codes for moveable, fixed, and software. This w...
1 902
by  Display NameJump to last post
03/25/2016 8:22 AM
1 Replies and 829 Views AP Report  829  1 Started by  Brad Wade Is there an AP report that shows the expense distribution of invoices on a check run This would be similar to the AP150, but with the expense distributions for the invoices as well. We are trying to find the easiest way to track where the expenses posted for each check run in a single report or job. Thanks.
1 829
by  Display NameJump to last post
03/23/2016 9:53 AM
0 Replies and 549 Views CB50 Upload  549  0 Started by  harold_c Hi. I am trying to do CB50 upload for a transaction like this one below: dept A Sales Tax-Feb 500 dept B Sales Tax-Feb 200 Company 1 Sales Tax-Feb 700 When viewing in GL90, what field or fields should I use so that it would show in dept A account description as 'Dept A sales tax Feb', in dept b account description as 'dept b sales tax Feb', and on the corresponding cash account as 'Company 1 Sales Tax Feb' Thanks.
0 549
03/18/2016 11:56 AM
0 Replies and 584 Views Lawson Flat rate tax on certain income codes  584  0 Started by  dkester How do I set up a flat withholding rate for a specific income code If an employee chooses a flat percentage rate on their W-4, how does that impact the calculation on income codes wtih a fixed rate
0 584
03/10/2016 5:12 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 812345 > >>


RSS Feed Available