By using this website, you agree to our Terms of Use (click here)
Hi all
Has anyone managed to successfully import cash accounts into Acumatica including adding in all required payment methods, populating all the remittance details for Name of user, Account number etc and populating all the required entry types including the tax setting on the line for each entry type.
Would love it if you have, if you share a screen shot of the import scenario.
Much appreciate the time taken to review this.
Anita
Do you have a lot of cash accounts to import? This was one table that I've always configured manually as it didn't take long to do and building a GI would take longer.
Hi Royce, I absolutley agree as I would also normally enter these manually but I have 397 cash accounts to setup so thought this would be the ideal time to build the GI. I have most of the import working, I just cant populate the Remittance Account settings for the various Payment Methods.
Here's an excerpt from a Suppliers import that i did which assigned remittance account details. Hopefully it might be similar for what you are doing.
The above populates the fields indicated below:
@roycelithgo Thanks for the above, I tried this as I can import Supplier bank details without error but the cash account is not working. I also tried to split the import and import the cash accounts without the Remittance Payment Method and details and then import these as a second import but I get the same error.
@roycelithgo Hi, finally got to work with some help. You need remove the requires remittance on the payment method to import the payments methods first, then tick these again and the do a second import with the above....but you have to tick the commit ticks on the Value lines in the above import scenario. Appreciate your assistance!
@anita-munnich Any chance you might be willing to share your Cash account import Scenario? I also have several hundred cash accounts to create and already have the bulk of the information in a excel file.
@anita-munnich Any chance you might be willing to share your Cash account import Scenario? I also have several hundred cash accounts to create and already have the bulk of the information in a excel file.
Hi CH, I no longer have access to the site that I wrote this on, but it is all in the screenshot above so you can replicate it. Just remember before you do, you need to remove the requires remittance on the payment method to import the payment methods first, then tick these again and then do a second import with the above....but you have to tick the commit ticks on the Value lines in the above import scenario.