Infor 3M Cloud (EMS)

The Infor 3M Cloud modules allow you to create, update, retrieve, and list the supplier invoices in your Infor 3M Cloud account.

Getting Started with Infor 3M Cloud

Prerequisites

The module dialog fields that are displayed in bold (in the Integromat scenario, not in this documentation article) are mandatory!

Connecting Infor 3M Cloud to Integromat

To connect your Infor 3M CloYou ud account to Integromat you need to obtain the Identifier, Key, and Website ID from your Infor 3M Cloud account and insert it in the Create a connection dialog in the Integromat module.

Supplier Invoice

List Supplier Invoices by Payee

Retrieves a list of supplier invoices by the payee.

ConnectionEstablish a connection to your Infor 3M Cloud account.
DIVI: DivisionEnter (map) the division whose supplier invoices you want to list. The value should be a minimum of three characters in length.
SPYN: PayeeEnter (map) the payee whose supplier invoice you want to list. The value should be a minimum of 10 characters in length. 
SUNO: SupplierEnter (map) the supplier whose invoices you want to list. The value should be a minimum of 10 characters in length. 
IBTP: Invoice Batch TypeEnter (map) the invoice batch type to list the invoices that match the specified type.
SUPA: Invoice StatusEnter (map) the invoice status to list the invoices that match the specified status.
LimitSet the maximum number of invoices Integromat should return during one execution cycle.

List Supplier Invoice Line Items

Retrieves a list of supplier invoice line items by the invoice batch number.

ConnectionEstablish a connection to your Infor 3M Cloud account.
DIVI: DivisionEnter (map) the division whose supplier invoices line items you want to list. The value should be a minimum of three characters in length.
INBN: Invoice Batch NumberEnter (map) the invoice batch number whose line items you want to list.
LimitSet the maximum number of line items Integromat should return during one execution cycle.

Create a Supplier Invoice

Creates a new supplier invoice.

ConnectionEstablish a connection to your Infor 3M Cloud account.
DIVI: DivisionEnter (map) the division whose supplier invoices line items you want to list. The value should be a minimum of three characters in length.
IVDT: Invoice DateEnter (map) the date on the invoice. 
SINO: Supplier Invoice NumberEnter (map) the supplier's invoice number.  The value must be at most 24 characters long.
SUNO: SupplierEnter (map) the supplier name.  The value must be at most 10 characters long.
CUCD: Currency CodeEnter (map) the applicable currency code for the supplier invoice. For example, USD.
TEPY: Payment TermsEnter (map) the payment terms.  The value must be at most three characters long.
PYME: Payment Method - Accounts PayableEnter (map) the details of the payment method. The value must be at most three characters long.
BKID: Bank Account IdentityEnter (map) the supplier's bank account identity information. The value must be at most five characters long.
TDCD: Trade CodeEnter (map) the supplier's trade code. The value must be at most four characters long.
CRTP: Exchange Rate TypeEnter (map) the supplier's applicable exchange rate type. The value must be at most 24 characters long.
DEDA: Delivery DateEnter (map) the when the invoice delivery date. The value must be at most 24 characters long.
IBTP: Invoice Batch TypeEnter (map) the invoice batch type. The value must be at most two characters long.
SPYN: PayeeEnter (map) the payee's name. The value must be at most 10 characters long.
ARAT: Exchange RateEnter (map) the exchange rate applicable to the invoice.
CUAM: Foreign Currency AmountEnter (map) the invoice amount in the supplier's applicable foreign currency.
VTAM: VATEnter (map) the applicable VAT amount on the invoice.
ACDT: Accounting DateEnter (map) the accounting date of the invoice.
APCD: Authorized UserEnter (map) the authorized user details of the invoice.
IMCD: Invoice MatchingSelect whether the invoice matching the details. 
SERS: Service CodeEnter (map) the service code applicable to the invoice.
DUDT: Due DateEnter (map) the date on which the invoice is due.
FECN: Future Rate Agreement NumberEnter (map) the future rate agreement number.
FTCO: From/To CountryEnter (map) the country name from which the invoice is billed or delivered to.
BSCD: Base CountryEnter (map) supplier's base country details.
PUNO: Purchase Order NumberEnter (map) the purchase order number in the invoice.
PUDT: Order DateEnter (map) the order date of the invoice.
TECD: Cash Discount TermEnter (map) the cash discount term applicable to the invoice.
CDT1: Cash Discount Date 1Enter (map) the date on which the cash discount is applicable.
CDP1: Cash Discount Percentage 1
Enter (map) the cash discount in percentage.
CDC1: Cash Discount Amount 1Enter (map) the cash discount amount.
CDT2: Cash Discount Date 2
Enter (map) the date on which the cash discount is applicable.
CDP2: Cash Discount PercentageEnter (map) the cash discount in percentage.
CDC2: Cash Discount Amount 2Enter (map) the cash discount amount.
CDT3: Cash Discount Date 3
Enter (map) the date on which the cash discount is applicable.
CDP3: Cash Discount Percentage 3
Enter (map) the cash discount in percentage.
CDC3: Cash Discount Amount 3Enter (map) the cash discount amount.
TTXA: Total Taxable Amount
Enter (map) the total tax applicable to the invoice.
TASD: Cash Discount Base
Enter (map) the cash discount base details.
PRPA: Prepaid Amount
Enter (map) the prepaid amount paid for the invoice.

