Has anyone successfully imported a txt file (eg. Payroll) with job site allocations included in the txt file format?
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
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
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.
*Community Hub is the new name for Sage City