1

(0 replies, posted in Report Bugs here)

noticed an error today when i entered a comment in on a direct invoice. when i placed a " symbol, and placed the invoice, the result once printed was something to the effect of &quot&amp might be worth looking into. keep up the great work!

2

(1 replies, posted in Report Bugs here)

I have just downloaded the new unstable from cvs, and found an error on the Direct-Invoice page. Once you enter a line item, and click "add item", the edit, and delete options do not work.

Another issue that has happened a few times and I have not been able to find when/where it occurs is that companies that have a "&" in there names occasionally have there names changed where there should be a "&" to "&" seems like a formatting issue somewhere?

Many thanks for all of your hard work! It is turning out to be a great project!

3

(4 replies, posted in Manufactoring)

This might be a mistake on my part, but I cant figure it out.
I have items that are inventory, and manufactured.
my manufactured items are created from inventory items.

the problem that I am having is this, when I create a work order to make the manufactured items, they are created in the proper inventory account etc. But there is no ledger entry in cost of goods sold as there is when I would invoice an item directly from the inventory.

this becomes a problem when creating a profit/loss report because there is no loss (overhead) associated with the inventory used in the manufacturing process.

any help would be greatly appreciated

4

(3 replies, posted in Report Bugs here)

Thanks for the reply, however it did not work. On the page pdf_report line around line 137. If make this change.
        if ($this->rtl) // this is good for presentation only
        //if (!$own)
   
Just changing the comments. It displays properly but I am not sure if this is the correct fix..
Also two other issues that I came across today with reports are on the customer balance sheet. It is not properly accounting for receipts and deliveries.
I have made a few changes on my own to test I can send these if you would like. But where I was uncertain was how you were dealing with negative values (GL entry ) and different transaction codes.
on the price list report (rep104.) I actually don't get any results. I have not done much looking into this though.

Thanks

5

(3 replies, posted in Report Bugs here)

I just downloaded and installed the beta 2.0 and for some reason, when I view any of the reports, they are in mirror image form... Elsewise things look great! Thanks guys keep it up

6

(5 replies, posted in Wish List)

For example, say you invoice a customer, then  the customer pays in full. The remaining balance would then be 0$. At this point, if you would need to print a receipt for example, it would be beneficial for it to state, paid in full, or something to that effect.

7

(6 replies, posted in Report Bugs here)

On the report Customer balances, the receipts are not being subtracted from the invoices thus there is never a 0 balance or remaining balance.

8

(5 replies, posted in Wish List)

One thing that might be worth considering, when an invoice has been paid in full having a paid stamp be placed on the report. This would allow for emailing paid invoice receipts.

9

(3 replies, posted in Report Bugs here)

Woops, my mistake! I thought that was in the error message. It was generated when accessing this page:
frontaccount/sales/customer_invoice.php?ModifyInvoice=34

The odd thing is that it is not consistant. On some of my entries it will generate an error on others it will permit an edit.

Also I am using the new release of 2.0.

On another note, probably an easier fix.
on page:
frontaccount/sales/sales_order_entry.php?
after an entry of an item, the edit/delete links are not visable, they are there however. I would imagine this just needs a color change in css?
below is the actual link
<td ><input type="submit" class="editbutton" name="Edit0" value="Edit" />

</td>
<td ><input type="submit" class="editbutton" name="Delete0" value="Delete" />

I will if I can find any more information on the first bug.

Thanks again

the following was produced on new unstable release


DATABASE ERROR : The debtor transaction detail could not be queried
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 debtor_trans_type=13 AND 0_stock_master.stock_id=0_debtor_trans_details.' at line 6
sql that failed was : SELECT 0_debtor_trans_details.*, 0_debtor_trans_details.unit_price+0_debtor_trans_details.unit_tax AS FullUnitPrice, 0_debtor_trans_details.description As StockDescription, 0_stock_master.units FROM 0_debtor_trans_details,0_stock_master WHERE () AND debtor_trans_type=13 AND 0_stock_master.stock_id=0_debtor_trans_details.stock_id ORDER BY id

11

(17 replies, posted in Accounts Receivable)

Hello again, found a similar problem with the coloring effects for outstanding/past due balances. Take a look at the sales/inquiry/sales_orders_view.php? page, it is showing all of the balances are red. Maybe I entered something wrong though? Thanks Again

12

(1 replies, posted in Wish List)

This is something that might be useful. There are many payments that are frequently used by businesses that are not only a purchasable item or inventory. More or less, expenses. Quite often these are payable to the same entity. It might be a good addition to the program to have a means to enter the names and profiles of these and allow for a way to select the (drop down, search field, etc) where they can be chosen when writing checks. Keep up the great work!

13

(9 replies, posted in Setup)

If anyone is intereted out there about ssl,
the following appears to work. It is inseted around line 20 of login.php
   
    $redirect=$_SERVER['SERVER_PORT'];
    if ($redirect==80)
    {
        $redirect="YOUR SSL DIR HERE";
    }
    else
    {
        $redirect="";
    }


Also the form line

<form action="<?php echo" $redirect".$_SERVER['PHP_SELF'];?>" name="loginform" method="post">

14

(17 replies, posted in Accounts Receivable)

Just a quick note. Your patch did fix the problem. I just switched hosts today and I uploaded to my old host, while using new host! After actually uploading, file is working properly. Always check the simple things first!

15

(17 replies, posted in Accounts Receivable)

Thanks for your response. I applied the path, however it still doesn't produce the desired result, might there be another previous path that needs to be applied? On a side note, if you create a .pdf "customer balance report" you will notice that under the "allocated" column, both values (credit/debit) are additive. Is this the intended operation? I cannot understand the purpose of an additive allocated value. Again, I might be making a mistake.
Many thanks
Warren

16

(17 replies, posted in Accounts Receivable)

Ok, this is minor I think but it has my curiosity.
If you enter a sales order, then process the invoice.
You can take a look at customer transaction inquiry and this invoice will be marked red for overdue. Which it should since there has been no payments.
However, if you enter a payment, and allocate it to the invoice and then go back to the customer transaction inquiry it will still show red. If you look at the GL there will be an equal debit/credit and the balance remaining or due will be 0 as well. Is this a quirk somewhere or am I doing something incorrectly?

17

(4 replies, posted in FA Modifications)

First,
I think you guys have a great project in the making. 

A few quick questions/suggestions though.
sales/purchasing....
-Ability to edit a sales/purchase order after entering?
--this would be a great feature to allow for that one item you forgot to add when you were filling out the original order.

-receiving a purchase order. A value is created for an item qty, this qty is shown in the inventory as an "on order" item. Is there a way to show that this item is received?

-making payments/receiving payments. Instead of having to allocate these payments after they have been made, couldn't an allocate to: list box, or something of that sort be inserted to prevent more work?

Again, many thanks and I like where this project is aimed!