Case 01052719

[Nicola6]

Hi

Can someone please contact me regarding case number 01052719. We need a script run on our items data and n one has contacted me back regarding this.

Thanks

[Komal_S]

Hi @Nicola6 

Can you please provide the details of the error you are getting while trying to import the inventory items so we can follow this up ?

[Nicola6]

The report just runs blank. We did an items import and export. Using the backup data before the report works but using the live data after the import the report does not work

[Komal_S]

Hi @Nicola6 

What is the name of the report that you're trying to run ?  Or is it happening with every items report ? 

[Nicola6]

It's a custom report. 

[Komal_S]

Hi @Nicola6 

If the custom report is not displaying anything, it might be due to corruption, please run the actual report, create the custom report again with the fields required and the correct data should be displayed. 

[Nicola6]

Hi Komal

I have tried this solution and found that the standard sales report - Analyse Sales [Item] does not work. Why would this be?

[Komal_S]

Hi @Nicola6 

This can happen if there are transactions having items which are no longer marked as "I Sell". This can be identified by exporting items and seeing which ones have income accounts but no 'S' for I sell.

 If you try to select some items and then run the report, it might work, but we are aware of this report not displaying any information in some circumstances and have raised it with the teams. We do not have an estimated time frame of when it will be fixed permanently but will post an update if we have further information. 

[Nicola6]

Hi Komal

The items that should appear on the report do have an S against them. This report worked when we restored a previous backup.

We really need a solution for running this standard report.

Thanks

[Komal_S]

Hi @Nicola6 

Our teams are still trying to work out a permanent solution for this report, in the meanwhile, it will be recommended to try selecting one item at a time and then run the report. If it doesn't work, please run alternative reports and we'll post an update once anything around this one changes.