Dynamics Community Forum Thread Details

Collection Management Letters (Output of Add-Ins field alignment issue)

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)

0576.aa.PNG

Example of how I pull the field to word document:

3718.b.png

Output of letter generated from Dynamics GP – Query Letters (Transaction --> Sales --> Query Letters)

Example 1:

2313.c.png

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?

Use the Pad Length to insert some spaces to the left, should result in better spacing.

Pad Length

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.

Currency

An integer indicating the currency:

0: Functional currency
1: Originating currency

Functions/Descriptions

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%@`

Quick Links