Sage 100

Sage 100 Advanced 2016 - I am looking for information, youtube videos, recorded webinars, technical documents, anything really for a better understanding of the day to day workings of using National Accounts in AR.  Specifically in two key areas ...

1) how does using National Accounts affect entering Cash Receipts?  Is the cash posted to the Parent corporate entity and it doesn't matter that the invoices were generated for the children subsidiary companies?  For example: we have been selling product to Krogers across the nation.  Each store is a Mas customer.  Orders are taken, product shipped, invoices generated for each store.  The stores send the invoices up the chain to corporate, who compiles them as they see fit and issues one check for a batch of invoices that span a multitude of stores (i.e. customers), generally quite a large batch.  As you can imagine, this is a CR nightmare.  Can creating a parent Corporate Kroger, tying all the stores to it ease the pain here?

2) This is a long time Mas customer, almost 30 years, with LOTS of data, lots of existing customers, lots of open invoices totaling in the millions... How do you go about converting a client like this from the old single company customer concept to using National Accounts?  What about the existing data?  Open invoices?  Invoice history?

If anyone has been through this process, or knows of some information on this somewhere, or any other insight, I would be interested to hear.

Thanks, Randy

------------------------------
Randy Marion
------------------------------

@Randy Marion - The invoices are created for the children like normal, but posted to the Open Invoice file using the Parent.  The Invoice History file, though, is still by the children, so there is a disconnect there.  You see them in Invoice History Inquiry only for the children and aging/open invoices only for the Parent. 

You can choose the print the child on the Aging and Statements, though.

When I've converted, I've let them pay out the invoices that currently existed (on the child accounts).  Takes a while to get it cleaned out and means a little hunting for a while, but since they are used to hunting, probably not much worse than normal.  No changes to anything historical happen when you add in National Accounts.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions
------------------------------

@Beth Bowers - Thanks for the insight ... As far as day to day usage goes, that sounds like the ticket here ... A check comes in from corporate with a long list of invoices on it from the children, and post it all directly to the parent corporate customer and it all flows down to the children on the lookup screens.  The fly in the ointment is getting them from where they are to there... They do far too much volume with too many National Account type companies to do the pay down and cut over technique... Is there another way?​

------------------------------
Randy Marion
------------------------------

Original Message:
Sent: 03-30-2022 10:48
From: Beth Bowers
Subject: More info on using National Accounts

@Randy Marion - The invoices are created for the children like normal, but posted to the Open Invoice file using the Parent.  The Invoice History file, though, is still by the children, so there is a disconnect there.  You see them in Invoice History Inquiry only for the children and aging/open invoices only for the Parent.

You can choose the print the child on the Aging and Statements, though.

When I've converted, I've let them pay out the invoices that currently existed (on the child accounts).  Takes a while to get it cleaned out and means a little hunting for a while, but since they are used to hunting, probably not much worse than normal.  No changes to anything historical happen when you add in National Accounts.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions
------------------------------

@Randy Marion - you could do adjustments off the old account and onto the new account - I'm sure you could use VI to adjust them around.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 03-30-2022 11:13
From: Randy Marion
Subject: More info on using National Accounts

@Beth Bowers - Thanks for the insight ... As far as day to day usage goes, that sounds like the ticket here ... A check comes in from corporate with a long list of invoices on it from the children, and post it all directly to the parent corporate customer and it all flows down to the children on the lookup screens.  The fly in the ointment is getting them from where they are to there... They do far too much volume with too many National Account type companies to do the pay down and cut over technique... Is there another way?​

------------------------------
Randy Marion
------------------------------


Original Message:
Sent: 03-30-2022 10:48
From: Beth Bowers
Subject: More info on using National Accounts

@Randy Marion - The invoices are created for the children like normal, but posted to the Open Invoice file using the Parent.  The Invoice History file, though, is still by the children, so there is a disconnect there.  You see them in Invoice History Inquiry only for the children and aging/open invoices only for the Parent.

You can choose the print the child on the Aging and Statements, though.

When I've converted, I've let them pay out the invoices that currently existed (on the child accounts).  Takes a while to get it cleaned out and means a little hunting for a while, but since they are used to hunting, probably not much worse than normal.  No changes to anything historical happen when you add in National Accounts.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions

