Not sure if this is the corect place to post, sorry in advance if it is.
I am having trouble running/creating 2 reports really could do with some help
This report is for customer spend on broken down by Unit. I will need to be able to run this either by u201Cfather cardu201D code or from the separate business partners, however when I run it by u201Cfather cardu201D I need to be able to see the spate splits on here too.
I will needu2026..
BP Number: Of the u201Cfather cardu201D
Depot: I will need to know which SAP system each customer comes from u2013 right now itu2019s going to be just KF but this is a really important part of the report.
BP Number: Of the separate accounts linked
BP Name: Of the separate accounts linked
Total £ : A single value of the actual invoiced amounts, including credit values u2013 This figures cannot be of a statement of account value, but the value of all the invoices processed. u2013 I will need to see zero values where there are any.
Total rebate: I need to see the total rebate value, including credit notes u2013 again this figure cannot be from amounts already taken/paid but of the rebate for the time period the same as above. u2013 I will need to see zero values where there are any.
Any help would be appreciated.
Joe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.