INVENTORY

 

Statement of item (History of an Item)

Top

In this report all item transactions can be viewed ordered by date.  It is the history of a stock item. It is a periodical report.  Existing quantity of all movements before from date is accumulated into previous quantity.  In the report output the quantities of purchases, return sales, and positive adjustments transactions are found in the column of IN quantity, while the quantities of sales, return purchases, and negative adjustments transactions, are found in the column of OUT quantity.  The existing column shows the existing quantity at each transaction.

Statement of item report is supported by the following options and parameters:

0. All movement options specify if all the movement should be included or one of the listed below. To get the exact figures of existing quantities the all movement options should be checked.

1. Date range of the report.  The movements between these 2 dates are listed.

2. The currency of prices that appear be in the report.
          Currency : Currency of item specified in the item form
          LL          :  Currency Base 1
          $            :  Currency Base 2

3. The statement of item can have the following options:

- Show selling price: The selling prices of sales and return sales movements are shown.
- Show purchase price: The FOB price or Landed Cost (FOB price + charges) of purchases movements are shown.
- Print the item movements even though the current existing quantity of the item is 0.
- Force new page: If more than one item is chosen (4) each item movements are in printed on separate pages.

4. From item code to item code: Range of items being selected.

Inventory Report

Top

This report shows the items in the stock, their quantities entered, quantities sold, existing quantities, their values and the total stock value in currency base1 and currency base 2. The value of the item can be according to several prices: the average cost, last cost price, last FOB price, and selling prices.

0. Currency by which the values of the stock items are: Currency of the item, currency base 1, or currency base 2.

 

1. Print layout options:

- The list should be ordered by: Item code, Item barcode, Item Description

- Enable detail: The value of each item is converted and displayed to currency base1 and currency  base 2.

- Print Zero quantities: The items with 0 existing quantities are also displayed

- Non stock items are also displayed.

- Only items with their existing quantities are greater than their maximum quantities are displayed.

- Only items with their existing quantities are less than their minimum quantities are displayed.

2. Grouped By:  If the items being printed will be grouped by one of these options

 

3. Start and end date of this inventory report.

 

4. The items that have one of the following movements within this period are displayed.

 

5. To enable the advanced parameters options (see below enable option).  When this option is checked parameters 7,8,9,and 10 in this page are neglected.

 

6. The inventory value is according to one of these prices.

 

7. Range of items from - to

 

8. Range of groups that the items belong to from - to

 

9. Range of suppliers that the items belong to from - to

 

10. Range of subgroups that the items belong to from - to

 

Enable option example: When it checked the reports parameters would be that of the option form.

e.g. suppose that an inventory report is required. The requested items should obey the following criteria.

- They belong only to 2 different non consecutive groups TG and TS (the group codes are not in sequence).

- They belong to a certain supplier X.

- The item 0005 should not be included in this report.

To reflect these criteria to report parameters in the option form:

