One of the less noticeable but nonetheless important enhancements to be found in the upcoming CAPITAL V8 release, is a vastly expanded and more detailed stock movement audit trail system.

The existing Series 7 audit trail has a number of limitations:

• The stock movements audit trail report is transaction date driven. This can be misleading if users forward or backdate transactions, as stock on hand quantities and costs are always affected according to the current system date.
• Stock quantity movements are consolidated and presented as a total movement per day.

The new CAPITAL V8 stock movement audit trail now records changes to stock on hand and CIS (cost in store, which is normally equivalent to your average cost) on an event by event basis. This means that every action that can effect either of these values can now be individually traced and inspected. The audit trail also tracks all of the following additional information:

• The origin of the event. For example, CAPITAL Business Manager, CAPITAL Server Agent, CAPITAL Sales Force Manager, etc.
• A more detailed event code for each action that has an effect, i.e., direct adjustment/alteration by user, off-cut write-down, assembly build process, etc.
• The transaction number(s) involved in the event, if any.
• The transaction date and the system date and time of the event.
• The line reference of the transaction that effected stock.
• The account code of the transaction.
• The transaction quantity and physical stock quantity effected. (For example, it is possible to purchase in cartons of 100 but perhaps carry the item in stock in individual units or packs of 10. Both units are included in the audit trail.)
• The cost value of the units.
• A ‘snapshot’ of the resulting total stock on hand (‘Stock In’) quantity in stock control after the event has been processed.
• A ‘snapshot’ of the resulting total unit CIS/average cost after the event has been processed.
• The stock location of the stock item.
• Whether the item was a kit.
• The name of the user who initiated the event, of any.

With the introduction of this much more exhaustive and detailed audit trail tracking system we are hoping that users will find troubleshooting stock discrepancy issues considerably easier in the future.