Topic Options
#43424 - 11/05/14 01:03 PM AR 9.1A - One Customer, two control account sets
Orianne Offline
Orianne

Registered: 06/11/12
Posts: 22
Loc: BC
Hi there,

Hoping someone out there will be able to help me on this one.....

I have 90 customers in my AR 9.1A. They are all defaulted with Control Account Set ("CAS") #1 (Lets call it Operating Account). Their recurring charges, etc... all typically get invoiced against this CAS...and their payments get deposited into their Operating Bank account.

I now need to invoice each customer with a different, one-off, separate type of invoice (that will show under a different Account # on my balance sheet). The payments received for this one-off invoice will be deposited into a different bank account. I've opened a new CAS #2 (lets call it "Levy Account") with this bank info on it and a new control account #.

Without having to go in and manually change every customer's CAS set from #1 to #2, then key in the one-off invoice, then post them and then go and change the CAS all back from #2 to #1....how can I do this??

The problem I've run into in having it done this way, is that when I do go to deposit the payments for this one-off invoice, I have to again go in and change that particular customer's default CAS to match it, make my deposit batch, post it, and then change it back again. Then....inevitably......it ended up mixing the outstanding receivables on the balance sheet because some of the customers had active o/s amounts in CAS #1 when the invoice was keyed in.

Is there an easier way for me to do this?? I've tried going into company profile in AR and changing the default control account ("CAS") set from 1 to 2 and then keying the one-off invoice...but it still defaulted to CAS 1.

I need to keep the invoices under the same customer, but need them to show separately as outstanding receivables on my balance sheet. Just can't seem to figure it out ???

Thanks!
Orianne

Top
#43426 - 11/05/14 01:27 PM Re: AR 9.1A - One Customer, two control account sets [Re: Orianne]
Warren Karges Offline


Registered: 08/04/11
Posts: 461
Loc: Waterloo, Ontario
Using the import and export functions to quickly change the setting for all your customer accounts at once will alleviate some of your pain, although there may be an even better way to accomplish the overall goal out there. It might be worth contacting your dealer to have them demonstrate how to use the import and export functions effectively for this purpose.
_________________________
Warren
Stief Group

Top
#43427 - 11/05/14 06:28 PM Re: AR 9.1A - One Customer, two control account sets [Re: Warren Karges]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
The best way to manage this is by using separate customers. You can't just change the Control Account set back and forth for each invoice type.

My firm has a lot of experience with property management firms using Adagio. Please give me a call if we can assist you further.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#43432 - 11/06/14 08:26 AM Re: AR 9.1A - One Customer, two control account sets [Re: Douglas Dickie]
Orianne Offline
Orianne

Registered: 06/11/12
Posts: 22
Loc: BC
Thank you Warren and Douglas for your quick replies. smile I was hoping there would be a quick and easy way. I may give the import/export function a try.

Douglas, I had thought about duplicating all 90 customers so I could use the different Control Account Set, but it seems so tedious just for the sake of one invoice. Not to mention, by doing it this way, then when sending statements out, I'd have to send out two statements to each customer which then just confuses them.

I typically don't go on the forum often as I usually just contact our Adagio Rep, but I thought I'd give it a try this time.

Thanks guys! smile
Orianne

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 87 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70650 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30