51 Reply by trafficpest

(10 replies, posted in Items and Inventory)

I as well want the 'long_description' on the invoice but I can't find it in the tables? inventory/manage/items.php says its called 'long_decription' I tried to replace 

$rep->TextColLines($c++, $c, $myrow2['StockDescription'], -2);
to:
$rep->TextColLines($c++, $c, $myrow2['long_description'], -2);

in /reporting/rep107.php but I get a blank spot on the invoice so, when I checked the DB I couldn't find it in the item_codes table
Where is it held?  Am I totally wrong?

Go to forum: Items and Inventory

52 Reply by trafficpest

(8 replies, posted in Setup)

Just as a warning in the United States you can change your books from cash to accrual but not the other way around. I would be surprised if it's the only Country too.

Cash is accounted when you get the payment

Accrual when it is invoiced or billed

Example

$100000 sales in in 2017, 80000 paid 20000 in accounts receivable

Accrual based taxes on 100000 of income
Cash based taxes on 80000

Go to forum: Setup

53 Reply by trafficpest

(4 replies, posted in Setup)

@Braath Waate

HAHA not that fancy I'll go over it now.

1: Exported all clients from Quickbooks to a CSV file (option in the clients section)

2: Opened Front Acc. and entered the first client entry from the CSV Manually (Entered Customer, Branch and CRM Sections)

3: Opened the Database to look at the tables affected and the format (I used PhpMyAdmin on my server)

4: Exported each of the tables affected to CSV in PhpMyAdmin (0_debtors_master: 0_crm_persons:0_crm_contacts: 0_cust_branch:)

5: Copy and Paste the data from your QB Clients.CSV file into each of the exported FA DB CSV files in a spreadsheet editor (I used OpenOffice/Libre Office)

6: Import the DB CSV files on your server (You can use PHP commands i.e. LOAD DATA INFILE "/home/jason/clients.csv" but I used PhpMyAdmin as it has built-in CSV import.

Et Voila c'est fini, That is my fancy import process.

Go to forum: Setup

54 Reply by trafficpest

(4 replies, posted in Setup)

Ok I'm following up for anyone in the future importing clients. I finished importing about 1000 clients directly in the database and it worked beautifully. Everything I wrote above was correct just missing one thing. The 0_crm_contacts table connects 0_cust_branch to 0_crm_persons as well as the 0_debtors_master table so you should have twice  as many entries in 0_crm_contacts as you have clients (assuming your clients are 1 branch per client like how my data was.)

@Braath Waate Thank you for the suggestion of  QuickBooks2FA.zip I decided to stay working directly with the database because I was close to done already.

Go to forum: Setup

55 Topic by trafficpest

(4 replies, posted in Setup)

Ok as stated I'm importing our customers to the our new FA System running Version 2.4.1 Build 22.05.2017 just in case for database consistency. Ive been looking at the database and I believe I found all the tables needed. Let me know if i have missed anything.

0_debtors_master:  to import the clients and some basic settings
0_crm_persons: to import clients customer relations / contact info such as billing address telephone and such
0_crm_contacts: to connect the clients crm_persons table to their debtors_master id
0_cust_branch: for the clients branch info and accounts affected

Is there any other tables needed or affected when creating a client?
Also is there anyway to give the client a starting / opening balance to not have to transfer over and open invoices?

Thank You,
Jason

Go to forum: Setup

56 Reply by trafficpest

(5 replies, posted in Report Bugs here)

Okay just to follow up for anyone with this issue. The error above is from having PHP 5.2 and older. Updating solved the problem right away. In my case, I had a line in .htaccess that prevented my server from using the updated version. At this time, I'm using PHP Version 5.4.43 and it works perfectly.

Thank you again for your help.

Go to forum: Report Bugs here

57 Reply by trafficpest

(5 replies, posted in Report Bugs here)

Okay it's the Justhost server it's running PHP 5.2.17

what's weird is when I change it with the server tools or the PHP.ini it doesnt change I have to dig deeper later.

maybe the .htaccess? i'll see

Go to forum: Report Bugs here

58 Reply by trafficpest

(5 replies, posted in Report Bugs here)

Thanks guys your awesome. You got me on train to find the problem. So, FA is not generating the PDFs on the server in the previously stated PDF folder and when I turned on Debugging the error log give me 

PHP Parse error:  syntax error, unexpected T_FUNCTION in /home4/traffid0/public_html/books/reporting/includes/html_entity_decode_php4.php on line 338

I'm looking into it now

Thanks again and Happy New Year!

Go to forum: Report Bugs here

59 Topic by trafficpest

(5 replies, posted in Report Bugs here)

I can't print invoices or Display PDF reports on a new install on my Justhost server. My browser can display PDFs fine but my FA install shows me a progress bar then does nothing. Permissions write problem perhaps? Please help me if you can I have the example company DB and login @

http://trafficpestsolutions.com/books/

User: tester
Pass: tester

Go to forum: Report Bugs here