Using the Future Ledger

Use the Future Ledger to view the inventory forecasts for a product within a selected branch.

The ledger lists all the branch's transactions affecting the product's availability and calculates inventory projections based on the ship dates and status of existing orders. It forecasts open and future purchase orders by considering normal order cycle and lead time for the product line, as well as the last time a line buy was made.

Use the ledger's inventory forecasts to decide how to commit inventory. From the ledger, you can drill down into orders to change order status, procure inventory for the order, or make stock available for another order.

For example, if you need product to fill an immediate order, you can take the product from other future orders that you viewed in the ledger.

About Authorization

Users are restricted to viewing only that information for which they are authorized by branch. If users are not authorized, the system masks the data with asterisks (***). Users must be assigned and S or T status to view branches that are outside their home branch assignments. Check the authorizations setup in the User Accessible Branches from User Maintenance.

Click here to view the possible masked fields .

To use the Future Ledger:

Position your cursor on the product for which to view inventory status and select the Future Ledger menu option from one of the following to display the Product Future Ledger window:

A product window
An inquiry menu - Navigate to the Future Ledger window, then select Orders > Inquiries > Inventory Inquiry. Then from the Inquiry menu, select Future Ledger.

In the Product Future Ledger window, the product you selected displays in the Product Description field.

Review or change the following fields, as needed:

Important: For Stock, Tagged, and Quantities information, the system uses the Branch and Show Only filters that you choose and totals the data for each of those categories. Each table may show data totals from multiple branches.

Branch - Branch for which to view the status of your inventory. You can select more than one branch or territory.
Show Only - Type of transactions to view in the ledger. To view all transactions, enter All.
Note: When you select more than one branch for inquiry, you cannot use the Priority filter.

Review the following product availability information for the product at the selected branch:

Field	Description
On Hand	Total amount on hand both in stock and tagged to orders.
Committed	Total amount committed to sales or transfer orders both in stock and tagged to orders.
On P/O	Total amount being purchased both in stock and tagged to orders.
In Transfer	Total amount being transferred from other branches both in stock and tagged to orders.
On Work Order	Total amount scheduled for work order processing both in stock and tagged to orders.

Review additional stock commitments for the product at the selected branch:

Field	Description
On Bid	Total amount included on bids.
In Review	Total amount that has been or is going to be returned as defective or over-shipments, that has been separated for review, and that is included in a direct shipment.
In Process	Total amount being picked or received
Net Commitments	Total amount committed on transactions in a multi-branch network if the displayed branch is a parent-branch.

Review the ledger listing:

Column	Description
Order Number	Transactions on which the product exists. Use the File > View Order menu option to view the order.
Status	Transaction's order status.
Date	Date of the transaction.
Type	Product location quantity type code for the product on the transaction.
In	Amount of the item coming into the branch on the transaction.
Out	Amount of the item leaving the branch on the transaction.
Available	Amount available for the product once the transaction occurs.
Branch	Branch number for order. There may be more than one branch in this column depending on the inquiry parameters.
Customer/Vendor	Customer or vendor associated with the transaction.
Customer P/O	Customer P/O number assigned to the transaction.

Exit the window.

More Options from the Product Future Ledger Window

The Product Future Ledger window also offers these options:

To...	Select this menu option...
view changes made to the product's maintenance record	File > Maintenance Log The Maintenance Log Viewing window displays.
view warehouse locations for the product	Inquiry > Location Maintenance The Product Location Maintenance window displays.
view product availability and other inventory information	Inquiry > Inventory Inquiry The Inventory Inquiry window displays.
view the transaction history of the product	Inquiry > History Ledger The Inventory History Ledger window displays.
save the settings in the Branch and Show Only fields to view future information for the same combination the next time you access the Product Future Ledger window	File > Save Settings You can also click the Save icon below the window's menu bar.