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?
Answer
Import scenario with no header records
Best answer by Naveen Boga
Hi
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.
+19Hi
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.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.