Inventory Planning

frederick89
frederick89 Member Posts: 10
in NAV Three Tier
Dear All,

Good Afternoon. When i run Planning Worksheet/Requisition Worksheet, system will consider each Location Inventory and Settings (SKU) and propose the Quantity to Purchase/Produce.

Currently i got 1 scenario:

Nav: Nav 2013
Inventory in Location Blue: 1000
Inventory in Location Red: 0
Outstanding Purchase Order in Red: 2000

Red Location actually act as my Goods Receiving Location before go into QC Location. Blue Location is after QC to store the Raw Materials/Components.
Red -> QC -> Blue

In SKU Settings-Replenishment:
Both Location i set as below:
Reordering Policy: Maximum
Reorder Point: 2500
Maximum Inventory 3000

When i run Planning Worksheet, system will check by Location and propose me to purchase:
1. Blue: 2000 quantity to purchase.
2. Red: 3000 quantity to purchase.

In actual, my company level total projected inventory will be 3000 (1000 on hand + 2000 outstanding PO), thus my planner actually NO NEED to purchase but based on settings, it will ask my planner to purchase for Blue and Red.

Did Nav got any settings or methods can solve my problem?


Thank You.


Best Regards,

Frederick

Best Answer

Answers

  • allenyyzhou
    allenyyzhou Member Posts: 142
    Hi

    I had a similar requirement from my client, and what I did is:
    1.Do not set SKU master, just set replenishment parameter in Item card.
    2.When calculate in requisition worksheet, create a SKU as Temporary record to use.
    3.Add a setup like "Location Filter"="Blue|Red", all locations set here will be consider as one location.
    (call SETFILTER("Location Filter", XXXSetup."Location Filter" before calculate Demand and Supply);

    Not sure if this is the best way, at least this works for me.

Categories