Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types - Everything Else

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

C_H — Tue, 19 Mar 2024 01:31:03 +0000

@anita-munnich Understood Anita,

I will recreate based on the screen shots.

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Anita Munnich — Mon, 18 Mar 2024 22:07:13 +0000

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.

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

C_H — Mon, 18 Mar 2024 19:24:07 +0000

@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.

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

C_H — Mon, 18 Mar 2024 19:23:56 +0000

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Anita Munnich — Fri, 04 Nov 2022 04:49:59 +0000

@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!

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Royce Lithgo — Fri, 04 Nov 2022 04:23:58 +0000

@anita-munnich what was the error?

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Anita Munnich — Fri, 04 Nov 2022 00:21:39 +0000

@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.
3005

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Royce Lithgo — Wed, 26 Oct 2022 21:47:13 +0000

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.

3002

The above populates the fields indicated below:

3003

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Anita Munnich — Tue, 25 Oct 2022 01:31:13 +0000

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.

RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Royce Lithgo — Tue, 25 Oct 2022 00:33:16 +0000

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.