Modifying report - Inventory Status by item

System
System Member Posts: 212 Moderator Moderator
in Accounts Hosted
This discussion was created from comments split from: Statements Template.

Comments

  • prasanna
    prasanna Member Posts: 65 Reckoner Reckoner

    Hi Team ,

    I can't filter out column in green, because it doesn't appear in the filter area in modify report tab

    Thanks Team

    image.png
  • Alexis McKeown
    Alexis McKeown Reckon Staff Posts: 504 Reckon Staff Reckon Staff

    Dear @prasanna,

    For Inventory Status by Item, you cannot filter by Units of Measure, Order, or On Product Order.

    These columns are not filterable on reports, mostly due to the following reasons:

    1. Units of Measure are containers for items in lots, as such, it is not a fully sortable column.
    2. Order will only tell you if it is currently on-order, and therefore, it is not classified as data to be sorted.
    3. On PO (On Product Order) is like Order, and does not contain data that Reckon Accounts can sort.

    This is a limitation of the current Reckon Accounts system, and to my knowledge, there are no reports where you could reasonably sort/filter these columns.

    You may wish to run a Custom Transaction Detail report, and toggle off these columns, and instead give you the data you can sort/filter.

    Kind regards,

    Alexander McKeown

    Reckon Senior Technical Support

Categories