Anyone have a data dictionary or an ERD for MSCM John: I know you had mentioned looking into it a while back. What's the status of that Thanks, -Greg

Does anyone know how to add a warning message if a user navigates away from an unreleased requisition in RQC

I need to export contract payments including every invoice/purchase order/contract line paid from Lawson. Do you know what tables would I need to get these from POLINE PURCHORDER

We use PO25 and PO20 for our contracts with vendors. I need the find the award amount of each contract. Does anybody know what table/field is the award amount stored in

I need to change the UOM information for an item that is on roughly 15 open PO's.  Its ordered every other week, or so.  The UOM was built incorrectly as just BX 1, when it should be EA 1/BX 6.  It won't let me change the BX to 6 because the item is on several open PO's. I can't wait for the open PO's to clear because there will be future orders at any time.  What is the best practice for correcting this issue  Build a new item

Is buyer's information (not procurement buyers) but actually end users that put in a request stored in Lawson For example, a user from pharmacy order items, can I retrieve her information

Hello, I would like to set up an over shipment tolerance using this field to avoid Buyer Messages (PO52) from being created when an over receipt occurs. I am unsure what to put in here to allow over receipts on PO line quantities. For example: I entered '50.00' in the 'Over Shipment Percentage' field. I then tried to receive in 15 EA on a PO line that orders 10 EA. A Buyer Message (PO52) was created for the line (which should not have happened). Any help is greatly appreciated.

Looking to see how others are producing usage reports.  Specifically through Lawson but if you're doing it another way I'd be interested to see that as well.

We've submitted a PO in V10 Prod during testing and we're getting this error and we're not sure what the fix is.  Not sure where the value 30010 is coming from. The system cannot find the path specified. ERROR: SUBSTITUTION TABLE ENTRY NOT FOUND Using List Name:     GHXAL_O_SHIPTO With a Lawson Value:        200177488-30010 Perhaps POEDI data contained an unexpected value.

We've submitted a PO in V10 Prod during testing and we're getting this error and we're not sure what the fix is.  Not sure where the value 30010 is coming from. The system cannot find the path specified. ERROR: SUBSTITUTION TABLE ENTRY NOT FOUND Using List Name:     GHXAL_O_SHIPTO With a Lawson Value:        200177488-30010 Perhaps POEDI data contained an unexpected value.

Hello - Looking to see if there is a way to limit requesters from ordering x-type/specials with certain account / sub account combinations.  We are on v9 & order via RQ10 or PO20.  Any advice would be greatly appreciated.  Thanks.

Switching Fax Integrator from our Unix platform to Windows. Thus, we need to switch from FTP to a Windows share... Can anyone tell me what path needs to be shared from Windows

We recently switched from non profit to profit and as such we now have to pay sales tax on many of the items we buy, including things we order via EDI. When we run MA540 the sales tax appears in the MA540CSV file which we get (via GHX, all our EDI vendors come through there) but it's not matching. Do we need an entry in the substitution table I don't get any errors saying something didn't match but I don't know where else we would set up to have the sales tax amount on the invoice agree with wh...

I am looking for a reference document or list of all the field names that are in Lawson Contract Manager that can be substituted in a Contract Template for example: 'Name or Supplier.SupplierName'

We sometimes will trade a product in as part of a new purchase and would like the requester to enter the full price of the item we are ordering and a negative value for the trade in, so that the PO will show both items and the correct grand total (which sometimes may be a negative amount) Our requesters use RQC to enter requisitions and our buyer converts POs through PO100.  Our requesters mostly use Service/Special Type Items. Is this something that can be done

Does anyone know of a program that prints the PO Header comments Looking for an example in how Lawson retrieves these comment values. Thank you

Hello - Not a functional question, but hoping to learn from others - When processing a return to vendor, is the PO132 enough for vendors to process the return, or are you sending a printed PO along with the PO132  Understood that there may be exceptions to the norm so looking for the norm.  Thanks.

We are new to Lawson and I have been asked on a PO that I requested for ex 21 units/hours at $220/hour for a total of $4620.  The company this PO was for is invoicing with separate invoices based on how much time staff in their company work on the project.   So and invoice may be for .25 hour for a total of $55 , another invoice for 4.3 hours totaling $946 and so on, but have not invoiced us for the total amount yet.    Our purchasing office is wanting to match these up but says they canno...

Hi, we are looking to use RQC as an ordering system but not create purchase orders or pick tickets. Merely creating the requisition and sending it out to our Pharmacy department in req form, where they will process the order via their own system.   Is anyone doing something similar, where the requisition created is kept in req form, and emailed out   Thanks for any input!

We are a stockless hospital with very small storerooms for backup/emergencies.  Since we went live in 2012, we've had our RQ01's set to Stockless Flag Y because we have a variety of stockless contracts.  This has always worked for us.   Now, from an incident I've had open with Infor since October, they are claiming we need to change our RQ01 stockless flags to N in order for items to process correctly from contracts that are not stockless.  The ONLY items that were not processing were the items...

We have an hourly job that pushes POs to GHX via PO120 and ED501.  Something happened during the 13:45 job to keep the POs from transmitting.  The job log is below.  I have not encountered this before.  Suggestions appreciated.   Step 2: ED501 Started. . . . . .: Wed May 25 13:46:20 2016 Token Command. . . . . .: /lsf/law/law/prod/obj/ED501.gnt Executable Command . . .: /lsf/law/gen/bin/lacobrts lacobrts /lsf/law/law/prod/obj/ED501.gnt prod mmlawson EDI850WE 2 Process ID . . . . . . .: 3060...

Could someone educate me on how to get around this error  We have items already loaded to IC81.1 but when I attempt to upload the update it gives me 'bin sequence already exists'.  Not sure what I'm doing wrong.

We created a new pyxis location and the REQ/orders are being rejected due to Account unit must match one specified for requester. Carefusion thinks is might be a setup issue in Lawson, any suggestions where to look

I have a PO20, with three   lines. PO line 3  'x' for a qty of 3. Two invoices were received for line 3. The quantity on each invoice was for a qty of 1. We now want to reduce the qty on line 3  from a qty of 3 to a qty of 2 allowing the PO falls off the PO135 report. How can I determine which receiver to select for a receiving adjustment There must be a way to determine which rec number can be adjusted. Thank you.       .

We are looking at our processes surrounding matching discrepancies with our vendor purchases.  What we are wondering is if others are using Lawson's chargeback functionality and what your experiences were (good or bad).   Thanks in advance.