|
|
|
|
|
|
8 Replies and 1479 Views
Cost Locked:YES 1479 8
Started by Bev Edwards
I have an item set up in Lawson with the correct pricing, however when the user submitted the order, it went to Owens & Minor with a different price.
When I drilled on the req, I saw the incorrect price that was submitted and there was also a field called Cost Locked:YES.
Is this a field value I can change to prevent this from happening again and on perhaps other items
I'm unable to upload the screen shot.
Bev
|
|
|
|
8 |
1479 |
by Bev Edwards 10/21/2015 4:47 PM |
|
1 Replies and 917 Views
Vaccines and Excise Tax 917 1
Started by Michelle Wetzel
Hi all – looking for some feedback on what you do with your vaccine purchases. Do you include the excise tax on the PO line with the cost of the item to be matched or is it applied separately as an add-on tax by Accounts Payable We have some vaccines being treated one way and some the other way and are looking to standardize into whatever is best practice.
Thanks, Michelle
|
|
|
|
1 |
917 |
by JonA10/20/2015 6:31 AM |
|
2 Replies and 1187 Views
PO223.csv output flip flops 1187 2
Started by Mark
Has anyone noticed on PO223 that columns DD and DE swap places randomly We seem to have them swap every 2-3 months.
|
|
|
|
2 |
1187 |
by Mark10/13/2015 4:48 PM |
|
0 Replies and 775 Views
PO225 Misaligned report rows 775 0
Started by Mark
Is anyone else noticing a misaligned report when running, and exporting, PO225 On my report, all the data drops one row at column CR.
tracts
|
|
|
|
0 |
775 |
10/13/2015 11:38 AM |
|
2 Replies and 978 Views
MSCM - Can it capture info and store to a file? 978 2
Started by Bev Edwards
We are beginning to weigh our linen carts now.
Instead of having staff to manually record the data and then log it into a computer, my director wants to know if we can use the MSCM hand helds and the application capture that data.
He wants to scan bar codes to record numbers for the weight, then scan the bar code on the Mayflower Linen sheet, and then transmit all of the bar code data captured to an electronic file that we would then maintain.
Does anyone use MSCM for that purpose
Is any...
|
|
|
|
2 |
978 |
by JonA10/09/2015 9:44 AM |
|
3 Replies and 1977 Views
IC11 change UOM: Error - Cannot change UOM info; PO interface records exist 1977 3
Started by Johnmac
I am trying to add EA as the lowest UOM in IC11.
I’ve followed these steps:
1. IC11 UOM tab – add EA UOM with all priorities to 2 and click change
2. PO115 – change UOM for CA to EA – run in update mode
3. IC11 main tab – change stock UOM from CA to EA and click change
4. IC11 UOM tab – change conversion factor and click change: error: 'Cannot change UOM info; PO interface records exi...
|
|
|
|
3 |
1977 |
by JonA10/09/2015 8:47 AM |
|
|
2 |
852 |
by Deleted User10/08/2015 1:27 PM |
|
2 Replies and 985 Views
Cost Default Vendor field 985 2
Started by Bev Edwards
When specials are ordered, the user has to fill in the Cost Default Vendor field.
What Lawson table is this field fed to
|
|
|
|
2 |
985 |
by Mike Bernhard10/05/2015 11:07 AM |
|
4 Replies and 901 Views
Cost not populating from Template 901 4
Started by Bev Edwards
I have an item that populates to the Shopping Cart in RQC fine when ordered via Express Order, however, I have a user that is trying to order it from a Template. When she selects the item and adds it to her shopping cart, it will not pull the pricing and produces an error.
Other items on that same template pull the pricing in when selected. Seems to just be a problem with this particular one.
Anyone ever seen that happen before
|
|
|
|
4 |
901 |
by JonA10/01/2015 1:09 PM |
|
12 Replies and 1447 Views
Adjust on hand inventory to negative 1447 12
Started by Johnmac
Hello,
I am cleaning up the RNI report (PO135).
Most of the report consists of inventory items that were received in the system but not actually received from our vendors.
In order to reverse these transactions, I adjust the line in PO33. I am running into situations where the RNI quantity I need to adjust is more than the available on hand quantity. Lawson will not allow me to adjust the on hand quantity to a negative number.
Is there an option to change this rule I want to be able...
|
|
|
|
12 |
1447 |
by JonA09/23/2015 3:21 PM |
|
0 Replies and 811 Views
Inv item showing as nonstock 811 0
Started by pmeckes
We are entering an order in oe10.3 for an inventoried item and the line type is showing as non-stock. When we try to change it to an I, the line type reverts back to non-stock. What could be causing this
|
|
|
|
0 |
811 |
09/22/2015 2:26 PM |
|
0 Replies and 787 Views
Adjust on hand inventory to negative 787 0
Started by Johnmac
Hello,
I am cleaning up the RNI report (PO135).
Most of the report consists of inventory items that were received in the system but not actually received from our vendors.
In order to reverse these transactions, I adjust the line in PO33. I am running into situations where the RNI quantity I need to adjust is more than the available on hand quantity. Lawson will not allow me to adjust the on hand quantity to a negative number.
Is there an option to change this rule I want to be able...
|
|
|
|
0 |
787 |
09/21/2015 9:58 AM |
|
3 Replies and 3608 Views
Cycle counting 3608 3
Started by Mark Pruente
This is the error 'Cannot Adj SOH - QTY is allocated or Picked - Above Rec Not Processed Current Lot/sublot/bin soh'.&160; How to reslove
|
|
|
|
3 |
3608 |
by JonA09/14/2015 2:13 PM |
|
|
1 |
943 |
by Kat V09/03/2015 1:04 PM |
|
|
3 |
809 |
by JonA09/02/2015 8:33 AM |
|
1 Replies and 1014 Views
Inventory Control Training Manaul 1014 1
Started by Brenda
Good Afternoon,
Does anyone have an inventory control training manual they are willing to share
Thank You
|
|
|
|
1 |
1014 |
by Kat V09/01/2015 1:40 PM |
|
5 Replies and 1242 Views
IC140/IC66 Replenishment & MSCM 1242 5
Started by Marisol E
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.
|
|
|
|
5 |
1242 |
by Marisol E08/26/2015 7:52 AM |
|
5 Replies and 3084 Views
IC140/IC66 Replenishment PO worksheet 3084 5
Started by Stephanie
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...
|
|
|
|
5 |
3084 |
by Marisol E08/25/2015 12:36 PM |
|
7 Replies and 2807 Views
PO64 - Open to Match Field 2807 7
Started by ardrao
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
|
|
|
|
7 |
2807 |
by JonA08/13/2015 3:05 PM |
|
2 Replies and 1237 Views
Using MSCM to manage home care/DME inventory 1237 2
Started by JonA
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...
|
|
|
|
2 |
1237 |
by JonA08/13/2015 7:28 AM |
|
1 Replies and 885 Views
Updateable Bar Codes 885 1
Started by SCMaster-jk2
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
|
|
|
|
1 |
885 |
by JonA08/11/2015 4:48 PM |
|
1 Replies and 870 Views
Stock item is out of stock 870 1
Started by SCMaster-jk2
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...
|
|
|
|
1 |
870 |
by David Williams08/11/2015 3:55 PM |
|
8 Replies and 3831 Views
Report for Open PO's by vendor 3831 8
Started by Bev Edwards
Does anyone have a Crystal report or directions on how to run an access query to obtain open PO information by vendor
|
|
|
|
8 |
3831 |
by JonA08/05/2015 7:52 AM |
|
2 Replies and 1094 Views
Stock vs Non Stock 1094 2
Started by ardrao
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
|
|
|
|
2 |
1094 |
by ardrao08/04/2015 7:07 AM |
|
2 Replies and 1281 Views
ICFREEZE Table in SCM 1281 2
Started by Robby
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 ...
|
|
|
|
2 |
1281 |
by Robby07/31/2015 1:46 PM |
|
3 Replies and 1348 Views
3 items in PO25.6 with the same vendor number 1348 3
Started by Bev Edwards
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...
|
|
|
|
3 |
1348 |
by Bev Edwards07/29/2015 12:15 PM |
|
0 Replies and 1317 Views
WH130 1317 0
Started by Alex Shklovsky
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...
|
|
|
|
0 |
1317 |
07/23/2015 2:09 PM |
|
16 Replies and 1282 Views
Contracts - 12 Month Spend 1282 16
Started by Deleted User
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
|
|
|
|
16 |
1282 |
by JonA07/15/2015 11:37 AM |
|
1 Replies and 935 Views
Smart Notifcations for PO25 935 1
Started by lars
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...
|
|
|
|
1 |
935 |
by Sheri07/14/2015 7:45 AM |
|
6 Replies and 1312 Views
Infor MSCM 10 Emulator 1312 6
Started by JonA
Does anyone have an emulator program for MSCM 10 We use the emulator to create training materials for the material handlers. The attached doc shows a screen capture of on older version.
|
|
|
|
6 |
1312 |
by Bev Edwards07/10/2015 9:41 AM |
|
6 Replies and 1574 Views
Managing items in PO13.3 1574 6
Started by Bev Edwards
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...
|
|
|
|
6 |
1574 |
by Kat V07/08/2015 5:25 PM |
|
2 Replies and 2313 Views
Optime Charge Codes - From Lawson or Epic? 2313 2
Started by Kat V
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
|
|
|
|
2 |
2313 |
by Kat V07/08/2015 9:38 AM |
|
13 Replies and 874 Views
Way to indicate additonal work? 874 13
Started by Den
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...
|
|
|
|
13 |
874 |
by Sheri07/08/2015 7:34 AM |
|
6 Replies and 1071 Views
Setting up EDI 810 Transactinos 1071 6
Started by Bev Edwards
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
|
|
|
|
6 |
1071 |
by Bev Edwards07/07/2015 10:59 AM |
|
4 Replies and 1195 Views
Item Audit Trail for Report Builder/Crystal 1195 4
Started by Jason
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...
|
|
|
|
4 |
1195 |
by Stephanie07/06/2015 3:11 PM |
|
3 Replies and 1681 Views
Lawson Carefusion Interface 1681 3
Started by Dennis
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
|
|
|
|
3 |
1681 |
by JonathanF07/06/2015 11:20 AM |
|
1 Replies and 788 Views
Quantites exist in locations. Cannot Change UOM 788 1
Started by SCMaster-jk2
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
|
|
|
|
1 |
788 |
by JonA07/06/2015 6:47 AM |
|
8 Replies and 1438 Views
PO Spend History 1438 8
Started by Bev Edwards
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.
|
|
|
|
8 |
1438 |
by Bev Edwards06/25/2015 2:55 PM |
|
10 Replies and 2078 Views
Mass Contract Status Changes 2078 10
Started by SCMaster-jk2
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
|
|
|
|
10 |
2078 |
by SCMaster-jk206/25/2015 12:15 PM |
|
0 Replies and 1427 Views
PO Spend History 1427 0
Started by Bev Edwards
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.
|
|
|
|
0 |
1427 |
06/25/2015 7:40 AM |
|
10 Replies and 1337 Views
Freezing one specific item 1337 10
Started by Bev Edwards
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
|
|
|
|
10 |
1337 |
by Kat V06/23/2015 3:26 PM |
|
0 Replies and 862 Views
Category Buying - Setting up a new Org Structure 862 0
Started by Jen U
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...
|
|
|
|
0 |
862 |
06/17/2015 3:43 PM |
|
9 Replies and 2010 Views
New Item added - cost not populating in Search 2010 9
Started by Bev Edwards
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
|
|
|
|
9 |
2010 |
by SCMaster-jk206/16/2015 2:42 PM |
|
5 Replies and 2143 Views
Need Help Pulling in UOM pricing in PO28 2143 5
Started by David M
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...
|
|
|
|
5 |
2143 |
by Kat V06/15/2015 1:07 PM |
|
4 Replies and 773 Views
IC81 Information 773 4
Started by Bev Edwards
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.
|
|
|
|
4 |
773 |
by JonA06/09/2015 1:03 PM |
|
5 Replies and 1358 Views
ED02 Setup..What is best practice 1358 5
Started by Patricia Mane
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 '...
|
|
|
|
5 |
1358 |
by Kat V06/09/2015 12:54 PM |
|
1 Replies and 929 Views
PO25 Agreement on hold 929 1
Started by Bev Edwards
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
|
|
|
|
1 |
929 |
by Kat V06/09/2015 9:53 AM |
|
5 Replies and 2017 Views
RQC Non-Stock Template 2017 5
Started by Denise E.J.
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...
|
|
|
|
5 |
2017 |
by Scott Perrier06/08/2015 4:19 PM |
|
2 Replies and 1112 Views
RQC Non-Stock Template 1112 2
Started by Denise E.J.
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...
|
|
|
|
2 |
1112 |
by Denise E.J.06/08/2015 1:01 PM |
|
6 Replies and 1011 Views
PO25 Agreement on hold 1011 6
Started by Bev Edwards
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
|
|
|
|
6 |
1011 |
by Bev Edwards06/05/2015 2:10 PM |
|
2 Replies and 1074 Views
fill pyxis orders from stockroom 1074 2
Started by Chesca
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...
|
|
|
|
2 |
1074 |
by Chesca06/05/2015 12:09 PM |
|
0 Replies and 792 Views
PO25 Agreement on hold 792 0
Started by Bev Edwards
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
|
|
|
|
0 |
792 |
06/05/2015 12:01 PM |
|
2 Replies and 1343 Views
Enabling GLN usage 1343 2
Started by Chesca
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
|
|
|
|
2 |
1343 |
by Chesca06/04/2015 12:15 PM |
|
1 Replies and 900 Views
PO Code on PO 900 1
Started by Deleted User
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
|
|
|
|
1 |
900 |
by JonA06/04/2015 9:51 AM |
|
4 Replies and 1029 Views
Interfaces for Par Ex to Lawson 1029 4
Started by B.Art
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...
|
|
|
|
4 |
1029 |
by B.Art06/04/2015 6:19 AM |
|
4 Replies and 1231 Views
Annual Spend by Requesting Location 1231 4
Started by Deleted User
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
|
|
|
|
4 |
1231 |
by Deleted User06/03/2015 9:06 AM |
|
7 Replies and 1682 Views
AOC error in MA54. 1682 7
Started by Deleted User
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
|
|
|
|
7 |
1682 |
by Deleted User06/02/2015 9:56 AM |
|
4 Replies and 1226 Views
Annual Spend by Requesting Location 1226 4
Started by Deleted User
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
|
|
|
|
4 |
1226 |
by Michelle Wetzel05/29/2015 3:36 PM |
|
9 Replies and 1452 Views
Trouble Receiving Items After PO25 Closed 1452 9
Started by SCMaster-jk2
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...
|
|
|
|
9 |
1452 |
by This_Guy05/29/2015 11:55 AM |
|
0 Replies and 1003 Views
Accessing GTIN data 1003 0
Started by JonA
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
|
|
|
|
0 |
1003 |
05/22/2015 6:47 AM |
|
2 Replies and 2757 Views
Lawson Tracking Barcode- Can it be replicated? 2757 2
Started by CamM
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
|
|
|
|
2 |
2757 |
by longwest05/19/2015 5:11 AM |
|
16 Replies and 2555 Views
WH130 2555 16
Started by Chesca
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...
|
|
|
|
16 |
2555 |
by JonA05/14/2015 12:20 PM |
|
0 Replies and 869 Views
Movement Analysis 869 0
Started by ardrao
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.
|
|
|
|
0 |
869 |
05/13/2015 9:58 PM |
|
4 Replies and 1069 Views
Delivery Comment 1069 4
Started by ardrao
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...
|
|
|
|
4 |
1069 |
by ardrao05/12/2015 8:02 PM |
|
0 Replies and 784 Views
PO25 Service Agreement Print-Out 784 0
Started by lars
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.
|
|
|
|
0 |
784 |
05/12/2015 11:07 AM |
|
8 Replies and 2056 Views
Fill/Kill orders 2056 8
Started by Bev Edwards
We have LUM orders that transmit EDI to Owens & Minor. They are set up as fill/kill orders because O&M doesn't backorder LUM items.
My buyer team informed me on Friday that when/if they get invoiced for a LUM item on a PO where the line is already closed, they have no way of knowing if we received the item (line would be closed when Receiving receives the item in PO30) OR if the order was killed by the Distributor. They are telling me since the amounts are so small, they are ju...
|
|
|
|
8 |
2056 |
by Kat V05/11/2015 4:11 PM |
|
2 Replies and 735 Views
How to handle different UOMs for different vendors? 735 2
Started by SCMaster-jk2
We have a situation where one vendor sells the item as '10EA/BX' and the other vendor sells it as 1 EA (but in this case, the EA is actually just referring to the box). We have decided to switch to the vendor who sells it by the EA but would still like to keep the actual packaging string (10ea/bx).
The problem is, when the PO is put through, the vendor will reject it because they don't recognize the BX UOM. Any ideas
|
|
|
|
2 |
735 |
by SCMaster-jk205/11/2015 11:18 AM |
|
7 Replies and 1167 Views
How to assign a price to items without a contract? 1167 7
Started by SCMaster-jk2
Not all of our items are under a contract which means they show up as '0.00' in RQC or RQ10. This can confuse department level employees because the requisition will give them an error since there's no price.
So far our process has been to have the requestor put in a price of $1 which should signal our buyers to do research on what the actual pricing may be but the requestors still get confused. To limit some of these '$0.00' cost items, we've created fake contracts in PO25 that correspon...
|
|
|
|
7 |
1167 |
by Kat V05/08/2015 1:04 PM |
|
8 Replies and 3375 Views
Dealing with Multiple Vendor Item Numbers 3375 8
Started by SCMaster-jk
Hey everyone,
Long time lurker, first time poster. We're a fairly large health system who just went live with Lawson 10.0 at 3 of our hospitals.
I'll get right into it. Medline has different vendor numbers for the same item depending on the UOM. for example:
IV cath - B-D383335 for the Case
IV cath - B-D383335Z for the Box
We have a single Lawson number for this item and it has multiple PO13s, one for the Z item number and one without (this one...
|
|
|
|
8 |
3375 |
by Kat V05/07/2015 8:34 AM |
|
7 Replies and 2766 Views
Daily Check List for Supply Chain 2766 7
Started by Patricia Mane
Good morning!!
My name is Trish (System Analyst II) and we here at Medical Center Navicent Health are 105 days on Lawson/Infor. I became full time on the project 90 days before go-live, so my main goal at that time was conversion and not learning task (if that makes any sense). We have implemented Supply Chain and Finance with HR/PR in the future. Today I have been tasked with creating Procedures for these two (SC/AP) areas. Before I begin creating,...
|
|
|
|
7 |
2766 |
by Bill Ianni05/01/2015 2:14 PM |
|
4 Replies and 1532 Views
How do I unallocate an item? 1532 4
Started by Bev Edwards
This item is no longer being purchased/used. I was able to use IC24.2 to add 20 of the 21 items on hand, but there is one that is allocated.
Is there a way to unallocated items so that I can get the QOH to zero
|
|
|
|
4 |
1532 |
by Bev Edwards05/01/2015 10:38 AM |
|
1 Replies and 1755 Views
Perpetual inventory to PAR 1755 1
Started by Michelle Wetzel
Both our Sterile Processing and Operating Room inventories are currently perpetual inventories. We struggle with the usual problems of returns to SPD, buttons not being pushed in the Omnicells in OR, etc. Right now, the OR is stocked from either SPD or a vendor depending on an item and SPD is stocked by either our main storeroom or a vendor.
We are starting to investigate moving one or both of these inventories (SPD and/or OR) to PAR locations and I just wondered if anyone had any advice/...
|
|
|
|
1 |
1755 |
by David Williams04/23/2015 1:56 PM |
|
6 Replies and 2133 Views
Handling overshipped quantities 2133 6
Started by Den
Hello Again All
I am looking for some of your best practices when your teams receive too much of something and processing payments/credits. Example: We order 10 EA of item XYZ. The PO says 10 EA of item XYZ. The vendor sends 15 EA of item XYZ.
There is a constant struggle between the Storeroom and our AP team. Referencing the above situation, our Storeroom believes the best practice is to receive the 10 EA of item XYZ and send the remaining 5 EA back to the vendor...
|
|
|
|
6 |
2133 |
by lars04/22/2015 9:23 AM |
|
2 Replies and 1177 Views
Bulk Order Purchase 1177 2
Started by ardrao
We have a particular item that we receive a discount on if we purchase in bulk order. Currently this item is set-up with a Lawson number and the pricing is if it is not purchased in bulk. Is it possible to set this item up with a UOM as bulk or can anyone share their practice with me Currently any bulk orders are requested as a special. Thank you
|
|
|
|
2 |
1177 |
by Scott Perrier04/20/2015 12:53 PM |
|
2 Replies and 1234 Views
Manufacturer Codes: When one vendor acquires another 1234 2
Started by Bev Edwards
LeMaitre acquired Vasutech.
In IC14, we had a manufacturer code of VASC for Vasutech. After the acquisition, the description for VASC in IC14 was changed to LeMaitre.
The pricing had changed as well, but the items were left on a pricing agreement titled Vasutech.
The original vendor code remained (4826), but the description was changed from Vasutech to LeMaitre.
This doesn't seem to be the way it should have been handled and I've found many other similar instances.
Can anyone shar...
|
|
|
|
2 |
1234 |
by Bev Edwards04/14/2015 1:46 PM |
|
4 Replies and 1401 Views
Lawson MSCM login 1401 4
Started by Chesca
Nobody can log in to MSCM, getting an invalid user name/password, any suggestion where I can start looking to troubleshoot this Thanks
|
|
|
|
4 |
1401 |
by Chesca04/03/2015 1:13 PM |
|
6 Replies and 1416 Views
Receiving Best Practices 1416 6
Started by Den
Hi All
We have our process concerning receiving goods from the outside and into Lawson. We also have our process for managing the packing lists from all of the incoming receipts. We are wondering how some of the other Lawson users manage the incoming goods and the paperwork associated with the receipt.
Right now, we enter the incoming info in PO30. Once the PO number is released, we write on the packing list: the receiver number, date and signature. Then, we have ...
|
|
|
|
6 |
1416 |
by Den04/01/2015 1:57 PM |
|
2 Replies and 970 Views
logging in to MSCM 970 2
Started by Mick
We have upgraded to MSCM 10.1.5.2 and after this we are unable to login using the MSCMADMIN.
Any thoughts would be appreciated.
thank you
|
|
|
|
2 |
970 |
by TJ Mann03/30/2015 6:50 AM |
|
2 Replies and 1398 Views
Par Location - IC81 1398 2
Started by ardrao
Hello everyone,
Is it possible to create the same item in IC81 with two different UOMS The WH would like to deliver to certain par locations in boxes and other areas in eaches dues to space constraints. I am not sure how to set this up.
Any assistance is greatly appreciated.
Thank you,
Ardra
|
|
|
|
2 |
1398 |
by ardrao03/25/2015 7:40 PM |
|
3 Replies and 1073 Views
Mass Release Requisitions with Add Ins 1073 3
Started by Jeremy
I was able to add a couple hundred requisitions and lines with add-ins. Now, after reviewing/editing them, I need to mass release them. How can I do this with add-ins Or, another way
I can see the req header status and attempted to change with add ins. I got 'change complete - no lines changed' and since the status on the lines didn't change, the requisition didn't change.
I can't find the req line status using addins so I can change it in order to change the ...
|
|
|
|
3 |
1073 |
by Mike Bernhard03/20/2015 1:18 PM |
|
10 Replies and 1399 Views
Assign Default Vendor When Vendor Not Selected in RQ 1399 10
Started by Jeremy
When we create PO's based on requisitions, if a requester does not select the vendor for an item, but we have the vendor assigned in PO13, is there a way to have the system assign the vendor when the requisitions are brought into the PO module from RQ
|
|
|
|
10 |
1399 |
by Kat V03/19/2015 10:24 AM |
|
0 Replies and 766 Views
Need MA531 Adjustment File Sample 766 0
Started by Amanda Valcik
We are trying to interface receiving adjustments and running into errors upon processing the file. The file layout is apparently incorrect per Infor. We are looking for a sample MA531 adjustment file that works successfully so that our interface/developer can mock the format. Client is on v10. Thanks in advance!
|
|
|
|
0 |
766 |
03/17/2015 10:29 AM |
|
4 Replies and 1208 Views
Crystal Report - Need Vendor for an Item in ITEMMAST 1208 4
Started by Deleted User
I have a Crystal Report in which I am displaying a list of Items from the ITEMMAST table. I need to display the active Vendor (Name and Number) for each Item. I know that the vendors are listed in the APVENMAST table; however, my report is retrieving the wrong Vendor.
The cause of the problem could be the fact that there are multiple contracts for the Item. If this is the case, could I retrieve the correct Vendor by looking at the POVAGRMTLN table and retrieving the co...
|
|
|
|
4 |
1208 |
by Deleted User03/16/2015 8:56 AM |
|
19 Replies and 5042 Views
MSCM Barcode Printer 5042 19
Started by R Phillips
We are looking to start using barcodes on PARs/Inventories with our handhelds and eventually anything else that will help process things quicker. I was frankly shocked when I was sent the supported label printers, Intermec 3400E, Zebra 105SL, Zebra 110xiIIIPlus, Zebra Z4M, not only due to their price, but the Zebra Z4M was taken out of production in 2004 and is no longer supported by Zebra. I am hoping I can get some guidance.
What does everyone else use for barcode printing
...
|
|
|
|
19 |
5042 |
by longwest03/08/2015 10:27 PM |
|
1 Replies and 838 Views
Product code did not populate on PO20 as expected. 838 1
Started by Bev Edwards
We received a LUM order where one of the lines did not pull in the product code.
In PO20, the F212 populated the Lawson Item number instead of the product code. My buyer is telling me the product code needs to go in the F212 field on PO20 so that it displays on the invoice for our Receiving department.
I checked PO25.6, PO13.3, IC12 and IC11 and the correct product code is present.
Does anyone know why/how the Lawson number would get populated in this field instead of the pr...
|
|
|
|
1 |
838 |
by JonA03/03/2015 3:07 PM |
|
3 Replies and 1400 Views
IC44.1 - Associated Report? 1400 3
Started by RobCarignan
I'm searching for a report that shows the 'Current Days Stock On Hand' as displayed in IC44.1. I'm also looking for this field in Lawson Add-ins: Query so I can build a custom report if needed.
Does anyone know if a report exists with this information
Thanks,
Rob Carignan
Mercy Hospital
Portland, Maine
|
|
|
|
3 |
1400 |
by RobCarignan02/26/2015 11:05 AM |
|
3 Replies and 1083 Views
Wrong cost showing in IC12 drill down 1083 3
Started by Bev Edwards
How can I use the IC24 to change the cost information that is showing in the IC12 drill down
|
|
|
|
3 |
1083 |
by JonA02/24/2015 10:33 AM |
|
1 Replies and 1027 Views
Par counting reports 1027 1
Started by Chesca
I am new to MSCM and looking for higher level overview of how MSCM and HH devices work. Is there a Lawson program that takes the orders and upload via HH I run the par counting report to review Par counts.
|
|
|
|
1 |
1027 |
by JonA02/23/2015 1:56 PM |
|
0 Replies and 1121 Views
HCCHRGITEM FILE 1121 0
Started by Chesca
Would anybody know why would the HCCHRGITEM FILE be empty We run program IC527 to interface with OR PICIS and we are having issues with items not having a price/cost = 0 when they should have a cost.
|
|
|
|
0 |
1121 |
02/18/2015 9:21 AM |
|
7 Replies and 1897 Views
Items with no purchase history 1897 7
Started by Bev Edwards
What tables would I use to get a list of all the items we have with no purchase history
|
|
|
|
7 |
1897 |
by Patti D02/13/2015 5:54 PM |
|
0 Replies and 1076 Views
Inventory Catalog Vendors 1076 0
Started by Darren
I'm looking for a vendor who offers catalog solutions to make searching our Lawson inventory easier for the end users. Anything out there
|
|
|
|
0 |
1076 |
02/13/2015 12:49 PM |
|
5 Replies and 1292 Views
Identifying Special Items 1292 5
Started by JonA
When we implemented Lawson 8.0.3, the consultant recommended that we instructed end users to add a to the beginning of the item number for X type items. There was a bug in RSS where if the requester entered an item number that was in the item master on the Special/Service screen the cost and source information from the nonstock item would default. So by putting a in front of the item number we worked around this issue. That bug was fixed quite a while ago but we still use t...
|
|
|
|
5 |
1292 |
by Kat V02/11/2015 9:47 AM |
|
1 Replies and 1211 Views
Change PO13 or PO13.3 Vendor 's 1211 1
Started by DCampbell
I'm trying to change the vendor number for an item to another vendor number without adding a new PO13 record. It keeps telling me to inquire when I change the vendor number, use the 'C' function code and click change at the top of the form. What am I doing wrong because it will not change and I would rather not create another record for this item because there are several that are inactive already
|
|
|
|
1 |
1211 |
by Kat V02/09/2015 3:59 PM |
|
2 Replies and 1669 Views
HCPCS Codes Utilization and Storage 1669 2
Started by John Turpin
Hi,
We are looking into how to best utilize HCPCS codes in our Lawson platform. We are currently not storing this information within Lawson. Is there anyone that is familiar with using and managing these codes in Lawson
Our end goal is to have our supply chain solutions integrate into our clinical and billing applications. Further allowing our end users to have quick access to up-to-date and accurate information that is provided from a single source of truth per say. Certainly let me kn...
|
|
|
|
2 |
1669 |
by Kat V02/09/2015 3:55 PM |
|
2 Replies and 953 Views
Punchout and ESP upgrade 953 2
Started by Chesca
We have punchout in test and Prod. Our unix Admin created a new environment to test and I we are trying to point punchout to the new test environment. Is there a configurations file like rqcconfig.xml or mscm properties file for punchout Where can I find the settings file
|
|
|
|
2 |
953 |
by Scott Perrier02/03/2015 12:53 PM |
|
0 Replies and 643 Views
Closing out a PO25.7 Service Agreement 643 0
Started by lars
I understand the PO25.7 Service Agreements expire with their end date, but that date could easily be change unless the Agreement is closed out.
What is the difference between 'Close Agreement' and 'Close Committment'
Once an Agreement is closed, then I know it cannot be reopend, but not sure if that applies to 'Close Committment'.
Thanks.
|
|
|
|
0 |
643 |
02/02/2015 8:34 AM |
|
3 Replies and 3284 Views
Par count sends from the Handheld 3284 3
Started by Mark Ivankovich
When uploading par counts to the backoffice there is no error dialog box on the handheld device telling you there is a problem. You have to go view the mscm_server.log to see what the error was with the count send. Is this as designed What type of process do you use to resolve par count send/upload errors Thanks!
|
|
|
|
3 |
3284 |
by JonA01/23/2015 12:32 PM |
|
18 Replies and 1988 Views
Agreement Nomenclature 1988 18
Started by Stephanie
Just curious how everyone sets up their agreement files. Do you currently utilize Contract Management Do you have both 'C' and 'T' type agreements set up in PO25.6 for the same item
Before my time they used the company number, spaces and then the vendor code (example: 0100 B0000). This is a mess to read through and makes it difficult for the users when they are inquiring on item information. We are implementing Contract Management ...
|
|
|
|
18 |
1988 |
by lars01/23/2015 11:03 AM |
|
0 Replies and 645 Views
Linen Process 645 0
Started by Brenda
Hello-I was hoping someone could share how you manage linen in your facility. Currently our linen supplier weighs our linen by bin (example 1 bin of blankets = approx. 300). We upload a receipt into IC20 to receive it in; however the receipt is by pieces. We constantely have discrepancies with the quantities. Any suggestions on managing it another way would be greatly appreciated.
Thank You
Brenda
|
|
|
|
0 |
645 |
01/22/2015 12:00 PM |
|
4 Replies and 880 Views
Items not ordering correctly 880 4
Started by Bev Edwards
I have several items (gloves) that were set up some time ago with BX as the lowest UOM, primary buy on a bulk agreement and 1 as the Conversion factor.
Our distributor has made some changes and we can no longer buy BX as a bulk item from them so we needed to add CA to as a bulk item and move BX to a LUM agreement.
Now, when an order is placed via RQC and BX is chosen, (via a template) instead of the BX price (250 pr per box), we're getting and EA price.
How can I change th...
|
|
|
|
4 |
880 |
by John Henley01/22/2015 7:47 AM |