Stock Sales - By Periods (#122)

This report will list sales by periods. For example, monthly sales summarised month by month. The default setting is monthly. The standard format of the report is:

Product Code Jan Feb Mar Apr May Total

Product ABC 515 4141 881 15 150 5702

Sales 12 21 300 41 5 379

Product XYZ 0 0 0 54 131 185

Sales 0 0 0 4 13 17

Begin by specifying the reporting start date. By default CAPITAL will print a report in monthly periods from this date forward for the maximum number of periods that will fit on the page. You may specify any period length you wish.

Report Start Date

Periods are calculated from this date forward. (The report will also show future periods if you specify a current date in case of forward dated invoices.) If you specify periods in calendar month units, sales analysis begins from the start of the month of this start date.

Compare From Date

You can enter a second start date for comparative purposes. If the report start date matches the compare date no comparison is performed. If you wish for example, to compare sales starting in January 2004 to sales starting in January 2003, you would enter 01/01/04 in the Report Start Date field and the date 01/01/03 in the Compare From Date field. If you specify periods in calendar month units, sales analysis begins from the start of the month of this date.

Reports that compare two date ranges take at least twice as long to process.

By Calendar Month

Leave this selected if you want the periods to be calendar months in length. This is the default setting.

By Weeks

Select this if you want the periods to be weeks in length (7 day periods).

Specify the Period

If you select this option you will be permitted to enter the period length. For example, if you wish to show sales more accurately on a 4 weekly range rather than a calendar month range, enter 28 here instead.

In Days

If you have selected the Specify the Period option, enter the number of days representing the length of the period to report on.

Include Tax

By default, the tax portion of the sales item is not included as part of the sales total. Tick to include tax in the sales figures on the report.

Round Off Decimals

This report has limited space in which to present its information. If you select this option then the decimal portion of the dollar amount for sales will be rounded up or down to the nearest whole dollar. This will mean that larger dollar amounts will fit on the report.

Without decimal rounding the largest dollar amount is: 9999999.99

With decimal rounding the largest decimal amount becomes: 9999999999

Add Description

If this option is selected, CAPITAL will include the product description on the report. This will make the report easier to read but will leave less space available for printing sales period data.

Check the No. Column Periods setting for the number of columns that will fit on the report.

Account Type

Select from the drop down list. See Account Types for the meaning of this field.

Grouping

As with all stock sales analysis reports relating to stock, you are able to group sales by stock group or supplier group. You may also specify further groupings as follows:

By State

Sales are grouped by state/territory.

CAPITAL retrieves the state data from the customer accounts record, not from the invoice transaction file.

By Salesperson

Sales are grouped by salesperson.

By Category

Sales are grouped by customer category

By Department

(Multi-departments only.) Sales are grouped by department.

No Grouping

This is the default option.

Account Range

If you select this option you can limit the report to a range of account codes.

From Account

If you have specified the above option, you will be able to enter the first customer account code to include on the analysis report.

To Account

This is the last account code to appear on the report. Only sales by customers with account codes between these two ranges will be considered for analysis. Leaving this field blank means that the last account in the customer account database will be included.

From Product Code

You may limit the analysis to a particular range of product codes. Enter the first product code here, if applicable. If this is left blank, the first product code in the stock file will be included.

To Product Code

Enter the last product code to include on the report for analysis. If this is left blank, the last product code in the stock file will be included.

If you decide to order your report by one of the above groups, and then also select stock group or supplier group sorting, the report will sort by main group, and then sub-sort by stock group.

Data Export

Export

The Export option will generate a sales analysis file in DBF format for reading into external applications such as database programs and spreadsheets, as well as by CAPITAL Visual Builder, for customised report printing.

Exported files record 12 sales periods by default and since they are not limited by the physical dimensions of a printed page, also include this additional information:

• Stock currently on hand

• Stock currently on order

• Stock currently on back order

• Reorder point

• Overstock level

• Cost in Store

• Lead time

• Supplier purchase unit

• Last sale

• Alternate product code

The generated file is stored in the default company directory and is assigned the name SALEDATA.DB3. It will be overwritten the next time an export file is generated.

This file can be processed by CAPITAL Visual Builder, greatly simplifying sales analysis report design.

Unique Stock Tracing Component

Stock Property Tracing

If stock items contain special properties such as sizes, colours, styles, etc., they are also listed on this report, below each stock item. For example, if a product comes in three colours and sales have been made for this item in these colours, the number of unit quanities for each period, by colour, will also be listed.

The individual sale quantities for properties may not exactly total to the unit sale amount for each period. The main reasons are:

• A product may be assigned more than one property type. For example, if a product has the property of "colour" and "batch number" and 10 units in total were sold, there might be 10 colour units, and 10 batch number units listed.

• Unless CAPITAL is set-up to specifically prevent unallocated invoicing, operators can invoice without specifying a property. The total of a particular property type, such as colour, may therefore not match the sale quantity sold.

Hints & Tips

• The summary version of the report prints group totals only.

• The report does not include product codes that have been deleted by operators for the applicable sales period. If any are found, the total number of units of deleted codes and their sales value are listed separately at the bottom of the report.

• As this is a stock based report, entries without stock codes are excluded. This is likely to account for the main differences in values between a regular sales report for a period and this report.

• If you select to sort by stock group or supplier group then groups that are not ticked are excluded from the report. See Reporting - Options for more information.

• Stock transfers are not normally included on this report as they involve movements between internal accounts. The default report option is to show movements and sales that relate only to regular accounts.

• For foreign currency transactions, sale items are converted to $AUD dollars on a sale item by sale item basis. Using regular sales reports CAPITAL converts the entire transaction from foreign currency to $AUD dollars. A small amount of rounding error is therefore inevitable, but its impact relative to total sales value is likely to be slight.