Forum Discussion

RPT's avatar
RPT
Experienced User
5 years ago

Stocktake Report with custom fields - AccountRight

Hi I need a stocktake report that includes one of our custom fields which shows the location of the stock, sorted by this field. I have tried several options as detailed below.  - I can include thi...
  • Neil_M's avatar
    Neil_M
    5 years ago

    Hi RPT 

     

    If the fields weren’t included in the Excel template then they wouldn’t come through on your export to Excel. That said, one way to get around this is to not use the Excel templates at all and instead export the file using a CSV format. Depending on your computer this may get saved with a .txt or a .csv extension.

     

    Assuming a .txt extension, you can trick Excel into opening it through the Open menu and changing the file type to .txt to be able to select the exported file. You will have to go through a couple of windows to tell Excel how to make sense of the information, but just read the entire window and it should become clear – it looks worse than it is. You’ll need to ensure that you select Delimited and that the data is separated by commas and this will open the file in Excel so you can format it.

     

    Do note that as this doesn’t use the template file it wont look quite as formatted as if you had exported the information direct to Excel, however it would allow you to format the information.