Goods Received (Continued)

The MSD Goods Received Database can be used as a standard feature for the day to day running of the inventory department. A lot of companies generate an internal GRN number for each delivery accepted by the company. The MSD Goods Received Database will hold the following details;

GRN Number
This is the unique Index, system generated in sequential order.

Advice Note Number
This is the suppliers advice/delivery note number. · Delivery Date This is the delivery date when the item was delivered

Source Delivery source.
This is generated by the system and it is the source module for this delivery, i.e. Stock.

Item Number
This is the stock line number as held in the Sage Line 100 Stock Control.

Item Description
This is the stock line description for the stock item as held in the Sage Line 100 Stock Control.

Purchase Order Number If applicable.
This is the purchase order number used in either the Sage Line 100 Purchase Order Processing or MSD Purchase Order Processing.

Supplier Number
This is the supplier number as held in the Sage Line 100 Purchase Ledger for this delivery.

Supplier Name
This is the supplier name as held in the Sage Line 100 Purchase Ledger for this delivery.

Depot
This is the depot which the stock lines were booked into.

Quantity
This is the quantity for this depot, for this item line for this delivery. MSD Goods Received Database Report This report will display the delivery history. The user enters a date range and can select to display the information by Item, Supplier or the Goods Received Number. The following fields will be displayed:- GRN Number, Advice Note Number, Delivery Date, Source, Item Number, Item Description, Purchase Order Number, Supplier Number, Supplier Name, Depot, and Quantity. The report will print in date order then either by Item, Supplier or GRN Number depending on the selection made when the report was generated. MSD Goods Received Database Clear Down Routine There will be a routine provided for the user to clear down the MSD Goods Received Database entries from the MSD Goods Received Database File. The system will generate an audit report detailing the Goods Received history removed. The user can clear the MSD Goods Received Database history by a single GRN number, a range of GRN numbers or by a single date or date range. The system will automatically spool an audit report.

MSD Goods Received Database History Clear Down Audit Report
When the user clears items from the MSD Goods Received Database history an audit report will be spooled automatically. The report will show the following fields and print in Date order. GRN Number, Advice Note Number, Delivery Date, Source, Item Number, Item Description, Purchase Order Number, Supplier Number, Supplier Name, Depot, and Quantity.

Links To Sage Line 100
The MSD Goods Received Database links to the Sage Line 100 data files in certain areas. The purpose of these links is to access the relevant information from the Sage Line 100 data files and to use this MSD Goods Received Database; thus saving the user valuable time in data entry. The links will also check the validity of the data entered and ensure that by utilising the data already set up within Sage Line 100, the data entered, reports and enquiries are uniform. The Sage Line 100 links are described in the following sections.

Sage Line 100 Purchase Ledger
The MSD Goods Received Database will use the Sage Line 100 Purchase Ledger to obtain the Supplier's Number, Name and transaction details for each delivery processed.

Sage Line 100 Purchase Order Processing
The MSD Goods Received Database will use the Sage Line 100 Purchase Order Processing to obtain the Supplier's Number, Name, Purchase Order Number and transaction details for each delivery processed. The MSD Goods Received Database will use the MSD Purchase Quick Ordering System to obtain the Supplier's Number, Name, Purchase Order Number and transaction details for each delivery processed.

Sage Line 100 Stock Control
The MSD Goods Received Database will use the Sage Line 100 Stock Control to obtain the Stock Code, Stock Code Description and Depot.