Item Maintenance: Audit Tab
The item's transactional details are displayed in this Tab. Within the order grid the item's SOH, On Order and On Hold quantities are tracked. By double clicking the the Ref #cells will open the program and batch that the audit record was apart of. For example, double clicking on Sales ID number in the Ref # grid, this will launch CSP audit and automatically load the target sales into search results.
Smart Grid Tools. In any grid (Tan Boxed Headings above data) throughout the system users can right click to sort, export to Excel, best fit columns & print content. In addition users can right click on a heading and customise columns and hide unwanted fields which will be remembered against the user login. Column orders can be easily moved by using the drag and drop function to suit their own preference and again this is remembered against the user login.
Item Audit Tab Troubleshooting Tips
1. The Audit Tab can be used as a go-to reference for any query relating to items purchase, receipt and transaction history.
2. Use 'Customise Columns' to view information needed.
For help on the Customise Columns function, see here.
Date, Action, Ref# and On Order are quiet useful along with any details associated with cost.
3. Searching Action Column can filter results for Sale, POrder, Invoice, Return Sale etc
Double clicking Ref# for action required will open relevant POS program to view extra details.
Foe example- if you receive stick and are unsure of whether it is a store order or group order, you can look at the Action Column and filer POrder to see when it was last ordered. Check the Ref# and double click the number to open the Purchase Order.
Using above as example, on 19/05/2024 POrder was placed, SOH is 10 and 1 is in order.
Qty of 1 is expected to be received in next delivery.
4. All SOH adjustments are recorded in the Audit Tab. You can view current SOH, on order quantities and why and when SOH has changed. Audit Tab is a live function of stock movement.
Pre SOH is quantity before action was performed.
Adjust Qty SOH is number adjusted.
Final SOH is quantity after functions has been made.
Using above as example, on 19/09/2023, SOH was -3, a SOH Adjustment was made of 3 which brings the Final SOH to 0.
5. Invoice and receipt items are recorded based on when Invoice has been accepted. It also takes into consideration and records quantity placed on order and if item is still on order- meaning, it has not been received.
Using above as example, on 16/05/2023, Invoice was accepted for qty of 2. Before invoice was accepted, Pre SOH was 3, Adjust Qty SOH of 2 was accepted on invoice which brings FInal SOH to 5. We can see that 2 were ordered in Pre On Order Column.
6. Cost is recorded based on Action. So order and invoice cost will be recorded for quantity ordered and accepted.
7. Average cost is used for GP reporting and if wrong can cause concern. Average cost is calculated using Average formula- Sum of Values/Number of Values.
Average cost should be similar to last cost and not much higher.
If Average cost for ex $29 and cost is $7.39- record has been made in error and needs to be rectified.
You can raise a service request for this to be corrected.
Audit Tab is informational only and no changes can be made.
Once Audit Tab functions are mastered, it is handy tool to have for all your item troubleshooting needs!
