51

(12 replies, posted in Installation)

The error log should tell you what's happening. It may not be available to you if you're using one of the cheaper hosting companies, though.

The problem - whatever it is - seems to be with the dashboard theme. To revert to the default theme, look at
https://frontaccounting.com/punbb/viewtopic.php?pid=17234#p17234

52

(48 replies, posted in Setup)

Thank you. Your efforts are most appreciated. As are those of Joe and Janusz, of course.

I'll install it tonight. I shouldn't need any of the fancier features, so hopefully it's good enough for production use. (I presume it's still beta grade, but I'll take my chances.)

Have we done away with the non-UTF encodings yet?

Does your client get a new IP address between requests? That would invalidate the session.

https://frontaccounting.com/fawiki/index.php?n=Devel.FrequentlyChangingClientIPFix

I wouldn't bother with A5. Even if I wanted to print the documents in A5 format, I would generate them in A4 and scale the file down either when saving it or (preferably) when it goes to the printer.

Have you looked at the usual tools for pdf and ps manipulation? pdftk, gs and the like?

The first thing to check is if there are any fields you're not using. If there is a longer field (like "notes" or something), you might be able to shove all the numbers into that and parse them out when the report/invoice is created.

If that doesn't work, you need to extend the database. This can be done either by adding columns with ALTER TABLE or by creating a new table and linking it to the customer table.

Adding a prefix should be simple enough. The tricky bit is to have the sequence reset for each new month. I guess it could be bolted on using a separate field in the database, but internally the documents would still have a plain sequence number.

The first two lines give you a reference to the current user object. Put them somewhere at the beginning, near any other assignments, so that they are executed before you start outputting data.

The third line outputs the username to stdout, so that won't work for you. I presume it was included as an example of how to access the username. You need to use $user['username'] as an argument to one of the output methods of the PDF class. I suggest you look for a place where it outputs a date or a reference or something which appears near where you'd want the name to be.

Then copy that function call, replacing its argument with $user['username'] and see what happens. That should give you something to work with.

OK, I was wrong on that. I could have sworn there was one, but... Sorry.

If you have the accounts in a CSV file, I'm sure Joe can generate the required sql. That seems to be how it's usually done.

On a more constructive note, one thing we might consider would be reusing COAs defined by/for other projects. Has anyone looked into this?

59

(7 replies, posted in Wish List)

Kind of... It'll be a valid HTML5 page, but it won't do anything that the old page didn't. Except not work in old browsers. smile

To benefit from the new features of HTML, the theme (which outputs the actual page) needs to explicitly include those features. I'm no web developer, but I don't think there are any such features which could not be implemented in Javascript.

If you don't mind account names in Dutch, there is indeed a Belgian COA you could use.

I suggest you install it, and have a look. If it looks (structurally) correct, you could replace the account names in the sql file with their French equivalents. You only need to do this for the accounts you actually use, but if you translate all of them the new file can be included in the repo for the benefit of all Belgians. Or, at least, some of them. smile

As for the language pack, I suspect the problem is that it expects the fr_FR locale to be installed on the server, and you probably have fr_BE. If you do get it installed, there may be a few tweaks required but they should be minimal. Even if there are no differences, we should still have a language pack for fr_BE.

I can't answer your question, but I would just have extended the field where you added the email addresses.

apmuthu wrote:

Make the title be part of the first name in this instance!

That would allow you to greet them with "Dear Mr. Joe" or "Dear Mr. Joe Smith", but not with the far more appropriate "Dear Mr. Smith".

And prepending the title to the surname would yield "Dear Joe Mr. Smith", which is even worse.

For now the best way is the "Dear" + name1 + name2, suggested in the first post, but the proper way would be adding a "title" field to the contact. That's a change that should not break anything.

I don't know how the templates are handled, but ideally they should be translated/adapted according to local customs. And while we're at it, the contacts should probably have a language field as well, so that documents can be issued in that particular language. That would be a nice touch in bilingual countries. Or for anyone doing business in more than one language, for that matter.

If you've already been paid, would it not be possible to just enter/import your web sales as daily journal entries? It's not like you have an invoice you need to keep track of at your end.

Granted, it doesn't help if you need FA to manage your stock.

(For what it's worth, I've recently had another look at the REST API (https://frontaccounting.com/punbb/viewtopic.php?id=3433) and actually got it working. It doesn't handle sales or invoices at all - which was what I meant to use it for - but I might still get around to that. If anyone has already written SQL to create sales invoices, sales orders etc., please let me know and I'll add the appropriate functions.)

64

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

I import daily (invoiced) sales from a Prestashop server as journal entries. It's not an ideal solution in my case, as I'd really like to keep track of payments/allocations using FA, but for POS data it's all you need.

Since you basically only need to split the total between sales and tax, and book the amounts to the appropriate accounts, you could use a "quick entry". And if you manage to get the data out of Unicenta programmatically, you can feed it into FA with a single curl call. (Actually two. You'll need one to login and create a session.) You wouldn't even need the CSV import plugin I use.

Let me know if you need any help.

65

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

If you just need daily sales figures, it's easy to insert them as a journal entry. I do that with a simple cron job which calls curl to feed the (CSV) data into the journal import plugin.

66

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

I suspect it's auto(-matic), rather than "self-". While my Spanish is somewhat limited, it seems to be a service for electronic invoices (and/or payment of them) in Mexico. And the ruby code which (I guess) provides an interface to it is written by the same chap who wrote "our" REST API.

He might well have planned to exchange invoice data between Autofactura and FA, using a ruby-based web service. But the API was abandoned (?) before it was finished, so who knows what was actually planned...

Just ignore iproaccount. It's one of those. smile

As for changing the transaction dates in the db... Just try it and see what happens. As long as you have a good backup, you should be able to get back to your current situation no matter what happens.

I'm not familiar enough with the inner workings of FA to give you a "proper" answer, but it seems unlikely to corrupt the database. After all, the whole point of having a database is to avoid storing redundant information.

The obvious "solution" would be to increase the prices...

(I know 1.79 is supposed to look cheaper than 1.80, but I'm not at all convinced. Personally, I think round figures somehow look more "honest".)

Or you could perhaps adjust the rounding settings. Either globally or by adding a test somewhere to not round when the product is a kit. (In fact, applying rounding at that stage might well be a bug. Perhaps someone else knows the intended behaviour.)

I'm afraid I don't know what utility functions there are for adding stuff to the database, but the "proper" way would be to create a comprehensive API for all kinds of read/write operations.

For the latter, you could look at https://frontaccounting.com/fawiki/index.php?n=Devel.SimpleAPIModule which might provide a good starting point. It's not complete, and I had very limited success with it, but it might get you started. (I had a look at it last year, but put it off hoping the author would clean it up a bit first.)

There is an extension for importing journal entries from a CSV file, but that's probably not going to help much. And with that number of transactions, you'd be better off writing them to the database directly.

There have been a few attempts at REST and SOAP API's for this kind of thing, but I don't think anything has ever been completed.

Does your IP address change between the clicks?

https://frontaccounting.com/punbb/viewtopic.php?id=4700

The "numbers" you are seeing are really strings, and they are correctly sorted - but alphabetically. Just pad the numbers with leading zeroes and you'll get what you were expecting.

Yes, that did it.

The only explanation I can think of is if privileges are set on a user basis, from the group's "template" when a group is joined.

Doesn't make much sense, but... At least it would explain why new users get the appropriate privileges.

I can confirm Erwin's observation.