You’re offline. This is a read only version of the page.
Collection Management Letter Maintenance (Cards --> Sales --> Collection Letters)
Below is the modified Microsoft Word Document (Query Letter format we use to generate the letter) consisting of fields added from Add-Ins.
Refer to below screenshots and examples of query letter output that have issues with the alignment field.
I have added OverdueInvoicesDetail field in the word document. (From ADD-INS --> INVOICE)
Example of how I pull the field to word document:
Output of letter generated from Dynamics GP – Query Letters (Transaction --> Sales --> Query Letters)
Example 1:
Example 2:
Discussion
As we can see from the output, the alignment of the field data are all positioned center, which eventually look untidy if all the amounts have different number of digits.
It is impossible for me to adjust the alignment, so I would like to know if anyone encountered this issue before and is there a way to overcome this alignment issue?
*This post is locked for comments
I have the same question (0)
Use the Pad Length to insert some spaces to the left, should result in better spacing.
An integer indicating the length of the field. Spaces will be added to the left of the returned amount until the length equals the number you enter.
An integer indicating the currency:
| Function Description Syntax Sample |
| All Invoices | Returns all of the outstanding invoices. | AllInvoices, Pad Length, Currency |
@%AllInvoices,10,1%@ |
| All Invoices Detail | Returns all outstanding invoices with the current amount and due date. | AllInvoicesDetail, Pad Length, Currency |
@%AllInvoicesDetail,10,1%@ |
| All Invoices Total | Returns the total of all outstanding invoices. | AllInvoiceTotal |
@%AllInvoicesTotal%@ |
| All Invoices in Aging Period | Returns all outstanding invoices from an aging bucket, specified by a parameter with a default of Current. | AllInvoicesInAgingPeriod, PeriodNumber |
@%AllInvoicesInAgingPeriod,1%@ |
| All Invoices in Aging Period Detail | Returns all outstanding invoices, with the current amount and due date, from an aging bucket specified by a parameter with a default of Current. | AllInvoicesInAgingPeriodDetail, PeriodNumber |
@%AllInvoicesInAgingPeriodDetail, PeriodNumber,1%@ |
| All Invoices Not Disputed | Returns all invoices that are not assigned to a note of the Dispute action type. | AllInvoicesNotDisputed, Pad Length, Currency |
@%AllInvoicesNotDisputed,10,1%@ |
| All Invoices Not Disputed Detail | Returns all non-disputed invoices for a customer, with the current amount and due date for each transaction. | AllInvoicesNotDisputedDetail, Pad Length, Currency |
@%AllInvoicesNotDisputedDetail,10,1%@ |
| All Invoices Not Disputed Total | Returns the total of all outstanding invoices that are not disputed. | AllInvoicesNotDisputedTotal |
@%AllInvoicesNotDisputedTotal%@ |
| Overdue Invoices | Returns all overdue invoices. | OverdueInvoices, Pad Length, Currency |
@%OverdueInvoices,10,1%@ |
Share
Report
All responses (
Answers (
2
