Incorrect receipt number when exporting sales report

[Maria_12]

When I export my sales report, the receipt number converts as a date and when I extract it, it doesn’t give me the correct receipt number, what to do?

[atik]

Oh! I also encounter the same situation every time I export my receipts. I also came here to find some solution to it, I hope someone can help us with this matter.

[Hanna]

Hello @Maria_12 & @atik

Let me help you 

When opening the file it is important to set up the settings accurately so it will not cause such an issue when exporting a report.

When using Google Spreadsheets, it is important to import the file as CSV and also not to enable the auto-convert data when extracting the file.

For more details instructions, feel free to check our article about this from our help center:

How to Open CSV File in Google Sheets

 

But if you wish to use MS Excel, it is important to set up proper settings from the application. 

To open the file in Excel, you can click on "Transform data".

Right-click the "Receipt number" column and choose the option "Chante Type" and then "Text".

A pop-up window will appear so click on "Replace current" to continue.

Finally, click on the "Close & Load" button to open the file with the correct receipt number format.

Please note: It's really important to correctly use the "transform data" feature following the instructions I gave above. As incorrect execution could lead to wrong numbers.

 

[atik]

Let me try!

Thank you so much @Hanna