Is there a way to run a report out of Lawson that will capture the number of PO lines on invoices for the last 365 days

Is there a way to run a report out of Lawson that will capture the number of PO lines on invoices for the last 365 days

Good Afternoon,   Does anyone have an inventory control training manual they are willing to share Thank You

Is it possible to perform an IC66 using the handhelds (MSCM) I’m looking to replenish my inventory the same method as Ic66, but with the handheld.

Has anyone utilized the IC140/IC66 PO worksheet process yet  We currently have multiple Warehouse locations that direct replenishment is still being processed in the Purchasing department due to security access direct to PO20 being pulled.  We are also hoping to experiment more with the Ordering Days.  We are hoping to roll out the IC140/IC66 process with them but are interested in hearing any issues that others have experienced, or any documentation if anyone is willing to share...

I was hoping for some help. I am trying to build a PO64 query and am specifically looking for the field for open to match with the amount remaining and am unable to locate it. Any help is greatly appreciated. Thank you, Ardra

Our Home Care/DME business is looking for a better way to manage their inventory.  They currently have a main warehouse, which is just a par location in Lawson, and a number of showrooms and trucks that deliver equipment and supplies to customers/patients.  They use TIMS for equipment rentals. The problem is they don't readily know how much of a particular item they have at each site unless they call the person working at the showroom or driving the truck and ask them to do a count. &n...

Let's say we have an item like syringes which lie on 5 different par locations in Pyxis machines and is a stock item in the warehouse. We print labels for this item for MSCM purposes but what happens when we have a product conversion and we have a new Lawson number to replace it Does this mean we'll have to reprint labels and relabel all the locations where the old item is at  Is there a way to just update the barcode itself to point to a new Lawson number

Hey everyone,   How would I handle a situation like the following:   Item A is a stock item at company XYZ Buyer from XYZ tries to order item but it's out of stock (both direct and through distribution) Item A lies in two IC81 par locations   Which would the buyer do: Order a substitute item as a non-stock and then just deliver the item as normal Order a substitute as a non-stock and transfer that stock into Item A even though it's technically n...

Does anyone have a Crystal report or directions on how to run an access query to obtain open PO information by vendor

Hello all, We have an item that is currently set up as an Inventory item and we would like to make it a non-stock item.  We went into the IC12 and made the staus inactive, inventory tracking N, allow issues N, Bin tracking N, Reorder Document N, and Automatic Purchasing N.  Now when a requester attempts to order this item, we receive an error stating the item is inactive at your From Location.  Can any help or point me in the right direction Thank you, Ardra

I'll let you know up front, I'm new to reporting for Supply Chain, so if this is too easy of a question....don't hold that against me!   The business wants me to create a report (custom, of course!) to highlight the cycle count variances. Apparently, Lawson only tells you 0 (zero) variance if your count is greater than the expected count.   But, here's my question, the data I want is in the ICFREEZE table (fields: FREEZE_QTY & COUNT_QTY). Come to find out, this table is wiped ...

I found one vendor item in PO13.3 attached to 3 different item numbers. I'll explain where I'm at with this now. I did a replace/inactivate in two of the PO13.3 and replaced one item with a vendor number of 'WRONGITEM' and replaced the other with 'WRONGITEM2'. I was then able to place those two items on hold in PO25.6 and add the correct item with the correct vendor number to the PO25.6 agreement. The two item numbers that are wrong are now in the PO25.6 on hold. I'm not able to delete t...

I have wh130 job running for company 20 and trying to set it up to run for another company 60. The only difference in parameters is location & company. Location is defined in IC02 the same way for both companies(Company 20 - location STRM & Company 60- PSTRM).  After first attempt I got this message:'Processing WH130 (Pick List Print) Bad File Status 9 021 On File PIK4-SUMM-FILE' After second attempt it was a different error message:     'Parameter Error: &nbs...

I am creating a Crystal Report in which I am retrieving a list of contracts from the Povagrmthd table.  For each contract, I need to calculate the 12 month spend.  Is the Amt-Ordered field (Povagrmthd) the best field to use in the calculation; or, should I use the Purchase Order tables (Purchorder, Poline) With Povagrmthd as the primary table for the report, what table/field should I use to calculate the 12 month spend for each contract Thanks

Lawson has a field  in PO25 called  'Review Date'. When the vendor agreement is near its expiration date, a notification goes out to the Agreement Administrator. Has anyone else set this up What tool was used Smart Notification  Process Flow Something else Can the notification be sent multiple times Can more than one email address be used for the notification The Lawson IT Group plans to use Smart Notification for this function. Any information wou...

I have 2 vendor items in PO13.3. One was set to default and was the active vendor item showing in PO25.6. I inactivated the active item, then set the other item as the default to activate, however when I check in PO25.6, the item I inactivated is on hold. Is there a way to manage 2 items in PO13.3, so that when you inactivate one, the other one will populate in PO25.6 as the active item I assumed that this action would sort of be the reverse to when you Inactivate and Replace. The replaceme...

We have Epic HB (Billing) and have Optime (OR), Cupid (Cath Lab) and Radiant (Radiology) installed.   We have charge codes built in PC10 as this was the setup in legacy systems.  However, it was recently pointed out to us that this means - we build a code in Epic, send it to Lawson to send it back to Epic (Optime, Cupid and Radiant).   Is anyone else doing this or do the Epic modules see one another

Hi Everyone... Does Lawson support a feature that tells the user when additional work is needed when an item is received with PO30  Example, if item XX is received in PO30, can a window pop up and tell the user this particular item needs additional processing  It does not need to be a pop up window.  Could something have change of color  Any kind of visual cue, to help us remember this item needs to follow more procedures until completed. Additionally, could we do someth...

I have a vendor who is only enabled for 810 transactions. Do I need to add the EDI number into the PO10 record or are just the ED10 and the ED40 records required

Due to changes made in the V10 upgrade we no longer see useful User ID's when we run IC191/IC91. All we get are the first 10 characters of our company name in IC191 and the NT00000*** in IC91. Because of this I have created a simple Report Builder report that mimics the IC191 and then compares the NT number to a cross reference of actual user names maintained by our IT dept. This works very well and gets me exactly what I want with one exception, it will not show when the item was added to the i...

Has anyone successfully interfaced the Lawson item master with the Carefusion item master  The challenge is Carefusion has a 50,000 SKU limit.  Has anyone worked around that limit  If so, what specifically did you do  We are being told that the OR has to have it's on item master.   Dennis

Hi everyone, I'm trying to change the uom for an item but am getting this error. I adjusted out the IC12 locations' stock but I must be missing one somewhere. Does anyone know how I could find out Also, does an item having 'On Order' quantities affect whether or not I can change the UOM

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.

I'm trying to clean up our vendor agreements area and need to put a lot of contracts on hold. I've tried to do this with add-ins but I'm not sure which field to use to put the contract on hold.   I mapped my columns as so:   Group Contract Left Column Check Status _f2,PVH-PROCURE-GROUP _F6,PVH-VEN-AGRMT-REF Left Column Check (H),_f4, PVH-STATUS   When I put 'H' into the status column for 'hold', nothing happens. Can anyone assist