DocBits- IDP for Infor ERP
HomeAppStatusAPI
🇳🇱 Nederlands
🇳🇱 Nederlands
  • Overzicht en basisprincipes
    • DocBits
      • Belangrijkste Kenmerken van DocBits
    • Architectuur
      • DocBits Infor on Premise Klant
      • Certificeringen
    • Infor Infrastructuur
    • Release-opmerkingen
  • Eindgebruiker en partners
    • Eindgebruikerssectie
      • Dashboard
        • Dashboard Tools
        • Documenten Samenvoegen
        • Documentstatus
        • Documenten Filteren
        • Overzicht van Geüploade Documenten
        • Taakenteller
        • Gevalideerde Geëxtraheerde Velden
        • Documentflow
        • Problemen oplossen
        • Toetsenbord Sneltoetsen
      • Taken
      • Advance Shipment Dashboard
      • Dashboard voor inkooporders
      • Factuurdashboard
      • Shipment Order Dashboard
      • Gebruikersconfiguratie-opties
      • AI Tabel
        • AI Tabel Tags
      • Validatiescherm
        • Vage Gegevens
        • QR-codes
        • Toetsenbord Sneltoetsen
      • Doel en Gebruik
      • Inkooporder Matching
        • Automatische Afstemming van Inkoopordergegevens
        • Leverancier Artikelnummer Map
        • Toetsenbord Sneltoetsen
      • Boekhouding voor Kostfactuur en Indirecte Verkoop
      • Hoe Documenten te Importeren
        • FTP
        • Handmatige Import
        • Webhook
        • E-mail
          • IMAP
          • OAuth Office365
      • Technische Ondersteuning in DocBits
        • Maak een ticket aan
        • Help-pictogrammen
      • Cursus
        • Introductie
        • Dashboard
        • Geverifieerde Documenten
        • AI Table
        • Master PO Matching met DocBits
      • Ons Document Prioriteit Systeem
      • Leverancier Portaal
        • Leverancier Registratie
        • Leverancierstatus
      • Bronnen en ondersteuning
        • Gebruikersondersteuning
    • Partner Sectie
      • Factuurautomatiseringstest met DocBits
  • Administratie en instelling
    • Instellingen
      • Global Settings
        • Bedrijfsinformatie
          • Defining App Color in Company Settings
        • Groups, Users and Permissions
          • Gebruikers
            • Modifying User Details
            • Admin Privileges
          • Suborganisaties
            • How to create a Sub-Organization
          • Groepen en Machtigingen
            • Purpose and Use
            • Adding/Editing Groups
            • Machtigingen activeren
            • Toegangscontrole
            • Troubleshooting
        • Integration
          • API Key
          • API Calls and Examples
          • API Key Management
          • Configuring Single Sign-On (SSO)
            • Infor SSO Configuration
              • V1
              • V2
              • Azure SSO
          • Identity Service Provider Configuration
          • Best practices
          • Troubleshooting Common Issues
        • Documenttypes
          • Purpose and Scope
          • Adding/Editing Document Types
          • Activation
          • Customization Options
          • Best Practice
          • Troubleshooting
          • Layout Manager
            • Purpose and Use
            • Navigeren in de Lay-outbeheerder
            • Configuring Field Properties
            • Using the Template Preview
            • Save and apply changes
            • Best practices
            • Troubleshooting
          • Document Sub Types
          • Creating a new Sub Type
          • Configure subtypes
          • Using Actions
          • Best Practices
          • Tabelkolommen
            • Purpose and Use
            • Adding a new Column
            • Editing and deleting columns
            • Best practices
            • Troubleshooting
          • Velden
            • Purpose and Use
            • Configuring Field Properties
            • Setting Validation and Match Score
            • Velden Toevoegen en Bewerken
            • Best practices
            • Troubleshooting
            • New Fields with Charges
          • Modeltraining
            • Purpose and Use: Model Training
            • Import Data: Model Training
            • Manage training data
            • Testing the model
            • Best practices
            • Troubleshooting
          • Regex
            • Purpose and use
            • Creating a Regex Pattern
            • Editing and Saving Regex Patterns
            • Best practices
            • Troubleshooting
          • Script
          • Script Activation and Management
          • Testing Scripts
          • Purpose and Use
          • Creating and Editing Scripts
          • Best Practices
          • Troubleshooting
          • e-docs
            • Purpose and Use
            • Setting Up EDI Templates
            • Using the XSLT Editor
            • Previewing EDI Messages
            • Best Practices
            • Troubleshooting
            • XRechnung
              • Standard Preview
            • Mapping XRechnung in DocBits
              • TOML Export
            • EDI 810 (Invoice) Mapping
            • EDI 850 (Purchase Order) Mapping
            • EDI 855 (Purchase Order Acknowledgement) Mapping
            • EDI 856 (Advance Shipment Notice) Mapping
            • Peppol BIS Billing 3.0
            • eSLOG 1.6 en 2.0
          • Meer Instellingen
            • Purpose and use
            • Best practices
            • Troubleshooting
            • Behandeling van dubbele documenten
            • Goedkeuringsstempel
            • Supplier Item Number Map - Admin Documentation
            • Aankooporder tolerantie-instellingen / Extra aankooporder tolerantie
            • Aankooporder uitschakelen statussen
            • PO-tabel in Layout Builder
            • Automatische controle op PO-updates
            • Eenheidsprijs PO berekenen
            • Export niet gematchte PO-regels
        • E-mailmelding
          • Configuring Notifications
          • Managing Notifications
          • Best Practice
          • Troubleshooting
        • Custom Filters
        • Dashboard
          • Customizing Filters
      • Documentverwerking
        • Documents Expiry
        • Importeren
          • Test: Multi Email Import and Handling Tests
          • Test: Email Import and Handling Tests
          • Test: FTP Import Connection
          • Test: File Import 1
        • Regelbeheerder
          • TransactionConfig Pro Template
            • Case 1, 2, 3: Quantity and Unit Price Within Tolerance
            • Case 4, 5: Quantity Within Tolerance, Unit Price Outside Tolerance (Approved)
            • Case 15: Charge Line - Charge Per Unit Outside Tolerance (Rejected)
            • Case 14: Header Charge - Charge Per Unit Outside Tolerance (Approved)
            • Case 12, 13: Header Charge - Charge Per Unit Within Tolerance
            • Charge Per Unit Outside Tolerance (Rejected)
            • Case 14: Charge Line - Charge Per Unit Outside Tolerance (Approved)
            • Charge Per Unit Within Tolerance
            • Case 11b: Quantity Outside Tolerance (Positive Rejected), Unit Price Outside Tolerance (Rejected)
            • Case 10b: Quantity Outside Tolerance (Negative Rejected), Unit Price Outside Tolerance (Rejected)
            • Case 8b, 9b: Quantity Outside Tolerance (Approved), Unit Price Outside Tolerance (Approved)
            • Case 11a: Quantity Outside Tolerance (Positive Rejected), Unit Price Within Tolerance
            • Case 10a: Quantity Outside Tolerance (Negative Rejected), Unit Price Within Tolerance
            • Case 7: Quantity Within Tolerance, Unit Price Outside Tolerance (Positive Rejected)
            • Case 6: Quantity Within Tolerance, Unit Price Outside Negative Tolerance (Rejected)
            • Case 8a, 9a: Quantity Outside Tolerance (Approved), Unit Price Within Tolerance
            • Case 15: Header Charge - Charge Per Unit Outside Tolerance (Rejected)
            • Tax Lines
        • Ocr-instellingen
        • Classificatie En Extractie
          • Tabelextractie voor kostenelement
          • Auto extract belastingcode
        • Master Data Lookup
        • Lijst van Waarden
        • Exporteren
        • Module
          • Annotatiemodus
          • Approval Before Export
          • Doc Scan
          • Doc Script
          • IDM ACL Updater
          • Swiss QR Code
          • Auto Export if PO Matched 100%
        • Beslisbomen
      • Loginstellingen
        • Taakbeheer
        • Gegevenssynchronisatie
      • Leverancier Instelling
        • Leverancier Algemene Instellingen
        • E-mail Sjablonen Bewerken
        • Exportconfiguratie voor Leverancierportaal voor M3
      • API-Licenties
      • Cachebeheer
    • Workflow
      • Release
      • When
        • Card description
        • Document Operator for Sub-Organizations
        • Document Type Operation
      • And
        • Assigned User Condition
        • Checkbox Field Condition
        • Checkbox
        • Combined Price of Quantity Difference
        • Compare two fields
        • Compare with Purchase Order
        • Confirmed Delivery Date
        • Docfield is
        • Document Field Comparison
        • Document Field
        • Document Status Condition List
        • Document Type Operation one of
        • In Order Confirmation Purchase Order
        • Single Assigned User Condition
        • Single Document Status Condition
        • Supplier on Invoice
        • Text in field
        • Unit Price Combined with Fields
      • Then
      • Workflow Example: Conditional Export Trigger
      • Workflow Documentation
      • Standard Workflow
        • Above Max Amount
        • Cost Invoice - Export
        • Less than Max Amount
        • Purchase Invoice - 2nd Approval Quantity Export
        • Purchase Invoice - 2nd Approval Quantity
        • Purchase Invoice - 2nd Approval Unit Price Export
        • Purchase Invoice - 2nd Approval Unit Price
      • Material Ordering and Processing Workflow
    • Setup
      • Document Types
        • EDI Data Transformation Process
        • Layout Builder
        • Origin Layouts
        • Regex Manager
      • Document Training
        • Training Header Fields
        • Training Line Fields/Table Training
          • Adding New Columns
          • Advanced Settings
          • Defining Tables and Columns
          • Grouping Function
          • Manual Row Selection
          • Mapping Columns
          • Save and Delete Rules
      • Stream for Cloud Customers
      • Testing
        • PO Matching
        • Auto Accounting
          • LN
          • M3
      • Leveranciersportaal
      • WatchDog Installatie
  • Infor integratie en configuratie
    • Importing Master Data
      • Field Mappings
      • LN
        • Auto Accounting
        • Suppliers and Purchase Orders
        • Tax Codes
      • M3
        • Auto Accounting
        • Suppliers and Purchase Orders
        • How to import all suppliers
        • Tabelextractie voor kostenelement
      • Custom Master Data
    • Exporting in DocBits
      • Export Module
    • Exporting to INFOR
      • Creating a BOD Mapping File
      • Een IDM Mappingbestand maken
      • Creating an ION API Endpoint
      • Creating an ION API File
      • Export to M3 Mapping (API)
      • Exporting to IDM
      • Order Confirmation
      • M3
        • Handling Charges with Infor M3
        • M3 Configuration
      • LN
        • Exporteer Belastingcodes naar LN
        • LN Configuration
      • Page
  • Geavanceerde functies en tools
    • Scripting in DocBits
      • Calculating Total Charges Script for Docbits
      • Calculating Total Charges Script for Docbits
      • Delete lines with empty quantity and amount
      • Formatting Export Certificate Reference Numbers Script for Docbits
      • Functies
      • Generating Extended Invoice Numbers Script for Docbits
      • Generating Extended Invoice Numbers Script for Docbits
      • USD as Default Currency
    • Course
      • A Step-by-Step Guide
      • Connect DocBits with Infor SSO
      • Create your Custom App in Infor OS
      • Infor OS with DocBits API Integration
      • M3 Export
      • Sync Flex Dimensions: Infor to DocBits
    • Postman for DocBits
    • SQL Access
    • Leverancier- en Inkoopordergegevens importeren in DocBits vanuit CSV-bestanden
    • PowerBI
