|
|
|
|
|
0 Replies and 2428 Views
How to tie DBWHWHS to DBBLCOR 2428 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 |
2428 |
11/20/2021 2:58 PM |
|
0 Replies and 4084 Views
Seperate Deliveries by Stock Zone M3 4084 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 |
4084 |
9/5/2017 2:08 PM |
|
0 Replies and 2629 Views
Seperate Deliveries by Stock Zone M3 2629 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 |
2629 |
9/5/2017 2:08 PM |
|
0 Replies and 2764 Views
MMS060MI only 99 rows 2764 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 |
2764 |
2/13/2017 7:38 PM |
|
0 Replies and 3738 Views
Manufacturing Order - Rescheduling Dates 3738 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 |
3738 |
10/19/2015 9:35 AM |
|
0 Replies and 3503 Views
Inventory Aging Report 3503 0
Started by Ramesh1
Can anyone help me to get an Inventory Aging Report
Thanks
|
|
|
|
0 |
3503 |
4/2/2015 4:32 PM |
|
0 Replies and 2986 Views
manufacturing order auto re-sequencing 2986 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 |
2986 |
1/16/2015 8:25 AM |
|
0 Replies and 3758 Views
PMS060 3758 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 |
3758 |
8/18/2014 6:44 PM |
|
1 Replies and 49850 Views
Printer Files 49850 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 |
49850 |
by JanS 7/5/2013 11:34 PM |
|
0 Replies and 3311 Views
Back Orders estimated arival date 3311 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 |
3311 |
1/30/2013 12:49 AM |
|
0 Replies and 3576 Views
Change materials on MO proposal 3576 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 |
3576 |
9/6/2012 1:57 PM |
|
1 Replies and 53810 Views
datadict / ERD 53810 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 |
53810 |
by John Henley 8/2/2012 10:42 PM |
|
0 Replies and 5001 Views
MHS850MI - AddDo 5001 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 |
5001 |
5/28/2012 10:14 AM |
|
0 Replies and 5247 Views
M3 Product Variant Configuration PDS060 5247 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 |
5247 |
1/4/2012 9:38 PM |
|
0 Replies and 4526 Views
Generate a claim for subcontracted inventory using PPS390 4526 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 |
4526 |
12/19/2011 9:46 AM |
|
0 Replies and 4083 Views
Sales Tolerenc in M3 4083 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 |
4083 |
11/22/2011 7:08 AM |
|
0 Replies and 5400 Views
Header Discounts OIS300 5400 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 |
5400 |
9/23/2011 12:08 PM |
|
0 Replies and 4018 Views
Migrating from M3v12.4 Java to M310.1 4018 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 |
4018 |
8/7/2011 10:30 AM |
|
0 |
3792 |
6/14/2011 10:15 AM |
|
1 Replies and 49196 Views
M3 Companion 49196 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 |
49196 |
by nancy.brownom9 4/7/2011 10:08 AM |
|
0 Replies and 4566 Views
OIS390 issue 4566 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 |
4566 |
2/3/2011 6:06 AM |
|
0 Replies and 4693 Views
DO line Item Status is Stuck at 69..?? 4693 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 |
4693 |
10/1/2010 4:59 AM |
|
8 Replies and 65753 Views
basic info or manual ** HELP ** 65753 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 |
65753 |
by Jenny Kehr 9/21/2010 11:32 PM |
|
0 Replies and 4236 Views
How to copy Panel versions, Inquiry Types/Sorting options 4236 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 |
4236 |
9/21/2010 3:51 AM |
|
0 Replies and 4859 Views
Price List with Quantity Break Export 4859 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 |
4859 |
9/20/2010 8:07 PM |
|
2 Replies and 49850 Views
View all the programs in M3 49850 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 |
49850 |
by GP 9/14/2010 2:29 AM |
|
0 Replies and 5916 Views
MRP 5916 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 |
5916 |
8/18/2010 1:05 PM |
|
1 |
49596 |
by Arno 7/27/2010 11:02 PM |