Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
15%
200 - 500 GB
27%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 33

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th October 2018, 17:02
Adel Sharnouby Adel Sharnouby is offline
Junior Member
 
Join Date: Sep 2016
Posts: 5
Adel Sharnouby is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL - OS: Windows 2012
Infor Planning & Manufacturing
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)

Dear Gentleman

We have INFOR LN 10.5. In Planning Module when we run Generate Order Planning. the planned purchase orders are not totaled in one line for the same item & same date. Same behavior when we transfer order planning from planned purchase orders to purchase orders.

Anybody has an idea to group the above in one line, pls. communicate
Adel
Reply With Quote
  #2  
Old 8th October 2018, 17:47
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,141
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
My first thought is to look at your planning parameters on the item. Make sure you do not have a max order quantity. I know we limit some of our make items, but not most of our purchased items. Just a thought.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #3  
Old 11th October 2018, 11:44
DStroud's Avatar
DStroud DStroud is offline
Senior Member
 
Join Date: Nov 2002
Location: North Carolina
Posts: 114
DStroud is on a distinguished road
Baan: ERP LN - DB: Oracle and SQL - OS: NT and Unix
Look at the item Ordering Data -- Order Interval - Fill in the number of days if, for example, you want to group the requirements per 5 days. In that case you will receive only one order per 5 days, and not per day.
__________________
Doug
Reply With Quote
  #4  
Old 12th October 2018, 22:05
Adel Sharnouby Adel Sharnouby is offline
Junior Member
 
Join Date: Sep 2016
Posts: 5
Adel Sharnouby is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL - OS: Windows 2012
Consolidating of purchase order lines against Item & date

Thank You Mark for your replay
May be max order qty. is part of item ordering not planning

Thank You DStroud for your solution
I understand your solution , but If there is one item has 3 lines have 3 dates withing 5 days, could be consolidated into one line against the earliest date ?
I hope that your solution is to be applicable .
I will try & feed back

Best Regards for All

Adel
Reply With Quote
  #5  
Old 13th October 2018, 00:06
DStroud's Avatar
DStroud DStroud is offline
Senior Member
 
Join Date: Nov 2002
Location: North Carolina
Posts: 114
DStroud is on a distinguished road
Baan: ERP LN - DB: Oracle and SQL - OS: NT and Unix
Yes, based on your order interval planning will group demand into 1 planned order.

Order Interval - The number of workdays or working hours for which all the requirements of a specific item are bundled in one (planned) order, during an order planning run. ERP LN calculates the order interval from the day when the first requirement occurs. Order intervals are used to prevent an excessive number of planned orders in one time period.

• Order Interval is defined in Item-Ordering Data
• Upon generation, EP looks for the date of first demand.
• At the date of first demand, EP groups demand within the order interval.
• Advice is created for the grouped demand.
• EP then looks for the next date of first demand and calculates again.
__________________
Doug
Reply With Quote
  #6  
Old 14th October 2018, 17:44
Adel Sharnouby Adel Sharnouby is offline
Junior Member
 
Join Date: Sep 2016
Posts: 5
Adel Sharnouby is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL - OS: Windows 2012
Grouping of planned production orders & planned purchase orders

Dear DStroud

Thank you my friend for your solution. It is fantastic . It gives me all my needs.
The consolidation is running well during generate order planning & against Item & planned received date.

Also , thank you Mark for his thoughts.

All the best
adel
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
Infor LN 10.3 Manufacturing and Logistic Consultant required for manufacturing compan mitra0611 Jobs and Resumes 0 4th April 2018 09:19
PERSBERICHT: Hiab Manufacturing BV implementeert Infor ERP LN mcroonen Nederlandstalig forum 0 29th January 2007 21:59
Baan touts diagnostic tool to identify manufacturing bottlenecks Flip_J Miscellaneous 1 31st March 2003 23:59
I need a Manufacturing Business Analyst hamidforouzi Jobs and Resumes 1 21st January 2002 00:49


All times are GMT +2. The time now is 03:43.


©2001-2018 - Baanboard.com - Baanforums.com