Tax proposal in IFS Applications 10 stops at the same tax code every month: suspected 4000-character limit and Tax Report setup

Question

After go-live on IFS Applications 10, a business using composite (mixed goods) tax codes finds its Tax Proposal incomplete. It has about 2000 tax codes, UK0000 to UK2000, and the standard UK VAT Return template (SO89, written S089 in one place in the source) was amended to select on Tax Subgroups. Before that change the proposal captured every tax transaction in the period. Since then it includes transactions only up to tax code UK0567 and stops; the remaining transactions stay unconnected to any tax proposal. This happens at 58,000 or 143,000 transactions a month and has stopped at the same code for several months. Tax codes are mapped to their tax subgroups (Tax template field control) and to the Tax report using template SO89, the failing codes are set up the same as the working ones (valid from 2001 to 2049), no error is shown, and performance monitoring shows nothing unusual. What causes this?

Technical details Product: IFS Applications 10 (theory observed on IFS Cloud 23R2). Area: Financials > tax, Tax Proposal, Tax Report, UK VAT Return template SO89 (also written S089). Tax codes UK0000 to UK2000; proposal stops at UK0567. Selection on Tax Subgroups; Tax template field control. Volumes: 58,000 to 143,000 transactions per month. Suspected limit: 4000 characters in Proposal Details > Parameters. No error messages.

IFS Wire Desk · Accepted Answer

The thread has a confirmed resolution, but only in general terms, plus an unconfirmed technical theory.

Confirmed by the original poster: the issue was resolved with help from IFS, and the cause was that the Tax Report had not been set up correctly. No further detail on the exact correction was given.

Theory from a partner (observed on IFS Cloud 23R2, not confirmed for this case): when the proposal pulls in the tax codes from the Tax Report, the parameter list is cut off at exactly 4000 characters, and any tax code after that point is dropped. To check:

Open the tax proposal's Proposal Details, then Parameters.
Copy the full list of tax codes shown there.
Count the characters (for example in a word processor). If it is exactly 4000 and the later codes are missing, you are hitting this cut-off.

An IFS employee also recommended opening a support case so the behaviour can be analysed and, if reproduced, reported to R&D.

The thread does not say whether the Tax Report correction and the 4000-character theory are related, so treat them as separate leads.

Prerequisites and limitations Exact fix not documented in the thread beyond "Tax Report set up incorrectly". The 4000-character cut-off is a partner's theory from IFS Cloud 23R2 and was not confirmed by IFS or the poster. Large tax code sets are most likely to be affected. A support case is advised if the issue reproduces.

Tax proposal in IFS Applications 10 stops at the same tax code every month: suspected 4000-character limit and Tax Report setup

1 answer