Purchasing > Exercise 6
  PPT
Exercise 6
Supplier Data
1 Use Supplier Data Maintenance (2.3.1) to review supplier contact information and other data for supplier 10S1002.
Click Next at the e-mail pop-up until you reach the Supplier Terms Data frame.
 
Field
Data
Supplier
10S1002
Name
Bridgeville Industries
Cr Terms
30D (1 month)
Partial OK
Unchecked
Verify that the Partial OK field is unchecked. Click Next until the Supplier field is highlighted, then click Back.
 
Supplier Items
Supplier items are used to cross-reference your item number with your supplier’s item number. You can also document the supplier’s quoted price for the item. Later, you can reference the supplier’s item number instead of your own on a purchase order, and the system will find your item number for you.
2 Use Supplier Item Maintenance (1.19) to create a record that cross-references your item numbers 60017 and 60018 to your supplier’s item numbers.
 
Field
Data
Item Number
60017
Supplier
10S1002
Supplier Item
SCC60017; click Next
Unit of Measure
EA
Supplier Lead Time
5
Currency
USD
Quote Price
0.49
Quote Qty
100
Update and exit the record.
 
Field
Data
Item Number
60018
Supplier
10S1002
Supplier Item
SCC60018; click Next
Unit of Measure
EA
Supplier Lead Time
5
Currency
USD
Quote Price
2.99
Quote Qty
100
Purchasing Control
3 Use Purchasing Control (5.24) and update settings as follows:
 
Field
Data
Ship To
10-100
PO Prefix
P10
Next PO
System Default
Receiver Prefix
R10
Next Receiver
System Default
Ln Format S/M
Single
PO Header Comments
No (unchecked)
PO Line Comments
No (unchecked)
Let all other fields default. Update and exit.
Create Purchase Orders for Component Items
4 Use Purchase Order Maintenance (5.7) to place an order for the components 60017 and 60018; all other components are already in inventory.
Purchase Order = [leave the purchase order number blank to default to the next number from Purchasing Control]
 
Field
Data
Purchase Order
Record for reference:
Supplier
10S1002; click Next
Order and Due Date will default to today’s date
 
Field
Data
Site
10-100 (used as a default for the line)
Credit Terms
30D (defaults from the supplier record)
Click Next twice.
Go to the line item data.
5 In the line item information, set up purchase order lines for each component for the calculated amount. Key fields to populate are:
 
PO Line
Site
Supplier Item No.
Qty Ordered
UM
Unit Cost
Line 1
10-100
SCC60017
100
EA
0.49
Line 2
10-100
SCC60018
100
EA
2.99
When you click Next after entering the supplier item, notice how the system switches the ordered item to your item number. This is because of the data you previously set up in Supplier Item Maintenance.
Notice the field Update Avg/Last Cost is checked. This indicates that when these items are received, the current cost of the item will be updated to reflect any difference between the last current cost and the prices on this PO. If you do not want this updated, you can uncheck this box and the current cost will not change.
6 When Ln 3 is highlighted click End Lines, Trailer, Next twice, then Back.
Record Receipts Against a Purchase Order
The supplier has sent the material you ordered for your components. Receive the items into inventory.
7 Use Purchase Order Receipts (5.13.1). Key fields to populate are:
 
Field
Data
Order
PO Number or use lookup (starts with P10); click Next
Supplier
Displays from the PO record
Packing Slip
Enter any number you want
Receiver
<blank>
Ship Date
<blank>
Receive All
Yes (Checked; very important for fast simple receipt)
Click Next 3 times, review each screen.
This will bring up a window showing the two line items from the PO. The data should look like this.
 
Line
Item
UM
Qty Open
Receipt Qty
1
60017
EA
100
100
2
60018
EA
100
100
If all the information is correct click Next.
This brings up a prompt: Display purchase order lines being received. Click Yes.
This brings up a frame with the receipt details that should look like this:
 
Ln
Item
Site
Location
Quantity
1
60017
10-100
020
100
2
60018
10-100
020
100
All items should be received into inventory location 020.
If all the information is correct, click Next, verify the data is correct when prompted, and clicking Yes completes the receipt transaction.
If you need to go back and fix something, click No, and you will have the opportunity to go back and fix any problems.
The last screen shows the trailer section. Be sure to click Next; otherwise, your receipt will not be saved.
8 Use Inventory Detail by Item Browse (3.2) to review the inventory levels for your component items. Enter the following search criteria:
 
Field
Operator
Data
Item Number
Starts At
60017
This selection criteria will display items beginning with those you received into site 10-100.
9 Use Transactions Detail Inquiry (3.21.1) to review the transactions you created when you did the receipt. The default transaction number that displays is for the last receipt (item 60018).
Scroll through the records you created in these activities by using the up and down arrows on your keyboard in the Transaction Number field. Look at the transaction type to understand what created the transaction.
Look at the GL detail and find the GL transaction number that was created for the last purchase order receipt. What accounts were debited and credited?