Request for General Ledger Query – Financial Edge NXT SKY API

Kuldeep Singh

We are working on integrating Financial Edge NXT General Ledger data with our Dynamics GP reporting. For this purpose, we need to retrieve General Ledger details through the SKY API Query endpoints.

Could you please confirm if there is a predefined Query available (or guide us on how to build one) that can return the following fields?

• Journal Entry
• Account Number
• Account Description
• Transaction Reference
• Distribution Reference
• Transaction Amount
• Beginning Balance
• Ending Balance
• Date / Post date

Your guidance or a sample query definition for retrieving these General Ledger fields would be greatly appreciated.