[#Part : EXPINV InvInfo] Repeat : EXPINV InvDetails : Sorted Inventory Entries [Collection : Sorted Inventory Entries] Type : Inventory Entries : Voucher Sort : Default : $Parent : StockItem : $StockItemName, $StockItemName This works to Sort First By Parent then by Stock item. But when I do this Type : Inventory Entries : Voucher Sort : Default : $Category : StockItem : $StockItemName, $StockItemName It fails says Bad formula. I want the inventory items to first be sorted by category then by stockitem name.. Can anyone guide whats the error that I am doing.
Nevermind.. Figured it out and Solved it.. Correct Code is [#Part : EXPINV InvInfo] Repeat : EXPINV InvDetails : Sorted Inventory Entries [Collection : Sorted Inventory Entries] Type : Inventory Entries : VoucherType : Inventory Entries : Voucher Sort : Default : $category:stockitem:$stockitemname