Current Position:Home > Approval Query for a specific customer group

Approval Query for a specific customer group

Update:10-11Source: network consolidation
Advertisement
Dear Experts,
             Following is the scenario, customer deals with whole sale and retail customers group. The client wishes to ensure that If the whole sales customer group account balance greater than zero then while making a sales order or invoice it should trigger approval.
Saravanan

The Best Answer

Advertisement
Hi Saravnan......
Thy this Approval Query and just put the Group Code for your customer in this group code's inverted comma....
SELECT Distinct 'TRUE' From OCRD T0 Where T0.Balance>0 and GroupCode=' '
And T0.CardCode=$[ORDR.CardCode.0]
If above does not work then use below...
SELECT Distinct 'TRUE' From OCRD T0 Where T0.Balance>0 and GroupCode=' '
And T0.CardCode=$[$4.0.0]
Regards,
Rahul
  • Approval Query for a specific customer group Update:10-11

    Dear Experts,              Following is the scenario, customer deals with whole sale and retail customers group. The client wishes to ensure that If the whole sales customer group account balance greater than zero then while making a sales order or i

  • Approve suppliers only for specific material groups Update:11-30

    Dear Experts, Current scenario: Our purchasers can buy products from all material groups from every boarded supplier. E.g. they can buy production materials from an office paper supplier. Target scenario: The moment a purchaser buys a material that's

  • Change Customer Address format with specific customer group Update:11-30

    Dear all, May I ask is it possible to change customer address fomat for a specified customer group or Company code only. Normally, the format is Street, City and Country. for a special cusomer group, i wan to change the format to street , street 2, s

  • Re: Create Custom Group - All devices minus specific devices. Update:11-30

    Worked ... perfect thanks!Hi Please help ...I want to create a custom group with the following attributes. 1) Contains all devices. 2) I want to be able to exclude specific devices if required. 3) I want all devices to be included automatically in th

  • Approval Query to skip for one Vendor Group - Not working Update:11-30

    Dear All, I am trying to create an approval query wherein when a user creates a Purchase Order for a Particular Vendor Group then the approval check is not required and for other Vendor Group approval check is required. The query is as under : SELECT

  • Approval Query on multi-level line discounts Update:11-30

    Hi Experts, I have this query that is attached in the A/R Reserve Invoice> free text field that triggers different values corresponding to the to approval levels of the management. The query is triggered when a discount is manually change. Also, the

  • The risks of not configuring the countries in their specific country group? Update:11-30

    Hi Experts, Please let me know the the risks of not configuring the countries in their specific country group /Molga, rather assigning them to international MOLGA 99. I have in my SAP HR box many countries assigned to their MOLGA, but some of them li

  • "Custom" grouping and / or colored lines in ALV Update:10-11

    Hi! Two questions: 1. Is it possible to use colors in the ALV for a given set of rows? I'd like to mark rows with a color, which are logically belongs together. 2. Other approach would be to sort the ALV and via that the "similar" rows (i.e. som

  • How to run a SQL based query against a specific collection Update:10-11

    Hello, I have used this query to make a custom reports, it works but all machines are mixed up, So I am looking for a way to run it against collection group win 8 or win 8.1. or if I can add a line to this query so it will also display OS version. SE

  • Partner functions for a specific customer not seen in XD03 but appears in XD02 Update:10-11

    Hello SAP Gurus, I have a situation where a partner functions for a specific customer not seen in XD03 but appears in XD02, In XD03 only one partner function (Ship to) appears but in XD02 (Sold to, Ship to, Bill to and payer appears), from the custom