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.
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.
If identified during the physical inventory review, correct in physical inventory instead of creating a manual adjustment.
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
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:
- Physical Inventory Module (Physical Inventory/Manual Adjustments)
- Manual
Adjustment Reporting (Reports/Standard Reports/Inventory/Adjustments
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:
- see
an in-depth analysis of manual adjustment
- sort
and filter the reporting details
- 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:
Related Articles
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: What should I check if on hands have not updated after I committed my physical?
What should I check if on hands have not updated after I committed my physical? The two most common causes of on hands not updating after committing a physical is that the Physical has not been committed or all active items were not brought into your ...Troubleshooting: How do I start investigating variances in my physical?
The first place to start investigating variances in your physical is an Item History report. This report will provide detailed information regarding when your item was purchased, received, manually adjusted, sold & inventoried. Variances are most ...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 ...Food and Beverage Core Features User Manual
The Food & Beverage Core Functions User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory ...