Multiple payment receipt lines on invoice

For ideas, tips and tricks and comments on using or creating MoneyWorks Forms (invoices, statements, labels etc.),
Forum rules
This forum is not the official Cognito Software support channel for MoneyWorks. If you need help from Cognito, then please contact us (or your local regional support representative) directly using the contact information on the Support page of the web site.

Please try the search facility before posting a new topic to see if your topic has already been covered.

If you do post a new topic, it's a good idea to choose a Topic Subject that it a bit more informative than "Help!" or "A problem". If your topic is actually recognisable by people scanning the forum, you'll have a much better chance of getting a response. Thanks and have fun.
Post Reply
Dee Jay
Posts: 2
Joined: 21 May 2013 15:05
Product: Express
Region: Australia

Multiple payment receipt lines on invoice

Post by Dee Jay » 21 May 2013 20:57

I am new to MoneyWorks express.
I am trying to code my invoice to show multiple payment receipt lines against a single invoice

Format required:-

Payment Date/Receipt#/Amount Paid/GST on Payment
10/2/13 / 002 / $380 / $38
20/4/13 / 004 / $200 / $20

With the help of the community I have been able to workout a code for the "Receipt #"
Unfortunately this code only displays a single receipt which is repeated down to the rest of the lines

Find ("transaction.ourref", `[Transaction:SequenceNumber = ` +SequenceNumber+`][Payments.InvoiceID][Payments.CashTrans][Transaction] `)

Appreciate if someone out there could help me on this :roll:

User avatar
Posts: 52
Joined: 06 Sep 2011 05:24
Product: Gold
Region: Canada
Location: Mississauga, Ontario

Re: Multiple payment receipt lines on invoice

Post by nasupport » 15 Jun 2013 06:08

Create a Payments type List with this Search function

Code: Select all


Date Paid column calc is :

Code: Select all


Receipt Number Column is:

Code: Select all


Amt. Paid is:

Code: Select all


Your inclusive AUS GST column:

Code: Select all

Payments.Amount / 110 * 10


Post Reply