Q: 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
In this example the Rose company purchased $932 of widgets on Invoice 33333, and then made two payments ($100 & $200) on the invoice that were recorded as receipts shown below.
And when we print the inv. we get the details as shown in the Red Square listing the date of the receipts, the receipt nos., the amt. of the receipts, plus in this case a calculation for tax for the Australian that wanted this calc.
Create a Payments type List with 4 columns and this Search function (Edit > Forms Designer > List Options)
Date Paid column calc is :
Receipt Number Column is:
Amt. Paid Column is:
Your inclusive AUS GST column:
Payments.Amount / 110 * 10
As posted on the Cognito Community Forum.