576

(24 replies, posted in FA Modifications)

Yes, IMO there is no big sense in GL lines on Supplier Invoice form. We have preserved the GL list here just for backward compatibility, the newer Direct Invoice does not contains this element.

Another issue is if you have categories GL ledger format then using service item is not possible. Please have a look at my COA.

I'm not sure what you mean here. Could you explain me the problem?

Janusz

You will find it in here in download section.
Janusz

578

(24 replies, posted in FA Modifications)

Ok, why do you prefer to entry general expenses via Supplier Invoice, instead of generic Direct Invoice form? Can you point out any cost type which cannot be entered here, and use of Supplier Invoice form is just necessary?
In my FA setup I use everyday I have just defined a couple of additional items like 'Electric energy', 'Communication services' and generic editable 'Other services' item, all with item type set to 'Service'. Using them with supplier Direct Invoice makes me free from any tax calculations, all is posted properly without manual calculations.

Janusz

Repo is active anyway all the time. What do you see on System Diagnostics page regarding openssl extension?
Janusz

Just as final comment to the printers sub-thread. IIP and LPD protocols are not compatible, and unfortunatelly the difference does not boils out to default port number. Currently FrontAccounting does not support IPP protocol. For anybody who want to implement IIP protocol in FA RFC 2569 is must read document at start (contains also direct links to both ipp and lpd protocols).

Thanks again for forging the knowledge in Wiki.
Janusz

581

(5 replies, posted in Wish List)

You can send it to contributions mailbox to be eventually included in FA extensions repo. Adress you will find in on Contact Us page.
Janusz

582

(24 replies, posted in FA Modifications)

On current FA supplier invoice form there is no auto calculation of tax.

There is some fundamental misunderstanding here. Every defined item has assigned Item tax group, which determines tax type and rate.  When item is included in invoice respective taxes are calculated. This works the same both in sales and purchase side.
Please read carefully Tax Configuration wiki topic.
Janusz

In my office server is host name on local network were main printer is connected (just put the name in /etc/hosts file if you  do not want to run dns service).

If you want to use network printer in configuration above and you have cups installed, just install cups-bsd package which provides old good lpd service. Or implement iip protocol in FA and send the code back to contributions mailbox wink.

Janusz

Well, you have to configure your printers under Setup|Printers first. Examples you will find in en_US-demo.sql file. Currently printing system supports only two print destination types:
. lpd compatible network service (standard port 515);
. printing via client browser.

Lpd is standard service supported by probably all printing systems, also currently most popular CUPS have lpd implementation builtin. Using second method you can print reports to any browser connected to your client box, but this is far less handy when you use FA heavily at work.

The example setup provided in en_US-demo.sql is exactly the same as I use in my office. Fortunatelly works as expected from the beginning. While priniting via browser is excelent option when you want to see the report before printing, there is no big sense to use this destination on printing sales invoices. Sending them directly to print server saves your time.

Janusz

585

(24 replies, posted in FA Modifications)

I see you tend to think from accountant perspective, while most people less skilled in accounting have problems with proper GL postings. This is why entering costs via purchase module is preffered over  low level GL journal. When you entry cost invoice via journal  you must to know what you are doing. For example taxes included in invoice depends on your supplier location, so you have to know how to post cost transaction in case o import, trade in EU or domestic supply, and all the 3 cases are posted differently to GL. Taxes can also depend on category of purchased goods. All this can be configured once for ever in supplier/items tables, then used flawlessly entering purchase order. This is why we prefer to not extend GL interface more than needed in favour to other higher level tools (yes, UE trade definitely need more support in FA).

I agree with the 4 preposition. Current accruals interface seems to be not the best way of dealing with the subject.
Finally thank you for all your warm words. Regarding UK COA I will contact you by email, you can also send it to contributions mailbox.
Janusz

Janusz

586

(9 replies, posted in Reporting)

Thank you apmuthu smile.
@danubi,
Look into  reporting/includes/header2.inc - this is typical template file for document layout.
Janusz

