Incorrect file version

I have created a file for import into Sage 50 2023.0 Canadian edition that looks like this:

<Version>
"12001","1"
</Version>
<SalInvoice>
...Details
</SalInvoice>

When I try to import it though we get the error that it is an incorrect file version.  Everything I can find says the 12001 should work... what am I doing wrong??

Parents
  • 0

    You have not indicated your method of import so maybe this thread can help you out.

  • 0 in reply to Richard S. Ridings

    We are just trying to import from the File >> Import menu option.

  • 0 in reply to HydraPS

    I just tested a file in 2023.0 using that method and I have used 12001 since about 2005.  I can't see any problems with the version you are using specifically.

    The only differences in my file is that I have a blank line between end version and start invoice and a space before the country code.  I can't remember if that causes a problem because I have used the same structure for so many years and haven't tested scenarios since.

    <Version>
    "12001", "1"
    </Version>


    <SalInvoice>
    ...Details
    </SalInvoice>

  • 0 in reply to Richard S. Ridings

    Thanks Richard.  I am starting to think it is something else now that I am looking closer.  Earlier I was walking someone through it but now I see that we don't even have the option to import invoices under file >> import.  when I click on import transactions I get a message saying I need edit access to the desired module.

    When I click next it just tells me it detected errors.  we don't even get to the file portion.. sigh..

  • 0 in reply to HydraPS

    I am confused.  How did you get to an error message initially that indicated the version was wrong when you can't get to the point where you can select the import file?

    If the security of the username is limiting your import, you need to give the task to a user that is allowed to create invoices using the normal sales module in the program.

    Otherwise you are going to have to explain exactly what you are doing, what version of the program you are using (you did this but I included it for others reading), what the user security is (an image of the security setup will help) and exactly what the error message is ("detected errors" doesn't help us help you).  It also wouldn't hurt to see the import file if the error message indicates a line in the import file.  You can replace confidential info with fake stuff if you wish (eg customer names, item codes).

  • 0 in reply to Richard S. Ridings

    Thanks for the help Richard!  It was a permissions issue which I managed to figure out.  Now I have a different problem and I am not sure if this is the right place to put it or if I should start a new question...

    When the import gets to the accounts it can't find them.. the situation we have is like this:

    The company I work for has three stations.  These stations are set up as departments within sage.  So their revenue account would be 1000 and each department would be linked (1000-0100 for station 1, etc) I have in my file the account as 1000-0100 and it wont find it.  Any ideas?

  • 0 in reply to HydraPS

    I'm going to pretend that your example of account 1000 for a revenue is just a bad choice and you really meant something like 4100-0100.  Most people will assume that is not possible in this program.

    However, the import utility does not allow direct allocation to a department.  You are getting to the choice of Item vs. Account because the item code you are using is not in your file.

    So create an item code for the specific revenue and link it's revenue account to the specific department you want and then use that item code in your import file in the first line item field.  Use a different item code for a different department.

Reply
  • 0 in reply to HydraPS

    I'm going to pretend that your example of account 1000 for a revenue is just a bad choice and you really meant something like 4100-0100.  Most people will assume that is not possible in this program.

    However, the import utility does not allow direct allocation to a department.  You are getting to the choice of Item vs. Account because the item code you are using is not in your file.

    So create an item code for the specific revenue and link it's revenue account to the specific department you want and then use that item code in your import file in the first line item field.  Use a different item code for a different department.

Children
No Data