DBeaver Error 1146 (42S02) on SQL database restore- Table 'acumatica.AUNotification' doesn't exist
The create table may not have used quotes around the table name, while a reference to it does.

Unless lower_case_table_names=1 is set upon database creation, the case of the tablenames has to be respected when quoted.