Dear Sir, Using ODBC How can i export item details (Product Name, Alias, Group, Category, Purchase Price, Sales Rate, Closing Stock ) to excel ?
Hi, Write a voucher collection for Vouchers (primary object), using that collection as a source write another collection whereas the secondary objects (Ledger Entries, Inventory Entries) . Make it " Is ODBC Table : Yes"
Stock Item Object is already available for ODBC .. But you want some method to exposed then use below Special Symbol. [#object: Stock Item] _ClosingBalance : $ClosingBalance means: Add "_" symbol infront of Method Name. So now _ClosingBalance will be available in ODBC