How To Apply Null Entries To Inventory Counts

When you enter inventory counts into the system, you can leave the count for a line item blank to create a null entry. Null entries can indicate one of the following:

Null entries come up throughout various physical inventory programs, such as the Count Variance Report. Decide which of the above definitions you want to use for null entries, and apply this definition consistently throughout the physical inventory programs for a single count.

The Effect of Count Dates on Null Entries

How you enter count dates effect how the system processes null entries, whether you lock the count date or manually enter the count date. Review the following table to see the effect of count dates on null entries.

Note: The system does not populate a count date on the Physical Count Load-In window for null entries, even if you lock the count date.

If the Count Date is...

And in the Cnt Date field you...

Then other physical inventory programs consider null entries as...

Locked

Do not enter a count date

  • Zero quantities when the Nulls=0 (Y/N) field is set to Y.

  • No count entries when the Nulls=0 (Y/N) field is set to N.

The system uses the locked count date as the count date.

Locked

Enter a count date

  • Zero quantities when the Nulls=0 (Y/N) field is set to Y.

  • No count entries when the Nulls=0 (Y/N) field is set to N.

The system uses the count date you entered as the count date.

Manually entered

Do not enter a count date

No count entries regardless of the Nulls=0 (Y/N) field setting.

The system does not use a count date for null entries.

Manually entered

Enter a count date

  • Zero quantities when the Nulls=0 (Y/N) field is set to Y.

  • No count entries when the Nulls=0 (Y/N) field is set to N.

The system uses the count date you entered as the count date.

See Also:

Entering the Inventory Counts

Locking Count Dates

Counting Recommendations and Guidelines Overview