Skip to Content
author's profile photo Former Member
Former Member

Sales Invoice, Purchase Invoice Merge

Hi Guys

I am creating a report that will give me the total # of Sales and Purchase Invoice, purpose of report is to merge the sales and purchase analysis.

i have added all the fields on the main report from the OINV table, i then created a sub report that has the same fields, only difference is its from OPCH table, i need to have a parameter "Date", that i have created, but doesnt seem to filter the values as to my selection. What could be the problem.

What i am trying to do is merge the Sales Analysis in SAP and the Purchase Analysis in SAP on one report.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 03, 2008 at 12:45 PM

    Euston,

    I am doing something similar to yours, I am merging total of (each credit job) with total (each free of charge job) to show in the single report.

    here what I am doing right now,

    1: Imported both tables into one new report

    2: Created a Running total field for FOC (free of charge job)

    3: Created a Running total field for CR (credit job)

    both of these running totals have formulas under "Evaluate each record"

    Formula is like this

    line_type="F"
    
    line_type="C"
    

    Both of them are grouped by two different groups however are of the same Reason ID.

    I then created formula like this

    Whileprintingrecords;
    Numbervar x:=0;
    Numbervar y:=0;
    Numbervar z:=0;
    
    x:=Runningtotal field for FOC
    y:=Runnitngtotalfield for CR
    z:=x+y
    z;
    

    This gives me combined result of two different jobs.

    Is that something what you are trying to do?

    Regards

    Jehanzeb

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 03, 2008 at 12:59 PM

    Hi Euston,

    Please check the following to get the filtered records :

    --Are you filtering the records based on your Parameter value ? You will have to filter records in Record Selection like :

    = {?ParameterField}

    --Have you link the sub report to main report using a common field or a parameter ?

    Right click on sub report and go in Change sub report links and link the sub report to your main report.

    --if you are using more than one table, check for table links.

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.