Adjustment Summary Report |
Top Previous Next |
This report is accessed through the menus P.O.S. / Inventory Reports / Adjustment Summary.
This report can summarize "raw" Adjustment record information. While it was intended as more of an auditing tool, it can also be useful for getting a total of all Purchases or Loss adjustments, for instance. You can then Print the report or use Export List to save it to a CSV file. Whenever you have finished generating reports of a particular type, just Close the dialog.
Value to Report
For all Adjustments found according to the date and other filtering, the report can total various values from the adjustments. Note that in all cases, zero values will be shown as blank in the grid, to make it easier to see what changes actually took place.
Change in Qty on hand -- If the adjustment changed the quantity, will show the amount that the quantity changed.
Change in Cost each -- If the adjustment changed the cost, will show the amount that the cost changed from the previous cost value. Note that this is cost values in the Inventory Item record, not a calculated cost using the cost accounting method.
Change in Price each -- If the adjustment changed the price, will show the amount that the price changed from the previous price value. Note that this is price values in the Inventory Item record, not related to actual sale transactions.
Number of adjustment entries -- the number of Adjustment records found in the time period.
Adj. effect on total Cost* On Hand -- This calculates the total effect (of all inventory on hand at the time) in total Cost On Hand -- in other words, the difference in Cost On Hand before and after the adjustment. This uses the Cost Accounting method selected in Program Options. Note that this is generally due to an On Hand Quantity adjustment, since a Cost adjustment is ignored for most accounting methods (since it's only a change in the inventory record's cost, not real accounting cost). However for Weighted Average accounting, Weighted Average Cost adjustments can have an effect.
Adj. effect on total Price On Hand -- This calculates the total effect (of all inventory on hand at the time) in total price of all items on hand -- in other words, the difference in Price On Hand before and after the adjustment. Note that this is generally due to an On Hand Quantity adjustment, but could also be due to a Price adjustment.
Adj. total raw cost (Qty x Cost) -- This is the non-calculated cost change of the adjustment. Instead of a calculated cost as mentioned above, this calculates using only the Cost from the Inventory Item record (and could also report a change due to a Cost adjustment).
Report Options
The report also has some common settings as you see throughout Campground Master:
From / To Date -- You can select any start and end date for the report.
Adjustment/Item Filtering -- You can further customize the report for the Types or Reasons of adjustment, or even the Operator who entered it, as well as ranges of adjustment values, etc. Inside this filter, you can also set up Purchase Order or Inventory Item filtering.
There's also an option to "Save filter" for next time, which can be checked when you set up a filter that you want to use as the default. If this is checked when you close the report, then the filter will be saved and re-used the next time you run the report (and "Use filtering" will be checked automatically.) If you make changes to the filter but this box isn't checked upon exit, then the changes won't be saved but the previous filter will still be loaded (but will no longer be used automatically -- just check "Use filtering" again to re-activate it next time).
Summarize period -- You can summarize the reports by days, months, quarters, or years. This results in one column (or row) for each day, month, or year of the selected date range. Keep in mind that the date range selected takes precedence. So for example if you summarize by month and selected the range 4/1/2001 to 5/1/2001, it will show April and May months in the report but will be reporting for only one day in May due to the 5/1/2001 ending date.
Auto-Generate -- By default, you must click the Generate Report before it will calculate a report and fill the grid, since some reports can take a significant time to generate. If you're reporting on a small date range or using a fast enough computer, you can select the auto-generate option so that the report is refreshed every time you change one of the options. This can be useful for experimenting with the controls to see how they affect the report before generating a report for a large date range.
Group Total for Each -- The results can be grouped by Inventory Item, Transaction Category, Item Class, Adjustment Type or Adjustment Reason.
Hide groups with no adjustments -- This will prevent showing group rows or columns (but not date summaries) that have a no adjustments for the entire date range.
Show Item: Codes / Descriptions -- Select whether you show the Item Code or Item Descriptions, or both, in the first column. If neither is selected, it will use the Description. This only has an effect if grouping by Inventory Item.
Further Topics:
Entering Inventory Adjustments