Enter (map) the invoice VAT registration number.
TXAP: Tax Applicable
Enter (map) the tax applicable to the invoice.
DNCO: Document Code
Enter (map) the document code 
SDAP: AP Standard Document
Enter (map) the invoice applicable AP standard document number.
DNRE: Debit Note Reason
Enter (map) the amount debit note reason.

Enter (map) your invoice address.
SDA1: Text line 1
Enter (map) the information about the invoice.
SDA2: Text line 2
Enter (map) the information about the invoice.
SDA3: Text line 3
Enter (map) the information about the invoice.
EALP: EAN Location Code Payee
Enter (map) the payee's EAN location code.
EALR: EAN Location Code Consignee
Enter (map) the consignee's EAN location code details.
EALS: EAN Location Code Supplier
Enter (map) the EAN Location Code of the supplier.
GPDF: Get Payee Defaults
Select whether you want to retrieve the supplier's payee default details.

Enter (map) the geographical code applicable to the invoice.
TXIN: Tax Included
Select whether the tax is included in the 
DNOI: Original Invoice Number
Enter (map) the original invoice number.
OYEA: Original Year
Enter (map) the invoice year.

Enter (map) the invoice reference number.
PPYN: Payment Request Number
Enter (map) the invoice payment request number.
YEA4: Year
Enter (map) the year applicable to the invoice.
PVLD: Partial Validation
Select whether the partial validation is applicable on 
VONO: Voucher Number
Enter (map) the voucher number applicable to the invoice.
CORI: Correlation ID
Enter (map) the invoice Correlation ID.
ECAR: State Code
Enter (map) the state code applicable to the invoice.

Add a Supplier Invoice Line Item

Creates a new line item and attaches it to an existing supplier invoice.

ConnectionEstablish a connection to your Infor 3M Cloud account.
INBN: Invoice Batch Number
Enter (map) the invoice batch number whose line items you want to add.
DIVI: Division
Enter (map) the division whose supplier invoices line items you want to list. The value should be a minimum of three characters in length.
RDTP: Line type
Enter (map) the invoice line item type.

Enter (map) the item number which you want to add.
PUUN: Purchase Order U/M
Enter (map) the purchase order number of the item.
PPUN: Purchase Price U/M
Enter (map) the purchase price of the item.
SERS: Service Code
Enter (map) the item's service code.
NLAM: Net Amount - Line
Enter (map) the total net amount of the line item.
VTA1: VAT Amount 1
Enter (map) the VAT amount applicable to the line item.
VTA2: VAT Amount 2
Enter (map) the VAT amount applicable to the line item.
VTCD: VAT Code
Enter (map) the VAT code applicable to the line item.
PUNO: Purchase Order Number
Enter (map) the purchase order number of the line.
PNLI: Purchase Order Line
Enter (map) the purchase order line sub number of the line item.
PNLS: Purchase Order Line Subnumber
Enter (map) the purchase order number in the invoice.
IVQA: Invoiced Quantity - Alternate U/MEnter (map) the number of invoiced line items.
GRPR: Gross Price
Enter (map) the gross amount of the line item.
NEPR: Net Price
Enter (map) the net price of the line items.
PUCD: Purchase Price QuantityEnter (map) the total purchase price of the present quantity of the items.
GLAM: Gross Amount - Line
Enter (map) the total gross amount of the line item.
DIPC: Discount
Enter (map) the discount provided on the line item.
DIAM: Discount Amount
Enter (map) the discount amount provided on the line item.
IVCW: Invoiced Catch Weight
Enter (map) the line item's weight listed in the invoice.
POPN: Alias Number
Enter (map) the invoice alias number. 
SBAN: Self-billing Agreement Number
Enter (map) the invoice self-billing agreement number.
Enter (map) the sequence number of the line item.
CEID: Costing Element
Enter (map) the line item costing element.
REPN: Receiving Number
Enter (map) the line item receiving number.
RELP: Receipt Type
Enter (map) the line item receipt type.
SUDO: Delivery Note Number
Enter (map) the delivery note number of the line item.
DNDT: Delivery Note Date
Enter (map) the date on which the delivery note was provided.
CLAN: Claim Number
Enter (map) the claim number.
CLLN: Claim Order Line
Enter (map) the claim order line number.
TRNO: Transaction Number
Enter (map) the line item transaction number.
VTP1: VAT Rate 1
Enter (map) the VAT rate of the line item.
VTP2: VAT Rate 2
Enter (map) the VAT rate of the line item.
CHGT: Charge Text
Enter (map) the item's charge text.
PVLD: Partial Validation
Select whether the partial validation is applicable on the invoice line item.

