90 Minds Mod Squad

 View Only
Back to discussions
Expand all | Collapse all

MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

  • 1.  MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-06-2020 14:02
      |   view attached
    Hello

    MS-SO-0060 design spec from Sage is ready for review.  Please post your comments.

    Thanks!
    @Madeline Stefanou
    @Beth Bowers
    @Andrew Hagenbach
    @Bill Pfahnl
    @Jeff Fiddelman​​​​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Attachment(s)

    docx
    MS_SO060_Sage 100 Reverse an Invoice.docx   138 KB 1 version


  • 2.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-06-2020 14:15
    Reviewed. Looks great. Only addition I would consider is a secondary Yes/No prompt for return entire quantity if 'Retain in Detail' is Yes. A 'Yes' would default the quantity returned to the original invoice quantity shipped, a 'No' would default all lines to zero quantity returned. This would act similarly to the dialog box you see when you invoice off a sales order and get a Yes/No prompt to invoice entire order.

    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------



  • 3.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-06-2020 14:24
    Don't see much use of the Summary option (only bringing in Header info).  I don't see an issue with requiring it to be Yes and both Summary/No don't do diddly for you.  Bringing in the Lot/Serial numbers is totally AWESOME.

    But now you know what I want?  A utility like the Check Reversal utility to be able to credit out an entire batch of invoices - again, needed around year end or any other date-fat-finger time.

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



  • 4.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-06-2020 14:29
    Looks good.  I don't see reference, so I am hoping the Unit Cost of each line item is "retained" when the line items are brought back into the Credit Memo.  Especially with Serial or Lot Tracked Inventory.  So I would want clarification that costing integrity from that Credit Memo is being maintained.

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 5.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-06-2020 14:39

    My concern has to do with the added functionality to capture the unit cost of all the lines, and use that unit cost for all calculations, including commission, cost value in inventory, etc.

     

    A written, this would be a great time saver, but if a user needs to credit out and invoice and re-bill it (perhaps to a different customer, etc.), the COGS can be totally different, and if the commission is based on profit, a rep can see an invoice with a profit of X, and the credit of that invoice has a profit of Y because although the billing is the same, the COGS is recalculated.    Then the user needs to find all these and manually fix them.......

     

    If this is out of scope, and MS SO060 was only to save time on entry, then perhaps this needs its own entry.

     

    Jeff

     

     






  • 6.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-14-2020 13:51
    In review of @Jeff Fiddelman concerns,

    Currently, when an existing invoice is applied to a credit memo, the user needs to enter the details of the original invoice, including line items with lot/serial distributions. This feature will streamline this process by copying the original invoice from history.

    When a credit memo is entered and an invoice is selected in the Apply to Inv No. field, a message will display asking the user if they want to bring in the invoice details from history. The message will only display if the A/R Option, "Retain in Detail" is Yes or Summary.
      • If the option is Yes, the credit memo entry will be populated with the data from the AR Invoice History tables, including any lot/serial distributions for sales order invoices
      • If the option is Summary, the credit memo entry will only be populated with the data from the AR_InvoiceHistoryHeader table since line detail was not saved

    If the details are pulling from Invoice History then the credit is a match to the original invoice and they'd cancel out each other.  The rebill to a new customer or the existing customer then becomes a new transaction.  If the tier costs has changed between the original invoice and the new invoice, I think it should be left to the user to determine if there is a needed correction for commissions.   (It could be the salesrep that errored in the original transaction) 

    However, there should be a time limit on recalling invoice details from history since the historical cost may be dramatically different than the current cost. Items are placed back into available qty, GL postings, commissions, and profit are all called into account. 

    I would suggest that the modification include a warning after the user has selected the invoice to recall for the credit:

    "The Apply to Invoice is X days old. The credit will recall costs from the original invoice that may no longer be current.  Do you want to continue?" 





    ​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 7.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-14-2020 14:03
    Nice

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

    Original Message


  • 8.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-15-2020 08:45
    I like the points that were brought up, but I also think this needs more design work....

    Rather than write it all out, do you think we can have a call on this, for whoever in the Mod Squad is interested, to discuss it ?

    (We have done this as a mod where we give the users the choice of how to handle the cost ...)

    Jeff

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 9.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-16-2020 09:24
    Edited by Madeline Stefanou 11-16-2020 09:24
    Since Jeff has experience with doing this "enhancement" it would be nice to schedule a conference call (with Sage Developers), to review features, options and choices.  If this happens, I would also like to be involved.

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 10.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-19-2020 16:52
    Thanks for the feedback.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 11.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-19-2020 20:06
    I've proposed at call with Sage Dev for the week after Thanksgiving - I'll keep everyone posted.

    And, have a wonderful Thanksgiving everyone!!

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 12.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 11-24-2020 12:45
    We have the call scheduled with Sage Dev. for Monday, November 30 at 10:00 am Pacific.  An email was sent with meeting invite.  In case is doesn't arrive to your inbox, here are the details:

    @Jeff Fiddelman @Beth Bowers @Bill Pfahnl @Andrew Hagenbach @Madeline Stefanou

    90 Minds Mod Squad & Sage Review MS-SO060
    Hosted by Moira Goggin

    https://chismet.my.webex.com/chismet.my/j.php?MTID=m052d89dc935d49f57a8074b72dfc702f
    Monday, Nov 30, 2020 10:00 am | 45 minutes | (UTC-08:00) Pacific Time (US & Canada)
    Meeting number: 126 487 8789
    Password: 1234
    Agenda: Review of the issues and options for MS-SO060 Add the option for an AR/SO credit memo applied to an invoice, to recall the original cost of the invoice its is being applied against.
    9faa59d357a544369ae19550bf54b8d7

    Join by video system
    Dial 1264878789@webex.com
    You can also dial 173.243.2.68 and enter your meeting number.

    Join by phone
    +1-510-338-9438 USA Toll
    Access code: 126 487 8789
    ​​​​​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 13.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 12-16-2020 13:13
      |   view attached
    UPDATED DEV DOC

    Attached is the updated design after our meeting with Sage.  Please review and comment,  thank you

    @Madeline Stefanou
    @Jeff Fiddelman
    @Andrew Hagenbach
    @Beth Bowers
    @Bill Pfahnl


    ​​​​​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 14.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 12-17-2020 09:11

    Reviewed.  I love it.  And am especially pleased with the Yes (from history) is the default and how you can see the Details.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 15.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 12-17-2020 10:24

    Excellent !



    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 16.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 02-03-2021 21:12

    Sage sent a follow up question:

    I have a question regarding MS-SO060.

    The purpose of the enhancement is to copy the invoice from history when applying an invoice to a credit memo, with the ability to recall the original cost from history, or to use the current cost from inventory.

    If the original cost from history is used instead of the current cost from inventory, does that go against GAAP for Average, LIFO and FIFO items?

    ​​

    ------------------------------
    Admin Robert Wood
    Consultant
    90 Minds, Inc.
    Ocala FL
    352-615-5898
    ------------------------------

    Original Message


  • 17.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 02-04-2021 09:01
    Edited by Madeline Stefanou 02-04-2021 09:01
    Tagging the group Team for a response @Robert Wood
    @Madeline Stefanou
    @Jeff Fiddelman
    @Andrew Hagenbach
    @Beth Bowers
    @Bill Pfahnl​

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 18.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 02-08-2021 10:00

    RE:  question regarding MS-SO060.  @Robert Wood
    Not an official CPA response, but I did as in our RKL CPA office for a recommendation. 

    "When looking into the answer for this question, I discovered that the FASB codification doesn't really discuss inventory costing from a return perspective.  Since I can't point my finger to clear guidance, here is how it would be handled under the different costing methods:

      FIFO – returned to inventory at the most recent cost when the sale was made

      LIFO – retuned to inventory at the oldest costs assigned to the inventory when the sale was made

      WAC – returned to inventory at the weighted average cost at the time of the return

    Unless the returns are significant in a volatile pricing market, it probably isn't going to have a material effect on the financial statements."
    @Madeline Stefanou
    @Jeff Fiddelman
    @Andrew Hagenbach
    @Beth Bowers
    @Bill Pfahnl

    ​

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 19.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 02-09-2021 01:44
    IMO the cost should be the original cost of the item when sold regardless of valuation. The item being returned should not be more of less valuable than when it was sold. The only caveat is Standard Cost where the standard cost is now different than when sold. If so, an inventory adjustment posting should be made similar to other transactions when true costs are different than the standard cost of the item.

    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------

    Original Message


  • 20.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 02-09-2021 06:51
    100% agree with Bill.  The reason for this request was to allow users to credit out an invoice, exactly reversing it, including the exact cost on each line of the invoice.  So on all places that store data based on Cost (such as the A/R salesperson commission report), the credit to reverse an invoice will exactly offset the invoice itself.  Right now there is no way to do this without a programming enhancement, and it is a challenge to explain to a client why when they "reverse" an invoice, by crediting it out,  salespeople being paid on margin can still earn or lose commission. (the salesperson commission is just an example of why this is needed).  As Bill pointed out, Standard cost may have changed, so this needs to be addressed so the line cost can be the original.  Another question is whether if LIFO or FIFO, a new tier will be created, or if a tier exists at the exact cost being returned, should that tier be used, and if multiple tiers, which one.

    Jeff

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 21.  RE: MS-SO060 - Sage 100 Reverse and Invoice - Review Design Spec

    Posted 02-09-2021 11:27
    Thanks! I'll pass the notes along.
    --

    Robert C. Wood  | Consultant

    DDF Consulting Group, Inc.

    direct: 352.615.5898 | help desk: 888.289.2075

    RobertW@ddfcgi.com |  www.ddfcgi.com


    Eric Hoffer: "In times of change learners inherit the earth; while the learned find themselves beautifully equipped to deal with a world that no longer exists."





    Original Message


Related Content