Hi, both IDs are already in the system, so this is really just a layout job, not a data one. Your own tax ID sits in Company Information, and the customer's tax ID is on the Customer card, the VAT Registration No. or the RFC field if you have the Mexican localization on. So the values exist, you just need them showing on the invoice report.
For one customer the cleanest way is a custom sales invoice layout that adds those two fields, then assign that layout only where you need it. From what I seen, easiest is copy the standard sales invoice report layout, add the company tax ID and the customer tax ID textboxes, and either set it as the document layout on that one customer through Document Layouts on the customer card, so only he gets it, or make it the general one if you do not mind everyone seeing it. The per customer Document Layouts is nice here because it is the single customer asking.
If you are on cloud a Word layout is the simpler edit for just dropping two fields in, RDLC is more fiddly.
Are you on the Mexican localization, because then the RFC fields are the right ones to pull, not the generic VAT Reg No.? And do you want it on posted invoices only or also the order confirmation? That decides which report you copy.
Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis