Inventory reports: sales, prices and profitتقارير المخزون: المبيعات والأسعار والأرباح

The ribbon every one of these screens shares - Preview, Direct printing, the report-selection box, and the saved-filter box - is covered in Inventory reports: how the report screens work. This page covers what each of the following ten screens actually asks for and answers.

1. Accounts / inventory statistics

Totals a date range of vouchers by account, grouped either by Receivables or by Items, and ordered Ascending or Descending. Vouchers selection narrows to Purchases or Sales first; Report information then picks which document kinds count toward the total - Sales, Sales Returns, Stock out, POS sales, POS returns. Summary by chooses whether the result reads in Amounts or Quantities.

2. Sales statistics

A Report type choice of Sales or Monthly. Narrow by Region, Warehouse, Cost center, Salesman or Account, and pick LBP, USD or Account currency for the result. Group by re-sorts the same totals by Salesmen, Region, Projects, or leaves them as one combined figure (No grouping).

3. Periodic Statistics

The one screen in this menu built to compare periods rather than report on one: Add a date range, Add another, and the list under Specify period holds as many as you need side by side - Remove, Up and Down manage the list. Vouchers selection narrows to Sales, Purchases, or With the returns included, and the same Region, Warehouse, Salesman and Branch filters as the other statistics screens apply across every period at once.

4. Inventory price evolution

Tracks one figure over a date range: Specify price strategy chooses whether that figure is FOB, Average cost or Sales price, over the dates in Specify period.

5. Compare item sales with price list

Checks what items actually sold for against a chosen Specify price list, over a date range, by Salesman or cost centre. Show differences only trims the result down to the lines that don't match the list - the ones worth a second look.

6. Inventory price list

A price list over a date range, in a chosen Result currency, with Hide items with zero onhand, Hide items with no price and Basic unit only as options. Narrow by Supplier, Warehouse or Customer name.

7. Items profits

Margin by item over a date range, with the Costing method - Last cost price or Average cost, optionally Based on current costs - deciding what "cost" means for the calculation. Profits margin sets a From/To band for the margin. Summary by reads the result Detailed, Balances only, or Group by family, one to three levels deep. Result currency covers Invoice currency, Item currency, LBP or USD.

8. Invoice profit

The same margin question, per invoice rather than per item, with an Invoice Number box (0 when the screen opens) and a date range. Group by re-sorts the result by Receivables, Invoice dates or Salesman, and the same Costing method choice as Items profits decides what "cost" means.

9. Client items report

What a customer has actually bought, over a date range, in Sales, Purchases or All invoice kinds. Group by reads the result as Receivables or by Items, with With cost centers adding that breakdown; Currency chooses LBP, USD, or each line's own Invoice currency. Narrow by Auxiliary account, Salesman, Warehouses, Region or Branches.

10. Commission report

The shortest of the sales screens: a Salesman, a date range, a Currency, and a Detailed option.