Idea (untested): 
CM to a clearing account.  Then add the BillTo/SoldTo settings, and post DM to the SoldTo customer with the BillTo account in place, using the same clearing account.  This should move the AR... but finding the right DM for the payments might be a challenge (unless you are able to reuse the same invoice # as the DM #).
Be sure to test.
​​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 03-30-2022 11:34
From: Beth Bowers
Subject: More info on using National Accounts

@Randy Marion - you could do adjustments off the old account and onto the new account - I'm sure you could use VI to adjust them around.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 03-30-2022 11:13
From: Randy Marion
Subject: More info on using National Accounts

@Beth Bowers - Thanks for the insight ... As far as day to day usage goes, that sounds like the ticket here ... A check comes in from corporate with a long list of invoices on it from the children, and post it all directly to the parent corporate customer and it all flows down to the children on the lookup screens.  The fly in the ointment is getting them from where they are to there... They do far too much volume with too many National Account type companies to do the pay down and cut over technique... Is there another way?​

------------------------------
Randy Marion


Original Message:
Sent: 03-30-2022 10:48
From: Beth Bowers
Subject: More info on using National Accounts

@Randy Marion - The invoices are created for the children like normal, but posted to the Open Invoice file using the Parent.  The Invoice History file, though, is still by the children, so there is a disconnect there.  You see them in Invoice History Inquiry only for the children and aging/open invoices only for the Parent.

You can choose the print the child on the Aging and Statements, though.

When I've converted, I've let them pay out the invoices that currently existed (on the child accounts).  Takes a while to get it cleaned out and means a little hunting for a while, but since they are used to hunting, probably not much worse than normal.  No changes to anything historical happen when you add in National Accounts.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions

@Kevin Moyes - I am currently testing your CM, set up the NA parent customer w/ children, and DM the invoices back in.  So far, looks to work ok.  Still have some issues to work out with negative open invoices (overpaid), and partially paid open invoices, but I think I can handle that.

The invoices coming back in as DM's - if it were just a few invoices, this might not be a problem, but when I get to the big company w/ over 6000 open invoices coming back in as a DM ... let's just say there are concerns... even though we are using the same invoice number for the DM, the issue is until all the current data is flushed through, data entry is going to have to deal with some invoices being IN and some DM ...

I had an idea and I was wondering if the brain trust here can foresee any pitfalls... Instead of bringing the invoices back in as DM's to the child company, what about bringing them in as IN invoices directly to the parent company?  The only issue I can see is that the child customer number will not be available to print on statements and I am not sure that is a deal breaker.  Am I about to step off the cliff here?
​

------------------------------
Randy Marion
------------------------------

Original Message:
Sent: 03-30-2022 11:40
From: Kevin Moyes
Subject: More info on using National Accounts

Idea (untested):
CM to a clearing account.  Then add the BillTo/SoldTo settings, and post DM to the SoldTo customer with the BillTo account in place, using the same clearing account.  This should move the AR... but finding the right DM for the payments might be a challenge (unless you are able to reuse the same invoice # as the DM #).
Be sure to test.
​​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 03-30-2022 11:34
From: Beth Bowers
Subject: More info on using National Accounts

@Randy Marion - you could do adjustments off the old account and onto the new account - I'm sure you could use VI to adjust them around.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions


Original Message:
Sent: 03-30-2022 11:13
From: Randy Marion
Subject: More info on using National Accounts

@Beth Bowers - Thanks for the insight ... As far as day to day usage goes, that sounds like the ticket here ... A check comes in from corporate with a long list of invoices on it from the children, and post it all directly to the parent corporate customer and it all flows down to the children on the lookup screens.  The fly in the ointment is getting them from where they are to there... They do far too much volume with too many National Account type companies to do the pay down and cut over technique... Is there another way?​

------------------------------
Randy Marion


Original Message:
Sent: 03-30-2022 10:48
From: Beth Bowers
Subject: More info on using National Accounts

@Randy Marion - The invoices are created for the children like normal, but posted to the Open Invoice file using the Parent.  The Invoice History file, though, is still by the children, so there is a disconnect there.  You see them in Invoice History Inquiry only for the children and aging/open invoices only for the Parent.

You can choose the print the child on the Aging and Statements, though.

When I've converted, I've let them pay out the invoices that currently existed (on the child accounts).  Takes a while to get it cleaned out and means a little hunting for a while, but since they are used to hunting, probably not much worse than normal.  No changes to anything historical happen when you add in National Accounts.​

------------------------------
Beth Bowers
Mom to Peanut, ChiChi, Canton, Cagney and Daisy (I miss you, Sammy)
Tennessee Software Solutions