Powered by GitBook
On this page
  • Prerequisites
  • Infor Configuration
  • ChartOfAccounts
  • Data Flow
  • ChartOfAccounts
  • M3 Company
  • Documents
  • Filter
  • DocBits (ChartOfAccounts)
  • BOD Triggering
  • Publish BODs
  • CostingElement

Was this helpful?

Export as PDF
  1. Infor integratie en configuratie
  2. Importing Master Data
  3. M3

Auto Accounting

PreviousM3NextSuppliers and Purchase Orders

Was this helpful?

Prerequisites

  • Functioning M3 to DocBits dataflow

  • Correctly configured DocBits environment

Infor Configuration

In Infor, open the ION Desk application. In the left tab, go to Connect → Connection Points

This is where you will create the connection point needed to import your data from M3 that is required for Auto Accounting.

Click on “+ADD” to create a new connection point, select the API option like below

You will need to configure the API connection point called:

  • ChartOfAccounts

ChartOfAccounts

The connection tab for your ChartOfAccounts connection point should look similar to what is illustrated below. Give the connection point an appropriate name and description, as well as import the Service Account you created.

You will need to add two BODs in this section for this connection point. These being Sync.ChartOfAccounts and Sync.CodeDefinition, to add these BODs do the following:

Sync.ChartOfAccounts

  • Click on the PLUS (+) icon

  • Select “Send to API”

  • Search for the Sync.ChartOfAccounts BOD

  • Switch to the ION API tab, copy the API name and search for the API Call by pressing the SELECT button

  • At product, select the API Endpoint that you created for the environment you are working with, which you created in ION API. Search for the following API call, select the API call and press OK.

  • Next, switch the Request Body tab

  • Here is where you will configure the field mapping for this BOD, your configuration should look like the following. The field mappings are available here.

