Skip to main content
Solved

Import scenario with no header records

  • 9 November 2021
  • 1 reply
  • 162 views

One of my clients receives a payroll file with no header records. They can import into Quickbooks by mapping the data field to the column in the excel file. Does Acumatica allow this type of mapping? For example, Column A = Date, Column B = Amount...In the Data Provider or Import Scenario can I specify Column A = Date?

1 reply

Userlevel 7
Badge +19

Hi @missyjimmy  I don’t think it is possible in standard default Acumatica.

In the Import Scenarios, either we need to provide the mapping using header fields or we can provide the static values, but with out header fields we can not do the mapping in Acumatica.

Reply