76 Topic by huotg01

(5 replies, posted in Accounts Receivable)

Would it be possible to add to the sales invoice the name of the customer contact, phone number and  email ?

Gaston

Go to forum: Accounts Receivable

77 Reply by huotg01

(11 replies, posted in Reporting)

Joe

These are the sql statements from the sql trail on my test db:

"381","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"382","SELECT id, CONCAT(reference,'  ',name) as ref FROM 1_dimensions WHERE (type_=1) ORDER BY reference","1",
"383","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"384","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"385","SELECT * FROM 1_fiscal_year WHERE id='5'","1","could not get current fiscal year"
"386","SELECT * FROM 1_company WHERE coy_code=1","1","The company preferences could not be retrieved"
"387","SELECT * FROM 1_chart_class WHERE !inactive AND ctype>3 OR ctype=0 ORDER BY cid","1","could not get account classes"
"388","SELECT printer FROM 1_print_profiles WHERE profile='' AND report='707'","1","report printer lookup failed"
"389","SELECT printer FROM 1_print_profiles WHERE profile='' AND report=''","1","default report printer lookup failed"

What do you think ?

Gaston

Go to forum: Reporting

78 Reply by huotg01

(7 replies, posted in Report Bugs here)

Docusave

Sorry, my last comment was not targeted to this thread...

That being said, as mentioned by Jarusz, there is another way that will just list the customers. It is convenient when there is not too many of them.

Gaston

Go to forum: Report Bugs here

79 Reply by huotg01

(11 replies, posted in Reporting)

The demo shows all the results. No problem there.

I will look at rep707 to try to better understand what I did wrong.

Gaston

Go to forum: Reporting

80 Reply by huotg01

(7 replies, posted in Report Bugs here)

The demo shows all the results. No problem there.

I will look at rep707 to try to better understand.

Misplaced comment

Gaston

Go to forum: Report Bugs here

81 Reply by huotg01

(7 replies, posted in Report Bugs here)

Thanks Janusz for reminding this feature. I tried before but I was unsure of the way of using it.

Gaston

Go to forum: Report Bugs here

82 Reply by huotg01

(11 replies, posted in Reporting)

Joe, I'm quite sure that FA is ok and that I am the problem, but I don't know what I'm supposed to expect.

I will go see the demo.

Gaston

Go to forum: Reporting

83 Reply by huotg01

(11 replies, posted in Reporting)

Joe

There is no account listed, just one line:

Period: 2010/07/01 - 2010/07/31 Page 1
Account                Account Name Period Accumulated Achieved %
Calculated Return                          0           0              0.000

Anything I should check out ?

Gaston

Go to forum: Reporting

84 Reply by huotg01

(11 replies, posted in Reporting)

Joe

Any "Start date" to any "End date" periods always reports zero !

Something to check out ?

Gaston

Go to forum: Reporting

85 Reply by huotg01

(7 replies, posted in Report Bugs here)

Hi

First, we have to make sure of what we are talking about.

In the Sales tab, you used "Add and Manage Customers" form to create new clients ?

You looked at the db, table 0_debtors_master and the table is populated ?

