sir, The Data Containing two financial year and the Purchase bill entered in march 2021 and the same purchase bill entered in april 2021 by mistake and assumption that the goods received in april 2021 in this situation the duplicate control not work because of financial year changed to current year 1-4-2021 to 31-03-2022 please guide me how to check the collection and filter
USE.....in your Collection........... Parm Var : SVFromDate : Date : @@PrevYearStart Parm Var : SVToDate : Date : ##SVToDate
[Collection : ClnSaleInfo] Type : Voucher ; Stock Item Child Of : $$BaseOwner:#VchRef Filter : SalesFilt Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName,reference,ReferenceDate
system formulas party01:$$CollectionField:$LedgerName:1:ClnSaleInfo party02:$$CollectionField:$Reference:1:ClnSaleInfo party03:$$CollectionField:$amount:1:ClnSaleInfo party04:$$CollectionField:$ReferenceDate:1:ClnSaleInfo