Flawless procurement
data managed for you.
Info RecordEditGotoExtrasEnvironmentSystemHelp
✓
✕
ME1M
▶
IR
Create Info Record: General DataTexts
Info Record
VendorXYZ Limited
Material Group
Vendor Data
1st Rem./Exped.Days
2nd Rem./Exped.Days
Vendor Mat. No.
Vendor Subrange
Salesperson
Telephone
Origin Data
Certif. Cat.
Certificate
Valid to
Ctry of Origin
Region
Purchase Order Unit of Measure
Order Unit
Sorting
Sort Term
SAP System • Client 800
X
Supplier_PriceList_2026.xlsx - Excel−
□
×
HomeInsertPage LayoutFormulasDataReviewView
B2
fx
142.50
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Material No | Net Price | UoM | Valid From | Valid To | Vendor |
| 2 | MAT-9042-X | 142.50 | EA | 01.01.2026 | 31.12.2026 | V-100234 |
| 3 | MAT-7108-B | 88.20 | KG | 15.03.2026 | 14.09.2026 | V-100234 |
| 4 | MAT-3341-C | 310.00 | PC | 01.02.2026 | 31.07.2026 | V-100891 |
| 5 | MAT-5520-D | 47.80 | EA | 10.04.2026 | 09.10.2026 | V-100234 |
| 6 | MAT-2217-E | 195.00 | L | 01.01.2026 | 31.12.2026 | V-100512 |
| 7 |
Sheet1
Sheet2
+
Power BIPurchasing Performance
Days Inventory Outstanding
46 days
Total Costs
$61.03M
Days Payable Outstanding
20 days
17.68%
Rejection Rate
65.40%
On-Time Delivery
$299.61M
Total Net Sales
114,340
Total Orders
Cost Distribution
Order Picking
Quality Control
Receiving
Shipping
Inventory Transport Warehousing Service
Perfect Orders by Warehouse
Warehouse 5
Warehouse 4
Warehouse 3
Warehouse 2
Warehouse 1
SAP Business One10.0 FP 2302
Purchasing>Purchase Order
Purchase Order - 4500012847
VendorV-100234
Posting Date01.07.2026
NameXYZ Limited
Delivery Date15.07.2026
Contents
Logistics
Accounting
| # | Item No. | Description | Qty | Unit Price | Total |
|---|---|---|---|---|---|
| 1 | MAT-9042-X | Hex Bolt M10x40 | 500 | 142.50 | 71,250.00 |
| 2 | MAT-7108-B | Copper Wire 2.5mm | 250 | 88.20 | 22,050.00 |
| 3 | MAT-3341-C | Bearing SKF 6205 | 100 | 310.00 | 31,000.00 |
Subtotal124,300.00
Tax (18%)22,374.00
Total146,674.00 USD
Status: OpenSAP Business One 10.0
snowflake
ACCOUNTADMINCOMPUTE_WH
procurement_audit.sql
+
PROCUREMENT_DB.PUBLIC • Settings
1
2
3
4
5
6
7
8
9
10
11
SELECT
po.po_number,
po.vendor_id,
po.material_no,
po.net_price,
ir.info_record_price,
(po.net_price - ir.info_record_price) AS variance
FROM purchase_orders po
INNER JOIN info_records ir
ON po.material_no = ir.material_no
WHERE po.net_price <> ir.info_record_price;
ResultsChart
| PO_NUMBER | VENDOR_ID | NET_PRICE | VARIANCE |
|---|---|---|---|
| 4500012847 | V-100234 | 142.50 | -3.20 |
| 4500012901 | V-100891 | 310.00 | +12.00 |
| 4500013002 | V-100512 | 195.00 | -7.50 |
Query duration: 476msRows: 3
oracle@procurement-db ~ SQL*Plus
SQL*Plus: Release 21.0.0.0 - Production on Thu Jul 01 14:22:38 2026
Connected to: Oracle Database 19c Enterprise Edition
Session altered.
SQL> SELECT vendor_id, material_no, contract_price,
po_price, (po_price - contract_price) AS delta
FROM procurement.purchase_audit
WHERE ABS(po_price - contract_price) > 5
ORDER BY delta DESC;
VENDOR_ID MATERIAL_NO CNTRCT_PRC PO_PRICE DELTA
---------- ------------- ---------- ---------- --------
V-100891 MAT-3341-C 298.00 310.00 +12.00
V-100512 MAT-2217-E 187.50 195.00 +7.50
V-100234 MAT-5520-D 42.00 47.80 +5.80
V-100234 MAT-9042-X 148.00 142.50 -5.50
4 rows selected.
SQL> _
oracle@procurement-db:1521/ORCLElapsed: 00:00:00.08
Info RecordEditGotoExtrasEnvironmentSystemHelp
✓
✕
ME1M
▶
IR
Create Info Record: General DataTexts
Info Record
VendorXYZ Limited
Material Group
Vendor Data
1st Rem./Exped.Days
2nd Rem./Exped.Days
Vendor Mat. No.
Vendor Subrange
Salesperson
Telephone
Origin Data
Certif. Cat.
Certificate
Valid to
Ctry of Origin
Region
Purchase Order Unit of Measure
Order Unit
Sorting
Sort Term
SAP System • Client 800
X
Supplier_PriceList_2026.xlsx - Excel−
□
×
HomeInsertPage LayoutFormulasDataReviewView
B2
fx
142.50
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Material No | Net Price | UoM | Valid From | Valid To | Vendor |
| 2 | MAT-9042-X | 142.50 | EA | 01.01.2026 | 31.12.2026 | V-100234 |
| 3 | MAT-7108-B | 88.20 | KG | 15.03.2026 | 14.09.2026 | V-100234 |
| 4 | MAT-3341-C | 310.00 | PC | 01.02.2026 | 31.07.2026 | V-100891 |
| 5 | MAT-5520-D | 47.80 | EA | 10.04.2026 | 09.10.2026 | V-100234 |
| 6 | MAT-2217-E | 195.00 | L | 01.01.2026 | 31.12.2026 | V-100512 |
| 7 |
Sheet1
Sheet2
+
Power BIPurchasing Performance
Days Inventory Outstanding
46 days
Total Costs
$61.03M
Days Payable Outstanding
20 days
17.68%
Rejection Rate
65.40%
On-Time Delivery
$299.61M
Total Net Sales
114,340
Total Orders
Cost Distribution
Order Picking
Quality Control
Receiving
Shipping
Inventory Transport Warehousing Service
Perfect Orders by Warehouse
Warehouse 5
Warehouse 4
Warehouse 3
Warehouse 2
Warehouse 1
SAP Business One10.0 FP 2302
Purchasing>Purchase Order
Purchase Order - 4500012847
VendorV-100234
Posting Date01.07.2026
NameXYZ Limited
Delivery Date15.07.2026
Contents
Logistics
Accounting
| # | Item No. | Description | Qty | Unit Price | Total |
|---|---|---|---|---|---|
| 1 | MAT-9042-X | Hex Bolt M10x40 | 500 | 142.50 | 71,250.00 |
| 2 | MAT-7108-B | Copper Wire 2.5mm | 250 | 88.20 | 22,050.00 |
| 3 | MAT-3341-C | Bearing SKF 6205 | 100 | 310.00 | 31,000.00 |
Subtotal124,300.00
Tax (18%)22,374.00
Total146,674.00 USD
Status: OpenSAP Business One 10.0
snowflake
ACCOUNTADMINCOMPUTE_WH
procurement_audit.sql
+
PROCUREMENT_DB.PUBLIC • Settings
1
2
3
4
5
6
7
8
9
10
11
SELECT
po.po_number,
po.vendor_id,
po.material_no,
po.net_price,
ir.info_record_price,
(po.net_price - ir.info_record_price) AS variance
FROM purchase_orders po
INNER JOIN info_records ir
ON po.material_no = ir.material_no
WHERE po.net_price <> ir.info_record_price;
ResultsChart
| PO_NUMBER | VENDOR_ID | NET_PRICE | VARIANCE |
|---|---|---|---|
| 4500012847 | V-100234 | 142.50 | -3.20 |
| 4500012901 | V-100891 | 310.00 | +12.00 |
| 4500013002 | V-100512 | 195.00 | -7.50 |
Query duration: 476msRows: 3
oracle@procurement-db ~ SQL*Plus
SQL*Plus: Release 21.0.0.0 - Production on Thu Jul 01 14:22:38 2026
Connected to: Oracle Database 19c Enterprise Edition
Session altered.
SQL> SELECT vendor_id, material_no, contract_price,
po_price, (po_price - contract_price) AS delta
FROM procurement.purchase_audit
WHERE ABS(po_price - contract_price) > 5
ORDER BY delta DESC;
VENDOR_ID MATERIAL_NO CNTRCT_PRC PO_PRICE DELTA
---------- ------------- ---------- ---------- --------
V-100891 MAT-3341-C 298.00 310.00 +12.00
V-100512 MAT-2217-E 187.50 195.00 +7.50
V-100234 MAT-5520-D 42.00 47.80 +5.80
V-100234 MAT-9042-X 148.00 142.50 -5.50
4 rows selected.
SQL> _
oracle@procurement-db:1521/ORCLElapsed: 00:00:00.08
Info RecordEditGotoExtrasEnvironmentSystemHelp
✓
✕
ME1M
▶
IR
Create Info Record: General DataTexts
Info Record
VendorXYZ Limited
Material Group
Vendor Data
1st Rem./Exped.Days
2nd Rem./Exped.Days
Vendor Mat. No.
Vendor Subrange
Salesperson
Telephone
Origin Data
Certif. Cat.
Certificate
Valid to
Ctry of Origin
Region
Purchase Order Unit of Measure
Order Unit
Sorting
Sort Term
SAP System • Client 800
X
Supplier_PriceList_2026.xlsx - Excel−
□
×
HomeInsertPage LayoutFormulasDataReviewView
B2
fx
142.50
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Material No | Net Price | UoM | Valid From | Valid To | Vendor |
| 2 | MAT-9042-X | 142.50 | EA | 01.01.2026 | 31.12.2026 | V-100234 |
| 3 | MAT-7108-B | 88.20 | KG | 15.03.2026 | 14.09.2026 | V-100234 |
| 4 | MAT-3341-C | 310.00 | PC | 01.02.2026 | 31.07.2026 | V-100891 |
| 5 | MAT-5520-D | 47.80 | EA | 10.04.2026 | 09.10.2026 | V-100234 |
| 6 | MAT-2217-E | 195.00 | L | 01.01.2026 | 31.12.2026 | V-100512 |
| 7 |
Sheet1
Sheet2
+
Power BIPurchasing Performance
Days Inventory Outstanding
46 days
Total Costs
$61.03M
Days Payable Outstanding
20 days
17.68%
Rejection Rate
65.40%
On-Time Delivery
$299.61M
Total Net Sales
114,340
Total Orders
Cost Distribution
Order Picking
Quality Control
Receiving
Shipping
Inventory Transport Warehousing Service
Perfect Orders by Warehouse
Warehouse 5
Warehouse 4
Warehouse 3
Warehouse 2
Warehouse 1
SAP Business One10.0 FP 2302
Purchasing>Purchase Order
Purchase Order - 4500012847
VendorV-100234
Posting Date01.07.2026
NameXYZ Limited
Delivery Date15.07.2026
Contents
Logistics
Accounting
| # | Item No. | Description | Qty | Unit Price | Total |
|---|---|---|---|---|---|
| 1 | MAT-9042-X | Hex Bolt M10x40 | 500 | 142.50 | 71,250.00 |
| 2 | MAT-7108-B | Copper Wire 2.5mm | 250 | 88.20 | 22,050.00 |
| 3 | MAT-3341-C | Bearing SKF 6205 | 100 | 310.00 | 31,000.00 |
Subtotal124,300.00
Tax (18%)22,374.00
Total146,674.00 USD
Status: OpenSAP Business One 10.0
snowflake
ACCOUNTADMINCOMPUTE_WH
procurement_audit.sql
+
PROCUREMENT_DB.PUBLIC • Settings
1
2
3
4
5
6
7
8
9
10
11
SELECT
po.po_number,
po.vendor_id,
po.material_no,
po.net_price,
ir.info_record_price,
(po.net_price - ir.info_record_price) AS variance
FROM purchase_orders po
INNER JOIN info_records ir
ON po.material_no = ir.material_no
WHERE po.net_price <> ir.info_record_price;
ResultsChart
| PO_NUMBER | VENDOR_ID | NET_PRICE | VARIANCE |
|---|---|---|---|
| 4500012847 | V-100234 | 142.50 | -3.20 |
| 4500012901 | V-100891 | 310.00 | +12.00 |
| 4500013002 | V-100512 | 195.00 | -7.50 |
Query duration: 476msRows: 3
oracle@procurement-db ~ SQL*Plus
SQL*Plus: Release 21.0.0.0 - Production on Thu Jul 01 14:22:38 2026
Connected to: Oracle Database 19c Enterprise Edition
Session altered.
SQL> SELECT vendor_id, material_no, contract_price,
po_price, (po_price - contract_price) AS delta
FROM procurement.purchase_audit
WHERE ABS(po_price - contract_price) > 5
ORDER BY delta DESC;
VENDOR_ID MATERIAL_NO CNTRCT_PRC PO_PRICE DELTA
---------- ------------- ---------- ---------- --------
V-100891 MAT-3341-C 298.00 310.00 +12.00
V-100512 MAT-2217-E 187.50 195.00 +7.50
V-100234 MAT-5520-D 42.00 47.80 +5.80
V-100234 MAT-9042-X 148.00 142.50 -5.50
4 rows selected.
SQL> _
oracle@procurement-db:1521/ORCLElapsed: 00:00:00.08
Clean procurement data shouldn't require a bloated headcount or overpriced consultants.
PROQRA pairs deep supply chain expertise with custom software automation. We maintain your ERP data flawlessly in real-time, giving your team their time back while keeping systems perfectly clean.
WHAT WE DO
Less administration. More execution.
01
Daily Order Execution
We take over the manual PR-to-PO grind and routine supplier follow-ups so your team can focus purely on strategy and negotiation.
02
ERP Data Management
We clean your master data, fix outdated material records, and maintain your vendor database so your team can finally trust the system.
03
Live MI Reporting
We replace outdated spreadsheets with custom, real-time dashboards that show exactly where your money is going and where delays are happening.
We manage the background data. You drive the strategy.
Stop losing time to repetitive supply chain tasks and ERP hygiene.
Book a quick discovery call to discuss your current supply chain bottlenecks, and let's map out exactly how much manual work we can take off your plate..