I am new to Lawson and have been tasked to write an SQL that lists shipments with other data.  Not knowing much about Lawson this is what I've come up with;  SELECT WHS.DBWHS_SHIPMENT_NBR ,WHS.DBWHS_DOC_NBR ,WHS.DBWHS_VENDOR ,WHS.DBWHS_CARRIER ,COR.DBCOR_ORDER_NBR ,COR.DBCOR_ORDER_TYPE ,WHL.DBWHL_DESCRIPTION ---,' ' AS sggroup ---,' ' AS sold_to-pt ,COR.DBCOR_CUST_PO_NBR ---, ' ' as fol-doc ,WHS.DBWHS_BOL_NBR ,WHS.DBWHS_WEIGHT ,WHS.DBWHS_CARTONS ,WHS.DBWHS_SHIP_DATE ,WHS.DBW...

Hi,   We have different stock zones that want to control the release of pick lists independently.  Ideally, they would get separate deliveries created.  I found in the dispatch policy where you can print separate pick lists by stock zone or warehouse equipment but tested the setting and it did not make any difference.  We could probably make this work thru stream serve but we really want separate deliveries not just separate paperwork.  We want to release in one area for pre-picking well befor...

Hi,   We have different stock zones that want to control the release of pick lists independently.  Ideally, they would get separate deliveries created.  I found in the dispatch policy where you can print separate pick lists by stock zone or warehouse equipment but tested the setting and it did not make any difference.  We could probably make this work thru stream serve but we really want separate deliveries not just separate paperwork.  We want to release in one area for pre-picking well befor...

Hello group! This is my first post!    I am trying to run the List API for MMS060 to see lot inventory. This could work for me as I can see how many rows there are, which will tell me how many we have in the warehouse. Problem I am having (running the API in Google Chrome) It is only returning a max of 99 rows.  Question is, how can I get ALL rows not just 99.    Thanks guys!

Hi there,   If we delete a Manufacturing order which is for our stocking policy and then run MRP through material plans the date assigned to the new manufacturing order is in the past, how do we overcome this give a realistic date in the future. Thanks   Paul

Can anyone help me to get an Inventory Aging Report Thanks

Hello, I have a problem with phantom items.  No matter in which place I add them in BoM they resequence all of it when order is released. I need a way to stop it. It would be nice if anyone could guide me how to do it or where I could find the answer. Or maybe it is not possible at all.

What is the best way to report material usage on a MO line after the line is auto closed due to reporting more than reserved using PMS060   Thanks!

Hi, Does anyone know the settings that link to MWS450PF We are trying to get this to print the put away rather than CRS676PF. Also looking for more information on Printer Files in general, is there other places to look in for settings other than MNS204/205 Any suggestions would be very helpful. Regards

Hi Anybody know if it is possible to get the back order estimated arrival date to update automatically when the item's planned arrival date (mms200) it updated Thanks

Is there any way to make material changes to a MO proposal without releasing the MO We want to only release MO's for 2 weeks in advance but need to change materials on proposals, especially long lead time items.

Dear all, I would like to have the ERD of our M3 PROD system. I've seen a post regarding the datadict files created by schemaspy. I need something similar for M3. We do have modifications (extension tables as well as completely new tables) that are in another scheme. Same for the Field Audit trail files, These are in another scheme as well. Can schemespy help me out making the 'ERD' Anyone with experience in this Best Regards, rwgrietveld

Hi, I'm trying to use MHS850MI to create RO's for an interface. Since this only returns a message number it's hard to add lines for the created RO. If anyone has come across with a scenario, creating DO/RO and add lines to the same using MHS850MI pls help me on this. Else if any other alternative method is used for the same scenario you're welcome to comment. Many thanks,

I am trying to write a Lawson web service to create a product variant but I keep getting the message '[FND0078] BCI Error: Option must be entered (WOP0702)', code: 2,002'. This web service is using PDS060/A-E with PDS600/E as a related process, I am providing the following six fields to PDS600: W01OPT through W06OPT. Could you tell me if it is possible to write such web service or if there is something I am missing or better way. I don't know if PDS600/E could be considered an scrollable window...

Hi All, We need to generate a claim for subcontracted reject returnts using PPS390. But we are unable to do that since subcontract inventories are not indicated in MWS060. they are virual inventory. Is there setting that we should use or is there a different solution. Regards,

Hi, We have a scenario in our solution where Dispatch qty needs to define with a - tolerance limit. Currently we have facilitate this by defining tolerance level in an attribute, where it get picked up in the dispatch interface for calculations. However this is not working according to the expected level due to the complex logics we have to build on that. Would like to know whether there’s anything in standard M3 we can use for this requirement. regds,

We're having a problem in order entry.  Whenever a delivery method is changed in the order header it calculates an additonal discount.  Has anyone ran into this before

Hi, I'm currently assign on a project to configure M3 10.1. This is basically a migration from M3 12.4 to M3 10.1. Since my experience is limited in the domain, I'm looking for any input on what to consider when doing the configuration in 10.1 as its previous version. All ideas are welcome. Thnx in advance.

SPLITTING a kit, status for Kit Item a moves to 99 but for Kit item b moves to 79 why

just wanted to know if any one is using M3 companion newer version Currently I'm refering M3 Companion 3.0 for M3 BE V13. Pls let me know. Thanks in Advance.

Hi All, Hope u all are doing well..!! We've found out that there's no controll over stock levels when entering customer order returns in OIS390. As an example, let's say if we have delivered a qty. of 1000units against a customer order 'X' & received a customer return of 100units. But using OIS390 you can repeat entering the qty.'s as much as you can. It never controlls customer order return against the qty. of 1000 units.. Thus increasing the on-hand balance/allocatable qty in MWS060. Jus...

Hi all, In our M3 some of the DO line items, the status is stuck at 69 though the DO has been completely received and stock has been transferred.Also when check both delivery status and picking list status, it shows 90 for both. Just wanted to know whether this is something to do with the configuration Currently what we're doing is rec Any ideas on this are welcome.   Thnx for reading, GP

Hello: Am new to Lawson and unfortuantely we are being trained by our own staff who has limited knowledge. of the ins and outs of Lawson. We are learning by getting in there and trying basically.  We are implementing M3 Smart Client and am looking for a basic info document on canvas shorcuts, the F help keys and  other shift F... shortucts, shortcuts for moving through panels and the like. Any help would be so beneficial. I have printed the M3 companion manual from navigator but is doesn't hav...

In M3 we've copied the 'live production' environment to create a test environment for end users. However we found out that Panel versions, Inquiry Types/Sorting options cannot copy from the live environment to test environment. Therefore currently we're doing it manually in test environment. Just wanted to know is there a way in M3, copying the exact Panel versions, Inquiry Types/Sorting options from the live environment.. All the suggestions are welcome. Many Thanks in Advance..!!

We just implemented M3. Our price lists are set up in OIS017 and our quantity breaks are set up as a related function in OIS018/B1.  Does anyone know how we can export our price list with the quantity break pricing  We can export OIS017, but it only shows the base price. Any and all suggestions are appreciated!