Icon

Understanding the Part Availability Finkelstein Screen for Inventory Management

Learn how to navigate the Part Availability Finkelstein screen to manage inventory levels, view stock availability, and handle customer orders efficiently.

By FML FINKELSTEIN METALS

In this guide, we'll learn how to navigate the Part Availability Finkelstein screen. This tool helps us track inventory levels and availability on specific dates, considering purchase orders and incoming goods against open customer orders. We'll explore how this screen supports various stages, from quoting to order entry, and how it helps us understand inventory status. Additionally, we'll demonstrate how to use this screen for customer quotes and manage alerts when orders might lead to negative inventory.

Let's get started

Hello everyone. In this guide, we will explain the Part Availability Finkelstein screen. This screen allows us to view our inventory levels and availability on any given date, based on purchase orders and incoming goods, compared to open customer orders we need to ship. First, we will access the screen. The Part Availability Finkelstein screen is integrated into several other screens to help us understand inventory during the quotation stage, when entering order lines, and when we simply want to check stock levels. To demonstrate the screen.

2
we will first access the Products catalog screen and click on Inventory, Part Catalog, and Part Catalog.
3
Click on "Inventory"
Step #3: Click on "Inventory"
4
Click on "Part Catalogue"
Step #4: Click on "Part Catalogue"

5
Click on "Part Catalogue"
Step #5: Click on "Part Catalogue"

We will now enter the 360 diameter three-quarter and check its stock availability.

6
Step #6:
7
Click on "Part Availability Finkelstein" screen.
First, we'll explain all the fields available on this screen.
Step #7: Click on "Part Availability Finkelstein" screen. First, we'll explain all the fields available on this screen.
8
The first field, , Availability Inventory, refers to the current stock available in our Main warehouse.
Step #8: The first field, , Availability Inventory, refers to the current stock available in our Main warehouse.
9
The next field, Transit Warehouse, shows the inventory currently in transit by sea to the Chicago warehouse.
Step #9: The next field, Transit Warehouse, shows the inventory currently in transit by sea to the Chicago warehouse.
10
The Open Sales Order field displays all open customer orders in the system.
Step #10: The Open Sales Order field displays all open customer orders in the system.
11
The Available For Sale field calculates the available stock for sale by subtracting the quantities in Transit Warehouse and Available Inventory from the Open Sales Order.
Step #11: The Available For Sale field calculates the available stock for sale by subtracting the quantities in Transit Warehouse and Available Inventory from the Open Sales Order.
12
The next field again shows the inventory in the Main warehouse.
Step #12: The next field again shows the inventory in the Main warehouse.
13
If we move to the Misc. screen, we'll see three additional fields.
Step #13: If we move to the Misc. screen, we'll see three additional fields.
14
The first, Immediate Availability, shows the stock available for sale today. The formula here is Open Sales Order minus the inventory in the Main warehouse. This helps us see that there is no available stock for sale today in this Part number.
Step #14: The first, Immediate Availability, shows the stock available for sale today. The formula here is Open Sales Order minus the inventory in the Main warehouse. This helps us see that there is no available stock for sale today in this Part number.
15
The next field, Scrap Warehouse Inventory, indicates if there is any rejected stock moved to the scrap warehouse.
Step #15: The next field, Scrap Warehouse Inventory, indicates if there is any rejected stock moved to the scrap warehouse.
16
The MRB Warehouse Inventory field shows stock awaiting quality assurance checks to decide whether to return it to inventory or send it to the scrap warehouse.
Step #16: The MRB Warehouse Inventory field shows stock awaiting quality assurance checks to decide whether to return it to inventory or send it to the scrap warehouse.

The next screen, Part Availability Details, provides detailed availability for each relevant date in the system.

17
Click on "Part Availability - Details"- The first row shows that the available inventory today is 10,814 pounds.
Step #17: Click on "Part Availability - Details"- The first row shows that the available inventory today is 10,814 pounds.
18
The second row shows a Sales Order movement for customer Great Lakes, with an order quantity of 10,000. Thus, the available balance after this order will be 814 pounds.
Step #18: The second row shows a Sales Order movement for customer Great Lakes, with an order quantity of 10,000. Thus, the available balance after this order will be 814 pounds.
19
The next row shows a Good Receiving Voucher from supplier Halcor in Greece, indicating an expected increase of 14,853 pounds in inventory. Therefore, the balance after receiving the container will be 15,667 pounds, which is 814 from the previous row plus the incoming container. Each row shows the transaction date and the expected balance on that date.
Step #19: The next row shows a Good Receiving Voucher from supplier Halcor in Greece, indicating an expected increase of 14,853 pounds in inventory. Therefore, the balance after receiving the container will be 15,667 pounds, which is 814 from the previous row plus the incoming container. Each row shows the transaction date and the expected balance on that date.

Next, we'll explain how we receive alerts when me making the customer order

20
Click on "Sales Orders"-Click on "Sales"-Enter the Orders screen, click Sales Order
Step #20: Click on "Sales Orders"-Click on "Sales"-Enter the Orders screen, click Sales Order
21
Create a new order for Great Lakes. Go to the Order Items screen
Step #21: Create a new order for Great Lakes. Go to the Order Items screen
22
Enter the relevant Part number. Enter a quantity, for example, 20,000 pounds, and set the date for tomorrow.
Step #22: Enter the relevant Part number. Enter a quantity, for example, 20,000 pounds, and set the date for tomorrow.
23
When attempting to exit the row, the system automatically checks Part Availability Finkelstein to see if another order will go negative due to the current order. We see an alert indicating that the current order has no available stock and is expected to go negative by 3,228 pounds, meaning we cannot fulfill this order on that date.
Step #23: When attempting to exit the row, the system automatically checks Part Availability Finkelstein to see if another order will go negative due to the current order. We see an alert indicating that the current order has no available stock and is expected to go negative by 3,228 pounds, meaning we cannot fulfill this order on that date.
24
If we try a different date, we see that on January 22nd, it is possible to fulfill the order.
The Status field on the right indicates that the material is currently in "Cont. on way". This suggests that the material will arrive before the delivery date set for the customer.
This field will perform the calculation and enter the status automatically in the order line after we have left the line
Step #24:  If we try a different date, we see that on January 22nd, it is possible to fulfill the order.The Status field on the right indicates that the material is currently in "Cont. on way". This suggests that the material will arrive before the delivery date set for the customer.This field will perform the calculation and enter the status automatically in the order line after we have left the line
25
You can go down to the screen "Part Avalibility (Finkelstein)" and see the balance for the specified date
Step #25: You can go down to the screen "Part Avalibility (Finkelstein)"  and see the balance for the specified date
26
Balance "28,856.00"
Step #26: Balance "28,856.00"