report

[Former Member]

Hi friends,

I am doing commission report as per the client requirement here my problem is,my client maintain two condition types for commission one is % and value. so client wants pick the condition type value from billling document..

How pick the value while doing the pattial invoice.

how the value shown up as negative when the invoice cancellation and reversal.

how the pick the value after paid the commission partially.

we have maintain 3 columns in report

invoce not paid

commission owed

total laibality.

[Former Member · Accepted solution]

Hi,

I would suggest that you have a validation for the report ,

1.That only invoices passed to accounts be picked up (Posting Status C in the fieldVBRK-RFBSK).

2.Do not consider Billing Type S1 (Cancelled Invoices).

3.Do not consider Bill with value "X" in the field VBRK-FKSTO.

There is nothing the report can do if the commission has been partially paid,the report will only pick up the relevant condition types and display and in case of partial billing, if your calculating your commission on the basic price then the comm.condition types will show the commssion for the goods billed (pro-rata).

[Former Member · Accepted solution]

Thank you PJ

My client consider cancellation invoice so when do the cancellation invoice that commssion amount shown up as negative value in the report we have maintain commission condition types at billing level so we consider cancell invoice please suggest

[Former Member]

thanks

[Former Member]

Hi,

Sorry to say iam not able to understand your query,why does your client want to consider cancelled invoices.