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 2319 Views How to tie DBWHWHS to DBBLCOR  2319  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 2319
11/20/2021 2:58 PM
0 Replies and 3947 Views Seperate Deliveries by Stock Zone M3  3947  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 3947
9/5/2017 2:08 PM
0 Replies and 2544 Views Seperate Deliveries by Stock Zone M3  2544  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 2544
9/5/2017 2:08 PM
0 Replies and 2693 Views MMS060MI only 99 rows  2693  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 2693
2/13/2017 7:38 PM
0 Replies and 3681 Views Manufacturing Order - Rescheduling Dates  3681  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 3681
10/19/2015 9:35 AM
0 Replies and 3457 Views Inventory Aging Report  3457  0 Started by  Ramesh1 Can anyone help me to get an Inventory Aging Report Thanks
0 3457
4/2/2015 4:32 PM
0 Replies and 2919 Views manufacturing order auto re-sequencing  2919  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 2919
1/16/2015 8:25 AM
0 Replies and 3688 Views PMS060  3688  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 3688
8/18/2014 6:44 PM
1 Replies and 45735 Views Printer Files  45735  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 45735
by  JanSJump to last post
7/5/2013 11:34 PM
0 Replies and 3265 Views Back Orders estimated arival date  3265  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 3265
1/30/2013 12:49 AM
0 Replies and 3527 Views Change materials on MO proposal  3527  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 3527
9/6/2012 1:57 PM
1 Replies and 49505 Views datadict / ERD  49505  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 49505
by  John HenleyJump to last post
8/2/2012 10:42 PM
0 Replies and 4906 Views MHS850MI - AddDo  4906  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 4906
5/28/2012 10:14 AM
0 Replies and 5158 Views M3 Product Variant Configuration PDS060  5158  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 5158
1/4/2012 9:38 PM
0 Replies and 4466 Views Generate a claim for subcontracted inventory using PPS390  4466  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 4466
12/19/2011 9:46 AM
0 Replies and 4008 Views Sales Tolerenc in M3  4008  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 4008
11/22/2011 7:08 AM
0 Replies and 5327 Views Header Discounts OIS300  5327  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 5327
9/23/2011 12:08 PM
0 Replies and 3961 Views Migrating from M3v12.4 Java to M310.1  3961  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 3961
8/7/2011 10:30 AM
0 Replies and 3740 Views SPLITTING a kit, status for Kit Item a moves to 99 but for Kit item b moves to 79 why?  3740  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 3740
6/14/2011 10:15 AM
1 Replies and 45958 Views M3 Companion  45958  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 45958
by  nancy.brownom9Jump to last post
4/7/2011 10:08 AM
0 Replies and 4497 Views OIS390 issue  4497  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 4497
2/3/2011 6:06 AM
0 Replies and 4610 Views DO line Item Status is Stuck at 69..??  4610  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 4610
10/1/2010 4:59 AM
8 Replies and 61458 Views basic info or manual ** HELP **  61458  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 61458
by  Jenny KehrJump to last post
9/21/2010 11:32 PM
0 Replies and 4170 Views How to copy Panel versions, Inquiry Types/Sorting options  4170  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 4170
9/21/2010 3:51 AM
0 Replies and 4775 Views Price List with Quantity Break Export  4775  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 4775
9/20/2010 8:07 PM
2 Replies and 45918 Views View all the programs in M3  45918  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 45918
by  GPJump to last post
9/14/2010 2:29 AM
0 Replies and 5840 Views MRP  5840  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 5840
8/18/2010 1:05 PM
1 Replies and 45391 Views Job (Maintenance Contract) Closing Report  45391  1 Started by  amynelson Is there a canned report in M3 that is a Job&160;(Maintenance Contract) Closing report Thanks!
1 45391
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