Sort Error - Pls Repair Code

Discussion in 'Free Source Codes' started by Adeshwar Mehta, Apr 25, 2022.

    

  1. [#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.
     



  2. 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
     


Share This Page