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 1319 Views How to tie DBWHWHS to DBBLCOR  1319  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 1319
11/20/2021 9:58 AM
0 Replies and 2808 Views Seperate Deliveries by Stock Zone M3  2808  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 2808
09/05/2017 10:08 AM
0 Replies and 1778 Views Seperate Deliveries by Stock Zone M3  1778  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 1778
09/05/2017 10:08 AM
0 Replies and 2047 Views MMS060MI only 99 rows  2047  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 2047
02/13/2017 2:38 PM
0 Replies and 2976 Views Manufacturing Order - Rescheduling Dates  2976  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 2976
10/19/2015 5:35 AM
0 Replies and 2901 Views Inventory Aging Report  2901  0 Started by  Ramesh1 Can anyone help me to get an Inventory Aging Report Thanks
0 2901
04/02/2015 12:32 PM
0 Replies and 2365 Views manufacturing order auto re-sequencing  2365  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 2365
01/16/2015 3:25 AM
0 Replies and 2980 Views PMS060  2980  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 2980
08/18/2014 2:44 PM
1 Replies and 24397 Views Printer Files  24397  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 24397
by  JanSJump to last post
07/05/2013 7:34 PM
0 Replies and 2835 Views Back Orders estimated arival date  2835  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 2835
01/29/2013 7:49 PM
0 Replies and 3071 Views Change materials on MO proposal  3071  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 3071
09/06/2012 9:57 AM
1 Replies and 26773 Views datadict / ERD  26773  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 26773
by  John HenleyJump to last post
08/02/2012 6:42 PM
0 Replies and 4304 Views MHS850MI - AddDo  4304  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 4304
05/28/2012 6:14 AM
0 Replies and 4582 Views M3 Product Variant Configuration PDS060  4582  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 4582
01/04/2012 4:38 PM
0 Replies and 3948 Views Generate a claim for subcontracted inventory using PPS390  3948  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 3948
12/19/2011 4:46 AM
0 Replies and 3440 Views Sales Tolerenc in M3  3440  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 3440
11/22/2011 2:08 AM
0 Replies and 4696 Views Header Discounts OIS300  4696  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 4696
09/23/2011 8:08 AM
0 Replies and 3473 Views Migrating from M3v12.4 Java to M310.1  3473  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 3473
08/07/2011 6:30 AM
0 Replies and 3263 Views SPLITTING a kit, status for Kit Item a moves to 99 but for Kit item b moves to 79 why?  3263  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 3263
06/14/2011 6:15 AM
1 Replies and 28099 Views M3 Companion  28099  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 28099
by  nancy.brownom9Jump to last post
04/07/2011 6:08 AM
0 Replies and 3977 Views OIS390 issue  3977  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 3977
02/03/2011 1:06 AM
0 Replies and 4058 Views DO line Item Status is Stuck at 69..??  4058  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 4058
10/01/2010 12:59 AM
8 Replies and 38608 Views basic info or manual ** HELP **  38608  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 38608
by  Jenny KehrJump to last post
09/21/2010 7:32 PM
0 Replies and 3609 Views How to copy Panel versions, Inquiry Types/Sorting options  3609  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 3609
09/20/2010 11:51 PM
0 Replies and 4167 Views Price List with Quantity Break Export  4167  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 4167
09/20/2010 4:07 PM
2 Replies and 24584 Views View all the programs in M3  24584  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 24584
by  GPJump to last post
09/13/2010 10:29 PM
0 Replies and 5021 Views MRP  5021  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 5021
08/18/2010 9:05 AM
1 Replies and 24067 Views Job (Maintenance Contract) Closing Report  24067  1 Started by  amynelson Is there a canned report in M3 that is a Job&160;(Maintenance Contract) Closing report Thanks!
1 24067
by  ArnoJump to last post
07/27/2010 7: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