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

Error Creating AR Invioce

Hi Experts,

When i am copying delivery to A/R Invoice, I faced error message: "The value of the document input parameter 'Unit price is missing' ". I am not able to copy the document in A/R invoice. Please guide me.

Thanks and Regards,

Manikandan

Edited by: Mani S kandan on Jul 17, 2009 4:11 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 11:25 AM

    hi

    TRY to copy from A/R invoice

    Ashish Gupte

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 12:17 PM

    do u get any error message?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Raj,

      I tried in Test DB and i disconnected all the addons , the error message is "The value of the document input parameter 'Unit price is missing'". The row level of the document Unit Price field is okay.But not only A/R invoice,i am not able to copy Return, Outgoing excise invoice in particular delivery document. Please guide me.

      Thanks and regards,

      Manikandan

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 04:57 PM

    Hi Manikandan,

    In your delivery form, change your form settings to display Unit Price field. If all prices are fine in that field, check if you have any add-on, SP or FMS that causes the error.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 17, 2009 at 05:20 PM

    Hi Mani,

    If you are using any addon in this process, take a backup of the db.

    Restore the backup as a testsystem.

    - Do NOT install or connect the addon to this db.

    - Comment out/delete any SP Transactions Notification.

    Now try to copy the Delivery to the Invoice.

    Let us know how it goes.

    Jesper

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jesper,

      I was tried in Test DB as you mentioned but still the error shown. How can i identify/delete any SP Transactions Notification in document.we are not able to post new A/R invoice Please guide me

      Thanks and Regards,

      Manikandan

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2009 at 04:58 AM

    Hi Mani,

    Procedure for Check any Stored Procedure are written in your DB

    1.Start->All Programs->Microsoft SQL Server 2005->SQL Sever Management Studio

    2.Click Databases it shown all the DB Select your DB

    3.Click Programmability

    4.Click Stored Procedure

    5.Choose dbo.SBO_SP_TransactionNotification

    6.Right click->Modify

    7.It opens the SP

    8.Check Below the ADD YOUR CODE HERE if any code are written if any thing written comment

    the written code and check the Delivery to Invoice any error shown

    The problem is not solved then Better Post a Message to SAP Support Center with HIGH Priority and also

    the Error screenshot are attached to the message.

    *Close the thread if issue solved.

    Regards

    Jambulingam.P

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jambulingam,

      I was tried to follow as you mentioned : Please find the below code.

      
      set ANSI_NULLS ON
      set QUOTED_IDENTIFIER ON
      GO
      ALTER proc [dbo].[SBO_SP_TransactionNotification] 
      
      @object_type nvarchar(25), 				-- SBO Object Type
      @transaction_type nchar(1),			-- [A]dd, <u>pdate, [D]elete, [C]ancel, C[L]ose
      @num_of_cols_in_key int,
      @list_of_key_cols_tab_del nvarchar(255),
      @list_of_cols_val_tab_del nvarchar(255)
      
      AS
      
      begin
      
      -- Return values
      declare @error  int				-- Result (0 for no error)
      declare @error_message nvarchar (200) 		-- Error string to be displayed
      select @error = 0
      select @error_message = N'Ok'
      
      --------------------------------------------------------------------------------------------------------------------------------
      
      --	ADD	YOUR	CODE	HERE
      
      --------------------------------------------------------------------------------------------------------------------------------
      
      -- Select the return values
      select @error, @error_message
      
      end
      
      

      Thanks and Regards,

      Manikandan

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2009 at 06:13 AM

    Hi Mani,

    There is NO Stored procedure are written, so better Post a Message to SAP Support Center.

    *Close the thread if issue solved.

    Regards

    Jambulingam.P

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks to all,

      The issue was solved . SAP Support Centre fix the issue as follow:

      After further investigation we found that the root cause for the reported issue is the tax definition of the tax code selected in the fright of the document footer. 
      
      The formula of tax code VAT@0 includes #UnitPrice# parameter (VAT_BaseAmt=UnitPrice * Qty), although this parameter does not exist in Freight. 
      
      We were able reproducing the same error message with the following steps: Create new Delivery, 
      before adding the document click on the #Freight# arrow link, select tax codeVAT@0 for one of the 
      fright s and enter an amount. 
      
      The error message #The value of the document input parameter 'UnitPrice' is missing# will appear. 
      
      We also test that changing the VAT@0 formula to use the parameter #Total# instead of #UnitPrice# (VAT_BaseAmt=Total) solves the issue (Delivery 10026 can be copied to Return/ A/R Invoice). 
      
      Please check and test the above steps. 
      

      I was checked my DB....... Now its work fine.

      Thanks and Regards,

      Manikandan

      Edited by: Mani S kandan on Aug 11, 2009 5:12 PM

      Edited by: Mani S kandan on Aug 11, 2009 5:13 PM

  • Posted on Jul 27, 2009 at 09:16 AM

    hello

    u do one thing man while ur copying from Delivery to A/r Invoice just go for form setting and see row format whether unit price checked or unchecked if not pls do check it and use copy to that u will get required result

    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.