Skip to main content
Question

AP vs GL - Generic Inquiry to Analyze Variance

  • November 20, 2025
  • 2 replies
  • 26 views

Generic Inquiry assistance needed! We are currently reconciling our general ledger balance of accounts payable with the balance from our AP Aging report. I asked copilot how to create a generic inquiry to help us find the difference, and despite following the provided steps, I am receiving an error that reads “’Parent Field’ cannot be empty.” From my perspective, parent field is not empty. Can someone help me resolve this issue? I have attached a screenshot that displays what I am seeing. Thank you!

 

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 20, 2025

Hello,

Did you already check Account Details screen to see if any transactions posted to your AP Control account, from modules that are NOT AP? As in this example:

If GL Anomoly Detection experimental feature has been turned on in Enable/Disable, these related AP screens may help further:

Laura


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 20, 2025

Regarding your joins, GLTran can be joined to batch using Two lines, Batch Number and Module.  Ledger, Account, and Subaccount should not be included.  I think GLTran should not be joined to either Account or sub, in order to solve an AP to GL out of balance situation.

 

Laura