Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

No Data showing in a Pivotier Express Plus Report


When running reports like many of the sales and purchase reports, no data shows when running the report. This is caused by failing to assign G/L Account Category codes to all posting accounts in the Chart of Accounts.

One of the major innovations to drive reporting accuracy and audit worthiness in Express Plus reports is achieved by sourcing amounts from the G/L Entry table versus the Customer Ledger or Vendor Ledger tables.

The reason for this is simple - the customer ledger provides customer invoice balances irrespective of whether line items in invoices are coded to revenue accounts. For example, maintenance is often coded to a deferred revenue account on the balance sheet and sales taxes are included in the customer ledger balance amount. Consequently using the Customer Ledger for sales and purchasing reports does not provide accurate reports which reconcile to a company's financial statements.

Solve this by assigning a G/L Account Category code to each posting account in the chart of accounts.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments