Skip to Content
0
Former Member
Aug 05, 2016 at 05:06 PM

Inventory balance report for previous month in SAP by Design

679 Views

Dear SAP Gurus,

We have an issue with inventory balance report for previous period and you probably can give us a hint how to manage this. Please find requirement and business case descriptions below.

Requirement

To have inventory posting transactions with posting date in current month in the inventory balance report for previous month.

Business case

There can be cases when posting for previous period to be done in current period when previous period is closed. From inventory balance point of view such postings has to belong to previous period even if they done in current period. Not having such postings in previous period inventory balance report lead to wrong figures and stock reconciliation issues.

AS-IS

In SAP by Design there are only 2 dates in material documents(Warehouse confirmation/Goods and Activity confirmation) generated based on inventory postings – actual execution date(posting date that can be selected manually) and document creation date(timestamp created automatically during doc posting). Considering these 2 dates it is not possible to post inventory transactions within current month for closed previous month and see that inventory postings in previous month’s inventory balance report.

TO-BE - ?

Is there any additional date in the material document that can be used for postings and which help us to see posing from current month in previous month?

As an example in SAP ECC there are document date and posting date that can be manually adjusted – this helps to have positing date in current month and document date in previous month. This allow us to post docs in current month if previous month is closed and see this posting in inventory balance report for previous month based on document date.

Is there any mechanism in SAP by Design which allows us to have posting date in current month and see that posting in inventory balance report for previous month?

I believe this is not something new and such process exist in other companies that run SAP by Design – so hope you have an idea.

Thank you in advance,

Denis