Stock Sales - By Products (#119) 
Stock Sales - By Products (#119)
This report will produce a stock sales report for stock sold between any two sets of invoice numbers or dates. Options include:
Start Date
Start of sales to report on.
End Date
Last date to report on.
Compare From
Start of period to compare sales to. Leave blank if you don't want a comparison with another period.
Compare To
The end date of comparison.
Profit Above
Enter a percentage that represents the margin the sale of stock must equal or exceed in order for it to be included on the report. Leave as zero to skip this condition.
Profit Below
Enter a percentage that represents the margin the sale of stock must be equal to or less than, for it to be included on the report. Leave as zero to skip this condition.
Transactions (1-8)
Tick 
the transaction types that are to be included on the report. All transaction types are included on the
report by default, except for payments. (Which do not have associated stock sales.)
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.
Include No Sale Stock
Tick
to include stock that has not been sold during the specified date range on the report.
Include No Sales Only
Tick
to only include stock that has not had sales for the specified date range.
Estimate Cash Orders
If ticked, cash order type transactions will have stock costs included on the report according to current stock pricing.
Note that this report then becomes an "estimate" of expected/approximate costs. (With cash orders
the cost price of an item is not known until the item is finally sold and delivered.) However, if you
use cash orders and do not estimate their cost on this report you are likely to underestimate your real
costs.
Include Full Lay-bys
By default lay-by or cash order transactions are treated as 'full sales' by this report. In other words, the sale is recognised as complete (although you may not yet have been paid in full). Untick to override this option. In which case the cost of the lay-by is shown on the report but not its derived income.
List Kit Components
When unticked the Stock Sales Report will list the cost and sell prices of entire kits only. This is desirable if the components that make up the kits are of small value and/or not sold separately. For example, IC's in electronic devices, various food mixtures in the production of packaged foods, etc.
Where the individual components that make up a kit are of higher value, for example, the pieces of furniture
in a lounge suite, or the various hardware components in a computer, then tick
this option to list the parts that make up the kits, rather than the kits themselves, on the report.
When ticked CAPITAL uses a ratio to calculate the sale value of the component according to the component's cost price, relative to the cost price of the entire kit. For example, if the cost price of a particular component is $10 and the total kit cost price is $100, then the component's sell price on the report is calculated as being 10 per cent of the kit's total sell price
The formula CAPITAL uses is:
Component Cost / Total Kit Cost * Kit Sell Price
As the formula requires division, a small degree of rounding error is inevitable. This will be more pronounced
when CAPITAL has to deal with fractional quantities and amounts. To determine the degree of 'error' print
the report without listing kit components and compare this to the kit component total. The difference
will be the amount of rounding error.
Only Marked Special
Only stock items that have their Special setting in Stock Control marked will be included on the report if this option is ticked. This is useful if you only wish to report on a very selective set of items, such as promotional stock.
As Mark-up
Will show percentage mark-up on report.
As Margin
Will show percentage margin on report.
Account Type
Select the account type from the list. The default is 'regular' which includes standard and cash account related sales.
____________________________
Related Topics:
 |