SQL Error - Open Failed -IMTRNHDR - Table not Found

[stranger26]

When we try to run "Reset Allocations" in IM module, the process fails with the following error:
"SQL Error - Open Failed -IMTRNHDR - Table Not Found"
followed by:
"SQL Error - Open Failed -IMTRNDTL - Table Not Found"

These tables indeed don't exist in company database. I can't seem to find ANY information about these tables anywhere.
Does anyone know what it does and how I can recreate them? Thank you in advance.

Macola Progression SQL 7.7.600

 

[dgillz]

Are you still having this issue? You need to initialize these tables in System Manager->Processes->Initialize Distribution->Inventory Management Files.

What is troubling is that these files should have been automatically created when you upgraded to Macola 7.6.300c, which was 7 years ago, and when these tables were first used by Macola. It could be that the reset allocations process is now looking for these tables in 7.7.600 where it did not do s oin prior versions, but the tables should still exist.

At any rate initializing these tables should do the trick.

Software Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[stranger26]

I figured these tables should have been there, but they weren't!
Actually, the issue has resolved itself just recently.
What's odd is how it got resolved:
We did "Clear Accumulations" which did just that, but after this procedure the above mentioned tables got recreated in the database.
They didn't have capital letters in their names like the rest of the tables do, however, just lowercase.
After that we were able to run "Reset Allocations" procedure with no problem.
Bizarre, isn't it?