Sounds like you need a Fact table for Parts Inventory and 2 dimensions, Customer and Parts, that are conformed to the Sales fact table.

Check out Kimball's website for more ideas about a snapshot fact table for inventory.

http://www.kimballgroup.com/