My Oracle Support Banner

In Retail Method Of Accounting For Transaction CMO% Defined For The New End-of-week Date Is Considered Instead Of Prior Week Ending (Doc ID 2976954.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.


In MFCS, when the system is calculating cost under the retail method of accounting, the system uses the week ending date in the stock ledger that is less than or equal to the transaction date. This means that Sun-Fri transactions are using the prior week and that the Sat transactions are using the current week. All of the transactions within the same week need to use the same week ending date.

For example :

Vdate : 3rd Aug,2023
Week_data: CMO% for 29th July is 50%
CMO% for 22nd July is 0

Transfer created for 28th July is using CMO% of 22nd July while transfer created on 29th July is using CMO% of 29th July. But ideally 23rd to 29th July falls in same period week.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.