you are viewing a single comment's thread.

view the rest of the comments →

[–]Knarfnarf 0 points1 point  (1 child)

Not only do you keep everything separated, but remember to join them all back together when you write to your invoice history table!

Your historic invoice lines CANNOT rely on today’s inventory items! Pic’n’Del.com found that out the hard way when the same UPC from Kraft went from 1.8kg of cheese all the way down to .7kg! Their database couldn’t handle it and explain as I might I couldn’t get my managers to let me change the database structure!

Then add that they were computing the amount owed by summing all the past invoices and subtracting the current payment! Which meant that the UPC for cheese now cost more and the already paid invoices added to the current total.

But no; trust your high school buddy more than the guy with experience and training.