Retail Merchandising System (MOSC)

MOSC Banner

GL - Month Data after Count Unit and Value is performed V16

edited Jun 8, 2020 1:21PM in Retail Merchandising System (MOSC) Question

Hi,

I am doing some tests related to the impact of stock count (Unit & Value) in Month_Data table and I saw the values wrote into the table are related to the new inventory values from stake_prod_loc table instead of the variances generated by the stock count itself, imagine this scenario for one department:

Close of previous Month_Data: 10,000.00$

Start of month Total Cost: 10,000.00$

POs: +8,000.00$

Inventory Adjustment: -300,00$

Sales: -7,500.00$

Close of Month_Data: 10,000.00+8,000.00-300.00-7,500.00=10,200.00

Imagine next month was performed an Unit & Value Stock Count:

Close of previous Month_Data: 10,200.00$

Start of month Total Cost: 12,000.00$

POs: +7,000.00$

Shrikage: +300,00

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center