Hi Srinivas,

Which subledgers are out of balance to the general ledger? What reports or inquiries are you currently using to balance?

Hi Pnightingale,

we have supplier subledgers and respective normal gl account when we posting together, and after the inquiries we are getting balance difference.

Is there any procedures or processes for finding imbalances between the sub ledgers and the general ledger?

Hi Srinvas,

Sage ERP X3  does not use subledgers for accounts receivable (AR) and accounts payable (AP) so no reconciliation is required. This is a little different from the traditional AP/AR control accounts. 

• Each entry to an AP or AP control (collective) account must include a reference to a Business Partner supplier or customer.
• Even journal entries to the control accounts must reference a Business Partner.

I'm still not clear what you are specifically using to balance. I recommend entering a ticket with Sage Support so that your issue can be looked at in detail.

Have you checked out the training classes on SagU.com?  The AR and AP control accounts are covered in the Financials classes.

How did you manage to resolve this one

Hi,

If your AR or AP isn't tying to the General Ledger, note that there is no subledger for either. AP and AR accounts are set up as control accounts, so all entries to the GL must have a BP.  If your aging does not tie to the GL, here are a few things to look at:

• Run as of today. The agings don't go back in time. The As of Date only works if there has been no activity since that date.
• Check that all the journals have a BP. It may be that in the beginning, the AP or AR account wasn't a control account.
• Are you running the out-of-the-box aging? Try that to see if it works. Your custom report may need adjustments. You can also look at the Account Inquiry.