Inventory valuation check

[Former Member]

Hi all,

I have my few customers who are candidates for IVC.I have uploaded the database to the SAP for the same. But i am confused what will be the result there after .Will SAP provide us solution or will upgrade the database to higher PL.What is going to exactly happen?

Regards-

Mona.

[Former Member · Accepted solution]

Hi Mona ,

SAP support will send you an email if you are the one who log the message .Sometimes you donot receive email in your inbox , make sure you log through portal .

SAP will send you an attachment of Excel file which shows you before and after revaluation . If the OINM table value is coming correct before and after ,that means system donot have any application issue .

SAP will list out all the transaction and suggested manual journal entry posting . They will also explain to you about the report .if you are consultant .If you are end user and you are not comfortable after the answer from your consultant , you can also request your consulant from direct support from SAP .

It is a very good report and useful...so wait for that report ...if you decide to go after the report , you need to bring your patch level upto the latest one (if you are end user ) ..if you are consultant you upgrade your patch level to the latest and show the result to client in your PC and if they want to do it , explain the procedure ..they will also include how to do it in the message they send

Hope this helps

Bishal

[Former Member · Accepted solution]

Hi,

Thanks for your response.

I am a consultant who is going to perform IVC.I have received XL spreadsheet & also the sample database from SAP support.I am trying to study the xl sheet. In that

1st sheet refers Account details - Before & after recalculation , so my question is what will get reflect after performing IVC recalculated one or we need to recalculate.

2nd sheet refers Transactions - Does the suggested postings refers to transactions which we need to perform manualy.

3rd sheet JE & service type - what is 3rd sheet actually refering & what has to be done?

4th sheet Quantity & value difference - what does it refer.

Then there are further sheets which refers particular account.At the end of the sheet there is account table refering debit & credit side.we need to pass manual JE for that as suggested.

Regards-

Mona.

[former_member186095 · Accepted solution]

Hi,

I have two customers that have been received inventory valuation checkup service. They'll satisfy with the result.

The recalculation tools from SAP B1 have applied on the live db. Indeed, there will be IVC report consists of suggested journal entry that must be posted manually. The data is available on the 2nd sheet. Although you posted it, the difference between stock value in G/L and warehouse journal will still be exists. When you generate tb or bs report, I am sure the result will be as same as the inventory audit report.

To know the different, you must run the query of IVC. you could replace the output result part of the query IVI identification script 1.11 with this following one :

--output results

if (@isPerpetual = 'N')
Begin
	Print 'System does not use perpetual inventory'
End
Else
Begin

if ((abs(@Difference) > 1000 AND @previousfix = 'N') or @CurrentConsistency ='N')
Begin
	set @CandidateForService = 'Y'
	--Print 'Database is candidate for the Inventory valuation Check-up service'
End
Else
Begin
	set @CandidateForService = 'N'	
	--Print 'Database is healthy'
End

End

select @isperpetual as 'Perpetual Inv. (Y/N)', 
@PreviousFix as 'History Db fix. (Y/N)',
@sumTransval as 'Total value in the Inv. Audit Report (IAR)', 
@sumposting as 'Total Stock Bal. in report G/L (SB)',
@Difference as 'Diff. between Total value in IAR & SB', 
@CurrentConsistency as 'DB consistency (Y/N)',
case when @candidateforservice =  'Y'
then 'Db is candidate for the inv. val. check-up service' 
when @CandidateForService = 'N'	then 'Db is healthy' 
when @isPerpetual = 'N' then 'System does not use perpetual inventory'
end as 'Potential Outcomes'

Rgds,

[former_member186095 · Accepted solution]

Hi Mona,

Have your problem resolved ? if not, check these following detail info:

1. Accounts details (summarized stock value before, after recalculation and G/L stock account balances)

2. Transactions (transaction value after recalculation and corresponding JE amounts - summarized by transaction types and also split by individual stock accounts, a legend of transaction codes, suggested postings

3. JE & service Type (a summary of manual journal entries and service type documents, which affect G/L stock account balances)

4. Next sheets are representing individual stock accounts (comparing transaction value after recalculation with original JE)

Summary:

No. 1 is for your no.1 question

No. 2 is for your no. 2 question

No. 3 is for your no. 3 question

for no. 4 question, the sheet is showing the value of the item in all warehouses after and before recalculation. If you give your backup db as a sample for recalculation, you must know the date of the backup. After knowing it, you can run the inventory audit report - history to know the items / stock data before and after recalculation per each warehouse. The items I am referring here are the items on the sheet quantity and value differences.

The suggested postings as you see in the no. 2 are the primary things to understand and it is the result of the IVC service that you must apply in the sample of recalculated db.

The objective of suggested postings is to provide sufficient information to create corrective JE in order to adjust G/L stock account balances to recalculated stock values.

The inventory valuation adjustments are used to eliminate possible stock valuation differences.

Why do they provide suggested postings ? it is because no G/L journal entries are created by SAP in customer productive database during the live fix or during testing phase. All the JEs related to IV adjustments must be created by customer.

Hope the above info is clear.

Rgds,

[Former Member · Accepted solution]

Dear Jimmy,

Thank you for your reply.

I am confused what does it actually meant?

Restore the fixed live database, revert back all existing manual JEs (Accounts Details tab - Manual Postings column) and then post the manual adjustment postings (Transaction tab).

Mona.

[JesperB1]

HI Mona,

I believe you should receive the full information from SAP.

What happens is that the table containing all the warehouse transactions - OINM - will be recalculated. Meaning, all transactions will be revaluated and a new value might be updated in case there was a previous corruption. The values in the Stock/Inventory Audit Report is taken directly from this table so the recalculation will change the results of this report.

When this is done SAP will offer suggestions to postings (journal entries) so that the balance on the stock accounts will be alligned with the new value in the report.

Either way, the consultant working on your db will be able to explain this in full.

Hope it helps,

Jesper

[Former Member]

Hi!

They may run some SQL Commands to rectify the problem, i belive.

[Former Member]

Hi,

Thanks OK let me know if you get any further details.

Regards-

Mona.

[Former Member]

Hi!

I don't have more details on the topic. Let we wait for other members to share their views.