We have the following setup on SAGE 300 2024:
IC Setup => GL Integration => Create GL Transactions by "Creating and Posting a New Batch"
PJC Setup => GL Integration => Create GL Transactions by "Creating and Posting a New Batch"
A user who is only allowed to create and post the below transactions:
1. IC transactions => Internal Usage, Shipment, Item Maintenance
2. PJC Transactions => Material Usage, Material Return, Material Allocation
With the user ID, he can create and post the IC transactions without error, and the related GL Transactions are also made and posted.
However, if he creates and post PJC Material Usage or Material Return, the system will always prompt the error message:
Error: Batch Attempt to perform Query Fetch without security authorization
Message: Material Usage posting completed.
The material usage and an IC Shipment entry are created and posted successfully.
However, the related GL transactions were created, but not posted.
We believe that PJC Material Usage / Return should be posted just like other subledgers without the errors.
by: Dylan L. | about a month ago | General Enhancements
Comments
we felt this is a bug instead of idea or enhancement request, howefer the SAGE directed me to here to submit it as an ideas:
https://communityhub.sage.com/us/sage300/f/operational-suite/244008/pjc-material-usage-return-posting-error-message-attempt-to-perform-query-fetch-without-security-authorization