Interface between IFS Applications and TPM systems

Ahead ERP Consulting takes great pride in its ability to provide its customers with creative and innovative approaches to solving problems and improving business processes. In 2017, Ahead designed and delivered interface solutions with external trade and promotion management (TPM) systems for two separate customers utilizing a similar design approach. The interface solutions went live in 2017 and continue to add value and automate processes vital to management of complex promotion activities.

Land o’Frost, a manufacturer of high quality lunchmeat, implemented WiPro Promax TPM system in 2016 and went live with IFS Applications 8 in March 2017. The interface was implemented with the main IFS solution and also went live in March 2017.

Nature’s Path Foods is producer of certified organic foods, known for its breakfast cereals. They are an established IFS customer, upgraded recently to IFS Applications 8. They implemented Kantar XTEL SM1 in 2017. The implementation included the solution for the interface. Both went live in June 2017.

The TPM software allows its customers to manage promotion planning and budgeting, execute promotions, process settlements, perform analysis, provide reporting based on promotional details, and apply predictive analytics to create improving promotion strategies. IFS Applications is the main source of static and transactional data consumed by the TPM system and serves as the recipient of matched claim, accrual, and forecast information from the TPM systems.

The challenge given to Ahead was to design and develop an interface solution allowing critical information exchange and processing between the two software systems. Each solution shares the following common characteristics.

Outbound interfaces (IFS to TPM system) are responsible for filtering and formatting of data and included the following.

Inbound interfaces (TPM system to IFS) are responsible for processing matched claim, accrual, and forecast information.

A total of 27 outbound (IFS to TPM system) and 8 inbound (TPM system to IFS) interfaces were created using the external files framework. Each was comprised of a custom external file type, template, appropriate parameters, and associated custom business API. In many cases, the use of custom fields and custom LU’s provided additional information required for either the filtering of data or additional data required by the TPM system. 

Data exchange between systems is required monthly, weekly, daily, or hourly depending on the interface. Execution timing of each external interface is controlled by a custom scheduled database task. Each schedule takes as parameters the external file type, template, and other required parameters. The custom API code associated with each external file provides feedback to the background job associated with the scheduled database task. Based on the feedback to the background job, event actions are triggered sending information to users in the form of email messaging. If required, any of the inbound and outbound external file interfaces can also be executed manually using the external file assistant.

Most outbound interfaces send a full set of data each time the interface file is created. For some data, such as sales history, it is not realistic to send the entire data set each time the interface is executed. In those cases, tracking tables have been established to ensure only new records are sent to the TPM systems.


Some highlights of inbound interface challenges

If an issue arises with the execution of an interface, a variety of tools are available for investigation.

The interface solutions developed by Ahead have proven very successful. The outbound interfaces send approximately 285,000 records per week. The inbound interfaces process approximately 200,000 records per week. The initial success of the first interface project led to capturing an addition opportunity resulting in two successful interface implementations in 2017 with TPM systems. By harnessing the creativity of the Ahead team, IFS customers are enjoying a robust interface solution providing required functionality delivered on time and budget.