RECEIVING MODULE
8.1.1 New (Enter A New Receiver)
Allows users to enter a new receiver into the Receiving Database File. pc/MRP will display the next available Receiver Number and ask if you wish to scroll the PO file. If users answer Yes they will be allowed to scroll the PO file by either PO Number, Account Number, or Part Number. If users answer No, pc/MRP will display the most recent PO Number and Item Number. You can write over these numbers and write in the desired Receiver and PO Numbers. The Receiver Number should consist of only numeric characters with leading zeros. pc/MRP is unable to increment alpha characters.
Part Number, Description, Manufacturer, Model Number, Vendor, Address, Order Quantity, Unit, Cost, Terms, Account Number, Trade Discount, Tax Rate, Div, and Freight are entered automatically from the PO and can be written over if no longer correct. The RECEIVED BY field is automatically populated by the user name and time.
If a file named RECSCOST.FLG exists pc/MRP will automatically refresh the standard cost field from the Inventory.
If configuration settings and utilities option 16 is set to enable dynamic stock locations pc/MRP will allow you to assign a new stock location for a part number if there are none in stock.
Part number data from inventory can be viewed in the receiver by pressing F1.
Quantity Received should be entered by the computer operator. Freight Bill Number, Collect, Delivered To, and Inspected By will give your Receiving Logs valuable information.
The comments field can be used to store additional information such as weight, number of packages, etc.
If the freight charge is invoiced separately enter the freight invoice number in the Freight Bill Number field.
pc/MRP automatically enters the Date Received. The Pay Date (normally 30 days after the date received), Vendor Invoice Number, and Freight are usually entered by accounting when the vendor sends the invoice (accounting will inspect and edit the receiver).
|
Receiver Data Entry Screen |
The Related Document Field is a 23 character scrollable field. It can be used to enter a related contract number, serial number, sales order number, etc.
Date Received is automatically entered and is used by the Accounting Module in aging the Accounts Receivables Records. It is also the date used to determine which of the receiving records to delete with the "Delete all receiving records over x years old."
The entire amount for the Freight, if known, can be entered once in one line item in the freight field or entered individually for all line items. The freight totals for all line items will be totaled and printed out on the forms and reports.
The Debit/Charge Number is not used by pc/MRP's accounting program at this time.
Once the new receiving record has been entered, pc/MRP will update the quantity received, date received, on time delivery, and complete field in the purchasing record. It will automatically increase the quantity on hand and decrease the quantity on order in inventory, provided pc/MRP has been configured to do so with Configuration, Settings and Utilities Option 4. If a receiver is over received pc/MRP will decrement the quantity on order in inventory but it will not take the onorder quantity negative.
|
If the new cost > 0 and quantity received > 0 and the old cost >= 0 and the quantity on hand >= 0, the average cost of the part will be recalculated based on the formula below: (original avecost x quantity onhand) + (new cost x quantity recreived) quantity on hand + quantity received |
If the old cost = 0 then the average cost will = the new cost including any discount.
Option 50 in pc/MRP's configuration menu allows you to include alternate area quantities and WIP quantities in the above formula. The option to add alternate area quantities and WIP quantities was added to pc/MRP versions 6.73AQ and 6.78AG and higher.
If you have pc/MRP version 6.51 or higher and have activated the serial/lot number module, pc/MRP will ask "Enter serial/lot numbers ". If you answer Y, you will be prompted to enter the quantity and serial/lot number of the part number you are receiving. This will append a new serial/lot number record to snlotdet.dbf detail file. It will also update the quantity or append a new record in the snlot.dbf master file. If you are receiving multiple serial numbers for the same part number, answer Y when prompted to "Enter another serial/lot number for this part number"
If the item you are receiving is an assembly and you are not using Inventory Adjustment Method S, pc/MRP will ask if you wish to Increase the onhand quantity of the assemblies or Convert parts to assemblies (increase assemblies & decrease onhand quantity of the parts). You will also have the options to run a cost roll-up and or sales price markup.
With version 6.82 and higher if the items you are receiving are assemblies and the configuration option 47 allows you to do cost roll-ups, pc/MRP will ask if you wish to do a cost roll-up and or a sales price mark-up. Be aware that if you turn off option 47 in the Configuration/Settings and Utilities this will also turn off the Inventory cost-roll-up option.
If the PO item has already been received pc/MRP will generate a warning allowing the user to continue or cancel.
Once the initial line item has been received pc/MRP will prompt:
Enter R to receive and additional item.
Enter A if all of the line items on the original PO are to be received on this receiver.
Enter F if you are finished.
After all the line items have been entered for a receiver pc/MRP will automatically debit and credit the general ledger if it is configured to do so (auto accounting on).
8.1.2 Edit/View (Scroll/Delete/Undelete Receiver Line Items)
This option will allow you to scroll, edit, delete or undelete receivers, and choose the sort order you wish to scroll the database by. Enter the first several characters you wish to begin scrolling at and press "OK". Use the arrow keys to scroll up or down the list. When the desired record is located, press enter to call the record up for view/edit. If it is the wrong record, enter N to continue scrolling. If it is the correct record enter [Rtn] or Y to view and or edit the record.
If users edit the quantity received in a receiver users must:
1. edit the quantity received in the PO record
2. edit the complete field in the PO record to be Y or N if the status of the purchase order has changed
3. edit the inventory area quantity representative of the quantity change
The reason pc/MRP doesn't edit other files automatically is that if the other files were edited first, your edit would then re-adjust the previous edit. This could create an endless loop of confusion. To edit the address, simply edit the address in the first line item.
To add an additional item to an existing receiver do not use the edit module. Instead, use the "Enter new receiver" option by typing in the original receiver and PO numbers and the line item number from the PO you are receiving.
The Complete, Amount Paid, and Check Number Fields are displayed only in the edit mode and are filled in automatically when Accounting records a payment towards this debt. The Amount Paid Field contains the accumulative amount paid. pc/MRP uses the Complete Field to determine if a record is open or closed. A Y in the Complete Field marks the record as closed. A N in the Complete Field marks the record as open.
The POSTED field is displayed only in the edit mode and is filled in automatically with a Y when accounting enters the initial general ledger I (accounts payable) transaction.
Use the delete button to mark a record for deletion with the Windows version of pc/MRP. Once the record has been marked for deletion, return to the menu and select REMOVE ALL DELETED RECORDS FROM DISK AND REINDEX.
When you finish editing line item #1, pc/MRP will ask 'Update header information on all line items'. If you answer Yes, the header vendor data, posted, date received, received by, vendor invoice #, ship via, delivered to, terms, paydate, account #, div, purchase req #, freight bill #, and related document number fields will be updated in all remaining line items.
8.1.3 Print/Email Receiver
This option will print, display, send to e-mail, or send the receiver to an HTML document to attach the receiver to an e-mail. Through the use of programs like WINFAX users can also directly fax from pc/MRP. The Receiver is (rec.frx) Furthermore, if the flag file DMMAILLB.FLG exists an address label for the vendor on that receiver will automatically be created from the CUSTARD*.LBX or the CUSARD*.LBX.
Note: If you send an e-mail directly from pc/MRP we use MS Outlook. The e-mail address in MS Outlook will automatically be populated from the e-mail entry in the pc/MRP Address Book. If you create an HTML document, you can save this document and attach it to an e-mail created in your existing e-mail program.
For laser printers
|
You can order the 3 part NCR carbonless paper by calling JC Paper in Mt. View, CA at (650)965-0983. Ask for the zero-form, straight sequence 3 part NCR pre-collated 8-1/2" X 11" paper. It comes in sets per package. |
8.1.4 Reports (Printout/Display Receiver Reports)
Selection 4 allows you to print out or display various reports from the Receiver Database File. See section 15.4.1 to create custom reports. Your standard report options are as follows:
All receiver records
(reclog.frx and custrec*.frx with receive.dbf)
All receiver records for a product code
All receiver records for a part number
All receiver records for a vend/cust account #
All receiver records for a document/contract #
All receiver records for a div/dept
All receiver records for a model number
All receiver records for a serial number
All receiver records for a purchase order number
All receiver records for a receiving agent
All receiver records for a debit/charge #
All receiver records for a requestor
Any
of the above can include the following:
Matching Exact: This selection allows you to find receiver records by using the exact receiver record number, product code, part number, vend/cust account #, document/contract #, div/dept, model number, serial number, purchase order number, purchasing agent, debit/charge #, or requestor. It will display/print/send only those records.
Matching Partial: This selection allows you to find receiver records by using a partial description of the receiver record number, product code, part number, vend/cust account #, document/contract #, div/dept, model number, serial number, purchase order number, purchasing agent, debit/charge #, or requestor. It will display/print/send all receiver records matching the partial description.
Any of the above can include:
Open and closed (all records)
Open records only (total quantity not received Complete # Y)
Closed records only (quantity received Complete = Y)
Overdue records only
Any
of the above can include:
All records regardless of time period
Records entered during a specified time period
Records due during a specified time period
Records exactly 30, 60, and 90 days old
Any
of the above may be sorted by:
Receiver Number (faster no re-indexing)
Part number (faster no re-indexing)
Account number (faster no re-indexing)
Part number root
Date entered
Division
Document/Contract #
Date due
Model number
Product code
PO number
Debit/Charge #
Requestor
Vendor invoice #
Vendor + vendor invoice #
The
report output options include:
Displayed
on screen
Printed in narrow carriage format
Printed in wide carriage format
Sent to a comma delimited ASCII file
HTML file
Sent
to a XLS file
Sent to a DBF file
If the Database, Comma Delimited or ASCII output options are chosen, pc/MRP will create a file of that type which contains all of the raw data used by the report. If you have the Windows Generic Print Driver installed, you may select one of the Print output options. Then select Print to File to generate a text file, which mirrors the actual report. Any portion of the printed report, which normally appears in bold, will be included in the text file three times. You may edit the report forms to remove the bolding and prevent the duplication. See Configuration, Settings & Utilities, option 24.
The
report format options include:
Standard format
Custom format (see custom report section)
8.1.5 Labels
This option will function the same as printing a label for a receiver in the inventory module, see section 5.1.7.
8.1.6 Index
Re-indexes the receiving index files. pc/MRP automatically updates its index files under normal operation. However, if you ever get a "record out of range" error message or can not find a specific receiver, re-indexing the index file is usually the cure.
8.1.7 Remove Marked Records
Removes all receiving records marked for deletion from the disk. The records will no longer be recoverable.
8.1.8 Remove Over X Years
Deletes and removes from the disk all Receivers over a specified number of years old. Prior to running this command it is advisable to save the Receiver Database File to disk and label it "Receiver DBF as of mm-dd-yr". You should also generate a printout of the file prior to closing it out.