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

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

1581 Views

Hello Experts,

I kindly request your suggestions to meet the following requirement in one of our SAP Business ByDesign project:


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( time stamp 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?

Will highly appreciate any ideas or input to achieve this requirement.

Thanks & Regards

Shashank Jain