Sage 100

 View Only
  • 1.  Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 09:20

    I have a client who has used Sales Order, Accounts Receivable and Inventory for many years. They recently hired a new controller. In the past all customer Invoices, Debit Memos and Credit Memos have been created using the Invoice Data Entry feature in Sales Order. The new controller wants to create some Invoice and Credit Memos using the Invoice Data Entry feature in the Accounts Receivable Module.

    The two modules automatically track "Next" invoice number using two different counters in their respective Setup Options screens. Is there a way to 'inter-weave" the two counters? Or is the answer: "When you have Sales Order installed you should NOT use Accounts Receivable for Invoicing, Credit Memo, etc.".



    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    (616) 813-8887 - mike@mcdcpa.com
    ------------------------------


  • 2.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 09:24
    The only way to do it would be a custom enhancement and I do not believe DSD has an already designed enhancement


    Thank you,

    Douglas Luchansky
    ACI Consulting
    O 714.282.0378
    D 714.694.4194

    Sent from my iPhone






  • 3.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 09:47

    "When you're using Sales Order you should NOT be doing invoicing out of AR."  I have people that do their CM sometimes in AR, but I always try to keep them away from it if they use SO.  The same Misc codes they use in AR can be used in SO, so I don't see the point.  What advantage do they think there is in doing it in AR?



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 4.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 11:26
      |   view attached

    @Beth Bowers The only "reason" I could get for wanting to enter a Credit Memo in AR was "That's where you do it in QuickBooks, Peachtree, etc. etc." He was upset that SAGE 100 has a "bug" because when he tried to enter the Credit Memo in AR, he received the "error" below.  The Next invoice number in the AR counter was an existing invoice number in Sales Order.



    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    (616) 813-8887 - mike@mcdcpa.com
    ------------------------------



  • 5.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 11:29

    You can fast forward the Next invoice # in AR to be a different range (eg. starting with a 9######...), but I'm of the philosophy that the user should be pushed to SO, for best results. 



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



  • 6.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 12:06

    Oh, @Michael McDonald - you're gonna have fun with that one.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 7.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 12:12

    Yeah... present it properly (i.e. SO is sooooo much better than AR for entering invoices...), and you can bypass a lot of BKAC issues.

    "But in (old system ABC) I did it this way."

    "Well, Sage 100 is not old system ABC, and this way is better."

    AKA: fudge it!



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



  • 8.  RE: Customer Invoice tracking in SAGE 100 STD SO and AR

    Posted 07-10-2023 12:38

    @Kevin Moyes Thank you for your response. But I think I will use a "FUD" answer to this client.

    Fear...If you use the AR module for Invoicing, CM and DM your whole SAGE system could blow!

    Uncertainty..The customer records from AR may not match up with customer records from Sales Order.

    Doubt...The Customer Aged Invoice Report may not print.

    But you're the customer, so go ahead!



    ------------------------------
    Michael McDonald - Consultant
    Michael T McDonald CPA
    (616) 813-8887 - mike@mcdcpa.com
    ------------------------------