Dear team I need the following report. Sales Report Item wise while selecting particular sales group. Report format- Invoice No- Date- customer Name-Qty-Unit-Rate-Stock item please find the attachments for your reference. Iam ready to pay for tdl..Contact me -6238786996
How much you are ready to pay. It will be donation to this website. Dear admin I will deliver the code as and when this will be credited. Account details you will get from thread
I GOT THIS CODE FROM THIS FORUM I TRIED MY BEST TO SOLVE THE PROBLEM CAN ANY 1 CHK AND MAKE CORRRECTION PLZZ ;;[Function: ReceiptVchCreate].......................... Function create problem please solve [Collection: Cash Class Ledgerscash] Use : VLedTable Type : Ledger Title : $$LocaleString:"List of Ledger Accounts" Collections : Notapplicable Include : Group:$$GroupCash ;Include : Group:$$GroupBank ;Include : Group:$$GroupBankOD Native Method : Name, Parent, ReserveName Keep Source : () Client Only : Yes Filter : ClassFilter ;;IsCashAccountVchRE [Collection: Cash Class LedgersBank] Use : VLedTable Type : Ledger Title : $$LocaleString:"List of Ledger Accounts" Collections : Notapplicable ;;Include : Group:$$GroupCash Include : Group:$$GroupBank Include : Group:$$GroupBankOD Native Method : Name, Parent, ReserveName Keep Source : () Client Only : Yes Filter : ClassFilter ;;IsBankAccountVchRE [Function: ReceiptVchCreate] Action : 01 : QUERYBOX : "Create Receipt Voucher ?":Yes:No Action : 02 : IF : $$LastResult Action : 03 : NEW OBJECT : VOUCHER Action : 04 : SET VALUE : Date : $date Action : 05 : SET VALUE : VoucherTypeName : $$VchTypeReceipt Action : 06 : SET VALUE : Narration : $Narration Action : 08 : INSERT COLLECTION OBJECT : AllLedgerEntries Action : 09 : SET VALUE : LedgerName : $Partyledgername Action : 10 : SET VALUE : Is Deemed Positive : "no" Action : 11 : SET VALUE : Amount : ($VchReceiptInfo+$VchReceiptInfo2) ;;($VchReceiptInfo+$VchReceiptInfo2) ;;$Amount Action : 12 : INSERT COLLECTION OBJECT : BillAllocations Action : 13 : SET VALUE : BillType : $$SysName:Advance Action : 14 : SET VALUE : Name : $vouchernumber Action : 15 : SET VALUE : Amount $VchReceiptInfo+$VchReceiptInfo2) ;;($VchReceiptInfo+$VchReceiptInfo2) ;;$amount Action : 16 : SET TARGET : ... Action : 17 : INSERT COLLECTION OBJECT : AllLedgerEntries Action : 18 : SET VALUE : LedgerName : $VchReceiptdr Action : 19 : SET VALUE : Amount : $VchReceiptInfo Action : 20 : SET VALUE : Is Deemed Positive : "yes" Action : 21 : SET TARGET : .. Action : 17a : INSERT COLLECTION OBJECT : AllLedgerEntries Action : 18a : SET VALUE : LedgerName : $VchReceiptdr2 Action : 19b : SET VALUE : Amount : $VchReceiptInfo2 Action : 20c : SET VALUE : Is Deemed Positive : "yes" Action : 0060 : INSERT COLLECTION OBJECT : BankAllocations Action : 0061 : SET TARGET : BANKALLOCATIONS Action : 0070 : SET VALUE : Date : $VCHBankDate Action : 0080 : SET VALUE : InstrumentDate : $VCHBankDate Action : 0090 : SET VALUE : InstrumentNumber : $VCHChequeno Action : 0091 : Set Value : Name : $$MakeUniqueID Action : 0092 : SET VALUE : PAYMENTMODE : "Transacted" Action : 0100 : SET VALUE : PaymentFavouring : $partyledgername Action : 0110 : SET VALUE : TransactionType : $$Sysname:ChequeDD Action : 0120 : SET VALUE : UniqueReferenceNumber : $VCHChequeno Action : 0140 : SET VALUE : ChequeCrossComment : $$LocaleString:"A/c Payee" Action : 0150 : SET VALUE : Amount : $VchReceiptInfo2 * -1 Action : 0160 : Set Target : .. Action : 22 : SET VALUE : PersistedView : ##SVViewName Action : 23 : CREATE TARGET Action : 24 : ENDIF [#System: Formulae] IsCashAccountVchRE : $ReserveName = ##GroupCash IsBankAccountVchRE : $ReserveName = ##GroupBank OR $ReserveName = ##GroupBankOD