I have been trying to add the QST Registration No. field to an invoice report using the XML Mappings available in Word when a report is exported.
I notice that there is a CompanyVATRegistrationNo field that displays the GST/HST Registration No. but there does not seem to be an equivalent QST Label and No field.
Is it under another name perhaps or is it non existant?
Am I able to add the field using the RDL Format?
Any help would be greatly appreciated.
It can be done through Report Extension AL code
Share
Report
All responses (
Answers (
75
reportextension 50100 QuoteReportExt extends "Standard Sales - Quote"
{
dataset
{
add(Header)
{
column("ext_CompanyQST"; myCompanyInfo."QST Registration No.") { }
}
}
trigger OnPreReport()
begin
myCompanyInfo.Get()
end;
var
myCompanyInfo: Record "Company Information";
}
Hello,
I checked the report using SQL Report Builder and the RDLC format and the QST Registration No is also not available there to be added to the report, it's not included in the DataSet for the report. I'm not seeing a way we can get it added to the Sales Invoice.
If this is a requirement please let me know or consider entering a product suggestion to have this field added to the DataSet, you can enter a suggestion here:
ideas.dynamics.com/.../dynamics-financials
Regards,
Jennifer Reinhardt
Please see our Dynamics 365 Financials Support Team Blog for helpful information:
Hello,
My apologies, I misread...it appears you are looking for the actual QST Registration No from the Company Information window. I will look into this further and post my findings.
Sorry about that! Stay tuned....
Jennifer Reinhardt
Hello,
The application code should take care of this and QST should automatically print for Quebec Customers. Try the following in a test company using the canned reports to make sure they work properly:
1. In the Report Selection Layout window search for Invoice and locate Draft Invoice 1303, make sure the Selected Layout is Customer Layout and Sales Invoice - Blue is selected for the Custom Layout Description, like the following:
2. Open the Report Selections -Sales and make sure it's setup like this with the Sales Invoice – Blue for your Draft Invoice:
3. Print your Draft Invoice for a Customer in Quebec. If I have a Customer in Quebec with the Tax Area Code of QC I see the following on my Draft Invoice (disregard the City as I didn’t change that on my Customer):
Regards,
Jennifer Reinhardt
Please see our Dynamics 365 Financials Support Team Blog for helpful information:
https://blogs.msdn.microsoft.com/dyn365finsupport/
