I want to control stockitems

Discussion in 'Requests' started by NAGARAJKMAR SUBRAMANIAN, Apr 22, 2012.

    
  1. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    I want to control stockitems based on rate given in Pricelist for particular party

    we are having 100 stock items have diffrent rates for different parties.

    i.e. I am fixing rates for only items for Party A and Price List A

    Creating Invoice for Party A

    only that items given rate in price list should appear for billing?

    How to achive this through TDL Code?
     
    kamalpatel likes this.


  2. admin

    admin Administrator Staff Member


    you can do this using TDL. Approach to do this

    1. Create a Price List
    2. Attach the priclist for the Party in the Customer Master
    3. During the Transaction entry,in the [Field: VCH Stock Item] , Remove the existing Table and add a new stock item collection which contains this price list.


    May be this leads to performance issue. But try it.

    If anybody had better solutions for this, please welcome.
     



  3. Same Approch in different Way

    1. In a customer Master Take 2 aggregates one for the items which the customer is going to purchasing from You. For Each Item Capure 2 Field
    Applicable Date and rate .

    ex. Take One Subform in Customer Mater
    Purchase Items : Yes
    When you enable Yes The Subform will open Then you Add Aggregate with 2 field (Item and One Logical Field)
    Then In That Line if You Enable Yes for Logical field Enable one More Subform there you add one more Aggregate to capture the 2 Fields Applicable Date And Rate

    2. In The [Field : VCH Rate] And [Field : VCH Batch Rate] Get The Value of Rate Which you have Stored in that Customer Based on Comparing The Applicable Date and Voucher Date.

    3. The Price List Of The Item For the Customer you Can Update in Customer Master itself. You Can import The Price list Also from Excel Sheet.

    Note : As Sir Above sujested you can do During the Transaction entry,in the [Field: VCH Stock Item] , Remove the existing Table and add a new stock item collection which contains this list of items in Customer Master
     
    Shetmano likes this.


Share This Page