Batch Mfd Date Sort

Dear Friends & Experts,

I Want to Sort "Collection : Active Batches VchExtract " in MfdOn but it is not working please help me.
is always sorting with batch name only.

Thanks in advance

Gopaal Sarawagi

 

If you are trying to order in Table then it will sort only on first "Format" value. In your case it is $Name, so it will sort only by $Name if you are using table.

 

Thanks Maulik

 

problem in stock summary

sir
I have come to the cause of the problem
The problem occurs because of the cost of each separate godown
For example
i have tow godowns (godown 1 and godown 2)
and i have one item ( item a ) and i will use cost avg
If i buy 10 item a in godown 1 rate 10 total amount will be in godown 1 100
and If i buy item a in godown 2 rate 9 total amount will be in godown 2 90
total amount in all 190 this good but the problem is in separate cost to each godown
in this case if i transfer 5 unit from godown 2 to godown 1 the rate cost in godown 1 is 9.67 total amount in godown 1 = 15*9.67=145 and the rate cost in godown 2 is 9 total amount in godown 2 =5*9=45
to now no problem
but now if i transfer stock 10 unit from godwn 1 to godwn 2 this is the problem here u can find loss 1.64 and cost to godwon 1 will be 5 unit*9.67=48 and cost to godwon 2 will be 15 unit *9.34=140.03
in first i had stock in total in all company =190
now my stock in total company is 188.36
no sales this is just transfer
sir solution this problem is very easy
1- transfer stock in stock jv must be without rate and amount
2- if i buy the same item in more than godown in Different rate must be find allocation this cost in each godown (means not godown 1 10 unit *10 =100 and in godown 2 10 unit * 9=90 this is very wrong this is the problem must tally give me cost like in godwon 1 10 unit *9.5= 950 and in godown 2 10 unit * 9.5=950 auto allocation cost in all godowns if tally to that this problem will done )
sir separate cost in each godwon is very wrong must be when purchase by Different rate in any godown must be change all rate in other godown must be the in all godwns is the same
1-sir if we buy stock in godwn 1( 10 unit rate 10 amount will be 100 )
and if i buy the same item in godown 2 (10 unit rate 9 amount will be 90)
total amount in godown 1( 100) and total amount in godwn 2 (90) and rate in godown 1 will be (10) and rate in godown 2 will be (9) this is Reason the problem in consumption the is the wrong
i want the same rate in all godown ( rate must be in godown 1 (9.5) and in godown 2 ( 9.5)
this is no.1 to solution my problem
2-and after that remove stock jv from stock summary
3-and in stock jv voucher i want hidden rate and amount (that in voucher stock jv entry )
this all i want ​

 

simply do not put rate when you transfer item from one godown to another godown in the transfer entry. It will keep your average cost same.

 

I was facing the same issue, i wanted to sort the collection by expiry date..but even when i set the first Format as ExpiryPeriod, its sorts the column in terms of alphabetic order of the month..therefore April is coming before March..I want it to sort in terms of the date itself..Please help