The requesting locations are housed in the REQUESTER table, but I'm not sure if that is a complete list, since the RQ04's are only set up for buyers.  I have seen one other hospital that needed to set up an RQ04 for every location because of the way their Req Approval process flow was designed, but that was a unique set up.    I do see the RQLOC table, but not sure if any info is housed here at the moment as I do not have access.    Also, what table are the Ship To locations housed

PO placed with vendor; vendor ships for next day; vendor sends 810 that evening, the receiving is not yet done, hence INR. Any thoughts

Hello - I want to delete all of our inactive PO13's but for some Lawson throws Item exists in Ven Agrmt XXXX.  It's a valid edit as items are on hold in PO25.6 but those won't delete with Lawson throwing Cannot delete, orders have been placed against agreement line.  Not sure if this is a valid edit or not.  Yes orders were placed, but all orders (PO Lines) are closed for this vendor.  How can I delete the PO13 in this instance  Do we have a bug  Thanks.

I have been tasked with adding a link (which is the result of a SQL stored procedure from a non-lawson database) to our Requisition tasks. I need to use recsum.htm to render the tasks. I can use a SQL node in the Req IPA to call the stored procedure, however I haven't been able to find a way to pass the resulting link as a parameter to recsum.htm. Does anyone know of a way to do this I suspect the best option is to call the SQL stored procedure from recsum.htm via a custom cgi or .NET script...

Good morning all, I am trying to write a query in Access pulling data from PO64...specifically, the transaction types listed at the bottom of PO64 of either REC, INV and RET. What Lawson table can I find these item types listed Thanks pg

I am not sure if this is an issue with Punchout in general or with our Punchout vendor.  When an item has a description greater than 30 characters, we are receiving comments.  We do not have this issue with RQC on items with descriptions greater than 30 characters.  Has anyone had this issue and how was this resolved

Good morning all, What are people using to calculate the cost to process a purchase order I have the average salary per buyer so far. thanks pg

Years ago we had both a bulk account & a LUM/JIT account with Owens & Minor.  We decided to go away from LUM/JIT in favor of a central inventory location.  We now are working towards being 100 LUM/JIT with Medline system wide.  As a part of the transition we expect to have a need to order some items both in bulk & in JIT temporarily.   My question is - is it possible to order in both bulk & JIT under the same vendor number  We had 2 vendor numbers with O&M so that's the only way we know.  We ...

Our finance department is inquiring about spreading an invoice amount for a PO over twelve months for example, if it's for a contract of twelve months.  They also would like the system to know if it's being paid halfway through the twelve months, to only spread it over the remaining months.  I don't believe this is a possibility within PO20 (or anywhere on the PO side) but I offered to reach out to others to see if there's something we're missing. Does anyone else do a spread of their service c...

Hello everyone, I am trying to create a sql report to get the data for PO and its contract info something like form PO20. I see there are fields from these tables: PURCHORDER, POLINE, MMDIST, REQHEADER, APVENMAST, APPPAYMENT, APPINVOICE, etc. but having difficulties in putting together with a query. Can any one please assist. Thanks in advance for your help!

We've been using Lawson for just over 5 years and our training was abysmal. As we're a small rural hospital we just 'make do' with what we know and move on even if it's clearly not the optimal way to do it. I would like to clean up our PO25 files to reflect only items on contract. One of my many issues with this is that Requisition Center templates will not allow an item to be requested (even if on the template) if it's not also on a PO25 so I'm required to have every item on a template also on ...

It's Policy & Procedure review time for us and the endless stream of 'but how do others do it' is starting! How do you assign roles and what rights do the roles have for Procure to Pay Requisition Approval  Procurement Receiving Accts Payable We currently do:   Requisition Assign Role: Requesters are not really restricted, they create an IT ticket to get rights but we don't limit them per department or any such thing.  Right...

Is there any way to set a maximum order limit when ordering off of a template in Requisition Center (RQC) Additionally, is there a way to rearrange the columns We would like the UOM and Available on the left side of the document.

Anyone using a system to tack rebates other than the contract module or an MS Office app

We've been using Lawson for just over 5 years and our training was abysmal. As we're a small rural hospital we just 'make do' with what we know and move on even if it's clearly not the optimal way to do it. I would like to clean up our PO25 files to reflect only items on contract. One of my many issues with this is that Requisition Center templates will not allow an item to be requested (even if on the template) if it's not also on a PO25 so I'm required to have every item on a template also on ...

Does anyone currently run a report to see who approved requisitions for the month And if so, please share! We are on V10 and use IPA for approvals.

Is there a way to locate the field length for any field on any Lawson form I'm looking specifically for the Vendor name in PO25.6, however it would be helpful if there was a way to find the length of any field on any form.

We have non-stock items that have never been ordered since we transitioned to Lawson 5 years ago.  They still want to keep the info going to EPIC through the clinical bridge so I need to find a way to hide these items from showing in RQC without inactivating in IC11.  Any ideas

We want to create new PO25.6 agreements with new Vendor Agreement Ref fields that will replace the ones currently in place.    In order to do so, I believe the items on existing open PO's will need to be closed, prior to inactivating the PO25.6 agreements we no longer want to reference.     I have a couple of questions.  1. When a requester creates an order (RQC or RQ10) is the Vendor name pulled from the PO25 Vendor Agreement Ref field 2. What would be the best way to close out any open ...

The HCPCS code looks like it can be loaded as is, but I'm not sure how the UNSPSC codes can be loaded into the individual categories. The field help doesn't show anything for these f4 field of Segment, Class, Family and Commodity. GHX is providing the file from Nuvia that contains the UNSPSC codes. They are 8 digits in length. There is one code that is numeric, but the individual categories have a title. Does anyone have a process they can share on how they load these codes into Lawson

This winter we will be moving from one warehouse location to a new facility, along with having all new bins for the inventory items. So all our IC12 inventory items will need a new bin entered. Currently in order to change bins on inventory items, you use the IC26 screen which brings the amount on hand along with the item when moving to another bin. Does anyone know or have experience with moving over 1,000 items I would like to use the upload function, to put in the new bin, but I want to m...

We are trying to use the PO520 to load vendor POs from an external system.  We have been testing this process in our test environment without any issues.  We moved the process to our production environment and we have an issue with the PO520 running successfully every time.  The PO520 will process some of our files in the production environment but not all files.  We get the following message in the job log when the job goes into Needs Recovery Execution error : file '/lawprd/law/prod90/obj/PO5...

Does anyone out there do a cross reference of vendor tax id's to 'something' to ensure that they are a valid business

I got the message below from someone in our IT. Does this make sense to anyone else Doesn't seem logical that the EDI job would need to be doing a full table scan each time. I'm pretty sure he means the EDHISTRANS table since I can't find the table he mentions. ----------------------- Our you ok with us  purging  the transaction history, it is causing the ED501/ED502 job to run extremely slow. The ED501 should complete in 1 minutes,  but it taking upto 12 minutes.   And we submit the job ov...

Does anyone know how to (or if it is possible) to get the fields you add to the List View through the Choose Columns button to stay as a default