Nicks AP Store

Enter the store access code to open the website.

Connecting to local SQL

This site runs on the SQL computer and only uses the local database. People outside the store still open the website; they never talk to SQL directly.

Nicks AP Store
SQL

Search / Edit

Scan a UPC or type a part number. Click a cell to edit, same as the desktop app.

View In-Stock Items

Export Excel

Inventory Audit

Different UPCs with the same part number count as the same inventory item.

Scan a location to begin.

Found Items

Scan a found UPC. Matching shortages use part number, so a different supplier UPC can satisfy the same missing part.

Ready to scan a found item.

Past Sales

Investment / Profit

Current investment is Items.Cost × on-hand quantity. Realized profit uses the cost snapshot stored with each sale.

Receive Stock

Scan a barcode to begin.

Import Receipt PDF

Nellis landed cost = line cost × 1.2449. Imported part numbers stay Pending until you receive them.

Sell Items

Scan an item to add it to this sale.

-

Current Sale

$0.00