Track materials. Cross check purchases with supplier invoices

Currently maintaining materials purchased on an Excel spreadsheet.
Below are activities, but it might be easier, if I provide the following:
(a) Our spreadsheet with all details held
(b) Supplier1: Fabric KNITTER PO and Invoice
(c) Supplier2: Fabric DYER PO and Invoice

Summary of activities as follows:
==========================
(1) We raise PO to order X GREIGE (ie undyed) fabric rolls and KG of a specific type of fabric

(2) Supplier1 (ie fabric knitting company) supplies Y number of GREIGE rolls of fabric
(a) May take several deliveries to deliver all the GREIGE Rolls of fabric.
(b) For each delivery, KNITTER provides a different KNITTER'S PO.

(3) Then Z number of GREIGE rolls of fabric sent to Supplier2, the DYERS:
(3a) The DYERS dye the GREIGE fabric different colours (ie becomes finished DYED fabric)
(3b) The DYERS deliver finished DYED fabric, in different quantities, as per as and when it is ready.
DYERS PO provided with every delivery

(3c) Info: There could remain X-(Y+Z) GREIGE rolls of fabric with the dyers (that we are unaware of)
(3d) Info: GREIGE Rolls can be dyed a variety of colours, as per our PO to the dyers

(4) Following needs checking:
(4a) KG and number of rolls of GREIGE fabric supplied by KNITTERS
(4b) KG and number of rolls of FINISHED fabric supplied by DYERS
(4c) YIELD per Roll of dyed fabric (ie calculated by taking PO, then metres dyed per KG of GREIGE Roll).

(5) Match KNITTERS Invoice to KNITTERS PO
--> Check IF all GREIGE fabric has been delivered

(6) Match DYERS Invoice to DYERS PO
--> Also IF check all dyed fabric has been delivered

(7) Identify GREIGE Rolls of fabric with the DYERS (yet to be dyed)

(8) Be able to search database on the following:
(8a) Ragvalley PO
(8b) KNITTERS PO and/or Invoice
(8c) DYERS PO and/or Invoice

There are other activities, but it will make more sense once further information is provided.
Currently we do not need a database, as mentioned, only use Excel spreadsheet.

Other - LAB DIPS to match Pantone colour:
===================================
Sometimes customers ask us to match a specific shade of colour for a specific fabric. This activity is performed by the dyers. The lab dips need to be tracked

ORDERS GIVEN TO DYERS:
======================
All orders and details of each order given to Dyers, need to tracked

IDENTIFY PAYMENTS MADE and OUTSTANDING FOR BOTH GREIGE & DYED FABRIC:
=====================================================================
Match KNITTERS & DYERS statement with purchases made from both
(system should also show greige fabric that has been paid and is outstanding)