Help and Support

Error: Inconsistent duplicate fact value when filing from Digita Suite

When filing with HMRC, you may get the error: "Inconsistent duplicate fact value - Raw Materials/Finished Goods/Merchandise/Work in Progress/Inventories/Production Supplies."
This error usually appears when there is a discrepancy between the opening figure in the current year and the closing figure in the prior year inventories codes within the iXBRL Detailed P&L.
For example, the Opening raw materials figure in 2018 is (100) but the Closing raw materials figure in 2017 is 99 which means this would reject with this error 'Inconsistent duplicate facts core: RawMaterials'. Note one of the figures is in brackets and one is not, this is intentional and if you have both figures in brackets or not in brackets this will be causing the issue so you'll need to review your postings to rectify.
To resolve this you will need to do one of the following:
Review your Trial Balance within the list of reports, check the TB to see which figure is rounding incorrectly.
  1. Go to
    Financial Period
    , then
    Configuration
     and
    Accounts
     to search for the code.
  2. Double-click on the code, tick the
    Round Independently
     checkbox, then select
    OK
     and rerun the report.
  3. If the closing balance doesn't match the opening balance in the trial balance a posting will need to be done to ensure these match exactly.
If you get this rejection message but upon reviewing the figures in the accounts they all look to match, then follow these instructions to make sure you're up to date with your template as this is an old issue that has since been resolved.
  1. Log into Accounts Production Advanced (APA) as the Administrator.
  2. Select the
    Template Entities
     tab where you will see a list of your master clients.
  3. You should have a master client in the list called
    Practice UK FRS102 Master
     which needs to be on at least version 13.
  4. If the record is not in the list, let Support know. If the record is on less than version 13, run the
    Content Downloads
     via the
    Tools
     drop-down menu to update your master client to the latest template.
  5. Open the entity and enter the password when prompted (the default password is 'DoNotDelete').
  6. Run the report within the
    Reports
     tab you are working on within your actual client e.g. FRS 102 Section 1a Small Entities.
  7. Within the Report Structure, locate the
    iXBRL detailed profit and loss account
     elements.
  8. Ensure they are not in bold, if either are right-click on them and select
    Revert To Template
    .
  9. You'll need to republish the template to save the changes via the
    Financial Period Template
     drop-down menu, then select
    Publish Current Period as a Template
    .
  10. Select
    Yes
     to both questions when prompted to republish the master client.
  11. Open any FRS102 clients in your database, then select the
    Update
     button.
  12. Once the client has been updated to the latest version, rerun the client report and ensure the
    iXBRL detailed profit and loss account
    elements within the
    Report Structure
     are not in bold.
  13. If it is in bold, right-clicking on it and select
    Revert to Template
    .

This article applies to:

  • Product: Companies House Accounts Filing, Digita Accounts Production