Our clients are so smart … During a recent conversation, a client stumbled on a wonderful, cost-effective solution to AP Uploads for Visual ERP that I just had to share!
Mike – “We are processing Vendor expense invoices (no PO) with a lot of lines. Is there any way to just import the AP invoice from an Excel file?”
Kim – “You could have an application created that would allow you to upload the data to Visual.”
Mike – “How much would that cost?”
Kim – “There would be the spec development, program creation, and then a testing phase; you would want to make sure it is thoroughly tested. You don’t want to overpay or underpay a vendor, and you don’t want to pay them too late or too early. It has to be just right.”
Mike – “Good points, but how much do you think that would cost?”
Kim – “I wouldn’t be surprised if it was somewhere around $5,000.”
Mike – “Hmmm. That seems like a lot of money. What if we entered the AP invoice as one line and posted it to an AP clearing account? Then we could take the Excel File and import it using Visual’s import General Journal functionality. We would debit all the expense accounts and credit the AP clearing account. Then we would just have to ensure AP clearing account is zero. Would that work instead?”
Kim – “That is a brilliant idea, and there is no cost. All you have to do is massage the file from the vendor so it can be used for the import. I love it.”
Mike – “Me too. There is no cost, and we could start using it tomorrow!”