Select in the tab sheet "group" from the option form the 2 needed groups          (selection is done by double clicking on the group TG, then holding on the control key (ctrl) then double clicking on the group TS, the 2 groups will be selected at the same time.

Select the supplier by double clinking on that supplier X in the tab sheet "supplier".

Select the item 0005 to be excluded form the "item” tab sheet then check excluded.

The inventory report now has the following output:

Only the items that belong to group TG, and TS and that belong to supplier X without Item 0005 are shown.

Profit By item

Top

This report shows the items sold within a certain period and their profit.  It shows the quantities sold, the cost of the quantity sold (average cost), the selling amount and the net profit/loss per each item and the total cost amount, total selling amount, total profit amount and the profit percentage.

0.  Currency by which the values are displayed: Currency of the item, currency base 1, or currency base 2.

1. Grouped By: If the items being printed will be grouped by one these options

2. Start and end date of this profit by item report.

3. To enable the advanced parameters options (see the enable option example). When this option is checked parameters 7,8,and 9 in this page are neglected.

4. Profit margin percentage is calculated according to the selling or the cost price.

E.g. selling is 100 $ cost is 90 $ profit is 10 $, profit margin is 100/10= 10% if it is considered according to the selling profit margin is 90/10 = 9% if it is considered according to the cost.

5. Range of items from – to.

6. Range of groups that the items belong to from – to.

7. Range of suppliers that the items belong to from – to.

8. Range of subgroups that the items belong to from – to.

9. Range of clients that the items being sold to them from – to.

Sales Report

Top

This report shows the items sold within a certain period and their profit.  It shows in details the quantities sold, the dates, the sales invoices numbers and the clients. The cost of the quantities sold (average cost), the selling amount and the net profit/loss per each item and the total cost amount, total selling amount, total profit amount and the profit percentage.

0. Currency by which the values are displayed: Currency of the item, currency base 1, or currency base 2

1. Grouped By: If the items being printed will be grouped by one these options

2. Cumulative: It shows cumulative sold quantities per client without invoice dates and references.

    Detail: It shows detailed sold quantities per client with invoice date and reference.  

    Print cost: It shows the cost of each item sold per client

3. Start and end date of this sales report.

4. Master by Client: The report shows each client and the items sold to.

    Master by Items: The report shows each item and the clients being sold to

5. Profit margin percentage is calculated according to the selling or the cost price. E.g. selling is 100$ cost is 90 $ profit is 10 $, profit margin is 100/10= 10%; if it is considered according to the selling profit margin is 90/10 = 9%; if it is considered according to the cost.

6. Range of items from – to.

7. To enable the advanced parameters options (see the enable option example).  When this option is checked parameters 6,8,9 and 10 in this page are neglected.

8. Range of groups that the items belong to from – to.

9. Range of suppliers that the items belong to from – to.

10. Range of subgroups that the items belong to from – to.

11. Range of clients that the items being sold to them from – to.

Purchases Report

Top

This report shows the items purchased within a certain period and their charges.  It shows in details the quantities purchased, the dates, the purchases invoices numbers and the suppliers. The cost of the quantity purchased (FOB, landed cost, and the charges)

0. Currency by which the values are displayed: Currency of the item, currency base1, or currency base 2.

1. Grouped By: If the items being printed will be grouped by one these options.

2. Master by Supplier: The report shows each supplier and the items purchased from

   Master by Items: The report shows each item and the suppliers being purchased from.

3. Start and end date of this purchases report

4. To enable the advanced parameters options (see the enable option example).  When this option is checked parameters 6,7,8 and 9 in this page are neglected

5. Cumulative: It shows cumulative purchased quantities per supplier without purchases invoice dates and references.

    Detail: It shows detailed purchased quantities per supplier with purchase invoice date and reference.

6. Range of items from – to.

7. Range of groups that the items belong to from – to.

8. Range of suppliers that the items belong to from – to.

9. Range of subgroups that the items belong to from – to.

List of Items Report

Top

It is an index of stock items.  It displays the fields found in the item form.

0. The report can be displayed with only seven fields from this part (due to paper size)

1. Grouped By: If the items being printed will be grouped by one these options

2. Range of items from – to.

3. Range of groups that the items belong to from – to.

4. Range of suppliers that the items belong to from – to.

5. Range of subgroups that the items belong to from – to.

List of transactions reports

Top

This report lists the inventory transactions purchases; return purchases, sales and return sales.  It shows the total amounts, the total discounts, and total VAT if exists.

0. Start and end date of the transactions being listed. 

1. Start and end reference of the transactions being listed. 

2. Invoice No (field found in purchase form) from – to.

3.  Currency by which the values are displayed: Currency of the transaction, currency base 1, or currency base 2.

4. Print along with each transaction its journal voucher reference or its folio -Detail: print the details of the purchases/return purchases invoice, sales/return sales invoice.

5. To print which type of transactions: purchases, return purchases or together (both), sales, return sales or together (both).

- To enable the advanced parameters options (see the enable option example).  When this option is checked parameters 6,7,8 and 9 in this page are neglected

6. If it is checked the purchases / return purchases are grouped by suppliers

7. Range of suppliers from – to.

8. If it is checked the sales / return sales are grouped by clients.

9. Range of clients from – to