/
Dimension Data Correction

Dimension Data Correction

It is intended only for internal Seyfor needs.

During the non-standard process of creating a contract from a calculation under unknown circumstances, there was sometimes a problem with renaming the empty value of the Contract dimension to a specific one.

The value of Dimension 2 has been recorded in the tables:

API Invoice Interface Template (4027202) Invoice Interface Template

Standard Sales Line (171) Standard Sales Codes Line

Standard Purchase Line (174) Standard Purchase Codes Line

G/L Account (15) Chart of Accounts

Bank Account (270 bank accounts)

Salesperson/Purchaser (13) Salesperson/Purchaser

Customer (18) Customers

Vendor (23) Suppliers

For data correction of these cases, a report "Data Correction – Delete Global Dimension 2" has been created. The report is not included in any menu, it can be opened via search – system magnifier:

 

image-20240626-191250.png

 

image-20240626-191257.png

 

The system opens a window where no filter can be entered, the system goes through the named tables and deletes global dimension 2 on all tables.