View and adjust stock on hand

Inventory and Purchasing

In Fred NXT Head Office, changes to stock-on-hand not associated with stocktaking are made using adjustment journals. You can adjust a store's stock-on-hand of one or more products directly, or make a bulk adjustment in Excel. Adjustment journals enable you to make small adjustments to stock-on-hand; for example, if some items are accidentally broken; or if a supplier supplies an incorrect quantity. The Data Import/Export Framework (DIEF) enables you to adjust your inventory in bulk by exporting a list of products to a spreadsheet, making changes in Excel, importing the spreadsheet to an adjustment journal, then finally posting the journal.

  1. Go to Merchandising > Stock on Hand.

  2. Click Chart in the ribbon to display the Sales information for the last 12 months as graph.

    Press CTRL + T to export the contents of the grid to Excel for further analysis.

  3. Click Multiple Items to select multiple items from the Hierarchy and display in the grid for comparative analysis.
  4. The Stock on Hand screen is also available from Merchandising > Release Products.It is located in the ribbon, under the Manage inventory tab.

  1. On the home screen, click Merchandising, then click Released Products.

    2. The Released products screen is displayed.

  2. Search for the required product.
  3. Double-click the product.

    The product details are displayed in a new window.

  4. Click the Manage Inventory tab.
  5. Click On-hand inventory.

    The Physical inventory column displays the Stock on Hand available for this product at each site.

    The Site column shows each store that stocks the product. The Order in total value is the number of units of the product currently on order.

  6. To close the product details window, click Close.
  1. Under Inventory and purchasing, click On-hand.

    The On-handwindow is displayed, and shows all the products in your database.

    The Physical inventory column shows the stock-on-hand of each product.

  2. ClickQuantity Adjustmenton the relevant item.
  1. Go to Merchandising > Stock on Hand.
  2. Click Multiple Items.

  3. In the Add Products form, select the Advanced tab.

  4. In Cost has changed within previous number of days, enter the relevant number of days you want to report on.
  5. Click Apply, then OK to close.
  6. Wait while the report is generated.

    The results are displayed in the Stock on Hand form.

  1. Under Inventory and Purchasing, click Inventory adjustment.

    2. The Inventory adjustment window is displayed, and shows a list of all adjustment journals that have been created.

  2. Click to select the adjustment journal you want to review.
  3. Click Lines.

    4. The product lines in the journal are displayed.

  4. Review the product lines in the journal.

    5. The value in the Quantity column is the quantity that will be added to or removed from the stock-on-hand. For example, if an item was broken, the store user would enter -1 to reduce the stock-on-hand by 1 unit.

  5. To apply the inventory changes made in the journal , click Post.

    The checkbox in the Posted column is ticked.

  1. Under Inventory and Purchasing, click Inventory adjustment.

    2. The Inventory adjustment window is displayed.

  2. Click New to add a line at the top of the list.
  3. Click the Name drop-down, then select the required type of adjustment journal line.
  4. Click the General tab and enter the reason for the adjustment in the Description field.
  5. In Store inventory tab, select the Site that matches the store whose stock you want to adjust.
  6. Select the Warehouse that matches the store whose stock you want to adjust.
  7. In Lines, click in the Item number column to search for and select an item.

    For example, if an item has been broken, you would enter -1 to reduce the stock-on-hand by 1 unit.

    • To change the cost price of the product, click in the Cost price column and enter the new cost price.

      This will overwrite the previous cost price for the product.

    • To apply the inventory changes made in the journal , click Post.

      The checkbox in the Posted column is ticked.

Related Topics