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

    GJ thanks for the reply.   I am having some difficulty interpreting the lines of code in your response.  For example, in line 2, what does 50100 represent, GL number?   Also "This is the first project" ?

    In line 3 is "Basement Renovation" the project?

    What version of Sage do you run?  I have Sage 50 Premium and they are restricted to four digit G/L #'s.

    Thanks so much for your help,

    JBEEZ

Reply
  • 0

    GJ thanks for the reply.   I am having some difficulty interpreting the lines of code in your response.  For example, in line 2, what does 50100 represent, GL number?   Also "This is the first project" ?

    In line 3 is "Basement Renovation" the project?

    What version of Sage do you run?  I have Sage 50 Premium and they are restricted to four digit G/L #'s.

    Thanks so much for your help,

    JBEEZ

Children
  • 0 in reply to JBEEZ

    It will make more sense if you open the sample comapny that these entries were modelled on.  Yes Basement Renovation is a Project name and you can extend account numbers to 8 digits in Premium and higher but I can't remember if the Premium sample file uses 5 digits or not.  If not, then just modify then entry GWG used and reduce the account number to 4 digits by removing the last zero.  eg. 50100 is 5010 and 40200 is 4020.

    This entry works in pretty much any version after 2006 or 2007.  I can't remember when projects were added to the journal entry import.