Inquiries

You can use the provided inquiries to review the underlying data in the LSP database and support the services with additional information.

Note: The inquiry data is based solely on the BODs you have published from your ERP and, therefore, may be incomplete.

This table shows the inquiries you can create for these master data:

Inquiry Description
Customer List Displays customer contact and tax information
Supplier List Displays supplier contact and tax information
Bill from List Displays billing information of your Accounting Entity
Bill to List Displays billing information of your customers
Ship from List Displays shipment information of your Accounting Entity
Ship to List Displays shipment information of your customers
Chart of Account Displays the number of records available and detailed list of accounts of your Accounting Entity.
GL Reconciliation Displays the comparative figures between Trial Balance and Journals per account code and period.

If there is a difference between the trial balance and journals, you can select an account code to show the journal. This code is used to compute the total amount in either the debit or the credit side. This enables you to determine the cause of the difference by checking if there are missing journal entries or if there are journal entries that do not have a GL movement counterpart.

Journals Displays the journal Base and Report Amount information for each selected year and period of your Accounting Entity.
Trial Balance Displays the opening and closing balance information of an account and the debit and credit amount if there are records for each year and period of your Accounting Entity.

Child accounting entities can be selected for reporting entities to show individual Trial Balance data.

List of All Sales Invoices Displays all sales invoices for a given time period.
List of All Purchase Invoices Displays all purchase invoices for a given time period.
List of All Receivables Displays all account receivable transactions for a given time period.
List of All Payables Displays all account payable transactions for a given time period.
  1. From the accordion panel on the left, select Inquiries.
  2. Select an Accounting Entity from the list, then select a master data for inquiry.
  3. Click the ID to view the detailed master data information.
  4. To filter the list, select Filter and specify parameters such as master data ID, Name, and Display ID.
  5. Click Export to download the master data, Contact, or Tax Information.
  6. In the Download Bucket window, click Download if the file is ready. Otherwise, click Refresh to update the status of the file.
  7. Click Save.
    You can also view the generated files by selecting Utilities > Download Bucket on the accordion panel.