| Oracle® Retail Sales Audit (ReSA) User Guide Release 16.0.024 E90750-01 |
|
 Previous |
 Next |
| Oracle® Retail Sales Audit (ReSA) User Guide Release 16.0.024 E90750-01 |
|
Previous |
Next |
This chapter explains the auditing process in detail and provides procedures to assist you while auditing transactional data. The process flow for auditing is as follows:
At the end of the day or by trickle-poll method, transactions are transmitted from the store to the head office. This data includes order initiation, order complete, and order return transactions from both OMS and POS.
The duplicate records received from OMS and POS are filtered within ReSA.
The transmitted transactions are loaded to the database, totaled, audited, and reviewed.
Any errors that are generated as part of the validation process must be corrected or overridden.
Once the audit is complete, the data is exported.
Auditing process followed by the Auditor
As a ReSA auditor, your responsibility is to review all exception errors related to your stores and either correct or override these errors.
The following is a standard auditing workflow for a auditor within ReSA:
Find and select the store/day containing and navigate to either Balancing Level Summary or Store Day Summary.
Use the Store Day Summary to review and audit the following:
Error List
Miscellaneous totals
Over short totals
Missing transactions
Import and export log
Use the Cashier/Register Level Summary to review and audit the following:
Error list
Miscellaneous total
Over short total
You can also perform data analysis such as, reviewing the audit trails. You can use the following screens for the analysis:
Transaction Search
Item Summary
Tender Summary
Transaction Audit Trail
Total Audit Trail
General Ledger Transactions
Import/Export Log
Bank ACH Maintenance
Store ACH Maintenance
|
Note: Once all errors are corrected or overridden, sales audit sets the store/day audit status to Audited. The store/day audit is then available for export to an external application. |
This chapter covers the following topics:
The Transaction Maintenance module allows you to investigate and correct errors in the external system transactions. You can review the transactions that were flagged by the automated audit process.
Transactions may have many types of errors, which need to be reviewed and corrected manually. In addition, it is also possible to review and edit the data from missing transactions or transactions that have passed the automated audit. Corrected transactions are exported to external systems by a batch program.
You can use the Transaction Maintenance window to view, create, and edit transactions.
From the Tasks menu, select Operations > Manage Transactions. The Transaction Search window appears.
Select Actions > Create. The Transaction Maintenance window appears.
|
Note: You can also navigate to the Transaction Maintenance window by selecting Operations > Create Transaction. |
In the Chain field, enter a chain number.
In the Store field, enter the store ID.
In the Business Day field, enter a date, or click the calendar button and select a date.
Entering a store results in opening a Search and Select pop-up which allows you to select a Business Date. The selection of store and business automatically populates the Chain, Banner and Business Date fields if they were not entered.
In the Transaction Date/Time field, enter the date and time the transaction occurred.
|
Note: The External Transaction field displays the transaction number that was used by the external system. |
In the Transaction Type field, enter the type of transaction you are creating.
|
Note: Depending on the type of transaction you select, additional fields are enabled. Enter the appropriate information in the enabled fields. |
Add any of the following details to the transaction as needed:
Items to a transaction.
Discount to the item on a transaction.
Tender records to a transaction.
Customer order information to a transaction.
Paid out details to a transaction.
Employee details to a transaction.
Tax details to a transaction.
Tax to the items on a transaction
Voucher details to either item or tender on a transaction
Customer attributes
Click OK to save your changes and close the window.
You can use the following procedures to add item information to a transaction.
On the Transaction window, in the Items section, select Actions > Add. The Add Item window appears.
Select the item type.
Enter the item ID. Details such as Unit Retail, Selling UOM are defaulted and can be overridden.
Enter details such as Quantity and Item Status.
Click OK to save your changes and close the window.
On the Transaction Maintenance window, in the Items section, select Actions > Edit. The Edit Item window appears.
In the Item Status field, select Return. The Return Reason field is activated.
In the Return Reason field, select the return reason code.
Click OK to save your changes and close the window.
On the Transaction Maintenance window, in the Items section, select Actions > Edit. The Edit Item window appears.
In the Price Override section, enter the override reason in the Override Reason field.
In the New Unit Retail Price field, enter the new price.
Click OK to save your changes and close the window.
In the Items section, click the arrow next to Item Details.
The Items Details section is expanded. You can add taxes and discounts here.
In the Items section, click the arrow next to Discounts to expand the discounts section. Click Actions > Add. The Add Discount window appears.
In the Component Type field, select the type of promotion or discount you are creating.
If you are creating a promotion, in the Promotion field, enter the promotion.
If you are creating a discount, from the Discount Type field, select the type of discount that you want to apply to the item.
In the Promotion Component field, edit the component of the promotion as necessary.
In the Coupon No. field, enter the ID of the promotion or discount.
In the Quantity field, enter the quantity for the discount.
In the Unit Discount Amount field, enter the amount of the discount.
Add the appropriate reference information.
Click OK to save your changes and close the window.
On the Transaction Maintenance window, click the arrow next to the Reference section. The Reference section is expanded.
In the Reference fields, enter the reference information as needed.
Click OK to save your changes and close the window.
To view the revisions of a transaction:
On the Transaction Maintenance window, from the More Actions menu, select Transaction Audit Trail. The Transaction Audit Trail window displays an audit trail of all revisions to the transaction.
Click OK to close the window.
To add comments:
On the Transaction Maintenance window, from the More Actions menu, select Comments. The Comments window appears.
Select Actions > Add. The next line in the table is enabled for commenting.
Enter your comments.
Click OK to save your changes and close the window.
To view errors:
On the Transaction Maintenance window, from the More Actions menu, select Errors. The Sales Audit Errors window appears. You can view all the errors associated with the transaction in this window.
Click OK to close the window.
To refresh the errors:
On the Transaction Maintenance window, from the More Actions menu, select Refresh Errors.
The errors are refreshed taking into account any updates that were made to the transaction.
|
Note: When refreshing errors, Total and Store Day Level rules are not included during the refresh. |
To add tender information to a transaction:
On the Transaction Maintenance window, in the Tender section, select Actions > Add. The Add Tender window appears.
In the Tender Type Group field, select the tender type group.
In the Tender Type field, select the tender type.
In the Amount field, enter the tender amount.
If you select a type of card payment in the Tender Type Group field the Credit Card section is enabled:
In the Authorization No. field, enter the authorization for user ID.
In the Token field, enter the credit card token.
In the remaining fields, select the information needed.
Click OK to save your changes and close the window.
|
Note: The Token field is only available when the selected Tender Type Group is either Credit Card, Debit Card, PayPal, Fonacot or Others. The section label is updated dynamically, based on the selected Tender Type Group. For example, if you select the Tender Type Group Debit Card, the section is labeled Debit Card. |
You can add user-defined reference information to a type of tender in the Reference section.
Click OK to save your changes and close the window.
To add customer information to a transaction:
On the Transaction Maintenance window, expand the Customer section.
In the Identification Type field, select the source of the customer information.
In the Identification No. field, enter the ID from the source document selected in the Identification Type field.
In the remaining fields, enter the name and the address information for the customer.
In the Customer Attributes section, select Actions > Add. The Add Customer Attribute window appears.
In the Attribute Type field, select the attribute type.
In the Attribute field, enter an attribute.
Click OK to save your changes and close the window.
To add paid out details to a transaction:
On the Transaction Maintenance window, expand the Paid Out Details section.
In the Vendor field, enter a vendor number.
In the Vendor Invoice No. field, enter a vendor invoice number.
In the Proof of Delivery No. field, enter a proof of delivery number.
In the Payment Reference No. field, enter a payment reference number.
Click OK to save your changes and close the window.
To view a transaction:
From the Tasks menu, select Operations > Manage Transactions. The Manage Transactions window appears.
Enter search criteria to find the transaction that you want to view and click Search.
Select the transaction from the Results table.
Select Actions > View. The Transaction Maintenance window appears in view mode.
You can view all the information related to the transaction on this window.
Click Done to close the window.
The Automated Clearing House (ACH) Maintenance module allows you to declare and manage how much money is deposited in local bank accounts. ACH maintenance allows Headquarter (HQ) users to manage how money moves from local bank accounts to centralized bank accounts. You can manage ACH transactions using the following procedures.
To view bank ACH transactions:
From the Tasks menu, select Operations > Bank ACH. The Bank ACH window appears.
To add a bank ACH transaction amount:
From the Tasks menu, select Operations > Bank ACH. The Bank ACH window appears.
Select Actions > Add. The Bank ACH - Add Adjustment window appears.
In the Bank field, enter the bank ID.
In the Bank Account field, enter a bank account number.
In the Business Day field, enter a business day, or click the calendar button and select the date.
In the Next Day Manual ACH Adjustment field, enter an amount.
Click OK to save your changes and close the window.
To delete a bank ACH transaction amount:
From the Tasks menu, select Operations > Bank ACH. The Bank ACH window appears.
Select the record.
Click Delete.
Click Yes to confirm deletion.
To view a store ACH transaction:
From the Tasks menu, select Operations > Store ACH. The Store ACH window appears.
To view the bank details for a selected store, click Bank Details. The Bank ACH window appears.
Click OK to close the window.
To add a store ACH amount:
From the Tasks menu, select Operations > Store ACH. The Store ACH window appears.
Click Actions > Add. The Add Adjustment window appears.
In the Store field, enter a store ID.
In the Business Day field, enter a business day.
In the Bank field, enter a bank ID.
In the Next Day Manual Deposit Adjustment field, enter an amount.
Click OK to save your changes and close the window.
To delete a store ACH transaction amount:
From the Tasks menu, select Operations > Store ACH. The Store ACH window appears.
Select a record.
Select Actions > Delete.
Click Yes to confirm deletion.
Click Save and Close to save your changes and close the window.
The Bank Stores window is used to enter and maintain the store/bank relationships and bank attributes. The bank attributes are exported to external ACH (Automated Clearing House) and UAR (Universal Account Reconciliation) systems.
To create a bank/store relationship:
From the Tasks menu, select Foundation Data > Bank Store. The Bank Stores window appears.
Select the bank from the Bank field.
In the Bank Stores table, select Actions > Add. The Add Store window appears.
In the Store field, enter a store ID number, select or search for the store.
In the Account Type field, select the account type the bank has for the store. The options are: Checking, Savings.
In the Bank Account field, enter a bank account number.
In the Routing field, enter the routing number for the bank.
To indicate that the account is a consolidating account, select Consolidating.
Click OK to add a store. You can add more stores by clicking OK and Add Another.
Click Cancel to return to the Bank Stores window.
To delete a bank/store relationship:
From the Tasks menu, select Foundation Data > Bank Store. The Bank Stores window appears.
Select the bank stores you want to delete.
Select Actions > Delete.
Click Yes to confirm deletion.
Click Save and Close to save the changes and close the window.
Audit trails allow you to view the revisions made to a transaction or a total. Summaries allow you to view the transactions that occurred on a Store Day.After modifying the information for a Store Day, you can view the information through audit trails or summaries. After you view the summaries, you can return to the Transaction Maintenance module to update any outstanding issues you find while reviewing the Store Day. For more information on working with the Transaction Maintenance module, see Working with the Transaction Maintenance Module
To view the revisions of a transaction:
From the Tasks menu, select Operations > Manage Transactions. The Manage Transactions window appears.
Search and select the transaction for which you want to view the audit trail.
Select Actions > View. The Transaction Maintenance window appears.
From the More Actions menu, select Transaction Audit Trail.
The Transaction Audit Trail window appears. This window displays an audit trail of all revisions to the transaction.
Select a revision from the table.
To view all revisions in detail:
Item level: Expand the Items section, select an item and expand the Item Revisions section. You can view all the revisions for the selected item.
Tender level: Expand the Tender section, select a tender and expand the Tender Revisions section. You can view all the revisions for the selected tender.
Export level: Expand the Exports section, select an export and expand the Export Revisions section. You can view all the revisions for the selected export.
Click Done to close the window.
To view a total audit trail:
From the Tasks menu, select Operations > Total Audit Trail. The Total Audit Trail Search window appears.
Enter criteria to make the search restrictive.
Click Search. A list of totals matching the criteria is displayed.
Select a total.
Select Actions > View. The Total Audit Trail window appears.
Click Done to close the window.
To search for an item summary:
From the Tasks menu, select Operations > Item Summary. The Item Summary window appears.
In the Store field, enter a store number.
In the Item Type field, select an item type.
In the Item field, enter an item number.
In the Business Day field, enter a business day, or click the calendar button and select the date.
Click Search. The table displays the items that match the search criteria.
Click Done to close the window.
The Sales Audit General Ledger Transactions window facilitates you to search and view transactions related to all the totals in a date range. This window also aids to view finance drill down report and finance drill back report.
To search for general ledger transaction view:
From the Tasks menu, select Operations > General Ledger Transactions. The General Ledger Transactions window appears.
In the Store field, enter a store number.
In the Processed Date field, enter a processed date, or click the calendar button and select the date.
In the Accounting Date field, enter an accounting date, or click the calendar button to select the date.
In the Total ID field, enter or search the total ID.
In the Business Day field, enter a business day, or click the calendar button to select the date.
Click Search. The table displays the items that match the search criteria.
Click Done to close the window.
To search for tender summary information:
From the Tasks menu, select Operations > Tender Summary. The Tender Summary window appears.
In the Store field, enter a valid store ID.
In the Business Day field, enter a valid business day, or click the calendar button and select a business day.
To narrow your search, enter or select values in additional search fields.
Click Search. The data matching your search criteria appears.
Click Done to close the window.
You can perform various operations on a store day using the following procedures.
To search for a store day:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
In the Store field, select a store.
In the Business Day field, select a date.
In the status fields, select varying status criteria.
Valid Overall Status are:
In Progress
Complete
Valid Data Status are:
Ready for Import
Loading
Partially Loaded
Fully Loaded
Purged
Valid Audit Status are:
Unaudited
Store Errors Pending
HQ Errors Pending
Re-Totalling/Auditing Required
Totaled
Audited
Enter additional criteria as desired to make the search more restrictive.
Click Search. A list of selected stores appears by business date.
Click Done to close the window.
To view the store day summary:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and select a store day.
From the Actions menu, select View. The Store Day Summary window appears.
Click Done to close the window.
To resolve errors:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in Edit mode.
In the Error List tab, select an error from the list.
Select Actions > Fix Error. The Sales Audit window appears.
Resolve the error.
Click OK to save your changes and close the window.
To view over/short totals information:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in View mode. The Store Day Summary window appears. You can view the Over/Short information in the Over/Short Totals tab.
From the Options menu, select Over/Short Totals. The Over/Short window appears.
According to the information that you want to view, select the appropriate option from the Actions menu.
Select Exports to view the Totals Export window.
Select Audit Trail to view the Audit Trail window.
Click OK to close the window.
To view miscellaneous totals:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in View mode. The Store Day Summary window appears. Select the Miscellaneous Totals tab.
From the Actions menu, select Exports, Audit Trail, Combined Total Details, or Errors.
Click Done to close the window.
The Missing Transaction tab allows you to view and update missing transactions. Missing transactions can occur when a transaction number, without any details, is generated at the POS or OMS. Missing transactions may represent transactions that were not properly polled, so you need to add the details. Another possibility is that the transaction numbers were polled erroneously from the POS or OMS, and do not represent actual transactions. You need to delete such transaction numbers.
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in Edit mode. The Store Day Summary window appears. Select the Missing Transactions tab.
Select an external system transaction to add details.
From the Actions menu, select Edit. The Transaction Maintenance window appears.
Enter the details of the transaction in the appropriate fields.
Click Save to save your changes and close the window.
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in Edit mode. The Store Day Summary window appears. Select the Missing Transactions tab.
Select the missing transaction.
From the Actions menu, select Delete.
Click Yes to confirm.
Click Done to save your changes and close the window.
To view import/export log:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in Edit mode. The Store Day Summary window appears.
Select the Import Log tab to view the import log.
Select the Export Log tab to view the export log.
Click Done to close the window.
To delete a store day:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in Edit mode. The Store Day Summary window appears.
From the More Actions menu, select Delete Store Day.
Click Yes to confirm.
To reopen a store day:
From the Tasks menu, select Store Day Audit. The Store Day Search window appears.
Search for and retrieve a store day in Edit mode. The Store Day Summary window appears.
From the More Actions menu, select Reopen Store Day.
|
Note: The Reopen Store Day function is only available if the Audit Status is Audited, the Data Status is Fully Loaded, the Store Day Status is Closed, and the Business Date is greater than last end of month date. |
The Audit Status is set to Unaudited. The Data Status is set to Ready for Import and the Audit Changes Date/Time is updated. Click Save or Save and Close to save your changes.
