How do you import cash payments into Sage 50 Accounts?

Posted By Ross Nicol over 4 years ago

Hi,

We have a client that uses a cash register which generates an import file to bring the transactions into Sage 50 as a CSV file.

Everything is working apart from when they try and import a cash refund into Sage as a cash payment (CP).

When they try and import that, Sage brings up the "Bank account type is not valid for the transaction type." error, even though the bank account involved (1240) is quite clearly shown in Sage as a 'Cash Account.

I even tried creating a brand new Cash Account on a new code, but it suffers from the same problem.

Is there a setting somewhere that I'm missing that allows / blocks cash payments from being imported?

Thanks

Ross

0 Sean White over 4 years ago

Hi Ross.

Thanks for using Sage City.

There isn't a setting that would stop this.

The best thing to do on this occasion would be to start a webchat with us or if you have telephone support, give us a call on 0191 479 5955 so we can take a look at the import sheet and program.

Regards,

Sean
Sage UKI
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Nick Wetherall over 4 years ago

Hi Ross

When importing transactions which need to allocated against invoice etc the type needs to changed.

Supplier Payments (PP) and Customer Receipts (SR) have to changed to on account type PA and SA as the import feature isn't able to allocate the transaction against the correct invoices.

As far as I'm aware this is the same for refunds as it doesn't know which invoice is allocate against.

Thanks

Nick
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Accounts

How do you import cash payments into Sage 50 Accounts?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING