Excel Invoice Form

This example uses Excel's WEBSERVICE() function to merge currency exchange API, Customers, Accounts Payable, and Inventory data.
Select a Customer from the drop-down selector to look-up the account's address, credit limit, current accounts payable, and available credit.
Select a Currency from the drop-down selector to query the currency API to retrieve U.S. dollar-based exchange rates for over 180 countries.
Select a Product # from the drop-down selectors to add the product to the form and look-up product description, quantity-on-hand, and price.
Adjust quantities to run calculations and update totals, double-order or add more products than are on-hand to see error-checking constraints.
Select Adjust Inventory to decrement inventory using a SQL transaction, click Print to preview the invoice, click Submit to view the output array.