In Location History, What Does the Asterisk Symbol Beside the Month Mean?

In Location History, What Does the Asterisk Symbol Beside the Month Mean?

Release: 5/28/2020
Version: 8.2 & up

Q - In Stock Status Inquiry, when you drill down to Location History, I see an "*" asterisk symbol beside the current and future months.  What does that mean?  Especially, in the following example, I notice the usage in the current month is 3. But the actual usage is only 3.  The total at YTD should be 24 if we add up the usage from Jan to May. See sample screen below:


A - This behavior is related to the Global Setup -> Cop-Ctl -> Stock Status Inquiry:
    12. Show ATP Data When Drill Down to Loc History?
See sample screen below:

If you have this flag set to "N," then the usage in May will become 2, which is the data stored in the IMLOCHST table. The purpose of this flag is to show the projected usage in the future based on ATP. If you look at the ATP of this item, it will show there’s one outstanding COP order that has not shipped for the month of May. It seems to be a back order. See sample screen below:
This ATP back order is counted as the May usage. This flag is valuable for people who have long shipping cycles with their customers. They can see the projected quantity that will be used in the future months. On the other hand, the YTD total does not count future projections. So the 23 is based on a quantity of 2 in May. The actual usage in May is 2 so far, not 3.

The “*” asterisk symbol beside the month of May (the current month) and future months signals that the usage data contains future ATP usage data.

On the other hand, if you turn off the corresponding Global Setup flag, you will see the "*" asterisk symbol beside current and future months disappear. In this case, the month of May usage will show 2, instead of 3.  See sample screen below:

Generally speaking, if you have long cycles of shipments and back orders, seeing future projections by month can be very valuable. If not, you can consider turning off this flag.


EMK


    • Related Articles

    • What Does the Asterisk Mean in A/R Account Inquiry?

      Release Date: 7/24/17 Q - On the Accounts Receivable Customer Account Summary screen, what do the asterisks mean next to the "I" in the type field? Some open invoices have the * and others do not. A - The asterisk means there’s a payment pending to ...

    • Feature - UDR Sales History Salesman Analysis by Year/Month/Customer

      Release Date: 07/18/2024 Version: 8.6 & Up Three new Report Desk reports are added in the following path: COP -> Processing -> Sales History Trx Processing -> Report -> Edit List: CPHstedt.B.6.1.0 UDR Sales History Salesman Analysis By Year/Cust ...

    • Procedure to Correct Bad Serial Number with Special Symbol

      Q - From time to time, either due to the bar code label or the bar code scanner, we get a bad scan of the serial number as we receive it. Since the receiving staff usually does not look at the serial number, they scan it in. So the problem does not ...

    • What Information Is Stored in the Location History (IMLOCHST) Table?

      Release Date: 11/27/2017 Many users have noticed the existence of the IMLOCHST (I/M Location History) table and would like to know what information is stored there and how to access it. This document is an attempt to explain what information is ...

    • IMGENMNU Inventory Management Generate Location History

      Generate Location History Application Overview This process will generate history records for all items for each location. Run Instructions From Inventory Menu à Util-Setup à Generate Location History à Generate This will prompt you for a starting ...