Customer Batch Update - DefaultDueDateDays does not recognize changes

1

Setting up new company. imported customer list with no terms, then went back to add “net 30” for all 83 customers. modified 1 customer manually to add “30”, then Batch Update and Copy to Clipboard.

When i paste the data into a spreadsheet, i see the manually updated customer has the logical field set to TRUE, and “30” is listed under the new DefaultDueDateDays column/field.

I copied TRUE to all the other customers under the HasDefaultDueDateDays column, and set all fields to 30 for all customer under the DefaultDueDateDays

  • both of which show the manual changes just made.

The issue is that when the spreadsheet data is copied back to the Batch Update window, the HasDefaultDueDateDays column now shows TRUE for all customers, but the “30” days is ONLY listed for the manually updated customer. Import does not seem to know that DefaultDueDateDays field exists.

running the latest version (server installation) 23.1.9.590, and did search the forum to figure out if anyone else has seen this.

Thanks.

2

How did you enter the other 30 numbers in the spreadsheet?

3

I can replicate this issue and it seems that there is no way of batch updating the DefaultDueDateDays field.

I tried to due the batch update twice, once to check the HasDefaultDueDateDays as true and the other to set the DefaultDueDateDays but that did not work.

I am putting this in bugs.

4

eko - I copied the existing “30” field down to the rest of the lines.

Ealfardan - I appreciate that you did the double-checking.

one other note - after the manual modification and export, I noticed that the HasDefaultDueDateDays logical column is not next to the DefaultDueDateDays column. I did try leaving it as exported, and then after moving the columns next to each other (both directions) - neither of the shifts worked as well.

thanks!

5

Fixed in the latest version (23.1.10)

6

late to follow up, but thank you for the fix.