1 Reply by sbt507

(12 replies, posted in Reporting)

Based on your instructions....the key was at db changes of tax types. Thanks alot.

However, and perhaps the most important request of all, will be to sync sales_order_entry and FORM setup with pdf files.

Here are snapshots of FA and DB for your review.

FA Form setup parameters .... [img]http://screenshot.net/vqmy2ce.jpg[/img]

FA Sales order Entry ...... [img]http://screenshot.net/vvnp9ap.jpg[/img]

FA Sales Order View ...... [img]http://screenshot.net/ve09xf9.jpg[/img]

DB Sales Order Table...... [img]http://screenshot.net/v5nzkhk.jpg[/img]

DB Ref Table ................ [img]http://screenshot.net/vzx3ju5.jpg[/img]

PDF Sales Quote file...... [img]http://screenshot.net/5e6zot1.jpg[/img]

My analysis is that Form Setup is drawing values from reference field. The values that prevail on all PDF reports and files are linked to, or in sync with, the order_id field. MY intentions are to change default order_id values to start at 100+. 

Is there a fix for the above ?

Finally, we want to thank you for such a fine job you guys are doing in making this project possible.

Go to forum: Reporting

2 Reply by sbt507

(12 replies, posted in Reporting)

See my problems within the below image......please, advise on fix.

[img]http://screenshot.net/5e6zot1.jpg[/img]

FYI, i have already done some changes myself, but there is some additional info I just don´t seem to figure out.

Would imagen that sames changes done to pdf reports will reflect on image below by default.......

[img]http://screenshot.net/5rl25ip.jpg[/img]

Thank you in advanced.

Go to forum: Reporting

3 Reply by sbt507

(6 replies, posted in Setup)

is this where if I will find the answer to my questions described on image below ? If so, where exactly ( lines ) do I go to change such info ?

[img]http://screenshot.net/516edb5.jpg[/img]

Go to forum: Setup

4 Reply by sbt507

(10 replies, posted in Report Bugs here)

apmuthu......in regards to your COA question....I´m using the ones checked here on this image.....

http://screenshot.net/37qnktm......[img]http://screenshot.net/37qnktm.jpg[/img]


Let me know if it´s ok.

Thanks for collaboration.

Go to forum: Report Bugs here

5 Reply by sbt507

(10 replies, posted in Report Bugs here)

My bad guys...sorry for disturbing your peace.....I guess I made a beginner´s mistake in changing the db field name from gst_no to ruc_no. I figured if php script was calling at ruc_no, then field name at db should have been named accordingly, but I guess a translation does not necessarily means the script core will change its path to the db.....Am I reasoning correctly ?

FYI, and based on my assumption, I went ahead and reversed the above changes on the db to its original " gst_no " ....and voila...it worked.

Go to forum: Report Bugs here

6 Reply by sbt507

(4 replies, posted in Accounts Receivable)

well do....will look into it.

thanks apmuthu.

Go to forum: Accounts Receivable

7 Reply by sbt507

(10 replies, posted in Report Bugs here)

db image & bd structure.....see here [img]http://s4.postimg.org/bt345zkft/2015_11_13_2.png[/img]

[img]http://s4.postimg.org/iktj8u9fd/2015_11_13_3.png[/img]

it seems as if script can´t communicate with db....that´s my impression.....FYI....I´m just an empirical fellow....so please, share your expert knowledge....it´ll be greatly appreciated.

Perhaps, you might want to check my supplier.php file here.....suppliers.php

Go to forum: Report Bugs here

8 Reply by sbt507

(10 replies, posted in Report Bugs here)

HostGator / shared hosting
Program Versions / Program Version / Apache: 2.2.29 / CentOS: CentOS release 6.7 (Final) / cPanel: 11.48.4 (build 7)
Curl: 7.12.1 / MySQL 5.5.42-37.1 / phpMyAdmin 4.3.8 / Python: 2.6.6 / Program Version Perl: 5.8.8 / PHP: 5.4.43
ionCube Loader: 4.7.4 / Zend Optimizer:   / Ruby: 1.8.7 / Rails: 2.3.18 / OpenSSL: 1.0.1e-fips

Web Browser: Google Chrome / Ver. 46.0.2490.86 m

Hope we have provided you with the requested info.

For snapshot provided....I guess we need to upload zip and decompress in order to replace currrent FA folder....right ?

Go to forum: Report Bugs here

9 Reply by sbt507

(10 replies, posted in Report Bugs here)

Using ver. 2.3.24 and can´t add suppliers.

I´m about to go blind and insane. Looked all over and can´t find any info on it that will correct the problem....plzzzz....HELP.

Go to forum: Report Bugs here

10 Reply by sbt507

(12 replies, posted in Reporting)

All I need is to change footer text, change the word VAT to ITBM and other minor wording changes within the invoice pdf output format .....found this for the footer..... var $footerText;  // store user-generated footer text...... on line 62 of pdf_report.inc, but don´t know what to do with it.....please, advise.

Go to forum: Reporting

11 Reply by sbt507

(4 replies, posted in Accounts Receivable)

I´m trying to include VAT / ITBM taxes on my invoices, but even though I configured it according to FA wiki, nothing shows, nor totals get calculated accordingly.

Please, somebody HELP Asap.

Thanks in advanced.

Go to forum: Accounts Receivable