26 Topic by carmelr

(22 replies, posted in Reporting)

Whenever I output an excel report and try to open it in Excel I get the following message:

The file you are trying to open, 'PriceListing.xls', is in a different format than specified by the file extension.

When I force the file to open in excel, the data is not there.

I then compared the first few bytes of the above file with those of a properly formatted file and I found that there are 4 spaces as the first characters of the file. When I remove the spaces, the file opens properly in Excel.

Here is a hex dump of a file produced by FA:
file name: PriceListing.xls
mime type: 

0000-0010:  20 20 20 20-d0 cf 11 e0-a1 b1 1a e1-00 00 00 00  ........ ........
0000-0020:  00 00 00 00-00 00 00 00-00 00 00 00-3e 00 03 00  ........ ....>...
0000-0030:  fe ff 09 00-06 00 00 00-00 00 00 00-00 00 00 00  ........ ........
0000-0040:  01 00 00 00-08 00 00 00-00 00 00 00-00 10 00 00  ........ ........

and here is a hex dump of another excel file:
file name: UK_UBL_feed_template_v1.11.xls
mime type: 

0000-0010:  d0 cf 11 e0-a1 b1 1a e1-00 00 00 00-00 00 00 00  ........ ........
0000-0020:  00 00 00 00-00 00 00 00-3e 00 03 00-fe ff 09 00  ........ >.......
0000-0030:  06 00 00 00-00 00 00 00-00 00 00 00-01 00 00 00  ........ ........
0000-0040:  01 00 00 00-00 00 00 00-00 10 00 00-58 00 00 00  ........ ....X...

What is placing the spaces in the file? Is there anything I can change to get the excel function working?

TIA
Carmelo

Go to forum: Reporting

27 Reply by carmelr

(6 replies, posted in Accounts Receivable)

Hi apmuthu,
I delved deeper in this issue and I found out that up to the level of a Sales Order, it seems to be safe to just change the pointer to the Customer in the table sales_order.
This is not so if the delivery note is issued as then even entries in the Tax due tables are updated.

Currently, while in the Modifying Sales Order screen, as soon as the Customer or the Branch is changed the Sales Order is reset and all items are removed. How can I disable this resetting of the Sales Order?

TIA
Carmelo

Go to forum: Accounts Receivable

28 Reply by carmelr

(6 replies, posted in Accounts Receivable)

Thanks apmuthu for your solution.
I'm afraid that the solution is too technical for an accountant or bookkeeper to perform.

Re-entering a hundred items is a huge job as well.

Go to forum: Accounts Receivable

29 Topic by carmelr

(6 replies, posted in Accounts Receivable)

Hi,
Is it possible to change the company (customer or client) after an invoice has been issued?

For example, I get an order of 100 items and I create the invoice to CompanyA. However, the invoice was meant to be to CompanyB. Is it possible to change the company to whom the invoice was issued?

Thanks
Carmelo

Go to forum: Accounts Receivable

30 Reply by carmelr

(2 replies, posted in Banking and General Ledger)

Thanks Joe for the reply.
It is true that there are other reports showing the information.
However, it seems that having a report listing the individual entries in an invoice but does not give details of the item is not ideal.

I tried to see if I could create a report that combines the information, but iI couldn't get the link between the GL Transaction data and the individual items in the mentioned invoices.

Regards,
Carmelo

Go to forum: Banking and General Ledger

31 Topic by carmelr

(2 replies, posted in Banking and General Ledger)

Hi,
When one issues an invoice with multiple items in it, the description line is not used when printing the GL Account Transactions report. So the report would look something like the following:

Type                Ref      #      Date             Dim             Person/Item                Debit        Credit           Balance
=================================================================
Sales Invoice   1034   161  03/11/2014                     Abc Ltd/john                              100.00            -4000
Sales Invoice   1034   161  03/11/2014                     Abc Ltd/john                                20.00            -4020
Sales Invoice   1034   161  03/11/2014                     Abc Ltd/john                                10.00            -4030
Sales Invoice   1034   161  03/11/2014                     Abc Ltd/john                                60.00            -4090

As one can imagine the items in the invoice were all different items. So why are they not showing in the report?
Am I missing something here?

TIA
Carmelo

Go to forum: Banking and General Ledger

32 Reply by carmelr

