Importing txt files with job sites

Has anyone successfully imported a txt file (eg. Payroll) with job site allocations included in the txt file format?

Parents
  • 0

    How do I access the sample data?

    Look at my txt file.  

    10-11-14,PayrollTEST

    5420,500.00,"this is the first project",2

    "AB1208-02",250.00

    "AB1400",200.00

    5430,150.00,

    5463,600.00,

    5464,3060.00,

    1060,-4010.00,

    2180,2000.00,

    2180,-2000.00,

    2185,1000.00,

    2185,-1000.00,

    2190,500.00,

    2190,-500.00,

    2210,-300.00,

    5420 is the expense account in which I am trying to allocate costs amongst two job sites, ab1208-01 and ab1400

    I am getting the following error upon export.

    Import started...

    Reading transactions...

    Reading transaction PayrollTEST.

    Import Error:  The total percentage of all Job Site allocation lines cannot exceed 100% or be less than 0% in line 2.

    Not sure why it is giving me this error.....

    Thoughts?

  • 0 in reply to JBEEZ

    JBEEZ said:
    How do I access the sample data?

    Open the program and on the open company dialog select the sample company as in the image below.  If you don't see this dialog, open your company file and then select View, Select Company Window At Startup.  Then reopen the program.  Or you can search for the file universl.sai on your system and find it deep under c:\users\public.... and open it from there.

     

    JBEEZ said:
    "AB1208-02",250.00

    "AB1400",200.00

    Import Error:  The total percentage of all Job Site allocation lines cannot exceed 100% or be less than 0% in line 2.

    I suppose it might be too obvious but both 250 and 200 are larger than 100.  As GwG stated, it allocates by percentage and percentage only.

  • 0 in reply to Richard S. Ridings

    Richard:

    Thanks for your help.   I didn't realize it allocates by % so that solved the problem. When I put the %'s in it worked slick.

    Thanks again,

    John

Reply Children
No Data