Skip to main content
Question

Import Scenario for Vendor T4A Configuration (Canada)

  • September 8, 2026
  • 2 replies
  • 40 views

I'm running into an issue with an Import Scenario built for the Vendors screen, specifically for updating T4A related fields (CRA Reporting Type, T4A Box, CRA Vendor Type, CRA Payroll Account Number/SIN) on existing vendors.

 

Here's the setup:

Data Provider: Excel Provider


Import Scenario mapped to the Vendors screen

 

On the Vendors screen itself, the conditional requirement works exactly as expected. Individual vendors ask for a SIN, Corporation and Partnership vendors ask for a CRA Payroll Account Number. No errors when entering manually.

 

But when I run these through the Import Scenario, I get two consistent problems:

  • Individual vendor type always fail with "CRA Payroll Account Number cannot be empty," even though SIN is the field that should actually be required for that vendor type. It behaves as if the import is checking CRA Payroll Account Number regardless of CRA Vendor Type.
  • Partnership vendor type import without any error at all, but when I open the vendor record afterward, CRA Vendor Type has silently saved as Corporation instead of Partnership. 

 

 

 

I've already tried several workarounds, including IIF formulas, but the issues still persist.

 

Has anyone else run into this kind of conditional-required field behavior breaking specifically through Import Scenario, but working fine on the actual screen when entered manually?

 

Any insight would be appreciated, trying to figure out if this is a config issue on my end or something that needs to go to support as a bug.

 

Thanks!

2 replies

mohammadnawaz51
Varsity I
Forum|alt.badge.img+7

@Zia It seems to be your updating the vendor information, in that case below mapping is not needed.

 


  • Author
  • September 10, 2026

Quick update on the issue I posted about earlier with importing T4A fields on the Vendors screen through an Import Scenario.

On Partnership, that one's fixed, turned out checking Commit on the CRA Reporting Type mapping row solved it.

Individual vendors are still failing though. I even built a separate scenario just for Individual vendor type and took CRA Payroll Account Number completely out of the mapping, leaving only CRA Reporting Type, T4A Box, CRA Vendor Type, and SIN. Still get this error:

'T4AProgramNumber' cannot be empty.

That's the underlying field behind CRA Payroll Account Number.