AVProcure

📊

Open Procurement Excel Workbook

Click or drag & drop your .xlsx workbook.
Product catalog and existing inventory load automatically.
Save to Workbook writes changes back to the file.

0 SKUs

0 units

0 serialized

0 bulk

⌕

	SKU	Manufacturer	Model	Qty	Par	Type	Serial Number	Condition	Status	Location	Project

Manufacturer

Model

SKU (auto)

Type

Qty

Serial Number

Location

Condition

Inv Status

Project

Notes

⊕

Batch Add — Serialized Items

Quantity

serialized units · fill in serial numbers below. All other fields (location, condition, status, project, notes) are copied from the main form.

◈

Open a workbook first

0 products

0 manufacturers

0 categories

⌕

SKU	Manufacturer	Model	Category	MSRP	Cost	Price

Manufacturer *

Model *

Category *

Subcategory

SKU (auto-generated)

MSRP ($)

Unit Cost ($)

Unit Price ($)

URL

SKU is auto-generated from category + manufacturer codes. You can type a new manufacturer — it will be added and assigned a code automatically.

◫

Open a workbook first

0 projects

0 open

0 in progress

0 complete

⌕

Project ID	Project Name	Client	Status	Contract Value	Start	Target	Items

Project ID (auto)

Project Name *

Client First Name

Client Last Name

Address

Phone

Status

Contract Value ($)

Start Date

Target Completion

Notes

Contract

Scope Total

Scope

Purchase Orders

SKU	Manufacturer	Model	Qty Needed	Qty on PO	Qty Rec.	Status	Unit Cost	Unit Price	Line Total	Inv Status	PO #	Notes

Manufacturer

Model

SKU (auto)

Qty

Unit Cost ($)

Unit Price ($)

Notes

PO #	Vendor	Status	Date	Total	Items	Scope

Edit Project

Project Name

Client First Name

Client Last Name

Address

Phone

Status

Contract Value ($)

Start Date

Target Completion

Notes

◉

Open a workbook first

All Orders

Backordered

0 POs

0 submitted

0 backordered

0 received

⌕

PO #	Vendor	Project	Status	Date	Total Value	Items

PO Number *

Vendor *

Project (optional)

Status

Date

Shipment

Notes

Total

Outstanding

SKU	Model / Description	Qty Ord.	Qty Rec.	Outstanding	Unit Price	Line Total	Status	Date Received

Manufacturer

Model

SKU (auto)

Qty

Unit Price ($)

Notes

Receive Shipment

Enter the quantity received for each line item. Leave at 0 if not yet received.

Review Imported POs

Review each PO and its line items. Unmatched items can be added to the Pricebook inline.

New Purchase Order

PO Number *

Vendor *

Date

Shipment

Status

Notes

Line Items

Project Scope ✓ Check items to include → set qty & price → click Create PO

Manufacturer

Model

SKU (auto)

Qty

Unit Price ($)

Description *

Qty

Unit Price ($)

PO Total:

$0.00

Edit Purchase Order

Vendor *

Status

Date

Shipment

Project

Notes

Edit Line Item

Manufacturer

Model

SKU

Qty Ordered

Unit Price ($)

Description / Notes

↩

Open a workbook first

0 RMAs

0 open

0 shipped

0 received

⌕

RMA ID	Type	Project	SKU	Manufacturer	Model	Qty	Vendor	Status	Opened

RMA ID (auto)

Type *

Manufacturer *

Model *

SKU (auto)

Qty

Project

Vendor

Status

Date Opened

Reason / Notes *

Reason / Notes

Edit RMA

Type

Status

Vendor

Qty

Date Opened

Date Closed

Reason / Notes

⬢

Open a workbook first

0 items

0 at par

0 low

0 out

⌕

Manufacturer	Model	Category	Qty on Hand	Par	Need to Order	Status	On Order	Notes	Last Received

⬡

Open a workbook first

0 warehouses

0 locations

0 staging

⇄

Transfer Item

From Project

—

Qty to Move

To Project (optional — leave blank to relocate within same project)

From Location

—

To Location (optional)

Transfer Note (optional)