201

(38 replies, posted in Modules Add-on's)

smummert wrote:

How did this go - any luck?  Also what about osCommerce integration ?

I would like to just have a script that would allow someone to search the products by location, category, etc.  And be able to see what is in stock, the retail price, description, and photo, without have to login.

This way a customer could check stock and price before they make the trip to the store.

AM

202

(2 replies, posted in FA Modifications)

Looks good so far, I will watch for a release...

203

(38 replies, posted in Wish List)

itronics wrote:

When your main business is made on B2B basis and only few income is from retail clients, what is the sense to fire up OpenBravo with all its requirements? Should I buy a gun to kill a fly?

Janusz

Of course you are correct, but when your main business is retail you will need these features, pole displays must be lit-up, scales turned on, cash drawers opened, bar code scanners and specialty printers operated. I just don't see how you can do all this with out running a little client side code?

Any ideas?

204

(38 replies, posted in Wish List)

For what it is worth I still think Openbravo POS is the best solution for this, we just need to get a little java dev done on it to work with FA, I am willing to put a few dollars toward this.

Let me know what you all think???

AM

205

(31 replies, posted in Wish List)

I just wanted to comment on Dave's statement

"Don't get distracted with all the crm, project management, and erp junk that so many others are trying to do. It only will make your accounting portion weaker because you will use up valuable resources to do things that aren't your core focus."

This is what modules are for. While not all business is the same, all business must do accounting.

This system is well suited to business that have many locations in many countries. A business like this uses some type of groupware to bring everyone in the business together. Much of fa already has features like locations, employees, suppliers, etc. that are used in groupware.

Perhaps it should be the other way around, maybe fa could become a module of a good groupware system.

We all love fa, may the force be with you.

Alvin

206

(31 replies, posted in Wish List)

rasmus_kristensen wrote:

What do you mean by Group-Office module?

a calendar, project management, e-mail, tasks, addressbook, file management, and more.

207

(31 replies, posted in Wish List)

My complements!!!

What about a Group-Office module?

AM

208

(9 replies, posted in Report Bugs here)

I updated the scripts, updated the db by hand, know I get this error at direct sales

Division by zero in file: /hsphere/local/home/alvin101/fatest.almacennaval.com/sales/includes/sales_db.inc at line 106
Division by zero in file: /hsphere/local/home/alvin101/fatest.almacennaval.com/sales/includes/sales_db.inc at line 114

I get the same error at price list, and the list shows 0's

209

(9 replies, posted in Report Bugs here)

OK, I went back to see what went wrong with alter2.1, the tables were created ok but none of the rows inserted, ?

I will do a little hand work for now and get back, to ya

AM

210

(9 replies, posted in Report Bugs here)

Hello Janusz

Not sure how I got badly updated db structure, I first run alter2.1 with update_db.php, got a small error, so went to myadmin and and pasted it in the sql window, I did get a some small error but... I did 0_ first then 1_ next

What do you think would be the best way to handle this db?

I will update scripts later and come back later,

AM

211

(9 replies, posted in Report Bugs here)

Janusz

I still have problem with this unstable, I run the alter2.1 on 0_ and 1_

but I still get this error,  What do you think?

DATABASE ERROR : could not get POS definition
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 'AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code' at line 1
sql that failed was : SELECT pos.*, loc.location_name, acc.bank_account_name, acc.account_code FROM 1_sales_pos as pos,1_locations as loc,1_bank_accounts as acc WHERE id= AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code

212

(9 replies, posted in Report Bugs here)

itronics wrote:

Well, I've just tried to reproduce both the problems, but with no effect.
More info is needed to track it down. Have you pricelist  problems also on stable FA version?

Yes, I have had this problem all along. 

To use new functionality in unstable you need to upgrade database structure with changes in alter2.1.sql file. Keep in mind that this file can be used directly only for db table set with prefix 0_. If you want to use it to upgrade tables for company 1_ you have to change the prefixes manually.

I thought this might be the case, I made the change, the direct invoice works again.

Janusz

ough

Janusz, yor still have admin rights at fatest.almacennaval.com, you can poke around and try some of this, Price List is z-employee, customer is Markus Dohlen, product is 105B,

There seems to be something funny going on at Inventory Item Sales prices, Item 105B,

Anyway let me know what you think?

AM

213

(9 replies, posted in Report Bugs here)

Just loaded the latest from unstable, to my test site, and I still have a problem with the price list

At Sales, Reports and Analysis, Price Listing: I set Currency Filter, it works ok, and I set sales type, but the report shows the regular retail price not the price in the sales type selected.

Any Ideas?

I also had a problem making a sale to a customer that was to get the special price in this Price List, but I could not make it work right, but now when I go to Direct Invoice, I get this error: (bellow)  Please let me know what you think?

DATABASE ERROR : could not get POS definition
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 'AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code' at line 1
sql that failed was : SELECT pos.*, loc.location_name, acc.bank_account_name, acc.account_code FROM 1_sales_pos as pos,1_locations as loc,1_bank_accounts as acc WHERE id= AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code

214

(1 replies, posted in Report Bugs here)

I just loaded the latest from unstable to my test site, got a small error...

Undefined index: print_profile in file: /hsphere/local/home/alvin101/fatest.almacennaval.com/includes/prefs/userprefs.inc at line 46
Undefined index: rep_popup in file: /hsphere/local/home/alvin101/fatest.almacennaval.com/includes/prefs/userprefs.inc at line 47

215

(13 replies, posted in Wish List)

Hello All

craigbass76 is correct about this barcode scanner he talks of.  It is a hand held scanner with a stand if you want.  It uses what we call a keyboard wedge, like he stated it is a Y cable that goes between the keyboard and the computer, when you scan a bar code the code goes into the field the cursor is setting in no mater what program you are using, just as if you had punched it in on your keyboard.

I still look forward to what a good POS module will bring to fa...  on day.

Regards, Alvin

I added a price list for employees, I added an employee as a customer, I added a customer branch for this customer,  But when I go to make a sale to this customer, using Direct Invoice, The right price list is auto selected, but when the item is selected and the invoice processed the price on the employee price list is not used, it keeps the Retail, base price.

What do you think?

AM

217

(5 replies, posted in Banking and General Ledger)

Here is a little chart I use when I can not remember how accounts are debited, credited, a bank account would be an asset account.

Account Type         Debit           Credit

ASSETS              Increases     Decreases
LIABILITIES       Decreases     Increases
EQUITY               Decreases     Increases
INCOME               Decreases     Increases
EXPENSES       Increases     Decreases


Enjoy,


Alvin

218

(1 replies, posted in Modules Add-on's)

An address book could be added to this module, or maybe a system modification.

It would be used for customers, employees, suppliers, vendors, and other.
For use in all areas of the system.

AM

219

(13 replies, posted in FA Modifications)

joe wrote:

You change/add Payment Terms in Setup, Payment terms. After that you can select the payment terms in Sales / Add and manage Customers. You can also set the Payment terms for a supplier in Purchase.

/Joe

Hey Joe, I don't how I missed that one.

The default install for the payment terms, (cash only, Following Month On, and Due After (Days)) should be set to N/A


I also added small things number 9, above

AM

220

(13 replies, posted in FA Modifications)

joe wrote:

6. What is the reason for printing the P/L in another currency than the domestic currency?
/Joe

It would be handy when you need to fill out forms in another country, or if your in that country and you just want to view your income statement  or other reports in that currency.

joe wrote:

8. Due-date is customer specific. It is calculated based on the payment terms.
/Joe

The customer (payment terms) is set to (Cash Sale), I don't see any way to add, change, or edit (Payments Terms)?

221

(13 replies, posted in FA Modifications)

I am happy to get the news of the "Planning for Next Major Release".

I updated my list of Small Things, number 6-8

More Later,

AM

222

(0 replies, posted in Wish List)

As we all know moving around any program is faster and more comfortable then mouse clicks.

This may not be possible with php, but you know how some programs will have a letter underscored for keyboard entry.

Maybe a Hotkey module that would allow users to set hot keys?

AM

223

(11 replies, posted in Report Bugs here)

I see, probably a good thing, 

More Later

AM

224

(11 replies, posted in Report Bugs here)

Silly me, I for got to put up (company/1 subdirectory), but now when I try to access (Create/Update Companies) I get this: "The security settings on your account do not permit you to access this function"  What do you think this could be, as I am logged in as admin?

The list problem, and the slash problem went away???

AM

225

(1 replies, posted in Modules Add-on's)

Company community portal

I would like to have a community module, something simple that would do:

1. Self register for users, that way there is no need to email passwords to new users (not secure), you just go in and assign access.
2. A forum for company use...
3. PM, a mail box system for private communication.
4. A chat box for instant communication.
5. Downloads, for company files, etc.
6. CMS, just some pages for news, events, etc.

There is a set of scripts that we may be able to use for this, at http://jasmineportal.net/jasmine/plugins/downloads/  maybe we can get the dev team to look at them, I am no coder so I can't tell how much work this would be?

Let me know what you all think?

Regards, Alvin