IC Product Reports - Add Layout

Navigator > Reports > Inventory Control > Product Reports > Add Layout

You can add and customise layouts. Once you have added a layout, it becomes a report and will be available from the appropriate Reports folder.

Comparison reports can be run at any period and automatically include records that were active in the selected period, derived from transactions and balances. Valuation reports contain data from the current period or end of time and only report values that are currently active. Valuation reports are typically faster to run than comparison reports.

Accredo will check if product revaluations are required, and will prompt you to revalue if necessary.

See also Report Selections Form.


Layouts
Bar Codes	Shows Bar codes by product. You can report bar codes for a given Customer or Creditor, Range of Products or all bar codes. Supplier fields on the Report band are populated from the default Supplier (Creditor Code on the IC Product tab) if one is specified.
Component Of	Shows the finished products that items are components of, that is, it is the opposite view to the component report below.
Components	Shows the components, quantities, cost price and extended cost for manufactured stock items and Kitsets. Select a Product range and Selling Price from the Selections button, when you add a layout. The manufactured item or Kitset Product code and description are printed followed by the components. Cost prices shown will be standard, latest or average depending on the valuation basis specified in IC Settings.
Group Sales and Valuation	A group summarised version of the Stock Sales and Valuation Report. This shows the current values and doesn't show previous periods. To see previous periods use the Product Balances report.
Location Balances	Reports product by location balances as at selected period. (Accredo Saturn Only)
No Activity	Reports products with no activity of selected types since a specified date.
Price Code List	Report on prices for all or a selected Price Code. Include Price Code and group by Price Code or Product Code if reporting for more than one Price Code.
Price List	Report on prices by Price No mapping for products. SellingPrice1 - 9 are the list prices, Sell1 - 9 the discounted prices if a Customer Discount Code is selected.
Product	Provides information from the Product record. You can report on Products and Stock Groups, for Creditors and Locations (in Accredo Saturn) as at the current date and period. You can customise in period to date and year to date figures. Product information and supplier details can be customised in, by selecting Customise, then using the Report, Information and Supplier tabs. Supplier fields on the Report band are populated from the default Supplier (Creditor Code on the IC Product tab) if one is specified. If Ignore Minimum Quantity is Selected, minimum quantities will not be considered when calculating reorder quantities. Reorder quantities are calculated consolidated by product if location is not specified. (Accredo Saturn Only) Note: The report includes a number of calculated fields relating to stock value: Closing Value Period To Date = Closing (Quantity) Period To Date * Valuation Cost Stock Value = Quantity In Stock * Valuation Cost Value Standard = Quantity In Stock * Standard Cost Value Latest = Quantity In Stock * Latest Cost Value Average = Quantity In Stock * Average Cost
Product and Location Detail	Report on quantities in stock, on order, and allocated, and can be summarised by product or location. If Ignore Minimum Quantity is Selected, minimum quantities will not be considered when calculating reorder quantities. Reorder quantities are calculated per location (Accredo Saturn Only)
Product Balances	Select data from the Product table and the balances table to provide information on quantities, values, and sales, as at the end of a selected period. You can report on one or more product and / or Stock Group, for a given or all creditors and locations (in Accredo Saturn). If a location is specified, quantities are shown for the location. Quantities are shown as at the end of the selected period. When reporting for the Current period you are prompted to revalue if there are any pending revaluations since these are not included in stock value, revaluation prior to reporting is recommended. Note: Unit Cost = Closing Value / Closing Quantity Closing Value = Opening Value + Movement value (i.e. cost value from transactions) + Revaluation value
Product by Locations	A master report showing the quantities for each location in the detail band. Supplier fields on the Report band are populated from the default Supplier (Creditor Code on the IC Product tab) if one is specified. (Accredo Saturn Only)
Product Links	Report on links for products.
Sales and Usage	Shows quantities, cost and value sold for period and year to date. Stock usages (that is, components of invoiced Kitsets or manufactured items and usages in JC) are included in the figures. The report is useful to see real stock usages (as opposed to just sold items). The report can be run as at any period.
Sales Budget	Shows 12 period budget figures from the period selected back. Total is the total of budgets from earliest period included to the reporting period.
Sales Budget Comparison	Contains budget and activity figures for the selected period and year to date. Percentages compare budgets with the activity. This report can be run at the end of any period.
Sales Comparison	Contains quantities and values sold for period and year to date including comparisons with the same period last year and total up to the same period last year. The percentages show current sales as a percentage of last year sales, that is, a percentage greater than 100% indicates an increase in sales. The report can be run at any period.
Stock Group Comparison	A group summarised version of the Sales Comparison Report above.
Stock Sales and Valuation	Produces a report of products to detail stock values, sales and cost of sales. Totals are shown as a summary of the inventory system. Stock is valued on the basis of the In Stock (that is, closing stock) quantity. If you integrate IC with the GL this report shows the stock value which is used for the transfer to the GL. This will be standard, latest or average depending on the IC Settings. Supplier fields on the Report band are populated from the default Supplier (Creditor Code on the IC Product tab) if one is specified. This shows the current values and doesn't show previous periods.
Supplier Price List	Report on supplier costs by product.
Thirteen Period Sales	Print a report of up to 13 months sales (by quantity) for each Product. You can report on sales only, usages only or both for selected Products, Stock Groups, Creditors, Locations (in Accredo Saturn) and Periods.
UOM Report	Lists the UOMs available for each Product.
UOM Quantities	Reports the quantities for products with the selected UOM Code. You can select to filter this by a particular Location (in Accredo Saturn). Displays the information available on the IC Products - Quantity tab when a Quantity UOM is selected.