Skip to main content

Adding line items on an invoice

  • July 28, 2023
  • 1 reply
  • 52 views

Forum|alt.badge.img+6
  • Known Participant

I am working on an invoice in the Page Designer extension and having trouble adding multiple line items. Company A has multiple line items in by Base. The unique identifier is the Company Name "Company A". In Quarter 1, 2023, Company A used 3 different hotels, and has 3 different revenues. I'd like to list on the invoice each of the hotels and their coordinating revenues.

Company A, Hotel A, Cost A

Company A, Hotel B, Cost B

Company A, Hotel C, Cost C

I'd like to add all of these to my invoice, but right now, only the 1st line is pulling into the invoice.

Help! And thank you!

 

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

You should be able to do this with three tables:
1. Companies
2. Invoices
3. Line Items



Link to base