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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th July 2017, 16:34
Jim Cousins Jim Cousins is offline
Junior Member
 
Join Date: Jul 2017
Posts: 4
Jim Cousins is on a distinguished road
Baan: LN6.1 - DB: SQL - OS: Windows
Safety Stock Parameters
Baan: ERP LN 6.1 FP5

How can I stop purchase requisitions specifying dates in the past when the available stock goes below the safety stock parameter
Reply With Quote
  #2  
Old 27th July 2017, 08:14
pillai.ganesh's Avatar
pillai.ganesh pillai.ganesh is offline
Senior Member
 
Join Date: Apr 2011
Location: United Arab Emirates
Posts: 105
pillai.ganesh is on a distinguished road
Baan: ERP LN 6.1 - DB: Oracle, SQL, Informix - OS: Windows
Jim, I understand that you have some Purchase Requisitions which should be ignored by the planning engine.
One way to do that will be to change the Warehouse of all those Purchase Requisitions to a non-planning warehouse.
In session Warehouses (whwmd2500m000) you will find a checkbox "Include in Enterprise Planning”. To exclude a warehouse from the planning process, clear this checkbox.
Hope this information helps!!
Reply With Quote
  #3  
Old 1st August 2017, 10:24
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Hello Jim,

Do you want to restrict the users from giving the dates in the past while creating a Purchase Requisition? Could you elaborate your requirement?
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
Reply With Quote
  #4  
Old 2nd August 2017, 09:45
Jim Cousins Jim Cousins is offline
Junior Member
 
Join Date: Jul 2017
Posts: 4
Jim Cousins is on a distinguished road
Baan: LN6.1 - DB: SQL - OS: Windows
Purchase Requisitions

When a purchase requisition is created for the replenishment of stock which has a safety stock value the requisition date is always in the past.
You are able to convert the purchase requisition to a purchase order with this required date in the past.
We want the purchase requisition to have a realistic date in the future, ideally today's date plus lead time without the buyer having to manually change the date

Thanks.
Reply With Quote
  #5  
Old 3rd August 2017, 08:03
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Hello Jim,

If the objective is to restrict the users from not giving the past date in the purchase requisitions, you can probably put an user exit dll for table tdpur201.

It is currently not possible to have a realistic date for the "Requested Date" field at the requisition line level. However, when you convert the requisition to the order, the buyer can go to the Purchase Order Lines (tdpur4101m000) session - Shipping Tab - Use the "Calculate" button to calculate the Planned Receipt Date of the Order Line. This will consider the Supply Time (Working Days) and updates the date. This is something that can be done without any customizations.

If you would like to achieve the same at the requisition line entry level, you can do it using a simpe UE Script for table (tdpur201)

Hope this helps you. If you still need more details, do not hesitate to reach me out.
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
Reply With Quote
  #6  
Old 4th August 2017, 09:38
Jim Cousins Jim Cousins is offline
Junior Member
 
Join Date: Jul 2017
Posts: 4
Jim Cousins is on a distinguished road
Baan: LN6.1 - DB: SQL - OS: Windows
Purchase Requisitions

Many thanks for the guidance, I will get back to you should I need any further assistance
Reply With Quote
  #7  
Old 11th August 2017, 07:40
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
You're Welcome Jim Cousins...

Have a great day!
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
Reply With Quote
  #8  
Old 11th August 2017, 11:53
Jim Cousins Jim Cousins is offline
Junior Member
 
Join Date: Jul 2017
Posts: 4
Jim Cousins is on a distinguished road
Baan: LN6.1 - DB: SQL - OS: Windows
Planned Order Required Dates In the Past

Having investigated further, we are using the Enterprise Planning Module and it is the planned order that has a required date in the past when trying to replenish safety stock.

Why does the planned order have a date in the past?

Is Option 2 previously suggested an option to correct this issue.
Reply With Quote
  #9  
Old 14th August 2017, 11:50
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Hello Jim,

The option 2 is meant to ignore the Requisitions completely from the Enterprise Planning. I believe that is not your intention.

Enterprise Planning (MRP Engine) is a Backward Planning Engine, so you might see the dates in the past as well.
__________________
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
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
Safety stock not considered in planning abby13 Manufacturing & Supply Chain 1 16th July 2015 07:45
Safety Stock and Item Order Planning mpolnz Manufacturing & Supply Chain 1 18th April 2012 07:26
safety stock and reorder point calculation helloakshay Distribution, Transportation & Warehousing 0 27th August 2010 14:16
Economic Order Qty Vs. Safety Stock hsaenz Manufacturing & Supply Chain 1 9th October 2007 20:39
Safety stock Henry Cui Manufacturing & Supply Chain 3 29th January 2007 18:05


All times are GMT +2. The time now is 09:59.


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