I need to run a report to pull in several fields for PO spend. I am familiar with running some reports, but I'm not sure of all the tables these fields are in and not sure how to link them to get all of the data needed.   If anyone has an example or a Crystal report already built they would be willing to share, I would greatly appreciate it! Im not able to attach an example because for some reason, Lawson guru is not allowing me to do so.

One of my distribution guys is requesting that one of our stock items be frozen so that he can find out what the on hand count is. Is it possible to use the IC70 to freeze just one item to get that      

Our system is currently made up of eight hospitals.  Each hospital has their own buyers who purchase all of the products for their facility and all outlying facilities associated with their hospital (at some of the smaller facilities these same people also handle receiving and distribution).  We are developing a new org structure in which the buyers will all move under the system umbrella and instead of purchasing for a facility, they will be assigned a category.  If a buyer is as...

I added a new item to our item master (it's a LUM item). It was ordered automatically via our Omnicell system and the correct cost was pulled. However, when you use the Search option in Requisition Center and try to add the item to the shopping cart, a zero cost is displayed and you get an error upon adding. Is there a way to fix this

Hello, I need to build an Excel query or application that will pull in all Units of Measure and there pricing for all 'active' items. The direct screen that I know I can find this info for 'manually' is PO28. I can't find a report in Lawson that will do this and I have tried to build the query and applicaton from Excel addins myself and have had no luck. expanded description of problem-- If i pull in the item master data, it only will pull in the base cost which is usually the hi...

Is there a Lawson table that correlates to the IC81 I need to dump all of my IC81 info into a spreadsheet to see what common items we have in each location.

We went live with Lawson 01-05-2015 as well going EDI with all our vendors via GHX.  For the last week we would receive the EDI Processing Error emails from Lawson:  Attempting Connection to 'GHX Server IP Address'..  I entered a ticket to support for GHX and they came back saying that my ED02 was possibly incorrect.  Which now leads me to wonder, if the information given by the consultant for our edi setup was correct.  I currently have the following on ED02 in UDF2 '...

I have an agreement showing 'expired' in PO28. When I look in PO25, the agreement is on hold. Is there a way to remove the hold

RQC non stock templates.  I am trying to change an item that was once an inventory item to non-stock. I inactivated the item in IC12 but the requestor now get an error message in RQC, when selecting that item – “the item you selected is not valid based on your requester set up”. How can I set this up without activating the item in IC12 again  I left the From Location blank thinking that would do it.  Still getting error message Any help would be greatly appre...

I have an agreement showing 'expired' in PO28. When I look in PO25, the agreement is on hold. Is there a way to remove the hold

We currently run RQ500 to interface with pyxis so our staff fills from orders from a vendor. We want to experiment to see how it will go if the staff fills from the storeroom instead of ordering from the vendor. We would like to test with 5 pyxis unit locations but no idea how to shut it off so we don't get orders from the vendor. The goal is to stop the process for 5 units on the same floor. Here is our process: • PO100 will create release PO’s for hospital A • PO100 will c...

I have an agreement showing 'expired' in PO28. When I look in PO25, the agreement is on hold. Is there a way to remove the hold

My users want to opt to use GLN so I put a ticket with Lawson so they can provide with with a setup guide. They told me GLNs are setup in IC58 and IC64 manually or IC558 if we have more than a few GLNs. Am I missing something Is anybody using GLN

We use PO code for PO. Based on the PO codes,AP decides which handling code to select. Now our operations want to get rid of PO code. Anyone have input on how to handle this at AP side so they don't have to select a handling code

Has anyone had any experience with the Lawson to PAR Ex interfaces   We are in the beginning process of implementing and have sought out some help with the interfaces.  We are looking for the infaces for RQ500, ICIBCSV and IC 527.   We are being told by one person approximately 60 hours and another 229 hours.  Im at the end user perspective and I'm not getting much help with understanding what it going to take to get these interfaces done.  Any help with a go...

I need to calculate the annual spend by location/department, and wanted to know if I can get the totals from one of the purchase order tables or from one of the requisition tables Which table and field can I use to get the total spend by department Thanks

We receive 810 invoices from some vendows. One vendor sends AOC in Invoice and at the time of PO, AOC amount is not confirmed.It becomes really cumbersome to unreceive line and add AOC at PO lin.Receive line again and then work on M54. Does anybody face the same issueAnyone have input on how to handle this

I need to calculate the annual spend by location/department, and wanted to know if I can get the totals from one of the purchase order tables or from one of the requisition tables Which table and field can I use to get the total spend by department Thanks

Hey everyone,   I have an issue where a buyer put in a PO last week. This week, I had to close an agreement in PO25 that one of the items on the PO was on.    Yesterday, there was an issue with one of the PO lines and the buyer had to make an adjustment. Once she did, she tried to release the PO in order to receive the items but now she's getting an error: 'Cannot release, closed agreement on po line 000001'   I'm at a loss and we can't receive the item and thus cannot...

Anyone accessing GTIN data through one of the data pools listed on the GS1 web site  The information on GTINs on their web site seems to be geared more for manufacturers.  How do do healthcare providers get access to the data pools  Is there a cost

So in an attempt to give our Recieving group a user friendly delivery ticket out of MSCM, we are trying to duplicate the 'LTxxxxxxxxx' barcode that prints on the current document. Just duplicating it as is does not work when trying to retrieve the delivery package in RAD.  Does anyone have any idea on what hidden values are being included in the Lawson barcode that I'm not able to see when I scan their barcode in Word  Any ideas 

We run the RQ500 program every day at about 6:30pm and PO120 for Pyxis orders. Then we run the ED501 to transmit orders via GHX to the vendors. We have the WH130 scheduled to run every 15 minutes and the users have reported the run from 6:00 doesn't print/send a report. I looked in the job log and shows there aren't any data to report. I am clueless as to what could be causing this issue as the users used to get the pick list report about 15 sheets every morning at 6am. Any help would be greatly...

Is there a quick report that can be run to find usage comparable to what is in IC49 to do an analysis for movement based on A,B,C order We are currently running the RQ235 for our warehouse and having to convert the UOMs to eaches and then crosswalk the numbers to what is in the IC49.

Hello, Our warehouse is having a problem with the delivery comments.  When a PO combines with requisitions from several different locations the same comment is showing up on all of the delivery documents creating problems.  Is it possible to have the delivery comments go on the issued line by department  I was told that this was not an option and when the PO100 runs, it will pick up the requisitions for each vendor and only print one delivery comment for one of the requesters.&n...

The Lawson printout of a PO25 Service Agreement through PO229 is causing issues with vendors, and I don't blame them. The print out is confusing and does not look professional. Has anyone customized the PO25 so it look more appealing If so, could you share the look of your re-designed PO25 Service Agreement I am working with a Lawson Partner Vendor, they will redesign the form. Thank you.