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

Inventory

Hi,

My client has a problem regarding PO.

When ever he raises the PO fro example he requires the material of 10tons but he receives 11tons instead of 10 and also in some cases he receives 10.4tons for him there is a loss of 0.4 tons or 1ton how can he resolve this problem.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Apr 28, 2008 at 08:09 AM

    I do not understand the problem. You client can modify the quantity when he create a GRPO (or AP Invoice). He can do it inside the Draw Document Wizard or overwriting the quantity in the derived document.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      if you use standard approval procedure in SAP B1, the document can be directly set to be approved by manager. Nevertheless, it is not available until row level approval but it is just in the title of the document.

      If you use SP_TN, then there is no authorization for that but only validation of document.

      I see that the approval you want is deal with row level and in SBO standard, it does not cover it. using validation, the user can be warned and reenter the quantity in GRPO not exceeding the PO qty.

      This is another SP_TN:

      IF @transaction_type IN (N'A', N'U') AND 
      (@Object_type = N'20')
      begin 
      if exists (SELECT T0.BaseEntry, 
      SUM(T0.Quantity) FROM [dbo].[PDN1] T0 INNER 
      JOIN [dbo].[POR1] T1 ON T1.DOCENTRY = 
      T0.BASEENTRY
      WHERE T0.BaseType = 22 AND T0.ItemCode = 
      T1.ItemCode AND T0.BaseLine = T1.LineNum
      and T0.DOCENTRY = @list_of_cols_val_tab_del
      GROUP BY T0.BaseEntry
      HAVING (SUM(T0.Quantity) > SUM(T1.Quantity)) or sum(t0.quantity) > sum(t0.BaseOpnQty))
      begin
      select @Error = 10, @error_message = 'GRPO quantity is over PO quantity'
      end
      end

      Rgds,

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.