Dynamics Community Forum Thread Details

Requistion Worksheet - how are values being calculated?

Hi everyone,

Can someone kindly assist in explaining how is the Requistion Worksheet proposing the below quantity with the below item setup, please?

All Item Ledger Entries that make up the inventory of 33 PCS are dated 26/01/2023 - item has never been sold and is not on any sales document.

The requisition worksheet with starting date 01/02/23 and ending date 28/02/2023 suggests to buy 60 with a Due Date 04/02/2023.

I understand that the due date is because of the 3D lead time but I do not get why the system is suggesting 60?

Any help is appreciated.

Thanks in advance.

Categories:

Purchasing

Other

Inventory and warehouse management

I would suggest either of two options (NOT BOTH) to potentially correct the suggestions:

Create a Stockkeeping Unit (SKU) record for the MAIN location with the planning parameters from the Item Card.
Within Manufacturing Setup, in the "Components at Location" field set the value to "MAIN".

If you have multiple Locations (or plan to), use Option 1.

If you have only a single Location (and will for a while), use Option 2.

P.S. In Inventory Setup, check the "Location Mandatory" flag to Yes. This helps avoid receiving Items into a blank Location and is good practice for all companies.

Please let me know if this resolves your planning suggestions.

Best Regards,

Ben Baxter

Accent Software Inc

Quick Links

Leaderboard