Import scenario with no header records

  • 9 November 2021
  • 1 reply

Userlevel 2

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?


Best answer by Naveen Boga 12 November 2021, 20:47

View original

1 reply

Userlevel 7
Badge +18

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.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved