Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Office Help Home

Table of Contents

Table of Contents
minLevel1
maxLevel7
excludeTable of Contents


Accessing the Tool

To access the Inventory Adjustment Wizard:

  1. Select the Items module.

  2. Select Inventory Adjustment Wizard.

Prepare - Post All Charge/Inventory Batches

Prior to performing any steps related to the Inventory Adjustment Wizard, care must be taken to ensure all POS charge batches and Inventory batches are posted.

To review for unposted batches, within Items:

  1. Click on the Approve Inventory Adjustment Batch.

  2. Set Posted filter to Unchecked to return all unposted batches.

  3. Contact Accounting to post any listed batches before continuing to next step.

    • Note: Clubessential is not allowed to change employee privileges for security purposes.  If you are unable to access this feature, contact your Club Administrator.

    • Do NOT proceed to next step if you have not checked with your Accounting Office that all POS batches for your area have been posted.

Make Inventory Adjustment 

Once all batches have been posted, navigate to the Inventory Adjustment Wizard

  1. Enter the G/L date to use for the transactions.  It will default to current date.

  2. Click Next.

  3. Next, enter the Adjustment.  

    • Enter the Item (use the Lookup feature for assistance).  

      • The On Hand Quantity will be displayed.  

    • Enter the Adjustment (Quantity).  

      • Enter Adjustment as a positive to increase inventory, or as a negative to decrease inventory.

    • The Cost field will populate with the Item’s current average cost.  This may be overridden.  

      • The Value field will calculate based on Quantity entered multiplied by Cost.  

    • Enter a Description to describe the Adjustment (optional).  

    • Add additional adjustments by repeating the above steps, and when all adjustment lines have been entered, click Finish.

  4. The Post Batch Preview screen will show the adjustment that will be made to the GL.

  5. Click Post Batchto post.

Review - Inventory Transaction History

The Inventory Transaction History Report will contain the posted batch, as well as the adjustment amount for future reference.  

To navigate to the Report:

  1. Click on Interactive Reports.

  2. Expand the Inventory Report section.

  3. Choose Inventory Transaction History report.

  4. Set appropriate parameters and click, View Report.

  5. Click to expand and view the details of the adjustment.

Inventory Adjustment - Override Average Cost 

In addition to regular Inventory Adjustments, a Club may also wish to override the entire average cost of an item.  

This could be performed in conjunction with an inventory restructuring that will impact item’s cost, and/or a general inventory clean up.

When performing an override of the average cost:

  1. In addition to specifying the G/L date to use for the adjustment,

  2. Ensure to check the Override Average Cost option.

  3. Click Next.

  4. On the following screen:

    1. Enter the Item(s).  The On Hand quantity will display.  

    2. Enter the New Cost (the new Average Cost) for the item.

    3. Click Finish.

  5. The Post Batch Preview will appear and will display the dollar adjustment that will be made to the G/L. Once reviewed, click Post Batch.

  6. Again, the Inventory Transaction History Report will contain the posted batch, as well as the adjustment amount for future reference.  Click to expand and view details.