GL Inquiry

GL Inquiry in Softbase is located under the main Accounting tab from the application menu. This module allows users to review a singular journal entry, multiple entries to the same account, invoice number, etc. and is a tool used for many purposes in the system.

Upon opening GL inquiry, you will want to use the select by menu to determine what you would review.  You can search by GL account number, Control number, Journal name, AR invoice number, AP invoice number, customer number, and vendor number.  

Then, you will populate the data you are looking for into the search grid and adjust your dates as needed in the start and end date fields before choosing the search option.  The search will return the results of the search query you entered.  This can allow you to easily see all lines posted to a journal entry, invoice, or account complete with the credit and debit values posted.

GL inquiry will also allow you to review balances.  When reviewing a customer number, I can pull the history for that customer and the inquiry will provide the balance of the account, as seen below in a test example.

When searching by an account number, the module will provide additional balances, such as the month to date total of the account and year to date total of the account.

You can also choose the information to display in the results grid by using the fields option of the top toolbar.  This allows you to display as much or as little information as needed with the following column options, where a check will include that column information in the search results and a blank will exclude that data from the results.

This function allows users to have enhanced control over their accounting processes as well as to enable consistent checks and balances within the system.  For additional review, users can use the Copy, save, and export functions in the top toolbar to export the data from the search results as needed for further review. You can also choose these same options from the file menu of the window as well as needed.

• Related Articles

• What do the colors mean in the WIP inquiry tab?

  For most departments in Softbase, work orders in the WIP tab of Softbase are highlighted based upon the following: Light red- Credit approval needed Yellow- Credit Approval granted For the rental department, however, the colors denote the following: ...

• How to apply a credit in AP with a journal entry

  When a user voids a check, the invoice will be reinstated into your payables and will be available for selection in AP payments to pay again. If you need to take a credit against that invoice, however, you cannot use the "apply to" change option in ...

• Paying an AR customer invoice with a credit memo from a vendor.

  This process is often used when you have a vendor account that is also a customer. If the vendor issues a credit to issue against an invoice on the AR side, you can apply the credit within the AP process to apply it against an AR invoice. This will ...

• How do I process a warranty work order?

  Softbase has a recommended process for warranty work orders that will need to be billed to a warranty vendor. First, you will need to have a warranty customer identified and set up in the system. Typically, this customer will be designated as both an ...

• How do I edit a recurring AP invoice?

  To edit or stop a recurring invoice, you will need to select the invoice within AP inquiry that you created. If you double click on the invoice line in AP inquiry that is set to be recurring, Softbase will open AP Invoice Recurring Maintenance and ...