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

Anyone have a PO21.3 upload map handy  I'm having issues trying to figure out the HK.   MMD- Component Sequence and AOC Code are particularly head-scratchy to me.

Good Day to all you fine folks!!! Currently, we use IPA to route REQs for approval to one specific user (via one of the index fields in RQ04) simple and effective..   However, we have end users that order for different Labs/Depts that use certain activities (grants) and when the user enters the REQ it goes to just that one person and many times this approver has to forward the approval to a different user/approver because they oversee the activity/grant.   Is anyone in the same situation a...

Are there other options available to users who want to search for items in the item master (to see if they have a number)   Other than granting read only access to IC11, I'm not sure what else can be done.   She is an approver, so she cannot have access to the search catalog because that will grant shopping access.   Are there other options to search for Lawson Item Master items, other than IC11

Hello!   Does anyone know if/where we can change the parameters so that the item description, rather than the item number, shows in the GL accounts after posting through IC130 Thanks!