If so, did you, for each client, created at least a branch ? (using "Customer branches:    Add or Edit" option in "Add and Manage Customers" form ?

If so, then the table 0_cust_branch should also be populated.

If you did all that, please confirm that you still have no client available when making a new invoice.

Gaston

Go to forum: Report Bugs here

86 Reply by huotg01

(3 replies, posted in Items and Inventory)

Thanks Janusz

Do you plan in a future release to "attach" this information to the transactions ?

In the mean time is it possible to accept a change in the currency if there is no transaction ? I'm asking but there is probably more important things to do.

Gaston

Go to forum: Items and Inventory

87 Reply by huotg01

(2 replies, posted in Banking and General Ledger)

itronics wrote:

Bank and General Ledger tab,  Payments option and
Bank and General Ledger tab , Deposits option
Janusz

Ok, I knew these ones (In Banking and General Ledger tab). I thought the wiki was referring to another form.
I will make the corrections to the wiki.

Thanks

Gaston

Go to forum: Banking and General Ledger

88 Topic by huotg01

(3 replies, posted in Items and Inventory)

Why is it impossible to edit Supplier's Currency ?

Gaston

Go to forum: Items and Inventory

89 Topic by huotg01

(2 replies, posted in Banking and General Ledger)

In the Wiki, under Quick entries, there is a reference to "Bank Payments / Deposits form"

Operation
In the Bank Payments / Deposits form there are an option for selecting Quick Entries, 
if you have defined some. After that a list shows up with the quick entries for the 
respective Payments / deposits and an amount field. Here you enter the base amount 
for calculations performed during the quick entry to make ready for you. Then press 
the 'Go' button to enter GL lines.

Where is that form ?

Gaston

Go to forum: Banking and General Ledger

90 Reply by huotg01

(11 replies, posted in Reporting)

joe wrote:

You can compare the profit and loss statement against Budget.

Are you referring to Profit & Loss Drilldown ? There is no result .

Gaston

Go to forum: Reporting

91 Topic by huotg01

(11 replies, posted in Reporting)

What are the reports using the Budget information ?

At the beginning of the fiscal year, let`s say that I want a report like:

"GL account" "Budget this year" "Budget last year" "Last year real"

is there anything like that ?

Gaston

Go to forum: Reporting

92 Reply by huotg01

(2 replies, posted in Reporting)

Thanks Janusz

Go to forum: Reporting

93 Topic by huotg01

(2 replies, posted in Reporting)

Sorry in advance if I just missed something very simple, but how can I get a basic list-report of all clients/branches ?

Thanks,

Gaston

Go to forum: Reporting

94 Reply by huotg01

(22 replies, posted in Setup)

Thanks Janusz

But, in the case of a fiscal year with no transaction, why is FA preventing the deletion of that fiscal year ? (trying to better understand).

Gaston

Go to forum: Setup

95 Reply by huotg01

(22 replies, posted in Setup)

thhui wrote:

If you have data in any fiscal year before, you cannot delete any fiscal years after
in spiite of having no data in that fiscal year.

So, in order you can delete any fiscal year, you must have no data before it and
no fiscal year before it.

What would be the logic ?


mudassir wrote:

cant delete july 2011 - june 2012 but its ok for me....

Why would you delete it ?

Gaston

Go to forum: Setup

96 Reply by huotg01

(22 replies, posted in Setup)

...you are right about demo data but a part of the questioning is regarding the error message:

"Cannot delete this fiscal year because thera are fiscal years before."

As said I tried myself to create a new fiscal year, and immediately deleted it (no transactions) and I got the same message as Mudassir. I was expecting Joe ou Janusz to explain why we have this message (may be the message is wrong ?).

Any clue about it ?

Gaston

Go to forum: Setup

97 Reply by huotg01

(22 replies, posted in Setup)

Newly installed without demo data ?

Anyway I think we will wait for the answer from the administrators to the thread 1433:
https://frontaccounting.com/punbb/viewtopic.php?id=1433

As said, I noticed the same problem

Gaston

Go to forum: Setup

98 Reply by huotg01

(7 replies, posted in FA Modifications)

chaitanya wrote:

Hi Janusz,

I would like to suggest that we should display Tax calculation on PO view / print.
It is required for Accounts Department to allocate amount for PO or drawing a cheque.

I agree with chaitanya

Gaston

Go to forum: FA Modifications

99 Reply by huotg01

(22 replies, posted in Setup)

We will wait an answer on thread 1433 before going on.

I have the same problem when trying to delete a newly created fiscal year.

Gaston

Go to forum: Setup

100 Topic by huotg01

(0 replies, posted in Setup)

When trying to help on thread 1432, I noticed that for mudassir and I, it was not possible to delete a newly created fiscal year.

We have the message: "Cannot delete this fiscal year because thera are fiscal years before."

In my case, just to check, I just created a new fiscal year, and immediately tried to delete it, but got the upper message.

This message is triggered by the following piece of code:

function check_can_delete($selected_id)
{
    $myrow = get_fiscalyear($selected_id);
    // PREVENT DELETES IF DEPENDENT RECORDS IN gl_trans
    if (check_years_before(sql2date($myrow['begin']), true))
    {
        display_error(_("Cannot delete this fiscal year because thera are fiscal years before."));
        return false;
    }

Why is it impossible to delete a just created fiscal year ?

Thanks

Gaston

Go to forum: Setup