MBEWH table updation logic

[Former Member]

Would like to know the MBEWH table updation logic.

[Former Member]

To clear a point, only one standard cost is created in period 01.

However, period 01 also had "goods issued" and :goods received".

Period 02 has no transactional activity.

[Former Member]

Okay.

The first period 001 "activity" was the cost change; therefore the history of 012 was written to MBEWH.

I would not expect any other activity in Period 001 to cause or change the 012 entry in MBEWH.

When there is activity in Period 002, the history of 001 will be written.

If there is no activity in 002 and 003, When there is activty in Perod 004, the history of 003 will be written.

To answer the question "what was the standard cost at the end of Period 002?"

- Look in 002 in MBEWH in this example there is no record.

- Look FORWARD to next period.

- See record for 003 - the information in record for 003 is also the information for the end of 002.

Hope this helps.

[Former Member]

Yes, I do have a change record for 12/2007, and expect one since this is the last period of a year. I believe I will always have a record for period 12...correct ?

[Former Member]

I suppose that you would. I forgot about the annual cost rolls.

My documentation and notes are very specific that the record is ALWAYS written to the previous period, when the FIRST activity in a u2018periodu2019 takes place.

I understand from your question, that the standard changed twice in Period 001? once for the cost roll and then again for another reason?

I would believe that the second change does not cause a record to be written. I have not ever actually tested this.

[Former Member]

I have situation whereby I have no MBEWH record for period 001/2008.

However, I have January "goods received" and January "goods issed" and January change in standard cost....why no record??

[Former Member]

Do you have a change posted for 12/2007?

[Former Member]

MBEWH is basically the History table for MBEW - Material Valuation table.

As MBEW is supposed to contain current values, when it has to be changed (like when updating material current price, etc.), the current value gets written to MBEWH and the new value gets written to MBEW.

Remember to assign points to say Thanks.

Regards

Gulshan

[Former Member]

The current standard is always in MBEW. When the first activity in a u2018periodu2019 takes place [valuation or quantity update]; a record is written to MBEWH to document the balance, std, price control, that existed BEFORE the "first activity

The number that represents the previous period record being written into the MBEWH table is represented in the u2018current periodu2019 [LFMON] field.

EXAMPLE: when the first activity occurs in period 3 (i.e., a goods receipt), an entry is written into the MBEWH table with a u2018current periodu2019 number of 2. The quant and value updated to the u2018total stocku2019 and u2018total valueu2019 fields are equal to the data that represents these fields PRIOR to the activity quant and value occurring in period 3.

If there is no activity for several periods, you will not have entries for every period in the MBEWH table.

[alpesh_saparia3]

Hi,

MBEWH table is updated whenever there is change in Moving Average Price.