Re: RE:[sap-log-mm] Business Analyst

Posted by Sap Land Tuesday, 10 May 2011 02:21

Posted by sharadphadke (AGM MATERIALS)
on May 10 at 5:24 AM

Since the stock count is 31 Jan your date should be 31 st Jan
This will avoid any confusions later as the new month you start on new slate
Calculation
Consider Issue as addition for calculations
Receipt as decrease
This is because you are reverse posting
Please just check and let me know for further

Sharad

---------------Original Message---------------
From: guthulasrinivas
Sent: Tuesday, May 10, 2011 1:06 AM
Subject: Business Analyst

Thanks Sharad !!, elaborating my query further
Have done Stock Take (Cycle Count ) on 31st Jan night.

After stock take (Cycle Count) have got the scanned data.
But I am not going to post on next day before my sales upload
Instead, after 4 days (i.e on 4th Feb), I would post the variance (difference qty), however, posting date would be 31st jan and not 4th Jan

Impact as follows
BQ = Book Qty, CQ= Counted Qty

31 Jan BQ = 100 CQ = 90 Variance = -10 (variance not posted)
1st Feb BQ = 100 , Sales =10 pcs; then BQ =90
2nd Feb BQ= 90 , Inward = 10 pcs then BQ = 100
3rd Feb Bq=100, sales= 20 pcs, then Bq = 80
4th Feb Bq= 80, sales= 10 pcs, then BQ= 70

Option 1 :
If I post dated for 31st on 4th Feb, transaction shown above from 1st feb to 4th feb would be overwritten, and BQ would become 90 on 4th feb instead of 70-10=60. which is incorrect

Option 2:
If I post on 4th Feb only, then there is no issues since I posting variance it just debit with whatever, BQ on that day as given obove on 4th feb BQ=70-10=60

The second option what we follow right now,
However, the schedule which are conducted on month end, there posting delay and same happen on next month and, PNL had wrong impact. Now the objective is even posting done on next month as given above in option 1,
BQ should continues as given in option 2 and other impact, as shown in option 1 should be eliminated -

suggest what approach to follow

Inward, outward, sales happened from 1st to 4th will be overwritten with variance posted for 31st jan on 4th Feb, BQ will continue from 31st Jan. Right?

Secondly, PO and only other transaction against those article will have impact, right ?

__.____._