x Want to participate? Join the group to interact
  • Replies 2 replies
  • Subscribers 138 subscribers
  • Views 686 views
  • Users 0 members are here
Browse Forums
Announcements
236
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
Chris le Roux9109

No data in GACCTMP

Posted By

Good day

We have an issue where no transaction is written to the GACCTMP table.

Any transaction that we try to post in Sage gives an error and the process stops. When I look at GACCTMP I see no record in this table.

I have tested Purchase Invoices, Sales Invoices, AP/AR Invoices, and Payments. All have the same issue.

Regards

Chris

  • >>Sage gives an error and the process stops

    What is the error?  

  • Hi Chris

    Also, what version and patch level are you on? Fixes and enhancements are added in patches and may impact the behavior of the product.

    When an X3 posting process runs into an error, it rolls back the journal entry piece and leaves nothing in the GL related temp tables. If you want to see what the journal would "look like" you would need to run GTEST. GTEST puts the posting into a debug state and allows you to see what the debits and credits would be. See knowledgebase article 16796. 

    You also can utilize User parameters: ACESIMTRC - Simulated entry generation. See the blog Preview of coming transactions for instructions on how to use this function to review postings.

    There are times when the process fails before the transaction gets to the creation of the journal and a different tool for troubleshooting would be required.

    As Stephen mentioned, what is the error message? 

*Community Hub is the new name for Sage City