Old Reports -> Stock -> Reorder Report

Parent Previous Next

Bug

The Tools → Old Reports → Reorder Report only supports up to 10-Digit Stock Codes.

New / Related Topic

The following reportman versions of the Reorder reports are available from the Reports → Reorder menu:

Reorder Reports

Current Stock Levels


To Print Labels for Stock Items, you may go to the Edit → Stock Items screen and select the Reorder Report from the sidebar on the Stock Item list screen.

This option allows you to view the reorder levels of your Stock Items as at a specific date. The reorder levels you have entered on the Edit → Stock Items menu and the quantity at hand will be displayed for the selected Stock items. You will use this report to reorder your Stock Items from your creditors (suppliers).

This report lists the reorder level quantities and quantities on hand. The difference between the reorder quantity and quantities on hand as well as any Invoiced and Backorder quantities will be displayed for the Invoices, Credit Notes, Purchase and Supplier Returns documents created on the selected date or dates and which is updated to the ledger.

Print Stock Item Reorder Reports

To Generate a Stock Item Reorder Report:

1.Click on the Tools  → Old Reports → Stock → Reorder menu.

The Reorder Options screen is displayed:

2.Send Report to - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Sequence - Select to list the Stock Items according to the Stock Codes, Stock Description, Stock Groups 1 or 2 (Reporting Groups 1 and 2).

The description of Stock Group 1 or 2 you have entered on the Reporting Group Name field on the Stock Groups tab on the Setup → System parameters → Groups menu, may be reflected in this list.

b)From Stock Code ... To - Select the stock code, or a range of stock codes, to include in the report.

c)New Page per Item - Not implemented.

d)Add Unposted - Select to include Invoices, Credit Notes, Purchase and Supplier Returns documents which have not yet been posted (updated) to the ledger.

e)Quotes / Orders - Select to include Quotes and Orders in this report.

f)Show All Items - Select to view additional information for each selected stock item.

g)Print Extra Info - Select to view additional information - i.e. Invoiced Quantity, Back Order Quantity and Latest Cost Price for each stock item.

h)All Stock Item - Select to view all stock items, including those with zero values, within the selected range of stock items.

4.Click on the OK button. The report will be sent to the medium selected in the Send Report to field.


View Stock Reorder Reports

All Options selected on the Reorder Options screen

An example of the Stock Reorder report, reflecting the details, is:

The details of this report are displayed in the following nine (9) columns:

1.Stock Code - The selected Stock Item code will be displayed.

2.Description - The name or description of the selected Stock Item code.

3.Reorder Level - The minimum quantity of stock items which should be on hand, before you need to order or purchase any further stock items. This reorder level quantities is entered in the Reorder field on the Edit → Stock Items menu, or in the Input → Adjust Stock (Advanced tab) menu.

4.Qty On Hand - This is updated when documents are updated to the ledger. Purchases and Credit Notes, as well as any adjustments which increases the Stock quantities (stock in), will update the quantity on hand as a positive quantity. Invoices and Supplier Returns documents, as well as any adjustments will decrease the Stock quantities (stock out).

5.Difference - This quantity indicates the quantity of stock items available below (or above) the reorder level. If you have selected to show all items, those items with sufficient quantities (more quantities than the reorder level), will be displayed as a negative figure.

6.Invoiced Quantity - This is the quantity that has been sold in the Invoicing process.

7.Backorder Quantity - This is the quantity of any outstanding backorders for the Invoices entered in the Input → Documents menu, and which are posted (updated) to the ledger for which no quantity is entered in the Ship field of the Document Entry Details screen.

8.Purchase - Order - Quantities on order outstanding orders from creditors (suppliers) which are not yet confirmed (converted to Purchase documents.

9.Total Free on Hand - The quantities available.

Extra Info Options not selected on the Reorder Options screen

An example of the Stock Reorder report, reflecting the details, is:

The details of this report are displayed in the following seven (7) columns:

1.Stock Code - The selected Stock Item code will be displayed.

2.Description - The name or description of the selected Stock Item code.

3.Reorder Level - The minimum quantity of stock items which should be on hand, before you need to order or purchase any further stock items. This reorder level quantities is entered in the Reorder field on the Edit → Stock Items menu, or in the Input → Adjust Stock (Advanced tab) menu.

4.Qty On Hand - This is updated when documents are updated to the ledger. Purchases and Credit Notes, as well as any adjustments which increases the Stock quantities (stock in), will update the quantity on hand as a positive quantity. Invoices and Supplier Returns documents, as well as any adjustments will decrease the Stock quantities (stock out).

5.Difference - This quantity indicates the quantity of stock items available below (or above) the reorder level. If you have selected to show all items, those items with sufficient quantities (more quantities than the reorder level), will be displayed as a negative figure.

6.Purchase - Order - Quantities on order outstanding orders from creditors (suppliers) which are not yet confirmed (converted to Purchase documents.

7.Total Free on Hand - The quantities available.

No Options selected on the Reorder Options screen

An example of the Stock Reorder report, reflecting the details, is:

The details of this report are displayed in the following five (5) columns:

1.Stock Code - The selected Stock Item code will be displayed.

2.Description - The name or description of the selected Stock Item code.

3.Reorder Level - The minimum quantity of stock items which should be on hand, before you need to order or purchase any further stock items. This reorder level quantities is entered in the Reorder field on the Edit → Stock Items menu, or in the Input → Adjust Stock (Advanced tab) menu.

4.Qty On Hand - This is updated when documents are updated to the ledger. Purchases and Credit Notes, as well as any adjustments which increases the Stock quantities (stock in), will update the quantity on hand as a positive quantity. Invoices and Supplier Returns documents, as well as any adjustments will decrease the Stock quantities (stock out).

5.Difference - This quantity indicates the quantity of stock items available below (or above) the reorder level. If you have selected to show all items, those items with sufficient quantities (more quantities than the reorder level), will be displayed as a negative figure.

Created with the Personal Edition of HelpNDoc: Full-featured EBook editor