Inquiries

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 general 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. Use this code 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.

You can select child accounting entities 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, 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 Download Bucket on the accordion panel.

United Kingdom MTDfV (via Web Services Gateway)

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

Inquiry Description
List of All Retrieved VAT Liabilities Shows all VAT liabilities retrieved from HMRC for the selected time period.
List of All Retrieved VAT Obligations Shows all VAT obligations retrieved from HMRC and those generated from VAT returns submitted to HMRC, along with the VAT return filing status and submission date.

These are the Obligation Status values:

  • Open – Set when the obligation is initially retrieved from HMRC.
  • Draft – Set when the obligation status for the period is not yet available from HMRC.
  • Fulfilled – Set when the obligation is considered completed by HMRC.
List of All Retrieved VAT Payments Shows all VAT payments retrieved from HMRC for the selected time period.
List of All VAT Returns Shows all VAT returns submitted to HMRC, their retrieved amounts, and those pending submission.

For VAT returns that are submitted successfully, the page shows the HMRC response details. To see a table that compares line amounts with the amounts retrieved from HMRC, open a report in the VAT Return Details view.