Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 171 of 200)
Topics by joe User defined search
Posts found: 4,251 to 4,275 of 4,990
Hello slax,
I am afraid that you have run into a bug. When the Bank Payment was used to pay a Customer (normally you use this for supplier payment) the amount was saved with a minus sign in the X_debtor_table (where X is the company number if you use table prefix).
As a side-effect you couldn't allocate this customer payment later, while is did not show up in the allocations.
This routine works OK the other way round (using the Bank Deposits for a Supplier Deposit), so no problem here. But,
The reports Customer Balances and Supplier Balances presented the wrong balance for this odd operations.
All this is now fixed in the CVS Main Repository. You can download the following files:
/sales/includes/db/cust_trans_db.inc - revision 1.7
/reporting/rep101.php - revision 1.7
/reporting/rep201.php - revision 1.7
Unfortunately the records are already saved in the X_debtor_trans table with this minus sign for trans type 1. You can use phpMyAdmin to edit your database, table X_debtor_trans and select View and find the records for trans type 1 and remove the minus sign from the amount.
Then everything will work ok.
/Joe
Both the Customer Transactions as well as Supplier Transactions are positively, that is invoices are displayed as debits (charges) and payments/deposits are displayed as credits. The reason is to have a uniform way of display.
/Joe
Maybe we can attract Tom to help us with this. He modified the Import Customers to also work with osCommerce. The developers are very busy with the 2.2 release.
/Joe
Well, I hope somebody using ubuntu can help here. I have a Windows developing environment.
You might try to download the frontaccount-2.1.3.tar.gz instead of the zip version. This version has been assembled by Janusz. He is using Linux as development environment.
And install this instead and extract the strings using this new installment. Maybe it is better.
And maybe somebody else can advise us here. I haven't heard about this line end problem before.
/Joe
Forgive me, I am not following you exactly. The only thing that is in transit here is the money. You haven't received anything until you have done your second payment.
This is how I would treat it:
1. PO to supplier, with correct required dates.
2. Payment 1 and 2 done to the supplier on the two dates.
3. Enter the receival per 30th jan and the supplier invoice. The receival and invoice could also be entered at once, but with correct future dates.
/Joe
Yes, why not. Just like the Inventory Items Movements inquiry, right?
But you will have to wait until release 2.2 for this I guess. Maybe it could be in 2.1.4 if this would be released before.
/Joe
jackel7007,
Did you try to fix the settings in the editor as explained on Mantis?
Also I see another thread regarding the missing strings for translation. There was a missing _ (underscore) bebore the parantheses. Please check that this has been fixed in your source. The CVS Main repository is updated with this fix, but you can also fix that yourself, as told in the other thread.
/Joe
I can see the following usage:
1. You have sent a customer invoice on $100.
2. You get a payment from your customer on $98. Instead of having a remainder of $2, you dicide to give him a discount of $2 and a payment of $98.
3. The invoice gets fully allocated.
You may have a normal payment terms of 10 days net to a supplier. If you pay in advance (cash) you get a discount of 2%.
1. Supplier Invoice $100.
2. You pay at once $98 and a discount of $2.
3. The invoice gets fully allocated.
/Joe
No, you cannot undo the creation of the invoices. However, you can void the invoices. To try again, you can temporarily set the days and months to 0. It will make it due once again.
The start date is only an informative field.
/Joe
Yes, this is an excellent way of doing it. You can then use quick entries for depreciations and include the dimensions here. You will get a good overview over your hardware/furniture this way.
/Joe
This has been fixed in CVS Main repository.
Download the following files:
/sales/create_recurrent_invoices.php - revision 1.4
/sales/sales_order_entry.php - 1.11
from
/Joe
I will look at it tomorrow.
/Joe
The tax inquiries are picked up from the X_tax_trans_details table, where X is the company no. You may look into the table by using the utility phpMyAdmin and select your database.
You should see all the transactions, both input and output.
But you may have run into a presentation bug if you use the Journal Entry or Bank Payment/Deposit form.
You can download the files:
/gl/includes/db/gl_db_banking.inc - revision 1.9
/gl/includes/db/gl_db_trans.inc - revision 1.14
/reporting/rep709.php - revision 1.4
from the CVS Main repository
/Joe
This is the correct link:
Download the revision 1.5
and the file /reporting/reports_main.php:
Download the revision 1.11
Both files are belonging to CVS Main trunk (2.1.3)
/Joe
And the correct Tax Group is set on the Suppliers? If this is the fact, I have no idea of what has gone wrong. I only know that it should work ok if set correctly.
/Joe
Hello again,
Everything seems to be ok, but you could try to download the chart of accounts script, en_US-new.sql from the CVS MAIN repository. Download the file with release 1.8 from the MAIN trunk.
There might be some kind of error in your copy of the file.
You can find it here:
It is important that you download the release 1.8 !
/Joe
Please check that you have setup correct Sales Tax accounts and Purchase Tax accounts on the Tax Types.
Also check that you have setup the correct Item Tax Types and correctly set the exempt values.
/Joe
Please try the new /reporting/rep304.php at the CVS Main Trunk.
/Joe
Thanks Tu for pointing this out 
/Joe
Did you see this Janusz?
/Joe
The attachments are stored under /company/X/attachemtns where X is the company number.
I am not sure if we are going to do anything further regarding the attachment feature. You have a total overview in the attachment form.
/Joe
Steven, can you give us a description of you server environment, please. Linux/Windows OS? Mysql version? PHP version?
Just to give us a chance to locate the problem.
/Joe
Try to address this question directly to t2webby or look into the source code.
/Joe
I guess there is some report that reports the sales. It could eventually be changed to include a column with this info. I will have a look at it when returning from a holiday. Back on Friday.
/Joe
I am out of office right now, sitting on some stairs next to a barn in the country side surfing with my laptops in my knees.
I will be back late Friday and will have a look at this.
/Joe
Posts found: 4,251 to 4,275 of 4,990
