ReSA - Store Day Over/Short Does Not Show The Correct Value In The First Auditing
(Doc ID 2855379.1)
Last updated on OCTOBER 05, 2023
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.
Store Day Over/Short does not show the correct value in the first auditing.
The Store Day Over/Short Total OVRSHT_S is not getting correctly calculated when we receive RTLOGs and they get imported and audited with success. It is comprised by two Totals: OVRSHT_S = (-)SYSBKTHE_S (System Calculated Total) + SYSBKDEC_S (Declared Combined Total) Only when we reset the Audit Status and we do the re-totaling/Re-auditing, it gets the correct value.
Step to recreate:
1- Create All Totals - Declared banking and Theoretical Banking (System Calculated)
2- Create main OVRSHT_S total
3- Import Sales
4- Go to the Store Day Summary screen and notice the incorrect Over/Short amount
5- Reset auditing status
6- Click Audit again, and correct value is displayed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document