(5 replies, posted in Installation)

I agree with you Joe and our intention is to follow the rules of GPL v.3. Please note however, according to the license we are not obliged to share code modifications. This is because we are not "propagating" or "conveying" the software but we are simply making it available through a network.

Notwithstanding the above, I'd like to reiterate our attitude towards this issue. We believe in developing a positive relationship with all stakeholders involved (most notably, FA developers, clients and FA users).

As is visible through my previous posts, I am ready to contribute my expertise (time-permitting) in the forum. I have also contributed some code developments. Unfortunately, they were not implemented though I understand the development team would have its own plans.

Most of the modifications we have done to Clever Accounting are a result of client requests and are minor changes. Joe, I would be happy to discuss these with you over a Skype call (carmelr).

@apmuthu, we would be glad to share our experiences with Clever Accounting. However, this is a bit vague. Again feel free to contact me on Skype (carmelr). We are quite open and wish to be fair.

As I said previously, we hope to build up the number of people that benefit from FA's technology through our model, and this will enable us to contribute further to FA.

Regards,
Carmelo

Go to forum: Installation

33 Reply by carmelr

(5 replies, posted in Installation)

Yes apmuthu and joe, Clever Accounting is based on FrontAccounting technology.

We love FrontAccounting. The fact that we have based our project on it shows how much we believe in the software. Our purpose is that through our efforts more people actually benefit from the hard work the developers put into the system. In the future when we scale the business, we look forward to contributing more towards FrontAccounting. Alas, for now we are humble company and are limited to giving the odd donation.

The service we offer includes hosting, back ups, training material and technical customer support. We are proud of our work and we do not hide the fact that Clever Accounting is based on FrontAccounting. As you can see it is in our about us page  and even when logging in.

We were actually encouraged to work on Clever Accounting when we saw this page on FrontAccounting's website.

We hope we can succeed in our purpose to bring this software to more people around the world, for the benefit of all stakeholders involved.

Cheers.

Go to forum: Installation

34 Reply by carmelr

(4 replies, posted in Banking and General Ledger)

Thanks, I will try it.

Carmelo

Go to forum: Banking and General Ledger

35 Reply by carmelr

(4 replies, posted in Banking and General Ledger)

Is there an easy way the extract GL transactions belonging to different bank accounts?

Thanks
Carmelo

Go to forum: Banking and General Ledger

36 Topic by carmelr

(4 replies, posted in Banking and General Ledger)

Hi,
My auditor noticed that the balance shown for the bank in the on-screen Trial Balance is totally different to the value shown in the Bank Report for the same account (and the same period).

When in the on-screen Trial Balance, I click the link to the bank account, I get all the transactions for the bank account and these are good (same result as the report).

Why do I have this difference? Doesn't the Trial Balance get it's totals from the same tables?
What can I do to fix this?

Thanks in Advance.
Carmelo

Go to forum: Banking and General Ledger

37 Reply by carmelr

(12 replies, posted in Banking and General Ledger)

I often find myself in the same situation as jlinkels as I usually enter my transactions in batch.
In fact there are two "traps" that I find I always fall into:
1. The date; having the wrong date for the invoice or payment
2. Wrong bank account for payment.

There is a simple solution that would be nice to have implemented.
A checkbox is added near the Date and also near the Bank Account (In payments). Unless the box is checked, the invoice or payment will not be accepted.

The ability to switch off the extra checkboxes should be made available either in the preferences menu or in the Company Setup menu.

Go to forum: Banking and General Ledger

38 Reply by carmelr

(21 replies, posted in Report Bugs here)

OK, let's try this and see if it solves your problem:
1. Go to Setup tab and then choose Access Setup.
2. (We are going to create a new Role) Enter the Role Name e.g. Stock-Product Manager
3. Check the boxes so that you allow the user with this role the functionality required, example check the Inventory configuration; the Inventory operations and so on.
4. Create a user and assign him the role just created.

Let us know if this solves your problem.

Go to forum: Report Bugs here

39 Reply by carmelr

(21 replies, posted in Report Bugs here)

Going back to your original requirement ...

Can't you create a new role for this user and then allow access to the sections you want this user to access?

If I got this wrong, then you might need to explain yourself better!!!

Regards,
carmelo

Go to forum: Report Bugs here

