Creating invoices with reporting functions

Hi, I'm tryin to use the below flow as a template for creating invoices for suppliers providing us with workers, because I have more than one record it is duplicating the output. (see attached)

Any idea how to stop this happening? Also is it possible to separate it in to individual PDF documents per supplier instead of it being continued on to the next page of the same PDF?

what would be the best way to add a GST 10% and Total to the bottom to make it look like a proper invoice?

Thanks

Engine_22452_bd17280f4ca94d5a8dcf7a99066d227e_.pdf

invoice template.yxmd

Datasets

Reporting

Accepted answers

binay2448

Hope this will work for you..

invoice template.yxmd

AngelosPachis

Hey @chelseariver90

For point no.1, you just have to reorganise your workflow a bit, so your table tool is placed before the headers tool. That will give you two snippets, one for each company, that you can then place the header at the top; no need for a multiple join tool.

For the second point, in your render tool you can configure it so it groups the outputs based on the field of company, which will return a separate pdf output for each company in your dataset

example.yxmd

All comments

binay2448

Hope this will work for you..

invoice template.yxmd

AngelosPachis

Hey @chelseariver90

For the second point, in your render tool you can configure it so it groups the outputs based on the field of company, which will return a separate pdf output for each company in your dataset