How does the Item Group know which GL chart of accounts to use I have Item Group A.   I have two companies, Co1 and Co2 attached to Group A.  I have two GL charts, Chart1 and Chart2 attached to Co1 and Co2 respectively.   In IC11, I go to add an Issue Account.  The account is in Chart1, but I get the error message 'Account number is not defined in Chart2.'   There is nothing to specify in IC11 which chart to use, only the Item Group.  How does the Item Group kno...

I have a Crystal Report in which I need to include the following information: - Current Base UOM - (Item) Stocked Locally through the Current Distributor - Yes or No Do you know where (table, screen, etc.) I can find this data 

I have a user who ordered 12 items, but only 2 were pulled into a requisition. I checked a few of the items that 'fell off' and they are set up correctly in Lawson and when I try to order them either by Express Order or Template, there are no error messages to be corrected. The items pull into the shopping cart like they should. Has anyone ever seen this happen before

We are looking at getting new handhelds and I was wondering if anyone had any luck (good or bad) with devices that were not on the supported list by Lawson.  We use MSCM for receiving, delivery, picking, par counting and issues. Your thoughts Thanks! Michelle

I need to run a report to compare daily order qty for each item and pull the par levels for each as well. The items for our bulks are ordered via Mobile Supply Chain. I'm not certain of what tables I need for this.

Is the upload process for Safety Stock in IC12 a manual transaction or can it be uploaded by another IC-type form. I know there is IC120 but this is for EOQ - (Which I'm still not too sure how useful that is). Does anyone have experience with inputting values into Safety stock And once this is filled, I believe there is a report I can run to see what is below my safety stock so I can start questioning/reseaching why it's below this point, right Thanks in advance!!

Hi, I am no longer receiving email notifications from postings. I have tried changing my settings, etc. But I still am not receiving notifications, can someone tell me what I need to do to receive them again   Thanks Sheri  

I have several questions about the ICTRANS table: 1) Does the ICTRANS.LOCATION field contain the location in which the stock item is stored 2) Does the ICTRANS.FROM_TO_LOC field contain the location in which a stock item was issued (to) 3) Does the ICTRANS.SOH_QTY field contain an item's stock-on-hand quantity at ICTRANS.LOCATION or at ICTRANS.FROM_TO_LOC Thanks

I have several questions about the requisition tables in Lawson: 1) Does the REQHEADER.ACCT_UNIT field contain the facility that made the request for an item 2) Does the REQHEADER.REQ_LOC field contain the department (within a facility) that made the request for an item 3) Does the REQLINE.FROM_LOCATION field contain the location in which the requested item came from Thanks

How can I get IC527 to pull the lowest unit of measure cost instead of the contract cost Please help!

We spend time deleting Service Line in PO25.7 and then adding Service lines before the Agreement is released. Somes we have an Agreement winding up with Service Lines 1,4,7,9. Our A/P will go crazy if they see a PO25 service agreement with non sequential numbering. Is there a way to resequence PO25 Service Lines without deleting every line and starting all over    

Anyone have any insight on why there would be a variance at month between my IC234 and GL90  What I'm looking for is a way to investigate variances so that we can easily identify mistakes.  We have 14 locations and every month 1 or 2 of them has a fairly significant variance.

I was using add-ins to upload into IC11 using my template from version 10.0.4.0.515 into our new version of 10.0.4.0.629.  I found that numerous F codes are off by two, which leads me to believe that the change in versions have added two additional fields to IC11.  Has anyone else run into this and if so were you able to find what the two new fields are  Thank you.  

I have this user's RQ04 record set up exactly like her co-worker. The co-worker DOES see the Special / Service option under Find / Shop in RQC. Could this be missing for her due to a component in the LSA that may not be set up

I have a user that signs into RQC (shopping). Her cost center is already populated as the default. Her RQ04 is set up with two accounting units since she buys for both areas. The template she is selecting is set up for the cost center that does NOT default in the Requesting location field when she logs in. When she tries to place an order from this template (set up for CC 733), the cost center is defaulting to 100749 instead of 100733. I had her change the requesting location to the c...

In the public sector there are a LOT of change orders to PO20's and PO25.7 Service Agreements. Currently, paperwork is issued for change orders. 90 of the time,the change order is to add or subtract money to a Service line How do others use RQC for change orders Do requesters enter the new dollars, and does the buyers add a new line for the increased funding, do buyers add a new line for the increased funding, then cancel the new line and add or subtract the dollar amount to the exisi...

Does anyone use the PO line delivery date as a means to evaluate vendors We have our inventory items control code set as 'S' (system generated) in IC12. So the system generates the lead time based on the last two PO receipts. But does not take into account weekends / holidays. Does anyone do anything different

Should an IC12 be set up for every location that orders a specific item

We pick our surgical case carts from our perpetual inventory location.  We currently 'return' unused items to inventory using a negative issue on IC21. Has anyone successfully implemented handhelds and barcode scanning for this process Notes: - Lawson version 9.0.1 - Items are issued via an interface from our OR info system and manually for add-on cases. Thanks.

Hi Everyone! I was wondering if anyone is aware of a location where I could find the table schemas for a handful of Lawson 9.0 tables I was referencing the Data Dictionary under the TECH tab here, but was wondering if there was a SQL schema somewhere to ensure I am capturing the right columns, data types, and constraints properly.  PS. I currently do not have direct access to the Lawson DB, so I'm relying heavily on the documentation and forums to gain an understanding. Thanks! :-) JME...

Hi Everyone, I was wondering if anyone would know how to obtain Contract/Agreement pricing information on Items in Lawson I have a client that I need to pull back Agreement/Contract pricing information per PO. I was directed to look at the PO25 (view ) but cant seem to find any documentation, such as fields and supporting overlying tables associated. I did see a FRContractMaster table, but this does not hold all the information I desire.   Thanks in advance! :-)

Hello - Is anyone tracking issues in Lawson for items for Ebola preparedness, & if so, how are you doing this  For example, a nitrile glove has been selected should the need arise, but it is already a stock item.  How can we pinpoint an issue solely for Ebola My thought was to use requesting locations, but not sure if that's the best way to go or not. We are going to use a special GL on our Purchase Orders. Thanks, Beth

What does it mean when you try to release a po and get a message that the cost center is no included in account generation list

I have created a Crystal Report which has a column that contains the POLINE.REC_QTY field.  The report has two parameters (Start and End date based on POLINE.REC_ACT_DATE) for a date range.  At the end of the report, I total the POLINE.REC_QTY column.  The users of the report are comparing the Crystal Report’s POLINE.REC_QTY total to the “Location Totals Receipt” total at the end of IC220 (IC220.prt Report Viewer) in Lawson.  They are running the IC220 rep...

Trying to add my location in IC02 per my IT direction, however when I try to add it, I'm being asked for a value to be placed in the Returns Suspense field on the Returns tab. None of the other bulk cart locations in IC02 have values in these fields, so I'm not sure how to get it added. Bev