40 Reply by carmelr

(21 replies, posted in Report Bugs here)

Hello tester1,
I'm not sure I understand correctly your request, but take a look at this page, it may be what you are looking for:
https://frontaccounting.com/punbb/viewtopic.php?id=886

regards,
Carmelo

Go to forum: Report Bugs here

41 Reply by carmelr

(15 replies, posted in Announcements)

Common

  • Added option to allow user password reset (by Mithy).

Hi,
I wonder how the password reset is accessed and used.

Thanks
Carmelo

Go to forum: Announcements

42 Reply by carmelr

(2 replies, posted in Items and Inventory)

Thanks Joe.
Yes, the name field is 200 characters long, which is good for many things. But when would like to put in a description of a computer system, 200 characters are not enough.
The Description field with its support for many more characters is more suitable in such cases.

But now I know and I will try to implement a different approach.

thanks again
Carmelo

Go to forum: Items and Inventory

43 Topic by carmelr

(2 replies, posted in Items and Inventory)

When adding an Item in the "Items and Inventory" section, the first three fields are:
Item Code; Name; and Description

The Description is capable of holding a lot of information as it is saved in a tinytext field in the database.
However, I cannot find where this information is used in FrontAccounting. When issuing an invoice or a sales order, only the field called Name is used.

My questions are:
1. Is there a place where this information is shown (apart from the Items form)?
2. How difficult would it be to include this information in Quotations and Invoices?

TIA
Carmelo

Go to forum: Items and Inventory

44 Reply by carmelr

(5 replies, posted in Accounts Receivable)

Thanks to both of you, Joe and Elax

Carmelo

Go to forum: Accounts Receivable

45 Reply by carmelr

(5 replies, posted in Accounts Receivable)

Thanks Joe,
I think I will use the sales order idea as that is cleaner.

Carmelo

Go to forum: Accounts Receivable

46 Topic by carmelr

(5 replies, posted in Accounts Receivable)

I offer a service to my clients and charge by the hour. However, I only issue an invoice once a month.
Is there a way to open an invoice for each client at the beginning of the month, add to it as the month goes by and then close it and send it to the client at the end of the month?

Thanks
Carmelo

Go to forum: Accounts Receivable

47 Topic by carmelr

(1 replies, posted in Wish List)

The two functions under the setup tab: Void and View/Print transactions show the number, Reference and Date of each transactions. It would be much more informative if the Total Amount of the transaction be added as well.

Is this possible?

Thanks
Carmelo

Go to forum: Wish List

48 Topic by carmelr

(2 replies, posted in Wish List)

How many times one enters a Direct Invoice, submits it and immediately realises that the Date was incorrect.
There is no way to change the date of an invoice once it is accepted.

May I suggest that a checkbox be added after the date and unless it is checked the submit will not work. This will force the user to remember the date and accept it.

Thanks
Carmelo

Go to forum: Wish List

49 Reply by carmelr

(11 replies, posted in Accounts Payable)

Here is an update.
So I started a totally new test company using the en_GB-general COA.
I got the same results. Here are the screen shots:

Purchase Invoice Entry
https://dl.dropboxusercontent.com/u/298 … emo-UK.png

Ledger Result:
https://dl.dropboxusercontent.com/u/298 … emo-UK.png

Regards
Carmelo

Go to forum: Accounts Payable

50 Reply by carmelr

(11 replies, posted in Accounts Payable)

Thanks Joe for your reply.
I did the following steps to try and locate the problem:

1. I used your Training Co. Demo site and entered the transactions there. Correct Result.
2. I installed a new instance of FA in another folder and copied my COA and config files.
3. Tried the same entries and the error appreared again.

I am using GL Accounts in the Supplier Invoice.

Here is a screenshot of the entry on the Training Co.
https://dl.dropboxusercontent.com/u/298 … nvoice.png

This is the result of the General Ledger on my system (note the entries arethe same only the GL Accounts are different in order to accomodate my COA:
https://dl.dropboxusercontent.com/u/298 … ger-my.png

This screenshot is for the System and General GL Settings:
https://dl.dropboxusercontent.com/u/298 … ttings.png

I hope the above information is enough to help pinpoint the problem.

I can also provide a backup of my test account.

Thanks, Carmelo

Go to forum: Accounts Payable