EN globe icon
user icon
What can we help you find? Products Platform Integration Playbooks and Resources Other Integration Playbooks ERP Integration Adapters Integration Scenarios 11. Flat File CSV Parser Scenario

11. Flat File CSV Parser Scenario

Revised: 14 September 2016

Overview

At Coupa we would like to validate that Flat File CSV parser uses column header as opposed to Flat File field positions to make sure compatibility with future releases. This Scenario is applicable for ERP Connectors using Coupa Flat File CSV exports.

OK To Pay Parser Scenario

  • Stop auto processing of OK to Pay file on ERP Connector Platform
  • Create an invoice in Coupa
  • Approve Invoice
  • Coupa exports Ok To Pay file to sFTP site
  • Take the file and swap the first 2 header columns and values, save the file
  • Start auto processing of OK to Pay file on ERP Connector Platform
  • Validate that the OK To Pay file has been imported to the ERP system correctly

Expense Report Parser Scenario

  • Stop auto processing of Expense Report file on ERP Connector Platform
  • Create an Expense Report in Coupa
  • Approve Expense Report
  • Coupa exports Expense report file to sFTP site
  • Take the file and swap the first 2 header columns and values, save the file
  • Start auto processing of Expense Report file on ERP Connector Platform
  • Validate that the Expense Report file has been imported to the ERP system correctly

Purchase Order Outbound Parser Scenario

  • Stop auto processing of Purchase Order file on ERP Connector Platform
  • Create a Requisition in Coupa
  • Approve Requisition, Purchase Order gets created
  • Coupa exports Purchase Order outbound file to sFTP site
  • Take the file and swap the first 2 header columns and values, save the file
  • Start auto processing of Purchase Order file on ERP Connector Platform
  • Validate that the Purchase Order file has been imported to the ERP system correctly

Goods Receipt Outbound Parser Scenario

  • Stop auto processing of Goods Receipt file on ERP Connector Platform
  • Create a Requisition in Coupa
  • Approve Requisition, Purchase Order gets created
  • Create a Goods receipt on the Purchase Order
  • Coupa exports Goods Receipt outbound file to sFTP site
  • Take the file and swap the first 2 header columns and values, save the file
  • Start auto processing of Goods receipt file on ERP Connector Platform
  • Validate that the Gods Receipt file has been imported to the ERP system correctly