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

SP FOR MAKING PROFIT CENTER MANDATORY

Hi Experts

Anybody have the SP for making Profit Centers mandatory for all Marketing documents including passing manual Journals

regards

KARTHIK

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 10:31 AM

    Hi

    This is for A/R invoice Document.. by the way you can proceed by changing object type

    If @object_type = '13' and (@transaction_type = 'A')
    begin
    IF EXISTS (SELECT T0.DOCENTRY FROM OINV T0 Inner join inv1 T1 on T0.DocEntry=T1.DocEntry WHERE (T1.ocrcode is null 
    ) AND T0.DOCENTRY = @list_of_cols_val_tab_del)
    begin
    set @error = 1
    set @error_message = 'Choose Profit Center'
    end
    end

    Regards,

    Sudhir B.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 10:57 AM

    Hi!

    In SAP 8.81, this feature has come as a default setting under General settings.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 11:57 AM

    Hi,

    What is your SAP Version and Patch Level ?

    In prior to 8.81 you use the Stored Procedure

    If You have in 8.81 then default option is there to make a mandatory in procit center.

    *Close the thread if issue solved.

    Regards

    Jambulingam.P

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 24, 2011 at 12:17 PM

    Hi ,

    To make profit centre mandatory in 2007 and 8.8 versions, look at http://wiki.sdn.sap.com/wiki/display/B1/SAPB1SQLZ-TSSettingMandatoryField , change T0.Project to To.OcrCode in query.

    It will set profit centre as mandatory field on all marketing documents.

    In 8.81 , go to general settings and set profit centre as mandatory field.

    Thanks,

    Neetu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 12:49 PM

    Hi Sudhir

    Thanks a Lot. It's working fine.

    regards

    KARTHIK

    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.