Hi
I have in general found the Word templates very easy to use in BC - as long as all the information you need is there.
I have struck a problem with the Reprint Remittance however. We are using Report 400. There is no built-in Word Layout, but there is a RDLC layout. I will build the remittance in this if there is no Word solution to the problem.
This is the detail section from the RDLC:
Essentially, it is grouping on first the payment document number, then of the Vendor Ledger Entry details. The first line of the Vendor Ledger Entry details relate to the invoices and then the second line to any applied credits - whether they were applied before payment or as part of the payment process. This is a sample of the output:
I want to create the same in the Word templates but I am unsure how to try and group the records together to do the same thing. I have tried:
- Two table lines and adding the repeating content control at VendLedgEntry2 level to both lines together (this gives no records)
- Using the Group function - both before and after using repeating content controls
- Two table lines with first line using repeating content control at VendLedgEntry2 and the second at Detailed_Vendor_Ledg_Entry level
- Nested repeating content controls (this gives no records)
The best result I can get is this:
And it only shows one of the credits.
Anyone know if this can be done in Word?
Cheers
Heather