RDLC how to make fields UPPERCASE in Dynamics 365 Business Central

-

Client's bank had a requirement to have the text on the check in all uppercase letters (CAPS). Here's how I accomplished this requirement. 

Within Microsoft Report Builder I opened the report. I then right clicked on the field and selected Expression. From there I added the following: 

=UCase(Cstr(Choose(101,Split(Cstr(ReportItems!FooterInfo.Value), Chr(177)))))






 ------

Kristen Hosman is a Microsoft MVP in Denver. She works with Dynamics 365 Business Central and related technologies. You can also connect with her through this link: Kristen Hosman | Linktree



Comments

Post a Comment

Popular posts from this blog

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

-
Image
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers.  Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for.  Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to.  Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
Read more

Send Remittance Advice in Microsoft Dynamics 365 Business Central

-
Image
The easiest way to send a remittance to a vendor is to open the vendor list and click on the vendor you'd like to send the remittance to.  With the vendor selected click on Actions > Functions > Send Remittance Advice.  You will then be welcomed with the Send Document to screen where you can decide how to process the remittance. In my case I want to email the remittance, so I make sure the Email is set to Yes.  Once I click OK, I am able to preview the email that will be sent. You can add emails for who it will be sent to, update the subject and message fields, and add any other attachments that should be sent.  Click send email when ready to send.  Written by: Kristen Hosman, Microsoft MVP
Read more

Dimension Corrections in Microsoft Dynamics 365 Business Central

-
Image
If you've ever coded something to the wrong dimension and noticed after posting don't just assume a journal entry is the only way to fix it. Microsoft has included a Dimension Corrections tool within Business Central and it's pretty easy to use. Let's walk through the process of updating a posted entries dimension where the user forgot to add the dimensions in this case. Same process would apply if you needed to change a posted dimension as well. Within the General Ledger Entries page, select the line for the entry that needs to be corrected, then click on Entry > Correct Dimensions.  Within the Draft Dimension Correction window go ahead and update the description if needed and mark Update Analyses Views if you're using those.  Next section Dimension Correction Changes go ahead and add the updates. In my case my entry is missing two dimensions so I'm going to add each of those in there. Since my dimensions were missing the Dimension Value Code field is blank,...
Read more