Reconcile Options

Use this field to:

• Specify the format and content of the RPI report.

• Control how the system updates the Inventory File.

If you use a Reconcile Option, you must also use Sequence 5.

• A = For dollar value calculations (for example, Net Beginning Quantity), use average cost instead of replacement cost.

• C = Only update location codes.  Use this option if you want to update the location codes, but don't want to update the inventory counts.  If you use this option, you must run Report RPI again with Reconcile Option R or F  to remove or finalize the inventory counts from the Count File.

• D = Insert a blank line between each line of information.

• F = Finalize the inventory counts. The system:

• Deletes the inventory count records specified in the From/To range.

• Updates the Inventory File based on the status of the count records. (See Reconcile Options V, Z, and U.)

• Updates the Shrinkage History File (if the Include PIP QOH Variances in Shrinkage History field in Function MPI-Modify Physical Inventory Constants is Y).

This option is required if you use Reconcile Option U.

• G = Delete items from Item List as they are finalized. If you finalize RPI with option F and G, it deletes items from the item list as they are finalized. Once all items are counted and finalized from an Item List, it is removed from the system. If option 1158 "Mobile Physical Inventory Display finalized items in Count List" is set to No, an item that has already been counted and then finalized with RPI appears as “FINAL.” If an item is currently being counted, it shows the count quantity. Note: never use option G when option 1158  is set to No in Options Configuration.

• I = Change the location codes. For each SKU in the From/To range, the system updates the location code in Inventory Maintenance with the first location code posted in Physical Inventory Posting (PIP) .

You can use this option with Reconcile Options F or Z. If the Always Use Location Codes for All Physical   Inventory field in Function MPI is N, you don't have to assign location codes in Physical Inventory Posting (PIP) or QPIP (Quick Physical Inventory Posting)

If you don't assign location codes, the system assigns a location code to the SKU in DDCCC format. (DD = department; CCC = class)

Note: You can't assign location codes to SKUs in Function QPIP. The system updates the location code for the SKU in DDCCC format if

• You used Function QPIP to post the first quantity you counted.

       and

• The SKU doesn't have a location code in Inventory Maintenance. This is true even if you post additional counts and locations to the same SKU later

• J = Do not print the prepage.

• K = The system posts a count of zero to all unposted items in the Count File. By using this option, the system assumes you don't have the items you do not post.

For example: You count everything in your store. The only items you Don't count are those you don't have.  If you don't  post the items, you must have zero on hand.

• L = Exclude items on ItemParts Lists. When running RPI using standard selection criteria (not using an ItemPart List) you need to use Option L to ensure that itemsparts on Physical Inventory type itempart lists are not included.

• N = Each time the location changes, start printing on a new page.

• R = Remove items without updating the Inventory File. The system deletes all count records within the From/To range you specify. Use this option when the count records are invalid or old, and you want to move them before you load new count records.

You can use this option with Reconcile Options T, J, and X.

• S = Print two lines of information for each SKU. The information includes:

• SKU

• description

• shrinkage type

• •  department

  • class

  • location codes

  • codes (MSOP1234)

  • unit of measure code for stocking, selling, and purchasing units

  • beginning quantity

  • total quantity and value counted

  • difference or variance quantity

  •  difference or variance value

• T = Print only totals. If you also use Reconcile Option S, and Subtotals is Y, one line prints for each SKU.  If you also use Reconcile Option N, a proofing total prints in the bottom left corner of the page. The proofing total is the sum of the total quantity counted. If the system can't update the SKU, an exception line prints.

• U = Finalize count records for SKUs that you added to the Count File, but have not posted inventory counts in Physical Inventory Posting (PIP) or QPIP. Use this option if you don't want to post to SKUs that have no quantity variance.  (Count Sheet Option O prints the same SKUs.)  Using this option will:

• Save you time when posting  counts, because you don't have to post to SKUs with no variance.

• Update the Date of Last Physical Inventory field in Inventory Maintenance. The system will NOT update the quantity on hand for SKUs with no variance.

• Create shrinkage history for SKUs with no variance.

Note: Unposted SKUs will remain in the Count File unless you use Reconcile Option R to remove them.

• V = Print only SKUs that have a positive or negative variance. The system calculates the variance as follows:

       Quantity Counted

     - Beginning Quantity

       ------------------

       Variance

If you also use Reconcile Option F, the system does the following for each SKU to which you posted counts in the From/To range:

• Update the Date of Last Physical Inventory field (in Inventory Maintenance) with the date you posted the counts (in Function PIP) or the  date you enter in the  __/__/__ field (at the top of the RPI Screen). Update the location codes in the same manner as they are updated with Reconcile Option I.

• Add the variance amount to the SKU's quantity on hand.

Note:  If you also use Reconcile Option F, the system includes SKUs with no variance when it updates  information. However, only SKUs with a positive or negative variance print.

If you don't use Reconcile Option F with this option, SKUs with the following characteristics print:

• The counts were posted in Physical Inventory Posting (PIP).

• The variance is a positive or negative amount.

If the Include PIP QOH Variances in Shrinkage History field in Function MPI is Y, for each positive or negative variance the system:

• Updates or creates one shrinkage history record.

• Increases the Current Shrinkage Incidents field in Physical Inventory Shrinkage History (MPH) by 1.

• Updates the Date and Location of the Last Incident field in Physical Inventory Shrinkage History (MPH) with the information in the count record.

• Adds the variance to the Current, PTD, and YTD Quantity fields in Physical Inventory Shrinkage History (MPH).

You can't use this option with Reconcile Option Z.

• W = Do not print the dollar values. (They print near the right edge of the report.)

Print the following:

• date of last sale

• date of last receipt

• date of last physical inventory

• X = Print one line of information for each SKU. The information includes:

• SKU

• description

• beginning quantity

• total value and quantity counted

• total difference or variance quantity

• variance value

• Y = Include Serial Number Detail. Requires Option 3074 “Physical Inventory - Count serialized items by Serial Number” set to Yes.

RPI has four columns when run with option Y:

• SERIAL# - the SKU’s serial number

• COUNTED = Y - serial number is counted; blank - serial number is NOT counted; S - serial number was sold after it was counted

• LAST PHYSICAL - date of last physical inventory finalized by RPI

• REFERENCE - serial number’s reference from Serial Number Maintenance

• Z = Finalize only those count records that you posted in Physical Inventory Posting (PIP) or QPIP and whose posted quantity is equal to the beginning quantity. The system updates the Date of Last Physical Inventory field in Inventory Maintenance.

The system does not update the quantity on hand or the shrinkage history for SKUs with no variance. You must also use Reconcile Option S or X.  You can't use this option with Reconcile Option V.