Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Topics
 Replies
 Views
 Last Post
0 Replies and 1558 Views How to tie DBWHWHS to DBBLCOR  1558  0 Started by  Richard 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&39;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 ---,&39; &39; AS sggroup ---,&39; &39; AS sold_to-pt ,COR.DBCOR_CUST_PO_NBR ---, &39; &39; as fol-doc ,WHS.DBWHS_BOL_NBR ,WHS.DBWHS_WEIGHT ,WHS.DBWHS_C...
0 1558
11/20/2021 2:58 PM
0 Replies and 3083 Views Seperate Deliveries by Stock Zone M3  3083  0 Started by  Brendan   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 on...
0 3083
9/5/2017 2:08 PM
0 Replies and 1962 Views Seperate Deliveries by Stock Zone M3  1962  0 Started by  Brendan   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 on...
0 1962
9/5/2017 2:08 PM
0 Replies and 2201 Views MMS060MI only 99 rows  2201  0 Started by  lilfarlee 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! 
0 2201
2/13/2017 7:38 PM
0 Replies and 3147 Views Manufacturing Order - Rescheduling Dates  3147  0 Started by  Deleted User 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  
0 3147
10/19/2015 9:35 AM
0 Replies and 3031 Views Inventory Aging Report  3031  0 Started by  Ramesh1 Can anyone help me to get an Inventory Aging Report Thanks
0 3031
4/2/2015 4:32 PM
0 Replies and 2471 Views manufacturing order auto re-sequencing  2471  0 Started by  Gediminas 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.
0 2471
1/16/2015 8:25 AM
0 Replies and 3113 Views PMS060  3113  0 Started by  dsarge 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!
0 3113
8/18/2014 6:44 PM
1 Replies and 30144 Views Printer Files  30144  1 Started by  Gill 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
1 30144
by  JanSJump to last post
7/5/2013 11:34 PM
0 Replies and 2939 Views Back Orders estimated arival date  2939  0 Started by  kybab 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
0 2939
1/30/2013 12:49 AM
0 Replies and 3189 Views Change materials on MO proposal  3189  0 Started by  dsarge 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.
0 3189
9/6/2012 1:57 PM
1 Replies and 32910 Views datadict / ERD  32910  1 Started by  rwgrietveld 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
1 32910
by  John HenleyJump to last post
8/2/2012 10:42 PM
0 Replies and 4434 Views MHS850MI - AddDo  4434  0 Started by  GP 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,
0 4434
5/28/2012 10:14 AM
0 Replies and 4695 Views M3 Product Variant Configuration PDS060  4695  0 Started by  gastonak I am trying to write a Lawson web service to create a product variant but I keep getting the message '&91;FND0078&93; 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 scro...
0 4695
1/4/2012 9:38 PM
0 Replies and 4071 Views Generate a claim for subcontracted inventory using PPS390  4071  0 Started by  lawsons1986 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,
0 4071
12/19/2011 9:46 AM
0 Replies and 3556 Views Sales Tolerenc in M3  3556  0 Started by  GP 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,
0 3556
11/22/2011 7:08 AM
0 Replies and 4840 Views Header Discounts OIS300  4840  0 Started by  ninajack 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
0 4840
9/23/2011 12:08 PM
0 Replies and 3592 Views Migrating from M3v12.4 Java to M310.1  3592  0 Started by  GP 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.
0 3592
8/7/2011 10:30 AM
0 Replies and 3401 Views SPLITTING a kit, status for Kit Item a moves to 99 but for Kit item b moves to 79 why?  3401  0 Started by  Rashmi Gupta SPLITTING a kit, status for Kit Item a moves to 99 but for Kit item b moves to 79 why
0 3401
6/14/2011 10:15 AM
1 Replies and 32899 Views M3 Companion  32899  1 Started by  GP 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.
1 32899
by  nancy.brownom9Jump to last post
4/7/2011 10:08 AM
0 Replies and 4117 Views OIS390 issue  4117  0 Started by  GP 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. ...
0 4117
2/3/2011 6:06 AM
0 Replies and 4170 Views DO line Item Status is Stuck at 69..??  4170  0 Started by  GP 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. &160; Thnx for reading, GP &160;
0 4170
10/1/2010 4:59 AM
8 Replies and 44737 Views basic info or manual ** HELP **  44737  8 Started by  KATRINA 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. &160;We are implementing M3 Smart Client and am looking for a basic info document on canvas shorcuts, the F help keys and&160; other shift F... shortucts, shortcuts for moving through panels and the like. Any help would be so beneficial. I&160;have printed the M3 companion manual from navigator but...
8 44737
by  Jenny KehrJump to last post
9/21/2010 11:32 PM
0 Replies and 3734 Views How to copy Panel versions, Inquiry Types/Sorting options  3734  0 Started by  GP In M3 we've copied the 'live production' environment to create a test environment for end&160;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&160;a way in M3,&160;copying the exact Panel versions, Inquiry Types/Sorting options from the live environment.. All the suggestions are welcome. Many Thanks in Advan...
0 3734
9/21/2010 3:51 AM
0 Replies and 4309 Views Price List with Quantity Break Export  4309  0 Started by  Amy 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.&160; Does anyone know how we can export our price list with the quantity break pricing&160; We can export OIS017, but it only shows the base price. Any and all suggestions are appreciated!&160;
0 4309
9/20/2010 8:07 PM
2 Replies and 30127 Views View all the programs in M3  30127  2 Started by  GP Hi, I want to know whether there's a program in M3, which shows you all the programs listed in M3 at once. Many Thanks in Advance..!!&160;&160; GP
2 30127
by  GPJump to last post
9/14/2010 2:29 AM
0 Replies and 5226 Views MRP  5226  0 Started by  DougE I am encountering a 'Numeric Error' message when trying to release a planned MRP order...... any idea what might be causing this ....... Thanks.
0 5226
8/18/2010 1:05 PM
1 Replies and 29734 Views Job (Maintenance Contract) Closing Report  29734  1 Started by  amynelson Is there a canned report in M3 that is a Job&160;(Maintenance Contract) Closing report Thanks!
1 29734
by  ArnoJump to last post
7/27/2010 11:02 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.


RSS Feed Available