Forum Discussion

Mike_James's avatar
Mike_James
Ultimate Partner
4 years ago
Solved

Analyse Sales (Item - FY comparison) - no information to display

Hi, I have this issue with a client's cloud file. Even selecting one item and 'include zero balances' gives the same result. I have cleared the cache, with no change.    Analyse Sales (Item) report...
  • Steven_M's avatar
    Steven_M
    4 years ago

    Hi Mike_James 

     

    I've arranged for some inventory scripts to be run over the company file. In short, these tidy up some of the item's history and rounding issues. So do give that report a try now.

     

    However, I do see that we are aware of an issue with some company files that those Analyse Sales [Item] based reports can show Nothing to display. This is something that we have been investigating and it does appear to be an issue with custom list entries for these files. While not feasible or an ideal workaround, removing the custom list entries for items has worked and allowed the report to be run for the majority of those cases.

Steven_M's avatar
Steven_M
Former Staff

Hi Mike_James 

 

I've arranged for some inventory scripts to be run over the company file. In short, these tidy up some of the item's history and rounding issues. So do give that report a try now.

 

However, I do see that we are aware of an issue with some company files that those Analyse Sales [Item] based reports can show Nothing to display. This is something that we have been investigating and it does appear to be an issue with custom list entries for these files. While not feasible or an ideal workaround, removing the custom list entries for items has worked and allowed the report to be run for the majority of those cases.

Mike_James's avatar
Mike_James
Ultimate Partner
4 years ago

Hi Steven_M , thanks for your prompt response. 

 

I did import some custom list entries to item list 3, and as it happens I have a local backup of the file before & after, so I ran the same report in both, and without the custom list entries the report runs correctly. 

 

So I will have to remove those entries, probably manually, as importing an empty entry does not delete them.

  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    4 years ago

    PS Since this was the only custom list entry, I have deleted it off the list, instead of editing each item.

Related content