5 Replies Latest reply: Jul 31, 2012 5:11 PM by Jitin Chawla RSS

specific items codes remove fro report

kumar sethi
Currently Being Moderated

When I generate sales reports, can I remove specific items codes (If I don’t want them to appear in the report) ?

  • Re: specific items codes remove fro report
    raghu rajendran
    Currently Being Moderated

    Hi Kumar,

     

    ya it is Possible.

     

    Use the following Query

     

    select i.* from oinv o

    inner join inv1 i on i.docentry=o.docentry

    where i.itemcode not in (specific items codes)

     

    Regards,

     

    Raghu Rajendran

  • Re: specific items codes remove fro report
    Rahul Moundekar
    Currently Being Moderated

    Hi Kumar........

     

    It is off course possible.

    Do you have any uniqueness or assigned value for identification for such Item Codes which should not be displayed in Report?

     

    Regards,

    Rahul

  • Re: specific items codes remove fro report
    Kennedy T
    Currently Being Moderated

    HI Kumar,

     

    Yes this can be acchived in Multiple ways.

     

    1. By Hard code the Item code in the Query

     

    Replace your Item code.('X1')


    select o.docentry , o.CardCode,i.itemcode,i.quantity from oinv o

    inner join inv1 i on i.docentry=o.docentry

    where i.itemcode not in ('X1')

     

     

    2. By Using the Item Property In Item master Date.   assign the Item Property  for those items which not required in the below Query.

    If you Use Item Property then you can also use the SAP Standard Inventory reports also.

     

    For Ex Now I assigned Item Property 1.  Change query according your assignment.

     

    select o.docentry , o.CardCode,i.itemcode,i.quantity from oinv o

    inner join inv1 i on i.docentry=o.docentry

    inner join OITM t1 on t1.ItemCode=i.itemcode

    where t1.QryGroup1='N'

     

     

    Regards

    Kennedy

  • Re: specific items codes remove fro report
    Gordon Du
    Currently Being Moderated

    Hi,

     

    If you are taking about system report, the answer would be NO. However, it is easy to be achieved through user query or crystal report.

     

    Thanks,

    Gordon

  • Re: specific items codes remove fro report
    Jitin Chawla
    Currently Being Moderated

    Hi,

     

    You can remove specific Item codes from the Sales Reports which are available in the database (system reports), provided they have a selection criteria before running that report and then in that selection you can either use

     

    1) Properties  or

    2) Item Groups

     

    Make sure that the item which you want to exclude has been checked for those properties or assigned to that specific Item Group.

     

    Check if it helps.

     

    Kind Regards,

    Jitin

    SAP Business One Forum Team

Actions