Sage 100

 View Only
Expand all | Collapse all

The Same Customer in a Different Division

  • 1.  The Same Customer in a Different Division

    Posted 10-21-2021 12:38
    The end user is considering implementing customer divisions - one for warehouse sales and another for repairs.  They are concerned about cash receipts, reports, or other issues when the same customer buys products or services from different divisions.  Does anyone have any suggestions on ways to work around any issues pertaining to having the same customer in two different divisions?

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 12:47
    Maybe this will help?  R152 - AR-1152 Security by Division

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 13:00
    My first question is WHY?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 4.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 13:13
    And Jon at DSD just mentioned that's one of the Enhancements subject to Q4 promotion.

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 5.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 14:05
    @Beth Bowers  They have a distribution business and a repair business. Customers bring tools in to the warehouse for repair.  Management wants to be able to track repair sales separately from the distribution sales and create financial reports either combined or seperated by division.  The same customer that buys tools may also need repair services.  Currently the warehouse person doesn't even enter a sales order when a repair comes in.  The item to be repaired may sit until someone gets around to fixing it.  Then when the repair is completed the person doing the repair tells the office the parts they used and that triggers an invoice to be created and sent to the customer. I suggested at a minimum a sales order needs to be created with a misc line item to get the order in the system.  Managements concern is that they have a bunch of sales orders in the system and they want to be able to distinguish orders that need a pick sheet and need to ship and the repair orders.  I mentioned that we could just put a UDF check box on the order and then use a custom filter for repair or distribution lists.  they really like the division idea and use a custom filter to list by division number - ir 00 for distribution orders and 01 for repair orders.  One issue that came up is how to handle a cash receipt that pays multiple invoices, some for each division - One customer# is 00-ABC and the other is 01-ABC.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 6.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 14:09
    Enter the repair orders as SO quotes... that won't affect any "what do we need to ship" reports.

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



  • 7.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 14:14
    @Kevin Moyes  Entering the order as a quote is a great idea.  @Brett Zimmerman  Thanks for the info on the DSD enhancement.  I took a look at it but not sure if it is going to help.  I may contact DSD and get more specifics on what they have available. ​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 8.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 15:33
    Based on what has been said above, going with divisions has the potential to be a big cluster!!!!!!!!!  Enter the order as a quote, use a UDF to differentiate order type.  Write a Crystal report for profit margin reporting.  If you really wanted to use the GL, set up Misc codes of some sort to drive the GL accounts.  Or use the order type UDF to drive the script to change GL account department segment.  Doubling customer numbers gives me chills.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 9.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 13:40
    National Accounts?

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



  • 10.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 15:29
    The first time the customers sends in one check to pay seven invoices from one customer# and 8 from another I think you will probably get a call that goes something like this "Doug, why did you ... "

    At least those seem to be the type of calls I get unless I also send something in writing saying "hey this isn't a good idea because have you also considered x, y and z happening"

    ------------------------------
    Wayne Schulz
    Schulz Consulting
    860-516-8990
    ------------------------------



  • 11.  RE: The Same Customer in a Different Division

    Posted 10-21-2021 16:12
    Thanks for the input @Jeff Schwenk and @Wayne Schulz  I agree with both of you on the recommendations.  I hope the customer will "see the light" also.. 
    ​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 12.  RE: The Same Customer in a Different Division

    Posted 10-22-2021 08:46
    This might not go anywhere, but if I were in your shoes, I'd probe more into where they think this repair business is going in their customer strategy. If they're only now trying to "fix" the process, then it's become bigger than it was. DSD's Service Center would be worth a look with them. At the very least, it could open their eyes to what they *could* be doing.

    ------------------------------
    Jerry Norman
    At-Large BOD Member, 90 Minds
    Smartbridge Partners
    512.419.1444 x112
    ------------------------------



  • 13.  RE: The Same Customer in a Different Division

    Posted 10-22-2021 09:19
    Thanks @Jerry Norman and @Brian Kelly !   Great ideas!
    ​​

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 14.  RE: The Same Customer in a Different Division

    Posted 10-22-2021 10:51
      |   view attached
    I also recall an "Segment substitution on the Fly " enhancement from DSD that provided a prompt in order entry for the GL account.  Customer likes it. PDF should be attached.

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------

    Attachment(s)



  • 15.  RE: The Same Customer in a Different Division

    Posted 10-22-2021 09:10
    @Doug Higgs What about posting to the GL by Warehouse?​  I haven't set this up in a long time, but I remember creating subaccounts specifically for sales and COGS accounts for warehouses.  Have the Repair warehouse post to a different subaccount.  I think that will work.

    ------------------------------
    Brian Kelly
    Accounting Systems, Inc. (ASI)
    Columbia SC
    803-454-6262
    http://www.asifocus.com/
    ------------------------------