Skip to Content

Need a SPT for Delivery Note

Dear Experts

Am having a Customer 'Cash Customer', it Is been used in my showroom counter, when ever a customer purchase on Cash, delivery note is generated via this Customer, and I had UDF called U_PMO, in which I have Cash & Credit

Now what I need is when a user select 'Cash Customer ' then he should be able to select U_PMO as Cash, if the user select Credit then Delivery Note should not be Allowed to add

pls help me to solve

REGARDS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 23, 2017 at 10:58 AM

    Hi Vinod,

    Try this.

    Here i had given T0.CardName = CashCustomer a , Change the customer name as you had given

    if @Object_type = '15' and @transaction_type in ('A', 'U')
    
    
    begin
    
    
    IF EXISTS (SELECT T0.DocNum FROM ORDR T0  
    WHERE  (T0.CardName = 'CashCustomer' and T0.U_PMO ='Credit' ) and T0.docentry = @list_of_cols_val_tab_del )
    
    
    BEGIN
    
    
    SET @error = 15
    
    
    SET @error_message = 'Pl Select the Appropriate Payment Mode !'
    
    
    END
    
    
    end
    
    Add comment
    10|10000 characters needed characters exceeded