BPM Country Reports

United Kingdom

This section describes the United Kingdom reports appendix.

UK Tax Submissions - Settings

Note: You must have System Administrator rights to configure some of these settings, such as the Reference Workspaces.

You may need to configure settings prior to using the UK Tax Submissions data export.

BPM Server REST API URL

  1. In Maconomy, go to Setup » System Setup » System Parameters.
  2. Double-click the BPM Server REST API URL parameter.
  3. In the BPM Server REST API URL field, enter the URL to the server.

Tax Settlements Period

By default, VAT data is calculated using Tax Settlements Period. If you need to calculate VAT date using Entry Dates, follow these steps:

  1. Go to Setup » System Setup » System Parameters.
  2. Double-click the Use Entry/Period Dates for Statutory Reports parameter.
  3. Select the Use Entry/Period Dates for Statutory Reports check box.

VAT Submissions

  1. Go to Reference Workspaces » Set-Up » Access Control » Groups.
  2. Set up or confirm access to the VAT Submissions and VAT Submission Entries windows.

Integration Lines

  1. Go to Reference Workspaces » Integrations » Integration Lines.
  2. Using the normal Extender process, add the following line to display in the GlobalMenu: 
    <Workspace title="UK Tax Submissions" source="uktaxsubmission:UKTaxSubmissionVatSubmissions" />

Configure XML / INI Files

  1. Verify in the following binding to the couplingconfiguration.mcsl.xml file if the standard couplingconfiguration exists. Otherwise, add the following lines: 
    <Binding namespace="mtd">
      <Fields>
        <Field name="HmrcUrl" value="urlRef('mtdhmrcurl') defaultTo ''" />
        <Field name="ClientId" value="urlRef('mtdclientid') defaultTo ''" />
      </Fields>
</Binding>
    Note: Ensure that there are no customized binding with the same namespace and fields as this result to an error when you run the report.
  2. To enable logging, add the following statement to the logback.xml file (<Path to Maconomy installation>\CouplingService\configuration\logback.xml): 
    <logger name="com.deltek.maconomy.bpm.uktaxsubmission" additivity="false">
    <level value="TRACE" />
    <appender-ref ref="FILE" />
</logger>
    Note: Other level values available for debugging the errors and fraud header values: ERROR, INFO.
  3. Add the following parameters to the Extension.ini file (<Path to Maconomy installation>\CouplingService\extension.ini): 
    url.mtdhmrcurl = <URL for MTD API>
url.mtdservertoken = <Maconomy server token>
url.mtdclientid = <Maconomy client ID>
url.mtdclientsecret = <Maconomy client secret>
url.mtdsysmanufacturer = <Machine System Manufacturer in the Computer Information>
url.mtdsysmodel = <Machine System Model in the Computer Information>
    Note: Contact PDM for these codes via the Deltek Customer Care/Services teams.

Troubleshooting

Add HMRC IP Address to OEL Hosts File

UK MTD statutory reports may fail to generate when using SAP BusinessObjects BI Suite installed on Oracle Enterprise Linux (OEL). To resolve this, add the IP address of the HMRC website to the OEL server’s hosts file.

To edit the Hosts file:

  1. Open the <OEL_INSTALL_DIR>/etc/hosts file in any text editor.
  2. Add the IP address of HMRC, for example: 
    54.230.202.101 test-api.service.hmrc.gov.uk
  3. Save the file and close the text editor.

Background Task Timeout

Reports with large volumes of records take longer to process and the background task may timeout. To prevent timeout errors, you must change the character stream size to 2000 or higher (on the BO server console), and set the background task duration to more than 24 hours (on Maconomy).

Set Character Stream Size

To prevent timeouts while running the report, you must change the character stream size on the Business Objects (BO) Central Management Console (CMC) prior to running the report.

To change the character stream size:

  1. On the BO CMC, log in as an Administrator.
  2. Click Servers and select Server List.
  3. From the list of server names, click WebIntelligenceProcessingServer.
  4. Select Properties then edit the Maximum Character Stream Size (MB) field value, from 15 to at least 2000 or your preferred value up to 4095.
    Note: The recommended value when running the report is 2000.
  5. Click Save then close the dialog box.
  6. Right-click WebIntelligenceProcessingServer then select Restart Server.

Set Background Task Maximum Duration

Note: This section applies to the Workspace Client.

If the default maximum duration time (1440 minutes) is not enough to generate the report, you can change the maximum duration for the background task.

To change the maximum duration:

  1. Generate a report to start a background task.

    Click OK in the prompt.

  2. Go to Setup » Background Tasks » Status and locate your task. It should be at the top of the list.
    1. Select the task and click the Abort action button.
    2. Click OK in the prompt.
    3. Right-click the task (the status displays as Failed) and click Copy as Template.

      A new task should display at the top of the list (the status displays as Pending.)

  3. Go to the Editing tab then locate and double-click the pending task.
    Note: You may need to filter the list and show Inactive Pending Tasks.
    1. Edit the Max. Duration field to a higher value, such as 2880 for 48 hours.
    2. Click the Save » Activate action.
    3. Click OK in the prompt.
  4. Go to the Status tab and click the Refresh action button.

    The task should run and generate a report.

    Note: If the background task still fails, you need to adjust the maximum duration time to accommodate the amount of records.