Skip to main content
Solved

Duplicate column name 'Removed' in custom table

  • November 7, 2024
  • 4 replies
  • 100 views

benb1977
Jr Varsity II
Forum|alt.badge.img

Hi all,

I am trying to publish a customisation with a custom table, but keep encountering the error in the screenshot attached. There is a column in the custom table named ‘InvCNModule’, but I have no idea why ‘RemovedInvCNModule’ is being defined as the column name. Is this something Acumatica does to keep track of column changes?

Cheers,

Ben.

Best answer by aiwan

Hi ​@benb1977 

 

I had this issue before, you should publish a script to drop the table from the database then republish your customisation.

 

Aleks

4 replies

Forum|alt.badge.img+1
  • Pro I
  • November 8, 2024

@benb1977 

When the data type is changed from one type to another in the InvCNModule, a field of the RemovedInvCNModule type will be created..


benb1977
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • November 10, 2024

@Giri K thanks for your reply.

It makes sense that columns like this would be used to back out changes when customisations are unpublished, but do you have any idea why such columns have duplicates?

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • January 22, 2025

Hi ​@benb1977 were you able to find a solution? Thank you!


Forum|alt.badge.img+8
  • Captain II
  • Answer
  • January 24, 2025

Hi ​@benb1977 

 

I had this issue before, you should publish a script to drop the table from the database then republish your customisation.

 

Aleks