Report to check freight amount for a month

[Former Member]

Dear All,

We have freight condition in the pricing procedure.

We would like to know how much we paid against freight.

Is there any standard report available to find out the same.

Regards,

Mullairaja

[Shiva_Ram]

You can directly read from the table VBRP.

Input the required parameters like sales org, and created on date range. Then execute. In the output one of the fields (depending on which sub total field is used for freight accrual), you can see the details in one of the subtotal fields.

Download this report into an Excel and add the freight value.

Alternatively, you can find the same details in the accounting side, using the G/L account used for freight accrual/payments.

Regards,

[Former Member]

Dear Shiva,

This report will be used by end user. They wont be having authorization to use the T code SE16.

They want to calculate freight for a particular month. They also want to have customerwise as well as materialwise freight paid in a month.

Suggest me if any standard report available for the same.

Regards,

Mullairaja

[Lakshmipathi]

Unfortunately, there is no standard report for this. You can develop a zee report for freight considering VBRP table with the required input fields.

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshmipathi,

Is it possible to use V/LD by chance.

Kindly suggest.

Regards,

Mullairaja

[Former Member]

Dear Lakshmipathi,

Is it possible to use V/LD by chance.

Kindly suggest.

Regards,

Mullairaja

[Lakshmipathi]

Not sure but check in V/LD maintaning 28 as Pricing Report where you have the option to key in Condition Type. There maintain your freight condition type and execute.

thanks

G. Lakshmipathi