Hi again Jodi,I went through the process of validating a test ROE file generated from our Acumatica sales demo data against the schema provided on the Service Canada website and found a number of issues with the output. I can provide you with the original output file and a “fixed version” that now validates against the schema if you wish. The list of issues that I found from the validation process are as follows:The first issue is the ProductVersion attribute in the ROEHEADER is 11 characters (ie. ProductVersion="23.110.0025"), in the schema the field is limited to 10 characters. Element <B5> is the BusinessNumberType with a value of 839432893PR0001 - this violates the pattern constraint "[0-9]{9}[R][PW][0-9]{4}". The value should be 839432893RP0001. Element <B14> is the ExpectedRecallInfoType with an element named <DT> that is a NullableDate. The value in the file is a bunch of spaces followed by a carriage return which doesn't parse. The field needs to either be
Hi Jodi, Out of curiosity, have you tried changing the extension to BLK and then tried manually importing it (instructions are here: https://www.canada.ca/en/employment-social-development/programs/ei/ei-list/reports/payroll-extract.html#h2.2)? From what I was able to find, the ROE files are created using Service Canada's XML ROE Web specification (https://www.canada.ca/en/employment-social-development/programs/ei/ei-list/ei-roe/user-requirements/appendix-d.html), and is saved with a .BLK file extension before transmission. Acumatica will need to change the file extension in their code so that it saves the files as .BLK however running a test import yourself will allow you to verify that the output is valid.
Hi Doug, how do we get on the controlled release? We have at least two customers that are very eager to get on this.
Were you able to find a solution? I have a customer with a similar request.Thanks,Scott
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.