Dear All, We design one report which belongs to Sundry Debtors and have multiple details of each party. i.e contact details i.e total sales i.e total receipt Now in this report we want to give Last receipt value and last 30 days sales amount partywise. Both of this calculate from report's To Date. so if any one have solution then kindly give some idear. Thanks. Yash Bohra
Hi.. need to write one more collection for the last 30days party wise sales amount.. [Collection : Last30days sales] Type : Vouchers : VoucherType Child Of : $$VchTypeSales Belongs To : Yes Fetch : Date, VoucherNumber, Amount, PartyLedgerName Parm Var : SVFromDate : Date : (##SVToDate-30) Parm Var : SVToDate : Date : ##SVToDate [Collection : Last30days PartyWise Sales] Source Collection : Last30days sales By : PartyLedName : $PartyLedgerName Aggr Compute : SalesAmount : Sum : $Amount
Dear Sir, I tried out as per attached code but i can't get it properly. 1. When i open report it shows me total sales value fromdate to to date. 2. Even if i change fromdata & to date then also my sales value can't change. Herewith i attached code and jpg file for reference. Kindly give some solution. Thanks, Yash
Sir I want to export all details of sales invoice in excell like ref.no. date bill no. party name with full detail, supplimentry details , inventory part and narration. & if bill is in cash nd i enter party name in supllimentry details then also export the all the data. Please help me..