Hi All
I want to import a journal entry via CSV upload which I have done many times before in my prior roles. However I am encountering this issue that surely has a workaround but I am unable to figure it out even after watching multiple YouTube vdos. So I am hoping I can find some help here.
Method 1 – Current process:
Set up –> Import/Export –> Import CSV records, it takes me to this screen where I can upload a CSV, map the fields the way I want it and then save a copy of that template. Next time if I want to upload a similar template, I need to go to Set up –> Import/Export –> Saved CSV imports –> find my template from the 100s of templates (or bookmark it) and use that template to upload a new JE without having to map everything again.
In this process, after I am done uploading a JE, it takes me to a confirmation page and then I need to click on the ‘Import Job Status’ link to see if my JE is uploaded successfully. Even there I have no way to directly go to the JE that I just posted and have to search it either from the Transaction report or JE name (if I used one)
Method 2 –
Type Import Journal entries in the Search Bar –> Takes me to the Import Assistant Page that has 2 Steps on the left hand side 1. Scan and Upload CSV file –> Next –> Step 2 is View Mapping/Start Import.
This is the part where in my old company I didn’t have to map my template everytime I use this method to upload a CSV file. I am not sure if the admin mapped it under my login, but usually I could upload my JE template without having to change the mapping. The template was mapped to how we wanted it. Whereas in my new job, if I use this method to upload a CSV file the mapping turns to default and I have to remap it with every new upload. The next step is to click on Run. This will take you to the actual JE page and let you know if the JE is successfully uploaded or not.
Is there any way I can use Method 2 and store the mapping for my template ? I tried to explain it as detailed as possible. Thanks in advance for the help.