Current Position:Home > SP Journal Entry

SP Journal Entry

Update:11-30Source: network consolidation
Hi All,
We need a validation when we create a journal entry in Financials->Journal Entry, where we need a UDF to be selected, but when we create this SP, it validates every single document (marketing, payments, etc) that creates a journal entry.
IF (@object_type = '30' AND @transaction_type = 'A')
--IF (@transaction_type = 'A')
   if  exists (select * from OJDT WHERE TransID= @list_of_cols_val_tab_del and (U_CUB_Reporte='01' OR U_CUB_Reporte IS NULL))
          SET @error = -1
            SET @error_message = 'El Campo Reporte de Ventas debe ser asignado'
What do we need to consider in order to make a SP only works in a journal entry in the financials module?, a journal entry of a manual origin.
Thanks in advance.

The Best Answer

Hi Mariaem.....
Try this........
IF (@object_type = '30' AND @transaction_type = 'A')
--IF (@transaction_type = 'A')
   if  exists (select * from OJDT WHERE TransID= @list_of_cols_val_tab_del and
(U_CUB_Reporte='01' OR U_CUB_Reporte IS NULL) And TransType=30)
          SELECT @error = -1,
            @error_message = 'El Campo Reporte de Ventas debe ser asignado'
Hope this will help you...........
  • Error while posting to Tax Journal Entry for sales and use tax Update:10-11

    Hi, I am trying to post a journal entry (FB50) to cleanup and correct the liability on our sales and use tax. All  lines are giving warnings and messages.Give me a suggestion  on how to get it to post .  Or if needed, another solution to correcting t

  • Decimal Places in Item Cost must be 6 characters while in Journal Entry 2. Update:10-11

    I have the following problem: Accounting needs to see and work with 2 decimal places, but the item cost is needed in 6 decimals. If I register a A/P Invoice and i go to the Journal Remark, the Journal Entry should be in 2 decimals. If i look for the

  • NULL Value in Journal Entry and Wrong Tax Summary Update:10-11

    Hi people, I need your expert help for a big problem that appens to some customers. They run SAP BO 8.8 SP:00 PL:12 This is the scenario: You insert a new documet,  A/R Invoice or A/P Invoice is the same, problem appear in all of them. After you inse

  • Preview of Journal Entry - G/L effect , GL Mapping reference Update:10-11

    Hi All, I have observed that due to non availability of preview of Journal Entry - G/L effect, there are chances that customer/users come to know of wrong G/L Mapping after the posting of transaction. If an option to preview the G/L effects before ad

  • Background Journal entry for Incoming payment Update:10-11

    Dear Experts, Would you please help me in how to get the journal entry for an incoming payment entered as "payment on account". The relationship map does not show this, but I can see the credit entry for the customer is passed. same happens for

  • Automaticly offer outstanding items of a business partner in journal entry Update:10-11

    One Customer ist a stright bookkeeper. Hi only likes to book in the journal and won't use the banking wizzard. Is there a possibility, that there will be automaticly an offer with the outstanding items of the business-partner when making a journal-en

  • *Journal Entries while uploading the vendor master data from legacy system* Update:10-11

    hi SAP Folks, can any one of you tell me the journal entries while uploading the vendor master data from legacy system to SAP system. Eg: legacy system is having 10000 vendors list, 1 reconciliation account and $ 1000000. while uploading all these da

  • Bank statement Nr in journal entry and Payments Update:10-11

    In Notenumber 1374872 (SP 01/PL7) a change has been implemented that the number of the payment run is copied to the remarks of the payment and the journal entry. I think it will be good idea to do the same for the number of the bankstatement in bank

  • Manual journal entries created in Ap did not see in Accounts Payable Trial Update:10-11

    Hi Experts, Report Accounts Payables Trial Balance, with parameter Include SLA/Manuals/Other Sources Flag set to Yes, does not show manual journal entries. These Manual journals entries are created in AP Navigation: Payables -->Accounting --> Subled

  • Stock Posting does not tally with Journal Entry Update:10-11

    Hi Mentors, I currently trying to see the cause of a particular issue with the JE being created by Stock Posting. After scavenging the forums, I came across SAP Note 1525960. Symptom On creating Inventory Posting in locked Posting Period, system give