Trail Balance-urgent

[Former Member]

Hi,

as a part of makking trail balance i want to know monthwise and plantwise net purchases.

i had used MB51 with mvt types 101,102,961 and 962.also i had used MC$G transaction.

both of the above transaction are not giving me exact purchases.

plz let me know is there any other way where i can get net purchases with exact values??

[Former Member]

Dear Balaji,

If are using MB51, for getting purchase values, then you may have problem in certain things like.

1) When you do the GRN your stock is updated, where as your vendor invoice may not be posted in the same month/period.

Eg:- GRN date 28/02/2008

Invoice booking date : 3/03/2008.

So you when you try to arrive at the derived purchase = Purcahses during the month you will find a difference.

2) This may also be due to using a wrong valuation class in the material code. You have to use moving avg price, for Material Masters, so that you do not have very few price difference entires which will be posted during Invoice Verification.

As of now, there is no standard report which gives exact purchases as per purchase register, You may have to develop a Z report ( for Invoice verification) and try to do a reconcilation with MB51.

Assign points if found useful.

Thanks & Regards

Sanjay Marathe