Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 05, 2016 at 03:01 PM

    Hi Shashank,

    Do you mean this way ? I did this via Migration that posting date last month & creation date : current month.

    But you want to do this way when the previous period closed ?

    Thanks

    Lokesh Sharma


    Capture.PNG (71.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 08, 2016 at 07:30 AM

    Hi Shashank,

    when you post with posting date in the previous month has impact on the inventory, which might have unforeseen impacts. So we do not allow backdated transactions, e.g. Inventory COunt as per last month or Warehouse confirmation or ... which might change the result of checks in the past.

    You can raise your request as idea in the ByDesign Ideas Forum under: https://ideas.sap.com.

    Best regards

    Marlene

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.