recreating Product Category after clearing folder

Question

Hello, 
 
 I have cleared all data on a certain folder by clearing the tables in the TABLES function. It happened that I need to re create the same product categories, and when I do I get an error saying ( Table Entry Error TABSTORUL ). I am not sure what to do with the TABSTORUL which is the stock management rules table. 
 Anybody can help me with this ?

Julien Patureau · Answer

Yes, TABSTORUL is the table used for stock management rules. Did you erase this table as well? If yes, you need to create the records in this table prior to the product category record.

Julien Patureau · Answer

It appears TABSTORUL table contains the stock management rules set at the product category level. So you "break" the data model by deleting the product category ITMCATEG table without deleting the related records in TABSTORUL. So you can try to delete the records in TABSTORUL linked to a product category (with a TCLCOD not empty) to restore the situation. Please be caution with deletion in the database and test this method to ensure its success.

Sage X3

recreating Product Category after clearing folder

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING