Location
Developmemt > Flow
Purpose
Generate a word document of payment overvoew
Technical Specification
- Transform Data Using Power Query
- Pass parameter from automate to Power Query
- using xpath to calculate Sum
- Using Select to arrange data and use as input for Word Template Repeated section
- Using Word Template to create a document with repeated section
The document consist of three parts
- address section
- two repeated areas: the first one summary the total invoice ( including payment to tranport agent and factory that delivered goods)
- The invoice for Transport Agent has only the costs at the DeliveryID level and without DeliveryDetails.
- the manufacturers have both transport costs ( from Delivery list) and Delivery Details ( with product id, unit price and quantity) . The specification of the products are shown in the second section.