Get a Supplier Invoice

Retrieves the details of a supplier invoice by its ID.

ConnectionEstablish a connection to your Infor 3M Cloud account.
DIVI: DivisionEnter (map) the division whose supplier invoices line items you want to list. The value should be a minimum of three characters in length.
INBN: Invoice Batch NumberEnter (map) the invoice batch number whose details you want to retrieve.

Get a Supplier Invoice Line Item

Retrieves the details of a supplier invoice line item by its ID. 

ConnectionEstablish a connection to your Infor 3M Cloud account.
DIVI: DivisionEnter (map) the division whose supplier invoices line items you want to list. The value should be a minimum of three characters in length.
INBN: Invoice Batch NumberEnter (map) the invoice batch number whose line items you want to retrieve.
TRNO: Transaction NumberEnter (map) the transaction number of the supplier invoice line item whose details you want to retrieve.

Update a Supplier Invoice

Updates an existing supplier invoice by its ID.

ConnectionEstablish a connection to your Infor 3M Cloud account.


DIVI: DivisionEnter (map) the division whose supplier invoices line items you want to list. The value should be a minimum of three characters in length.
IVDT: Invoice DateEnter (map) the date on the invoice. 
SINO: Supplier Invoice NumberEnter (map) the supplier's invoice number.  The value must be at most 24 characters long.
SUNO: SupplierEnter (map) the supplier name.  The value must be at most 10 characters long.
CUCD: Currency CodeEnter (map) the applicable currency code for the supplier invoice. For example, USD.
TEPY: Payment TermsEnter (map) the payment terms.  The value must be at most three characters long.
PYME: Payment Method - Accounts PayableEnter (map) the details of the payment method. The value must be at most three characters long.
BKID: Bank Account IdentityEnter (map) the supplier's bank account identity information. The value must be at most five characters long.
TDCD: Trade CodeEnter (map) the supplier's trade code. The value must be at most four characters long.
CRTP: Exchange Rate TypeEnter (map) the supplier's applicable exchange rate type. The value must be at most 24 characters long.
DEDA: Delivery DateEnter (map) the when the invoice delivery date. The value must be at most 24 characters long.
IBTP: Invoice Batch TypeEnter (map) the invoice batch type. The value must be at most two characters long.
SPYN: PayeeEnter (map) the payee's name. The value must be at most 10 characters long.
ARAT: Exchange RateEnter (map) the exchange rate applicable to the invoice.
CUAM: Foreign Currency AmountEnter (map) the invoice amount in the supplier's applicable foreign currency.
VTAM: VATEnter (map) the applicable VAT amount on the invoice.
ACDT: Accounting DateEnter (map) the accounting date of the invoice.
APCD: Authorized UserEnter (map) the authorized user details of the invoice.
IMCD: Invoice MatchingSelect whether the invoice matching the details. 
SERS: Service CodeEnter (map) the service code applicable to the invoice.
DUDT: Due DateEnter (map) the date on which the invoice is due.
FECN: Future Rate Agreement NumberEnter (map) the future rate agreement number.
FTCO: From/To CountryEnter (map) the country name from which the invoice is billed or delivered to.
BSCD: Base CountryEnter (map) supplier's base country details.
PUNO: Purchase Order NumberEnter (map) the purchase order number in the invoice.
PUDT: Order DateEnter (map) the order date of the invoice.
TECD: Cash Discount TermEnter (map) the cash discount term applicable to the invoice.
CDT1: Cash Discount Date 1Enter (map) the date on which the cash discount is applicable.
CDP1: Cash Discount Percentage 1
Enter (map) the cash discount in percentage.
CDC1: Cash Discount Amount 1
Enter (map) the cash discount amount.
CDT2: Cash Discount Date 2
Enter (map) the date on which the cash discount is applicable.
CDP2: Cash Discount Percentage 2
Enter (map) the cash discount in percentage.
CDC2: Cash Discount Amount 2
Enter (map) the cash discount amount.
CDT3: Cash Discount Date 3
Enter (map) the date on which the cash discount is applicable.
CDP3: Cash Discount Percentage 3
Enter (map) the cash discount in percentage.
CDC3: Cash Discount Amount 3
Enter (map) the cash discount amount.
TTXA: Total Taxable Amount
Enter (map) the total tax applicable to the invoice.
TASD: Cash Discount Base
Enter (map) the cash discount base details.
PRPA: Prepaid Amount
Enter (map) the prepaid amount paid for the invoice.

