Code: [#Field: VCHBATCH GRNName] Add : Option : VCHBATCH NrmlName KNS : @@IsPurchase [!Field: VCHBATCH NrmlName KNS] Set By Condition : $$InCreateMode : 123456 You can add Anything as your logic You Should Try.
But it creates same batches, there is no variation or difference in those batches while creating purchase entry... As Suggested by KNSivam Sir, I have use this logic $$Numsets: (ST/) +1 But it is not working
[#Field: VCHBATCH GRNName] Add : Option : VCHBATCH NrmlName KNS : @@IsPurchase [!Field: VCHBATCH NrmlName KNS] Set By Condition : $$InCreateMode : ($$RandomNumber:100000:999999)
Sir, Thank you so much for your Immediate reply....Sir It worked for new entries only but not working in early entires which are already posted. All entries are about 100 + entries how can I give them auto batches while editing them.....All Entries are in Primary Batches now.... pls help me on this.... Can I can send you the data and the code file to review the errors... Kindly Share your email so I will sent you the DATA and Source Code file.
Do it like this: [#Field: VCHBATCH GRNName] Add : Option : VCHBATCH NrmlName KNS : @@IsPurchase [!Field: VCHBATCH NrmlName KNS] Set By Condition : Yes: If $$IsEmpty:$$Value Or $$IsEqual:$$Value:"Primary Batch" Then $$RandomNumber:1:999 Else $$Value Note: You would need to re-accept purchase vouchers in order to update batch names
1.How to calculate no of days from Purchase Voucher Date to Sale Voucher Date in report? 2.How to calculate subtotals only of Stock Opening & Closing Qty, Rate & Value? Please Help......
1. #SalesDateField - #PurchaseDateField 2. I think you use Explode. So, we can't total it. If you need grand total, you should add values in Main line.
Yes Sir I have use explode but unable to get grand total of opening and closing stock ....The value of opening and closing stock get double due to it takes totals including explode..