Yes, all the pdf reports are printed in the same manner. You can configure your browser to display pdf files directly, but anyway they have to be cached somehow on client side. Most documents has also equivalent html viewers implemented e.g. you can display invoices in popup window instead of printing clicking on respective link in Customer Inquiry.
Janusz

588

(11 replies, posted in Banking and General Ledger)

Additional config here is unnecessary, as in next major release one another cash type account without limit control is planned (for employee advance payments case). In mean time you can simply choose another type of bank account (e.g. cheque).
Janusz

589

(25 replies, posted in Installation)

Seems your case is more complex than expected. Seems the original proces failed on first company, but the others could be consistent. You can try following last resort procedure:
. comment out the first company in config_db.php temporarily;
. retry upgrade after login to admin account on the first (not commented out) company;
. if all will go right just uncommnet first company and you are done.
Before starting above procedure I strongly recommend detailed inspection of all companies database schemes - all should be identical to sheme used in version  2.2 (providing you have started upgrade from 2.2).
Janusz

590

(5 replies, posted in Wish List)

Please, dude!

591

(24 replies, posted in FA Modifications)

1) You should entry such an invoices via normal purchase Direct Invoice interface. Just create separate inventory item with type service for the accounting services and you can use it Direct Invoice. Then you have all needed taxes calculated automatically, there is no place for errors.
2) I'm not sure about this preposition. Where such a constraints should be added? (journal entries has its switch in access setup, so you can keep newbies away from the journal funtcionality)
3) Introducing complex taxed transactions via journal does not make sense. In many countries beside taxes you have to register also respectoive net amount. There is no easy way to link tax lines to net value GL lines in journal, also other things aree important like vat category for posted item etc, so you should just do taxed postings as described above (p1)

Janusz

pdf_files directory is temporary cache on server side, where pdf reports are created. This folder is automatically cleaned from files older than 3 minutes on every print atempt.

'~/Download folder (I guess) is download directory used by your browser to store downloaded files. In most cases pdf reports are sparse after printing, so you can even configure FA to directly send the report to the printer - in this case ~/Download folder will never be used. It is up to you what you do with the reports after downloading it - FA application does not store the generated reports.
Janusz

593

(11 replies, posted in Banking and General Ledger)

If you are sure you  have sometimes negative amounts in your cash account, this is acceptable wink.
Janusz

594

(15 replies, posted in Installation)

extract all and uploaded on a new directory, called "fa" (555) under the root folder

You mean  document_root, not file system root I hope?
Also 500 Error sometimes is triggered by .htaccess files on unusual apache configurations. Try remove the .htaccess file temporarily form fa folder.
Janusz

595

(25 replies, posted in Installation)

The sql files in 2.3.11 are corect. This stable branch wink.
Janusz

596

(5 replies, posted in Setup)

You will have to change the php code in gl/includes/ui/gl_journal_ui about line 30 replacing ref_cells() call with respective label_cells() plus hidden() helper calls.

Janusz

597

(9 replies, posted in Reporting)

Yes, you can use any pdf file as background image for pdf report:
. put the pdf template file in reporting/forms folder;
. after creating FrontReport object call SetHeaderType() method passing basename of the template file;
. if you want to add any additional constant elements printed on every page (like titles, additional graphics) you can create *.php file with the same base name in the reporting/forms folder, and put any needed code here.

The pages in template file are used in cycle, so if there is only one page in template file - this page will be used for every page of report generated, if your template has 3 pages and the generated report has 4 - the last page of report will use page 1 as background again.
Janusz

598

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

@apmuthu
If you want to be involved in google code payroll project please contact Joshua (sticmann) - he is original project leader.
@Farhaj
It would be good to know your plans about HR/Payroll code announced here on forum. What licensing you plan regarding your works? Do you want to make it open source in some point? Regardless of your decision, I think it is good to keep theese things clear.

Janusz

Yes. If you have barcode scanner pluggable in between your box and kbd, you can use it together
with Foreign Item Codes definitions.
Janusz

600

(5 replies, posted in Wish List)

Thanks to apmuthu the sql files in unstable repo has been updated smile. No warranty on completness/usufullness of current alpha code though.
Janusz