Once you have completed the above steps, you will have successfully configured the Sync.ChartOfAccounts BOD. Click on the PLUS icon to add the next and final BOD.

Sync.CodeDefinition

The connection tab for your CodeDefinition connection point should look similar to what is illustrated below. Give the connection point an appropriate name and description, as well as import the Service Account you created.

  • Select “Send to API”

  • Search for the Sync.CodeDefinition BOD

  • Switch to the ION API tab, copy the API name and search for the API Call by pressing the SELECT button

  • Next, switch the Request Body tab

  • Here is where you will configure the field mapping for this BOD, your configuration should look like the following. The field mappings are available here.

Once you have completed the above steps, you will have successfully configured the Sync.CodeDefinition BOD for the M3FlexDimensions master data table.

Data Flow

You will need to configure the following data flow for Auto Accounting:

  • ChartOfAccounts

ChartOfAccounts

An overview of this data flow looks as shown below (the amount of DocBits API connection points at the end depends on the amount of different environments you are configuring).

M3 Company

The configuration for this connection point depends on the M3 company which contains the master data you wish to import into DocBits, yours should look similar to what is shown below.

Documents

The following documents need to be added to the data flow:

  • Sync.ChartOfAccounts

  • Sync.CodeDefinition

Filter

For the second route of the dataflow (according to the routing in the data flow), we apply a filter with the following configuration.