Enter (map) the invoice VAT registration number.
TXAP: Tax Applicable
Enter (map) the tax applicable to the invoice.
DNCO: Document Code
Enter (map) the document code 
SDAP: AP Standard Document
Enter (map) the invoice applicable AP standard document number.
DNRE: Debit Note Reason
Enter (map) the amount debit note reason.

Enter (map) your invoice address.
SDA1: Text line 1
Enter (map) the information about the invoice.
SDA2: Text line 2
Enter (map) the information about the invoice.
SDA3: Text line 3
Enter (map) the information about the invoice.
EALP: EAN Location Code Payee
Enter (map) the payee's EAN location code.
EALR: EAN Location Code Consignee
Enter (map) the consignee's EAN location code details.
EALS: EAN Location Code Supplier
Enter (map) the EAN Location Code of the supplier.
GPDF: Get Payee Defaults
Select whether you want to retrieve the supplier's payee default details.

Enter (map) the geographical code applicable to the invoice.
TXIN: Tax Included
Select whether the tax is included in the 
DNOI: Original Invoice Number
Enter (map) the original invoice number.
OYEA: Original Year
Enter (map) the invoice year.

Enter (map) the invoice reference number.
PPYN: Payment Request Number
Enter (map) the invoice payment request number.
YEA4: Year
Enter (map) the year applicable to the invoice.
PVLD: Partial Validation
Select whether the partial validation is applicable on 
VONO: Voucher Number
Enter (map) the voucher number applicable to the invoice.
CORI: Correlation ID
Enter (map) the invoice Correlation ID.
ECAR: State Code
Enter (map) the state code applicable to the invoice.

Other

Make an API Call

Performs an arbitrary authorized API call.

ConnectionEstablish a connection to your Infor 3M Cloud account.
URL

Enter a path relative to  https://{YOUR_HOST}/m3api-res. For example: /execute/<Your_Account>/GetUserInfo

Method

Select the HTTP method you want to use:

GET
to retrieve information for an entry.

POST
to create a new entry.

PUT
to update/replace an existing entry.

PATCH
to make a partial entry update.

DELETE
to delete an entry.

HeadersEnter the desired request headers. You don't have to add authorization headers; we already did that for you.
Query StringEnter the request query string.
BodyEnter the body content for your API call.

Example of Use - Get Users

The following API call returns all the conversations from your Infor 3M Cloud account:

URL:
/execute/<Account_Host>/GetUserInfo

Method:
GET

Matches of the search can be found in the module's Output under Bundle > Body > Metadata
In our example, 13 users were returned:

Popular use cases from our blog

Using Notion as CMS for Webflow -Tutorial- -illustration.png

How to Use Notion as a CMS for Your Webflow Site [Tutorial]

Basic-tutorial-for-Revolut-users-illustration.png

How to Create Your First Revolut Business Automation [Tutorial]

cancelled saas subscriptions-ILLUSTRATION.png

How to Track SaaS Subscriptions to Reduce Churn [Tutorial]

jira-excel-automation.png

How to Export From Jira to Excel Using Integromat [Tutorial]

influencer partner code sign up tracking-Illustration.png

How to Track Influencer Campaigns With Integromat

Invoice3-automation-illustration.png

How to Get Paid Fast: A Do-It-Yourself Automated Invoicing System

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.