Posting Sub Ledgers Error

[ultrav]

Progression SQL 7.6.4b

We got the Following error when posting the AR & AP subledgers

THe following error has occured in MacMSS.dll:

Invalid object name 'DATA_02.DBO.GLJNL001_SQL'.
Statement(s) could not be prepared.

Everything looks like it posted - has anyone gotten this error?

WHat should I look out for?

Thanks
Celeste

 

[dgillz]

Where are you printing the posting report? Screen, file or printer?

Are you using SQL or Pervasive?

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

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

 

[dgillz]

All the GLJNL tables that end in numbers are temporary tables that are supposed to delete themselves when they are done posting. It could be a rights issue for the user(s) posting from subledger. They must - as all Macola users must - have full rights.

Rename these tables and try it again. Let us know the results.

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

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

 

[ultrav]

THere were no tables with that name. We ran the posting again and it came up nothing in range.

We print the posting to file. The report is there.

I guess we will just keep a lookout and see if it happens again.

Thanks
Celeste

 

[NEmacGuy]

DGilz,
Looks like a SQL version of Macola, table should be created in SQL. Looks like problem with GLPASFLS table. They must have transaction control posting enabled. Search out doc# 17.253.803