It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by alvin
Strange. Your demo at almacennaval seems behave as it should.
OK, got them scripts updated, but I put them in a subdomain, fatest.almacennaval.com, keeps my folder structure cleaner.
However this small problem does not occur on fatest.almacennaval.com, It occurs on fatest.aljo2.com, scripts are the same, only database is diff,
When you get time, let me know?
AM
OK, Janusz
I went to the test folder of almacennaval, and got a blank page, (whatever), So...
I put the updated scripts in a subdomain for both systems that I use, fatest.aljo2.com, and fatest.almacennaval.com, Using phpmyadmin I added your user name and password to fatest.aljo2.com, should work?
Here is the funny part, scripts are the same, only database is diff,
This small problem occurs on fatest.aljo2.com, but not on fatest.almacennaval.com
When you get time, it is not that big of a deal?
AM
This happens at > Banking and General Ledger > Bank Account Payment Entry, I went to your demo site and tried it with the name Mount's in the memo field, got this error (below), I will get my test system updated so you can see, more later,
AM
DATABASE ERROR : The GL transaction could not be inserted
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's')' at line 3
sql that failed was : INSERT INTO 0_gl_trans ( type, type_no, tran_date, account, dimension_id, dimension2_id, memo_, amount, person_type_id, person_id) VALUES (1, 26, '2008/09/09', '1705', 0, 0, '', -25, 0, 'mount's')
Good point, I have not upgraded the scripts on the test folder, I will get that done tomorrow, more later.
AM
Thanks Joe, I will try some of this, but no big deal, as the months go by they will be gone.
You have done a great job, My hat's off to the dev team!
Alvin
Is Javascript disabled?
/Joe
No
I think critical is voided, It does not show on P&L now. I will know more later.
However when canceling sales order I get the error:
This order cannot be cancelled because some of it has already been invoiced or dispatched. However, the line item quantities may be modified.
?
AM
No, when I input the account code, and not change the Account Description, it will default to what ever is in Account Description.
AM
After voiding sales order, sales invoice, and delivery note, I go back to search all sales orders, and they are still there.
?
I have no templates
AM
I have all search list checked in company setup, but in bank account payment entry, account code, the search does not function.
?
AM
When I enter a name with an apostrophe (') like Lowe's in the memo field, it comes back as Lowe\'s
Not a big deal, but...
AM
How come them little blue (select) check marks came back?
Do I need to use them if I make a change in the box were they are?
AM
Hello Team
During testing and a bug fix, I have racked up some sales transactions that the system will not let me delete.
I may need to go in with phpMyAdmin and remove theses.
Please let me know how would be the best way to do this?
Thanks
AM
check your file config_db.php
make sure your database information there is correct, I have had this problem lots of times working with these scripts, it is not hard to fix.
AM
I don't know what to look for? I looked at the function, I did a text diff, on the file I am using, with the latest export I have from cvs, there is no diff.
Please let me know.
AM
Ya Joe, I think account setup is fine, the transaction below won't show in Bank Account Inquiry, It should show a 152 credit to the bank account
http://www3.speedyshare.com/data/886197433/12573368/65136494/001.jpg
When I enter transaction using payments, the transactions are viewed in Bank Account Inquiry, But when I enter transaction in Journal Entry, that effect bank accounts, these transactions are not visible in Bank Account Inquiry. I must go to GL Account Inquiry to see them.
Bank Account Inquiry should show all transactions to that account, no?
Theses Journal Entry transaction are posted to more then two GL Accounts.
AM
Try clearing cookies, and re login, maybe re start broswer.
This has help me with stuff like this
I get a blank popup browser window with blank page, only an address bar, no links, no nothing?
Thanks for your reply
The install went fine, but I see no way to edit pages. On pmwiki you get an edit button at the top of the help page.
I would like to edit pages for in house use?
AM
How can I install the wiki so that I can edit pages for in house use
roger wrote:
What are your estimates on developing a reasonable POS module?
I may be willing to share some of the costs if I can participate in the design of the same.
Regards, Roger
Alvin Martin wrote:
Hello Roger
Sorry I am late with my mail.
I will do some work on this, this week. Have you downloaded openbravoPOS yet, it will run standalone, let me know what you think about it, we will go from there. Joe has some java experience, we may be able to get him to look at it for us, but will no doubt need to hire a java developer...
More later
AM
Hello RK
RK wrote:
> Hi Alvin,
> This system look pretty good. What is your idea on the integration?
It needs to be changed to work with FA
> Would it operate online against the Frontaccounting database over the net
The pos program, the module, will run on the client.
> or would it operate more in a store and forward mode?
It would operate in real time, it would work like your browser does for other transactions, you will need to be online.
> If in store and foreward mode I would expect products, stocks etc. are >updated from Freebooks and no changes should be made on the POS end?
Everything is done server side, there is no need for update, or to save anything client side.
>
> My doubt is in that I would preferre not to have any piece of SW installed on
> the client PC.
I do not think we can get by without running a small program for pos, Java seems to be the best, it will be needed to run things like bar code scanners, receipt printers, scales, pole displays, cash drawers, etc.
> The idea I have is to have soe similar functionality but in PHP running on the > Frontaccount server.
I do not think php will drive those pos prifeals.
> One big missing item is the possibility to recieve payments in multiple
> currencies (E.g. tourists).
I see, I will also need this feature, if it is something that the folks over at openbravo will also need, then we get them to do it for us. I will look more at it later.
>
> Regards
>
> Roger
Regards, Alvin
OK, got that one figured out, by accident,
The problem is in that php.ini file above, you see at one time I had a script that required I have access to my php.ini file on my hosted, so what they do is move it to your cgi folder so you have access to it. When I discovered that my scripts worked fine under another domain on the same server I started to look a little closer, I renamed my php.ini file that is in my cgi folder and all is fine at least for fa, I will look more at is later, but if anyone sees anything in that file above let me know? But no big deal. If I use the script that needs that php.ini file I will just put it in a sub domain.
Thanks for all the help.
AM
Hello All
I currently use authorize.net for my payment gateway, I will want an integration one day, they supply all the code to do it, Here is a link to their Integration Center
http://developer.authorize.net/ I will be looking more at this later.
AM
Janusz
I looked over the php.ini and did a text diff with the php.ini on my local, everything seems normal to me. Take a quick look and and see if you can spot something:
[PHP]
engine = 1
zend.ze1_compatibility_mode =
short_open_tag = 1
asp_tags =
precision = 14
y2k_compliance = 1
output_buffering = 4096
zlib.output_compression =
implicit_flush =
unserialize_callback_func =
serialize_precision = 100
allow_call_time_pass_reference =
safe_mode =
safe_mode_gid = 1
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions =
disable_classes =
highlight.string = #DD0000
highlight.comment = #FF9900
highlight.keyword = #007700
highlight.bg = #FFFFFF
highlight.default = #0000BB
highlight.html = #000000
expose_php = 1
max_execution_time = 600
max_input_time = 600
memory_limit = 64M
error_reporting = 6135
display_errors =
display_startup_errors =
log_errors = 1
log_errors_max_len = 1024
ignore_repeated_errors =
ignore_repeated_source =
report_memleaks = 1
track_errors =
html_errors =
error_log = /hsphere/local/var/httpd/logs/php_error.log
variables_order = GPCS
register_globals = off
register_long_arrays = 1
register_argc_argv = 1
post_max_size = 16M
magic_quotes_gpc = off
magic_quotes_runtime = off
magic_quotes_sybase =
auto_prepend_file =
auto_append_file =
default_mimetype = text/html
always_populate_raw_post_data = 1
;***** Added by go-pear
include_path=".:/hsphere/shared/php5/share/pear:/hsphere/shared/apache/libexec/php5ext/php/"
;*****
doc_root =
user_dir =
extension_dir = /hsphere/shared/apache/libexec/php5ext/
cgi.fix_pathinfo = 1
file_uploads = 1
upload_tmp_dir =
upload_max_filesize = 16M
allow_url_fopen = 1
default_socket_timeout = 60
auto_detect_line_endings = 1
[Syslog]
define_syslog_variables =
[mail function]
sendmail_path = /usr/sbin/sendmail -t -i
mail.force_extra_parameters =
[SQL]
sql.safe_mode =
[ODBC]
odbc.allow_persistent =
odbc.check_persistent = 1
odbc.max_persistent = -1
odbc.max_links = -1
odbc.defaultlrl = 4096
odbc.defaultbinmode = 1
[MySQL]
mysql.allow_persistent =
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port = 3306
mysql.default_socket = /var/lib/mysql/mysql.sock
mysql.default_host = localhost
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode =
[PostgresSQL]
pgsql.allow_persistent =
pgsql.auto_reset_persistent =
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[dbx]
dbx.colnames_case = lowercase
[bcmath]
bcmath.scale = 0
[Session]
session.save_handler = files
session.use_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 10
session.gc_maxlifetime = 1440
session.bug_compat_42 = 0
session.bug_compat_warn = 1
session.referer_check =
session.entropy_length = 0
session.entropy_file =
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = off
session.hash_function = 0
session.hash_bits_per_character = 5
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
[Assertion]
assert.active = 1
assert.warning = 1
assert.bail =
assert.callback =
assert.quiet_eval = 0
[Sockets]
sockets.use_system_read = 1
[mbstring]
mbstring.language = Japanese
mbstring.internal_encoding = EUC-JP
mbstring.http_input = auto
mbstring.http_output = SJIS
mbstring.encoding_translation =
mbstring.detect_order = auto
mbstring.substitute_character =
mbstring.func_overload = 7
[exif]
exif.encode_unicode = ISO-8859-15
exif.decode_unicode_motorola = UCS-2BE
exif.decode_unicode_intel = UCS-2LE
exif.encode_jis =
exif.decode_jis_motorola = JIS
exif.decode_jis_intel = JIS
[soap]
soap.wsdl_cache_enabled = 1
soap.wsdl_cache_dir = /tmp
soap.wsdl_cache_ttl = 86400
[Zend]
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.3.0
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.0
zend_optimizer.version=3.3.0a
zend_extension=/usr/local/Zend/lib/ZendExtensionManager.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so
FrontAccounting forum → Posts by alvin
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.