I did a batch update to sales invoices and I have lost all the customer names on the invoices.
from 2025 to 2013
In the excel that I copied to clip board and pasted in it looks like this it just has customer number
from 2025 to 2013
In the excel that I copied to clip board and pasted in it looks like this it just has customer number
Go to Sales invoice tab and click on History then Select view of the first entry. If it relates to the batch update it will show all involved. Click Undo. It should be as if before the Bulk action.
Always also create a backup before doing anything significant such as Bulk actions.
After your Business is back to before, please show an Edit screen of one of the Sales invoice records and also an Edit screen of the related Customer.
View the first one as explained. Then you will see all related will also be shown then click undo in that screen!
Oh thank you so much 
Now for the problem how do I bulk up date The sales invoices. I want to update the column has it been filed. but obviously keep the rest of the information.
The leading zeros in your customer numbers are the problem.
Format the cells in Excel spreadsheet to “Text” before pasting in data.
@Wornout I moved your cross-post here. Please note FAQ - Manager Forum
- Don’t cross-post the same question or comment in multiple topics.
oh thank you one post was asking how to fix the other was asking how to do I just assumed that was 2 different things. Once before someone said to me in a similar circumstance that I needed to ask in another post .
I have done that and it makes no diffrence
- Start with blank Excel spreadsheet and left click here to select all cells in the sheet
- Then select Text from this drop down menu
- Then paste Batch Update data from Manager into this sheet. The customer numbers should appear like this
- Make the required changes to the data and paste back into Manager.
Thanks AJD. I do know how to do it I teach all of the microsoft office suite . any how it does not work.
@Wornout you still did not provide the requested screenshots. Please do.
Thank you for the screenshots. As @AJD mentioned the leading zero may be causing you issues, but your screenshot with the spreadsheet showed that you corrected it, so it should work but you report it still does not.
So maybe test using another code for a single customer.by first making a backup of the business and by only changing one of these Customer codes in for example the letters ab rather than the number 0 and see if that would work. You obviously do a complete new Batch Update process and ensure that all is properly copied to clipboard, to the spreadsheet and then copied back into the batch update screen, select all and click the blue botton.