Po Master 06 25 09

  • Uploaded by: Norman May
  • 0
  • 0
  • October 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Po Master 06 25 09 as PDF for free.

More details

  • Words: 918
  • Pages: 10
File Name: 19137555.xls

Sheet Name: Instructions

Date: 06/27/2009 and Time: 15:09:18

PO Master 06_25_09 If you have any questions or comments, please contact: [email protected] Enter the percentage of tax applied to your PO > 0.00% If you want this workbook to automatically save before closing, check the box below Select the first empty cell and start entering the vendor information. Press the column heading in A to sort. It will sort alphabetically by column A. Enter a unique suffix for the vendor. A unique suffix is critical for the workbook to function properly.

Comments: [email protected]

Auto Save? FALSE

Page 1 of 10

File Name: 19137555.xls

Sheet Name: Instructions

Date: 06/27/2009 and Time: 15:09:21

Press the column heading in A & B to sort. The sorted column heading will change color.

Enter parts information on the next blank row then press the column A or B heading to sort. Notes can be added.

Comments: [email protected]

Enter the unique vendor suffix that corresponds to that vendor's parts. These will become the only selectable parts for that vendor on the Order sheet. If this column is completely empty, all of the parts listed will be available to all vendors.

Page 2 of 10

File Name: 19137555.xls

Sheet Name: Instructions

Date: 06/27/2009 and Time: 15:09:22

Select the desired vendor from the drop down. The vendor information will fill in automatically. Enter the Order Qty. The delivered quantity and date will be competed on the Look-Up sheet as the parts arrive.

The parts information will appear in the drop downs. Select the desired item. The Unit of Measure and Part Number will fill in automatically.

Comments: [email protected]

To finalize, press the "Copy This Sheets Contents To The History Sheet". The information from this sheet will be pasted on the next available row in the history sheet. The Order sheet will be reset and the PO number will increase by one.

Page 3 of 10

File Name: 19137555.xls

Sheet Name: Instructions

All of the information from the Order sheet will be stored and displayed in the history sheet. The information can be filtered if desired. Some header cells contain a subtotal formula that will display results of filtered data.

Comments: [email protected]

Date: 06/27/2009 and Time: 15:09:24

The text in this cell will change color and display a note if the Look-Up sheet contains History data. To clear the Look-Up sheet, select the blank in the drop down

Page 4 of 10

File Name: 19137555.xls

Sheet Name: Instructions

Date: 06/27/2009 and Time: 15:09:26

A finalized PO can be selected from the drop down, reviewed and modified. The Look-Up sheet uses the unique suffix to lookup vendor information. After reviewing, it can be e-mailed. The e-mail will automatically indicate the PO number in the subject line as well as a sheet named from the PO number in a new workbook that is sent as an attachment to the address in the E-Mail cell on the Address sheet. To clear the Look-Up sheet, select the blank line at the top of the drop down list. The data will be written back to the History sheet with any modifications.

Comments: [email protected]

Page 5 of 10

File Name: 19137555.xls Vendor Name

Sheet Name: Address Street Address

Comments: [email protected]

Date: 06/27/2009 City, State Zip Code

Contact

Email

Phone Number

Fax Number

Unique Suffix

Time: 15:09:30 Account Number

Page 6 of 10

File Name: 19137555.xls

Sheet Name: Parts Part Description

Comments: [email protected]

Date: 06/27/2009 Part Number

Unit of Measure

Unit Price

Notes

Time: 15:09:32 Vendor Suffix

Page 7 of 10

Bill to: Ship to:

Company Name Street Address City,State Zip Code

Phone 123-456-7890 Contact:

[email protected]

John Polk

[email protected]

Purchase Order Vendor:

Fax 123-555-5555

Bill Bailey ext. 123 Approved By

Please review this document and notify us with any questions, changes or discrepancies PO Number 00001The vendor cell is empty or no suffix was found

PO Date & Time 27-Jun-2009 03:09 PM

Contact:

Delivery Date

E-Mail:

Ship Via UPS Ground

Phone: Fax: Line

Order

Item Part

Unit of

Item

Qty

Number

Measure

Terms net 45 Requester: Description

Received

Received

Unit

Total

Back

Qty

Date

Price

Price

Order

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Total

Comments: [email protected]

-

File Name: 19137555.xls Line Item

Sheet Name: _History

Sheet Date & Time

Comments: [email protected]

Sheet Name

Date: 06/27/2009 and Time: 15:09:37 Requester:

OrderQty0

Item PartNumber

Unit of Measure

DescriptionNumber of Items = 0

Received Qty 0

ReceivedDate UnitPrice

TotalPrice0

BackOrder0

Page 9 of 10

Bill to: Ship to:

Company Name Street Address City,State Zip Code

Phone 123-456-7890 Contact:

[email protected]

John Polk

[email protected]

Purchase Order Vendor:

Fax 123-555-5555

Bill Bailey ext. 123 Approved By

Please review this document and notify us with any questions, changes or discrepancies PO Number PO Date & Time

Contact:

Delivery Date

E-Mail:

Ship Via UPS Ground

Phone: Fax: Line

Order

Item Part

Unit of

Item

Qty

Number

Measure

Terms net 45 Requester: Description

Received

Received

Unit

Total

Back

Qty

Date

Price

Price

Order

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Total Comments: [email protected]

-

Related Documents


More Documents from ""

Account Register 12 10 09
October 2019 27
Po Master 06 25 09
October 2019 17
Datasort12x1000
November 2019 13
Baseball Lineup 01 25 10
October 2019 14