free code :- Custmoer Item Rate fixed

Good to see you again.

Bundle not sent by you till date.

 

ok thanks

 

After a long break, hope you developed a bundle of TDL's, please share it as committed by you earlier. Waiting for the Bundle.

 

still bundle are waiting

 

Where is Bundle ?

 

sir ,
when I set alter price to yes ..after saving its autometicaly comes to NO .

 

Dear All Members,

If you want fixed rate then Change Control As Under:

[#Field: VCH NrmlRate]

Control : MyRateControl : $(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate >< $$Value And $$IsSales:##SVVoucherType

 

Sir I have a query from all...

What if we use RATE PRICE FIELD instead of Amount Field in your Field MSTSFItemRate?????

I checked that it is not validate if we use RATE FIELD. I want to know how we can use Rate Field for this. I need a solution for my knowledge. Kindly all concern about this and let us know.

Thanks in advance.


Shamsher Singh

 

nice report as per your screen xls attachment but where is updated code

 

Can't we save the rates inclusive of GST

 

I heartily appreciate you for your thoughts.
Thanks for sharing.
Keep it up.

 

Code:

[#Part: MST LED Explode Sundry]
    Add : Line : At end : ItemRateSetings
[Line :  ItemRateSetings]
  Field : Medium Prompt, ItemRateSetings
  Local : Field : Medium Prompt : Set As : "Set/Alter Item Rates :"
    [Field :  ItemRateSetings]
        use : Logical Field
        Set aS : No
      Sub form : ItemRateSF : $$Value
[Report : ItemRateSF]
    Form :ItemRateSF
    [Form :ItemRateSF]
        Part :ItemRateSF
        [Part :ItemRateSF]
            Line : ItemRateSF
            Repeat : ItemRateSF : ItemRatesAggregate
            Scroll : Vertical
            Break on : $$Isend:$MSTSFItemName
            [Line :ItemRateSF]
                Field : MSTSFItemName,MSTSFItemRate
          [Field : MSTSFItemName]
                  Use : Name Field
                    Storage :MSTSFItemName
                    Table : MyStockitems,End of List
                [Field : MSTSFItemRate]
                    Use  : Amount Field
                    Storage :MSTSFItemRate
                    Inactive : $$IsEnd:$MSTSFItemName
[System : UDF]
ItemRatesAggregate    : Aggregate : 21000
MSTSFItemName        : String    : 21001
MSTSFItemRate        : Amount    : 21002
[Collection : MyStockitems]
  Title : "List of Items"
    Type : StockItem
    Format : $Name,25
[#Field: VCH NrmlRate]
set as    :$(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate


[System : Formula]
IsSameItem : $$ReqObject:$Parent:StockItem:$StockitemName = $MSTSFItemName

i have not checked its buts modifie pls check its

 

Please tell me from where we have to set/alter the rates??

 

Now its not taking the rates automatically.
Cant we make it such that it takes thae rates automatically??

 

How to remove number...only

 

;; This is Working fine i am wriiting a collection of ledger & set with collection field by key


[#Part: MST LED Explode Sundry]
Add : Line : At end : ItemRateSetings
[Line : ItemRateSetings]
Field : Medium Prompt, ItemRateSetings
Local : Field : Medium Prompt : Set As : "Set/Alter Item Rates :"
[Field : ItemRateSetings]
use : Logical Field
Set aS : No
Sub form : ItemRateSF : $$Value
[Report : ItemRateSF]
Form :ItemRateSF
[Form :ItemRateSF]
Part :ItemRateSF
[Part :ItemRateSF]
Line : ItemRateSF
Repeat : ItemRateSF : ItemRatesAggregate
Scroll : Vertical
Break on : $$Isend:$MSTSFItemName
[Line :ItemRateSF]
Field : MSTSFItemName,MSTSFItemRate
[Field : MSTSFItemName]
Use : Name Field
Storage :MSTSFItemName
Table : MyStockitems,End of List
[Field : MSTSFItemRate]
Use : Amount Field
Storage :MSTSFItemRate
Inactive : $$IsEnd:$MSTSFItemName
[System : UDF]
ItemRatesAggregate : Aggregate : 21000
MSTSFItemName : String : 21001
MSTSFItemRate : Amount : 21002
[Object :MSTSFItemRate]
[Object :ItemRatesAggregate]
[Collection : MyStockitems]
Title : "List of Items"
Type : StockItem
Format : $Name,25
[#Field: VCH NrmlRate]
Set as:$$CollectionFieldByKey:$rsrchartycoll
srch:#EIConsignee +#vchstockitem
[#Field: VCHBATCH ItemRate]
Set as:$$CollectionFieldByKey:$rsrchartycoll
srch:#EIConsignee +#vchstockitem
[Collection : SaleVchColll]
Type:ledger
Fetch:NAME
[Collection : PartyColl]
Source Collection : SaleVchColll
Walk : ItemRatesAggregate;InventoryEntries, batch allocations
Compute : Pname : $Name
Compute:item:$stockitemname
;Aggr Compute : Rate : sum : $Rate
Compute:b:$MSTSFItemName
Compute:r:$MSTSFItemRate
Search Key:$Pname + $b

 

---- but rate is not shown fixed one or neither takes automatically -- showing when doing accounting voucher

 

sir, thanks for sharing above code, sir can you modify above code to include discount also along with rate.

 

Can we set Rate based On Batch.