Sage 100

 View Only
  • 1.  A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 04-29-2021 11:43
    Related to A/P Automation such as Beanworks and other solutions, has anyone been involved (or aware) where Job Cost data and A/P sales tax were in play?

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


  • 2.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 04-29-2021 13:39
    I don't understand the question. A/P Automation is essentially the capture of electronic invoices from vendors to add into Sage. It is no different from hand-entering the invoice on receipts. If a PO exists to match against, it does; again, same as manual process. 

    It has the same challenges for sales tax as you do manually: one way or the other you must match the vendor's tax, whether through tax rules or fat-fingered line entry. 

    Beanworks, AvidXchange, and others all use workflow to approve the invoice and coding before creating the invoice in Sage. The user can modify the automated first-pass. If there are complications about charging to job, then you would probably by generating POs to simplify.

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



  • 3.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 04-29-2021 14:15
    I don't think Beanworks/AP Automation works with Job Cost
    At least it didn't about 4 months ago when one of my other customers ( who uses JC ) had a demo

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



  • 4.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 05-05-2021 16:11

    Thanks for the responses, @Wayne Schulz and @Jerry Norman.  Essentially I'm wondering if anyone has had to address A/P sales tax and/or Job Cost data for an A/P Automation solution.  Our client is trying to implement something to help with their volume of manual A/P invoice entry.  For the majority of invoices they have to determine the correct invoice-specific Tax Schedule (often different than Vendor's default Tax Sched), edit the Tax Amount relative to which lines are taxable/non-taxable, and specify the J/C data for the applicable lines and each G/L account.  

    Apparently Beanworks (BW) just doesn't allow for J/C data at all.  And unlike Chrome River (the first solution considered which the client found on their own, but it resulted in too much manual intervention), it sounds like BW doesn't have a place to edit the data before bringing it into Sage 100, of which I'm a little surprised.
    It appeared the client was expecting that more data on each invoice could be scanned, including handwritten data such as Job #, G/L account, etc.

    Any thoughts on Concur?  Does that have a scanning component?

    Might have to go "back to formula" on this one.

    ​​

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



  • 5.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 05-05-2021 21:51
    Brett - It's really dangerous for an outsider to offer significant analysis suggestions since I don't have important info. Nevertheless, "Nick Danger, 3rd Eye" will jump in ...

    The customer should look hard at answering the question, "why does it seem none of these vendors address my situation?" One answer is, "Because sophisticated users don't have it."

    1. Are they really adjusting the vendor's sales tax amounts on the invoice? Who does this? If their customers were so presumptuous, what would they think? If the vendor is wrong, talk to them to resolve it -- after all, the vendor is actually paying it! Because your customer thinks it knows the vendor's business better, they are creating accounting headaches for the vendor? There must be countless back-and-forth over mismatched statement balances over this. They should check with their CPA/Atty, but I think they don't have much if any liability if the vendor is miscalculating the tax owed. 

    2. I think it's a bit much for your customer to expect the vendor to know which part of JC the invoice applies. Again, if they want vendors to do this, it must be through an enforced PO process. Otherwise, the vendor has no realistic way. If your customer insists on extensive rules before entering, then they are a good candidate for Altec, which lets its users employ extensive customer workflow.

    Altec readily says that companies starting with AP Automation are good prospects for their products if it also looks like will have further doc mgt needs. This customer's needs are a subset of that.

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



  • 6.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 05-13-2021 11:23
    Client is now looking at Conur, which apparently can scan handwritten notes and can handle sales tax.

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



  • 7.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 05-13-2021 11:38
    I have a medical customer using Concur. They seem happy. I think they bring in the invoices using VI.

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



  • 8.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 05-19-2021 08:08
    And now client is also looking at doc-link.

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



  • 9.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 08-10-2021 14:33
    Apparently Job Cost functionality for Beanworks AP Automation is coming later this year.  They mentioned that during a webinar I just attended.

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



  • 10.  RE: A/P Automation, e.g. Beanworks, etc. - incl Job Cost data and A/P sales tax

    Posted 08-10-2021 14:46
    If it works like the integration with Purchase Orders, color me less than impressed.

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