I run PO191 to get a list of deleted purchase orders.  However, I do not have a way to look at history of PO numbers that are deleted.  I need to see what items were on the PO that was deleted. How can I view detail about a deleted PO  How can I see the PO lines and the source (in DrillAround)

Hello - We are currently testing RQC (not sure which version but we are about to install 10.0.6.0) & v10 (currently 10.0.5.0 but may also go to .6).  We entered some procedure info in RQC but I cannot see it in PO20.  Is there a company setting or something I need to flip first  Thanks.

When I select XML options within (Mass purchase order issue) Lawson PO120, it will generate a (date time stamp). PO file which includes issues purchase orders in an XML format.  At the top of that file, it has the reference: Needless to say, I'm looking for that .DTD file since it will tell me the definition of the XML file so that I can read it correctly.  I have already entered a support ticket, but no luck yet. Any ideas

Does anyone know what tables are associated with the header comments in IC11  I've found the tables for the detail comments but not for the header comments.

Does anyone have a process to auto-distribute the PO122 report by buyer  I'd like the ackxxxxxxxx reports to be emailed as pdf attachments to the buyer based on the buyer code on the report.

Hey All,  We're running into an interesting problem and I'm only involved on the periphery and the issue is certainly on the Cerner side. Hopefully some of you have encountered this and could help me out. Here's the rundown:   We have an item that we buy and transact in the UOM of EA. The price of this item is X. This data is sent over to Cerner via an interface that our host created and it's querying the IC11 and PO25.6 records every night. The problem is the item in question is re...

I have been racking my brain trying to figure out what tables would be best to query so that I can report on all X, N, and I type items that our organization purchased last year using one of our medical supply accounts. The problem I run into is that if I pull from the POLINE table, I'm not able to see the inventory purchases because our inventory orders all go through a balance sheet account. I can look at REQLINE, but our leadership says that they aren't comfortable using those figures because...

We use Requisition center to replenish an off-site facility. (NURSING HOME 2)  The nursing portion of the template was extremely huge and cumbersome.  We were able to make smaller templates in PO15 using the one location.  We used 'where' the item was stocked to create the sub categories.  (ie-wound care, oxygen, briefs)  This really helps with pulling the items.  We can put all of one sub location into one box.  This also helps when t...

We use PO25 to maintain our contracts. Our vendors are consolidated into one master vendor number per tax ID number. Vendors like Stryker, Bard, Medtronic, etc who have assigned different accounts to us for each of their divisions are then broken into Purchase Froms (pfroms). So that we can order the correct item from the right division, I have our PO25 contracts setup to tie items to vendor AND pfroms (when it matters) for divisions. This worked fine until our Surgicenter (which has different ...

Does anyone know how to obtain Approver historical information. Specifically, if there is anywhere I can find an old req and who the approver was. The point being if an Approver approved a very large dollar requisition.   I use MS addins. But I have some coding ability (even though I never coded in Lawson).

Does anyone know why when there's an item in the item master that it puts the hospital number / lawson number in the the vendor catalog number field in po20 I used to think it was if a number has more than one catalog number associated with it ie if you added another catalog number to the same hospital number by simply putting the old one on hold. But now it just seems kind of random to me when it does it.

Have read through the guru threads on Stockless, but they're older and don't address a significant issue when using stockless purchasing. Stockless COULD be an amazing solution to manage what we call LUM (Lowest Unit of Measure) or generally JIT (Just In Time) stocking arrangements. Most PAR locations are replenished directly from the vendor, using totes delivered directly to the point of use without intermediary receiving/handling. These process through Lawson as NonStock orders (or should) -...

I'm looking for a way to track changes in average cost by creating a custom SQL report.  I'm not seeing that it's hitting the audit table which is where I was hoping to pull these changes from.  I really just need to identify when the average cost changes significantly.  Am I missing it somewhere

We went live with Prodigo Marketplace and are starting to set up Prodigo Xchange.  Does anyone have any tips on this setup

Anyone else finding any interesting ones   There's one to change the login page to a downtime page. We point the shortcuts on our Citrix and intranet to a down page but users with bookmarks get in before the gates are open all the time.  I'd really love a way to get the MSCM devices to display a 'GET OUT' message.   We're trying to load the new D status.  Apparently it doesn't extend to MSCM!   The eternal cry to make replacement item realize that matching ...

Has anyone set up a non Lawson vendor on punchout.  If so what are the steps do so with the vendor

We are revamping our Capital process & want to determine a better way to handle shipments to the dock.  Today the clerks struggle with aligning the packing slips with the PO & do not know what to receive.  Also, we want to keep the PO line(s) open until everything is received, but quantities are not always clear at the point of PO issue.  Does anyone have a good process & PO practice in place they'd be willing to share  Is anyone using Receiving Self Service to p...

  We want to set up some nonstock items that have two different buy uom, so item 'A' can be purchased by a CA/100 for one requesting location, and can be purchased by a EA/1 for a different requesting location. Does anyone have this set up, and is it working well or are there some work arounds/issues with it   Thanks!  

Our supply chain department wants to separate shipments from our main distributor into 'stock' and 'non-stock' pallets to ease delivery and put-away.  We have two ship-to locations, therefore the distributor provided one new additional account for each ship-to location.  We are fully integrated with this supplier via EDI/GHX (850, 855, 856, 810). We are struggling with how to route orders for non-stocked items to these new accounts, yet retain the same 2 original ship-to locations.&nb...

We are trying to set up punchout for a vendor who performs desktop delivery.  As part of the cXML they receive the have requested that the requesters' name be part of the data in with the PO.  This will help them to ensure packages are delivered correctly. We anticipate sending over 3 cXML files a day to the vendor that contains multiple PO's.   We were trying to use the POSR setting to pass the requester, requesting location and requisition number.  After much trial and...

I have a Crystal Report that lists monthly usage for the year for inventory tracked locations. The problem I am having is I would like to pull the max usage month into an additional column. My row has the following data in columns; Item, Description, MO1 Usage, MO2 Usage etc. Does anyone have any insight into any Crystal or SQL Function that will pull the max month data Thanks, Jeff Nelson

Hi All- Typically if you have freight charges against inventory - they come in as invoice AOCs and cause a cost adjustment - so the inventory cost reflects the total cost to bring in the item. But we use Optifreight so AP isn't matching to the PO - it's not the same vendor number for one thing - so the AP transaction shows on the balance sheet at month end (and throws it off from the IC234) and the inventory isn't getting any cost adjustments. Are we missing something  Is there a way to...

Hello.  We have an finance audit underway that requires us to identify the invoices for all medical supply purchases that are received into our gl inventory accounts.  Our invoices post to the PO accrual accounts and the postings to the inventory accounts are po receipts.  MM280 shows the inventory account but not the invoice number.  Or shows the invoice number to the PO accrual account.  What is the best way to get the invoices for the inventory accounts

Hello, we are trying to add Service POs with a handling code of SER to our upload to Lawson via the MA540 file.  No matter what we do, we have our line type being set as X for lines coming in from our MA540.  Any info out there on how to get these into the system as S Item Types or what is needed to pass in the file to do so  Thanks in advance!

We are running 10.1.8.25 and are experiencing problems with our 'Inventory Issue Delivery Tickets' that are printed from the handheld device action.  The problem occurs when an order is placed for a value greater than the stock on hand.  The initial delivery ticket that is printed shows two line items - one for the amount of inventory available and another for the amount that is not available.  There is nothing on the delivery ticket to indicate to the person making the delivery ...