We have been using custom fields to print on document.
Recently, we have updated the record through Batch Update and validated the details. However, live details are not appearing in view option on software application whereas once we export the details through Copy to Clipboard details reflect respectively.
We are not sure why such issue is happening. We will appreciate if Manager Team can assist us on Urgent Basis with a suggestion and solution.
We have updated the dates in these Custom Fields through Batch Update unfortunately these are not showing up in view and neither reflecting on printed vouchers.
If you enter the date manually in one of the document, then do batch update, copy into Excel, change the dates and then copy back to the batch update window you will see that the format of the date to be changed is not the same as the format of the date that was exported.
This may or may not be a bug - I don’t know
If you format the dates as Manager does, it should work
I suggest you try using a copy of your data, of course before doing it on your actual data
This will not work and will leave the custom field blank
But if you enter '2021-02-15 in excel that will work but be very carefule as it seems to expect ALL dates to be in this format
@Rajwani, it is also worth mentioning that unless a custom field has content, it will not display even though it is set up to do so. That is to prevent labels without content. But it appears you are in fact entering content; it just is not showing up.
@Joe91 Thank you for your suggestion and prompt assistance. After several attempts it works now to manage with time constraints but I think this is not the logical solution.
Manager has the provision of Date and Number Format so the same should be followed in all respect. As it is also evident with your screen shot that date input in a format dd/mm/yyyy which should be updated likewise but Batch Update screen shot speak different story yyyy-mm-dd!!
I disagree, as I quote earlier it is not showing in view option however actual data is updated in database which we reverified through Batch Update.
I hope Manager Team will give logical solution to manage the situation with certain guidelines.
We will appreciate Manager to guide us for date formatting.
As we have to use Batch Create and Update for other tabs and facing the same issue.
We explore Import Bank Statement option and tested with sample data through *.csv file. Our date setting is dd-mm-yyyy, following is the screen shot of csv file.
After importing, we got following screen where dates and months are swap.
We hope Manager can guide us for corrective steps if any or will resolve the issue if needed to address from back hand programming.
It has been quite some time, I had given much briefing on the challanges we are facing due to difference in interpretator of Manager and MS Excel. Is there any way, Manager can assist us to understand the step to over such challange because there are so many different dates in stored in custom field and once we export excel understand it very differently so updating once again in Manager, irrespective of the guidelines to opt for ’ [apostrophe]; this is only sucessful when date is same/unique so once can amend the date easily. When there are multiple dates, we sare stuck!! Please assist!!!