How are cells in an excel file mapped so that when you “load records from file” Acumatica knows which cell to map to which field in Acumatica?
The values don’t appear on the dropdown menu to select the mapping so I suspect there is config in the backend that needs changed to enable this to work.
As an example
PO Screen
Excel file:
Load records:
When I try to import the file again with the edits, I get as far as here then most of the columns aren't mapped and you can see from the dropdown the only ones which are
Where do I go within Acumatica to configure this?
