IT Rules!

by Ivan Radenkovic
  • Windows XP operating system
  • MS Access Project as frontend (client)
  • MS SQL as backend (server)

Project request was to create access database for follow-up it equipment movement from one user to another, stock to user or user to stock. I’ve decided to use accounting logic to keep balance of equipment in database all the time. Users and stock become positions (like accounts in ledger) but instead of amounts I’ve using quantities. Benefits of this approach is that you cannot lose any piece of equipment - for every equipment movement you have to enter two positions:

  • from (debit position in accounting terms)
  • to (credit position in accounting terms)

Now it’s become obvious that some position are of debit some others of credit nature. For example:

  • persons could receive equipments from stock or they could return equipments to the stock, but in any case they can return more equipments than they have;
  • suppliers/vendors will deliver new equipments to stock and since they are treated in a same way like persons or stock they will always be in debit - if you list equipment stock on suppliers positions, quantities will be negative;

 

Trackback