Laserfiche WebLink
3. Invoice Journals from enQuesta (Utility Billing) <br />Source: enQuesta <br />Target: Dynamics 365, Accounts Payable <br />Frequency: As needed <br />Direction of Integration: One-way <br />Summary: The City needs the ability to send Invoice Journals from their new utility <br />billing system (enQuesta) to Dynamics to be processed and paid. <br />Below is a summary of the expected interface: <br />• Crowe assumes that the City will provide a flat file that will conform to the Dynamics <br />format. <br />• Crowe assumes that no mapping tables are required in Dynamics. Crowe assumes <br />all values in the flat file will match applicable values in Dynamics. <br />• Crowe will develop an interface that passes invoice transactions from enQuesta to <br />Dynamics 365 as an AP Invoice Journal within Dynamics. <br />• Crowe assumes that enQuesta will send Dynamics 365 the following information: <br />Valid vendor ID, Invoice ID, method of payment, transaction date, quantity, unit price, <br />remittance information, and all applicable accounting information (valid account <br />segment values). <br />• Crowe will write additional logic in the interface to systematically create a new vendor <br />in Dynamics if a new vendor ID comes over from enQuesta that doesn't exist in <br />Dynamics. Note: It is assumed that the enQuesta file will include the vendor remit -to <br />addresses, method of payment, and payment terms. Please note, Crowe will treat <br />this as one interface. <br />• This interface will be implemented after cutover. Crowe and the City will mutually <br />agree on the timing of implementing this interface — based on the timing of the City's <br />enQuesta implementation. <br />Please note, it is anticipated that this interface will leverage some of the code <br />developed for interface #2 above (Inventory Invoice Journals from Faster to <br />Dynamics 365. It is also assumed that the Faster interface will be developed and <br />implemented before the one with enQuesta. Should the enQuesta interface be <br />implemented first, we would flip the costs associated with Interfaces #2 and #3. <br />3. Assumptions: <br />1. The City will make resources available to assist in the development and testing of any changes <br />that were added to scope. <br />2. The City will make resources available to review and approve the functional designs <br />associated with the new changes being added to scope. <br />3. It is assumed that the new interfaces included in this SOW will be delivered post cutover. <br />Crowe and the City will work together to determine the timing. It is assumed that the fixed <br />asset customization will be delivered by the end of conference room pilot so it can be tested <br />prior to cutover. The City will communicate the timing of the changes to all functional area <br />owners impacted. <br />4. City functional area owners will be responsible for signing off on their respective changes at <br />the end of conference room pilot testing (or after cutover, if the item will be delivered post- <br />cutover). <br />Crowe <br />Page 5 <br />