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
Janusz,
The error: (MySQL returned an empty result set (i.e. zero rows)) is coming from statement (AND 0_locations.loc_code = 0_sales_orders.from_stk_loc) in looking at the tables, even thou enters are being made in 0_sales_orders, there are no enters in column (from_stk_loc)
What you think?
Alvin
The currency is not noted at ECB, the rate has been set manually, the system should check to see if a rate is set and current before giving the warning?
In Purchases > Purchase Order Entry, when I select a Supplier, all Items in the system show, Items are not filtered by Supplier?
In Direct Sales Invoice, after adding an Item, I get this sql error when I hit Place Invoice, What do you think I did wrong here?
DATABASE ERROR : FATAL : sales order return nothing - 0
sql that failed was : SELECT 0_sales_orders.*, 0_debtors_master.name, 0_debtors_master.curr_code, 0_locations.location_name, 0_debtors_master.payment_terms, 0_debtors_master.discount, 0_sales_types.sales_type, 0_sales_types.id AS sales_type_id, 0_sales_types.tax_included, 0_shippers.shipper_name, 0_tax_groups.name AS tax_group_name , 0_tax_groups.id AS tax_group_id FROM 0_sales_orders, 0_debtors_master, 0_sales_types, 0_tax_groups, 0_cust_branch, 0_locations, 0_shippers WHERE 0_sales_orders.order_type=0_sales_types.id AND 0_cust_branch.branch_code = 0_sales_orders.branch_code AND 0_cust_branch.tax_group_id = 0_tax_groups.id AND 0_sales_orders.debtor_no = 0_debtors_master.debtor_no AND 0_locations.loc_code = 0_sales_orders.from_stk_loc AND 0_shippers.shipper_id = 0_sales_orders.ship_via AND 0_sales_orders.order_no = 3
How is the best way to turn off this warning: Cannot retrieve currency rate from ECB page. Please set the rate manually.
Just a quick question..
When you update main CVS, is unstable also updated?
using 2.2 in Items and Inventory > Items Adjustments Note > Adjustment Items, when Item code is selected the Unit Cost remains blank, you must go and look it up and enter it manually.
I also have a rather annoying problem, using windows, and Firefox, on my local, I quite often alt tab between windows... when I get back to fa most of my keys on my key broad will not work to enter more data in the boxes, I must reload the page to make it work again, most of the time this is fine, but here in Adjustment Items if I have any Items Added but before I process Adjustments I lose everything and must start over. I don't know if this problem happens on hosted yet.
Alvin
Fixes for both issues in main CVS.
Thanks again.
I will look for fixes in unstable in a few days... Thanks
Hello,
I guess you mean 2.1. The bugs are here too. Fixed bugs in 2.1 will later be merged into 2.2.
I will fix this. Wait a while for CVS Main update. File /inventory/manage/items.php/Joe
No I am using 2.2 unstable, But thanks Joe
Alvin
Hey Janusz I got another for you...
In 2.2 Items and Inventory > Items, when I enter a new Item and pick an image file, it loads to a blank item, I must go back and select the Item again reselect the image and update.
Here is another... When my Item Code has a / in it, I can not load an image.
Is there a way to set a Default Order Quantity for an Item? So when you go to Purchase Order Entry for a supplier the preset order quantity would show in the Order Items.
If a supplier gives you a better price each when you buy 6 instead of 1, you may have set your purchase price at the price of each at the buy 6 price. When someone in purchasing that doesn't know this they may only buy 4 and the price would be higher, and your po wrong.
Would be handy after Insert New Item, you would get the boxes to enter Supplier Purchasing Data, Reorder Levels, and Item Sales Prices, all in the next window?
In 2.2 After entering Item code, Name, and Description, then I change Category from components to Stock, then I loose the name and description, I have to re enter
That did it, thanks
Just a small error at start up before login (Warning: The first parameter of bindtextdomain must not be empty in C:\xampp\htdocs\fa2.2.almacennaval.com\includes\lang\gettext.php on line 273)
I updated from cvs, and reinstalled language files.. but still have error.
To all those who monitor this thread I have been going back and forth with Hans about POSper you may want to get in on this at https://sourceforge.net/forum/forum.php?forum_id=606132
Cheers,
To all those who monitor this thread I have been going back and forth with Hans about POSper you may want to get in on this at https://sourceforge.net/forum/forum.php?forum_id=606132
Cheers,
To all those who monitor this thread I have been going back and forth with Hans about POSper you may want to get in on this at https://sourceforge.net/forum/forum.php?forum_id=606132
Cheers,
To all those who monitor this thread I have been going back and forth with Hans about POSper you may want to get in on this at https://sourceforge.net/forum/forum.php?forum_id=606132
Cheers,
To all those who monitor this thread I have been going back and forth with Hans about POSper you may want to get in on this at https://sourceforge.net/forum/forum.php?forum_id=606132
Cheers,
On my local, I used to be able to be login to two different installs in two different tabs in my FF browser, know when I try it I get this error:
(DATABASE ERROR : The company preferences could not be retrieved
error code : 1046
error message : No database selected
sql that failed was : SELECT * FROM company WHERE coy_code=1)
Now I must logout, or clear cookies to login to the other install.
This is no big deal, but sure was handy when you need to look at one install and make entries in the other.
So then I guess you should always have company 0, just for the purpose of doing Software Upgrade, etc. If your live company is 1_ then I guess you would prepare alter.sql to 1_ and run it from admin 0_ and your tables with 1_ prefix will be updated, right?
Interesting, you could set the pages that you want to access to $page_security = 15; but for me if I did then some other users with admin rights could make a mess of things. I suppose that it would be a good idea to have a user that would be super admin, (sysop) a user that you would only use to do sys upgrades etc. not regular use.
I did an install on my local with the 2.1.0b got the updates from unstable today, took an import sql from my live FA made sure that every line in the alter2.1 was queried.
Everything works good but... in both Sales Order Entry and Direct Invoice the items are not available, when I create a new item no problem it works fine, when I try to edit an existing Item the Item loads ok and looks ok. But in Inventory Item Sales prices, no existing Items show, only the new Item I entered. But existing Items show in Supplier Purchasing Data and Inventory Item Cost Update, just fine, but the cost data is not there.
What do you think?
Hello All
I have always said from the beginning that pos should be a module. Joe and Janusz do a great job at keeping fa an accounting system, it is the reason I am here. If you are a subscriber the lists then you know how hard they work at it. My self, I would not ask them to anything else.
I have been messing with pos sense the days of Dbase,
Some time back I spoke with someone over at weberp, and he had worked on a pos before, he is the one that told me obpos would be the easiest to connect to the data base.
I did some more poking around the other day to see what was new looks like the guys over at posper are hard at again, so I grabbed a copy (https:/sourceforge.net/project/showfiles.php?group_id=175878) and took a look at it, I like the ui much better then obpos, but I have no idea how to get it to read and write to fa's database, but there are others on this forum that will contribute to development cost to do this kind of thing.
Janusz, if you took a look at posper it would give you a real good idea as to what we in the retail business need in a pos, it takes about 35 meg in a folder to run.
In the mean time I will make fa do all the pos it can do...
To everyone, the best.
Alvin
PS: bruzergear, posper has payment gateways already built in.
FrontAccounting forum → Posts by alvin
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.