Custom Briefing Job: ERP Export

  • Published on Feb 6, 2025
  • 1 minute(s) read
  • Migration Team
 Prev Next

ERP Export Job exports two files: XML and navik that contain the necessary information for External Financial System

The following fields must be mapped to execute this job:

In Briefing Module:

  • Biefing Code Field

  • Field with Chains

  • Field with Export to Financial System (Date Field)

  • Field with briefing period purchase start

  • Field with briefing period purchase end

  • Briefing Name field

In Chains Module:

  • Field with Abbreviation

  • Partner # Field

In Prices Module:

  • Field with Original Price

  • Field with price

  • Rental field

In Products on Briefing Module:

  • Field with Headline

  • Field with Product

In Supplier Module:

  • Field with Number and Name 

In Products Module:

  • Field with Product Name

  • Field with Product Number

  • Supplier Field (Module link to Supplier Module > Field with Number and Name)

Job Description

The job produces two different types of files:

  1. a fixed format file "navik" is overwritten every time the job runs, the file contains one or more campaigns

  2. xml files with unique names like pt10811p1IT03032008.xml. The code is chain abbreviation + sagskode +  current date, only one campaign per file

The job runs once a day and the navik file and one or more xml files are created if one or more campaigns have the current date (or a date in the past) in the Field with Export to Financial System date field.

Location: System Configuration > System Status > Scheduler > Scheduler Properties

Table below describes parameters of ERP Export Job:

Parameter

Description

joblist=ERPExportJob

Specify scheduler to run Product Import Job

job.ERPExportJob.type= enCode.app.common.briefing.jobs.ERPExportJob

Specify class of the job

job.ERPExportJob.startimes=5:00,12:00

Time from 00:00-23:59 when the job starts. Job is performed on daily basis. Comma separated list (spaces not allowed)

job.ERPExportJob.param.dropdir=/data/Files/customer/inbox

Path to folder with XML and navik files that will be exported

job.ERPExportJob.param.SenderEmail=some@email.domain

After xml and navik files were exported, letter will be sent from this address

job.ERPExportJob.param.RecipientEmail=somemail@encode.dk

After xml and navik files were exported, letter will be sent to this address

job.ERPExportJob.param.EmailSubject=Transfer file from Briefing system to Navision

Subject of the sent E-mail after job has been finished

job.ERPExportJob.param.EmailBody

Body of the sent E-mail after job has been finished

job.ERPExportJob.param.SiteID=1

Id of the site for which ERPExportJob will be performed.

 Example

joblist=ERPExportJob
job.ERPExportJob.type=enCode.app.common.briefing.jobs.ERPExportJob
job.ERPExportJob.startimes=5:00,12:00
job.ERPExportJob.param.dropdir=/data/Files/ERPExportJob
job.ERPExportJob.param.SenderEmail=blane@encode.dk
job.ERPExportJob.param.RecipientEmail=abn@encode.dk
job.ERPExportJob.param.EmailSubject=Transfer file from Briefing system to Navision
job.ERPExportJob.param.EmailBody=Transfer file from Briefing system to Navision
job.ERPExportJob.param.SiteID=4

Related articles