DocBits (ChartOfAccounts)

This is where you add the ChartOfAccounts API connection point which you created earlier, the configuration for this should look similar to this

BOD Triggering

Once all the above is completed, you will need to navigate to Infor M3 and trigger the BODs in order for the various master data you need for Auto Accounting to arrive in DocBits.

Start by pressing Command + r, to open the prompt menu, type “evs006” and press enter.

The following menu will be displayed to you

To add the various BODs you will need to enter the BOD nouns and Table names for each BOD individually.

The BODs you need to add include:

  • ChartOfAccounts

  • CodeDefinition

  • CodeDefinitionAccountingDimension

To add the new BOD after, after entering the BOD Noun and Table Name, press the pLUS icon indicated below

The BOD nouns and Table names are as follows.

ChartOfAccounts

  • BOD Noun: ChartOfAccounts

  • Table Name: FCHACC

CodeDefinition

  • BOD Noun: CodeDefinitionAccountingDimension

  • Table Name: FCHACC

Publish BODs

After adding each BOD, right click on the BOD you added, select Related and then Run.

You will be taken to this screen.

Change BOD Verb to “sync” and press NEXT.

Once you press NEXT, you will get a notification indicating that the BOD publishing process has begun.

CostingElement

In order to import the m3costingelement table into DocBits, you need to do the following.

From the M3 Homepage, type Command + r and search the “PPS280” prompt.

Select any of the lines displayed to you. On the next menu, select TOOLS and “Export to Excel”

Select “Export all Rows” and then press EXPORT.

Once downloaded, you will need to alter the excel file before converting it into a CSV file.

You will need to open the excel file, it will look similar to what is shown below.

From this excel sheet you only need the first 2 columns, alter the excel sheet so that the end result looks as follows.

Once this is done, save the file as a CSV.

Once you have your CSV file, go to the following webpage. This depends on which environment you are using:

  • Prod: http://api.docbits.com/

  • Sandbox: http://sandbox.api.docbits.com/

  • Stage: http://stage.api.docbits.com/

  • Demo: http://demo.api.docbits.com/

  • Dev: http://dev.api.docbits.com/

Here you will manually upload the CostingElement table via an API. Click on the Authorise button.

Here you will need to insert the API Key from your DocBits environment. This is located in Settings under Integration.

Once complete, search for the API called master_data_lookup/import_data and fill in the required information. Once complete, click EXECUTE to trigger the API.

If done correctly, the M3CostingElement table should now be in your DocBits environment. Auto Accounting for M3 has now been configured for your environment.