How do I manually adjust on-hands (track waste)?

How do I manually adjust on-hands (track waste)?


Manually adjusting on hand quantities is used to correct discrepancies or changes in inventory levels that cannot be accounted for through regular transactions (sales, purchasing or physical inventory adjustments).



Purpose of Manual Adjustments

Manual adjustments allow users to manually update the on-hand quantities of an item.

Reasons for Manual Adjustments

You may find yourself needing to complete a manual adjustment to update on hands because of one of the below reasons:

Common Reasons

·   Damage                           

·   Spoilage

·   Waste

·   Donations

·   In House Production

·   Theft

Uncommon Reasons
Sometimes, the need for a manual adjustment arises from errors in inventory management processes. In such cases, it’s essential to first pinpoint the underlying issue and work towards resolving its root cause before resorting to a manual adjustment.

·   Incorrect Purchasing Adjustments
Start by identifying the purchasing document that gave rise to the error. If within the uncommit time frame, corrections should be made within that document.
·   Inaccurate Physical Inventory Counts
If identified during the physical inventory review, correct in physical inventory instead of creating a manual adjustment.
·   Sales Discrepancies
Reach out to the Yellow Dog Support team to request their assistance troubleshooting the issue before proceeding with a manual adjustment.

 

Creating a Manual Adjustment

1. Open the Item Management/Inventory Item screen.

2. Click to highlight the item you would like to adjust then select the “Adjust On Hand Quantity” button.

3. Select the store for the adjustment by clicking to highlight the store then hit “Select”.

 

 

4. Update date and time if necessary.
The date and time set here will determine when the adjustment will be applied to the item(s).

5.     Enter the quantity to adjust in the “Adjust” column.
Alternatively, you can enter the new on hand quantity in the “New On Hand Cost” column.

6.    Use the accounting dropdown to select a reason for the adjustment.

If you do not have an accounting dropdown or need to add a new accounting code, see Manual Adjustments Q&A.

7.    Enter a reference for the adjustment in the reference field.

8.    Click “Submit”.

 

Tricks and Tips: If you have more items you need to adjust, select “Add Items” to bring in additional inventory item into the manual adjustment editor.

Reviewing Manual Adjustments

There are two options available when looking to review manual adjustment details:

  1. Physical Inventory Module (Physical Inventory/Manual Adjustments)
  2.  Manual Adjustment Reporting (Reports/Standard Reports/Inventory/Adjustments
Physical Inventory Module

Where: Physical Inventory/Manual Adjustments

Why: Provides an easy way to quickly review manual adjustments.


Tricks and Tips: To learn more about the options available on the manual adjustment screen, click on the on-form help located on the right-hand side of the database. In the screenshot above, the on-form help is the purple bar with the yellow question mark that says, “Click here for on-form help”.

Manual Adjustment Reporting

Where: Reports/Standard Reports/Inventory/Adjustments

Why: Running manual adjustment reporting allows you to:

  1. see an in-depth analysis of manual adjustment 
  2. sort and filter the reporting details
  3. export and print information

 

Ex. Manual Adjustment Reporting (Manual Adj – Detailed Report)


Manual Adjustments Q&A

Can I remove a manual adjustment?

Manual adjustment cannot be removed after committed. If a manual adjustment is incorrectly entered, create a new manual adjustment to correct.

Is there a suggested manual adjustment report?

We suggest the Manual Adj – Detailed Report but recommend checking out the other reports that are available to see if they fit your needs.

What if I do not have an account dropdown in the manual adjustment editor or would like to add new accounting code (reason for the adjustment)?

An admin user with access to System Setup will need to:

1.   Go to System Setup/Accounts.
2.   Select “Create New Accounting Code”.


3.   Enter description.
4.   Select “Save and Close”.

 












    • Related Articles

    • Troubleshooting: On hands have not updated after committing a Physical

      Items not updating after committing a physical inventory. The most common reasons on-hand quantities don’t update after a physical inventory are: The physical inventory was never committed. The item wasn’t included in the physical inventory, so its ...

    • How To: Create a Cost Adjustment (Fix Calculated Cost)

      The Cost Adjustments feature allows users to correct inaccurate calculated costs resulting from improper item management, ensuring consistent inventory valuation and reporting. All client types can take advantage of this feature, though it is ...

    • Troubleshooting: Variances in a Physical Inventory

      A Physical Inventory shows variances, and you need to identify the cause Most variances occur because of: Missing or committed receiving/invoicing Missing or unprocessed sales The Item History Report is the most reliable tool for determining where an ...

    • Physical Inventory Process for Venue Warehouses

      Physical Inventory Checklist One Day Before Physical Inventory ☐ Step 1: Complete all Pre-Inventory Preparations Day of Physical Inventory ☐ Step 2: Count Warehouse Using Handheld with Count XL (Step 2A if alternatively using Count Sheets) ☐ Step 3: ...

    • End of Month Process Checklist - FnB (Physical Inventory)

      Getting Ready for End-of-Month Physical Inventory? Ensure a smooth, accurate, and efficient inventory count by following our End of Month Process Checklist. It’s your go-to guide for staying organized and on track.

    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...

    • How do I use Par & Re-Order Points?

      What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...

    • Tips & Tricks: How do I download and install drivers for my Zebra Printer?

      **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...

    • How To: Swap the On-Hand/Parent Size (Edit Base Unit)

      When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...

    • What are Bins and how can I use them?

      Bins are supplemental location markers. Unlike flags they do not have to be created prior to assigning them to items and are primarily used in in the stores tab to identify more precisely where an item is located. They can also be used in Physicals ...