Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Manufacturing & Supply Chain

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th January 2008, 19:53
metbaan's Avatar
metbaan metbaan is offline
Member
 
Join Date: Apr 2006
Location: North America
Posts: 30
metbaan is on a distinguished road
Baan: Baan IVc4, SSA LN6.1 - DB: Oracle - OS: Unix
Question MPS generating plan purchase order with qty 1 every day
Baan: Baan IVc4

Hi,

I am never worked with MPS before and am trying to do a basic MPS setup to figure out the process.

I am running MPS for a new part with the following details:

stock-on-hand = 0
saftety stock = 14
lead time = 60 days.
mps period = 1week

The weekly demand for this part is 4

When I run Gen MPS (with gen Planned orders=yes), the process creates a planned order for 18 for the first week(SS+week1 demand). On the following weeks however, instead of creating an order for qty 4 in each week, it creates 4 orders with qty 1 on 4 days of the week. Is there some setting that I am missing? I checked the max order qty on the Item master and this is set to 999999.

Could some one help with this one.

Thanks,

Metbaan
Reply With Quote
Sponsored Links
  #2  
Old 8th January 2008, 13:00
Baan user Baan user is offline
Member
 
Join Date: Sep 2001
Posts: 32
Baan user is on a distinguished road
check min order quantity

I'm not sure which Baan verison you are using, but you should be able to set the minumum order quantity. If this is set to 1, and the order interval is f.e. 0 days, it will create orders for 1 pcs. If you set the min order quantity to 5, MPS will generate a planned order for 20 and another for 5 etc.
Reply With Quote
  #3  
Old 10th January 2008, 20:20
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Behind the scene MPS is bucketless. It divides the forecast into daily, hence you are seeing a MPS order of 1 pcs. You will need to set order interval. But this becomes tricky. It depends upon the day when you generate the MPS. so if you give MPS day of Tue and order intervalof 7 days then 7 days will start from Tue, and so on. But I think you can control this by always giving the week begining day as starting day of generating the MPS.

Arvind Patil
Reply With Quote
  #4  
Old 18th January 2008, 11:33
more_rajiv more_rajiv is offline
Junior Member
 
Join Date: Oct 2007
Location: India - Mumbai
Posts: 13
more_rajiv is on a distinguished road
Baan: BaaN4/Ln 6.1 FP2 - DB: SQL SERVER - OS: WINDOWS 2003
Check for Order Method - If its FOQ and Fix Order qty 1 then it may happen.
Reply With Quote
  #5  
Old 28th January 2008, 17:14
metbaan's Avatar
metbaan metbaan is offline
Member
 
Join Date: Apr 2006
Location: North America
Posts: 30
metbaan is on a distinguished road
Baan: Baan IVc4, SSA LN6.1 - DB: Oracle - OS: Unix
Daily Order porblem solved... but more questions

Hello,

Thanks for all your responses. I used avpatil's suggestion and setup the order interval. That seemed to take care of the daily buckets issues.

I have another issue though.

I am runing MPS for a part that has the following info:

Inv on Hand: 30 (27 in nettable, 3 in non-nettable warehouse)
Safety Stock : 18
Min/Max Order Qty : 32
Demand Forecast of 2 per week

No Sales or Purchase Orders pending.

When I run MPS for the above part, I see a "scheduled receipt" of qty 28 in the first week. Also, there is a Planned Purchase Order of 28 generated along with this. I looked everywhere to see where the qty from 28 is coming from, but have no clue. Could someone shed some light.

I am attaching the MPS session screenprint as well.

Thanks,

Metbaan
Attached Images
File Type: jpg mps_issue.JPG (66.7 KB, 27 views)
Reply With Quote
  #6  
Old 28th January 2008, 18:08
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Hi,
Here is the reason for Order of 28.
Your Demand forecast is for 2 per week. I am not sure if you have any backward forecats consumption, but it seems that you have one quantity left from the forecast and since your nettable warehouse inventoy is 27, so 27 + 1 = 28. Though you mnetioned min qty of 32, so system should have generated 32, but the logic for 28 is as mentioned. Try to generate the MPS with always giving the begining of week date, in that way system will always consider the full forecast for the week.

Arvind
Reply With Quote
  #7  
Old 28th January 2008, 20:54
metbaan's Avatar
metbaan metbaan is offline
Member
 
Join Date: Apr 2006
Location: North America
Posts: 30
metbaan is on a distinguished road
Baan: Baan IVc4, SSA LN6.1 - DB: Oracle - OS: Unix
further clarification

no, there is no prior forecast (i.e forecast before current week). Each time we load the demand forecast, we delete forecast prior to current week. Also, i have other parts with the same problem for e.g.

Part with

Safety Stock = 24
min/multiple order qty = 32
inv on hand = 74 (68 in nettable, 6 in non-nettable)

this generates a first bucket of 48 (and a plan order qty of 48).

as you can see, in this case, the qty in the first bucket is less than the on hand qty. And it's only a problem with the first bucket. Everything else seems to be just fine.

Do you have any suggestions? Could it be orders in past that are not delivered completely (for whatever reason)?

Any help would be great. And unfortunately, we do not have source code, else I'd have put it in debug and gone the tedious route to figure it out.

Thanks,
Reply With Quote
  #8  
Old 29th January 2008, 17:43
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
As I mentioned in my previous example of 32 pcs. Try to generate with the MPS generation date of begining of the week. I can see how 28 can be arrived?

What is the forecast for your second example?

Arvind
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating purchase advice for PRP for “suppliers always with delay” Chufos Manufacturing & Supply Chain 1 10th December 2007 23:21
Planning Method releated to plan purchase order baan_ghai Manufacturing & Supply Chain 2 10th January 2006 01:23
Payment term at Purchase Order teddybear Distribution, Transportation & Warehousing 0 20th September 2005 07:10
Subcontracting Purchase Order LittleJohn Manufacturing & Supply Chain 3 30th May 2005 05:01
purchase order activity skipped rcitra Distribution, Transportation & Warehousing 8 21st February 2005 02:30


All times are GMT +2. The time now is 11:08.


©2001-2017 - Baanboard.com - Baanforums.com