51 Reply by popsicles12

(28 replies, posted in Items and Inventory)

Hello Joe,

This is the error I get from Phpmyadmin when I try to import database to  be used by 2.4.7. #1062 - Duplicate entry '16381-10' for key 'PRIMARY'.
how do I correct this.

thanks.

Popsicles12

Go to forum: Items and Inventory

52 Reply by popsicles12

(28 replies, posted in Items and Inventory)

Thanks Joe.

Sorry to bother you a little. Is there a table in the database that I can correct this for the meantime as we use this report to check the profit margin per product and to know which product is doing well and the one not doing well.
Please.
Secondly, I wanted to install 2.4.7 fresh and import my database into it. but the database is large 150MB and it is complaining of timing out. I increase the timing in php.ini and now it is complaining of table duplication. The database in question is an update from 2.2. Any ideas?
thanks.

Popsicles12

Go to forum: Items and Inventory

53 Reply by popsicles12

(28 replies, posted in Items and Inventory)

Hello Joe,

Could you Please attend to my question "Standard Cost Changes and as such result to Negative Profit in Report". I have been stock with the above problems.
Please help out. This errors is not allowing out books to balance. As where you are to make a profit, the software shows losses which is not supposed to be.

Thanks.

Popsicles12

Go to forum: Items and Inventory

54 Reply by popsicles12

(28 replies, posted in Items and Inventory)

Hello Apmuthu,

Please could you kindly attend to my initial post before boxygen answer. As boxygen answer does not answer my question.

I updated from 2.4.3 to 2.4.7 thinking as you suggested that the negative figure for Contribution will be rectified. But after the update the problem still persist.
Present more problems have erupted as I cannot do Location transfer, I cannot void any document, etc.

What I need you to help me do is how do I eliminate the negative figure for the Contribution (profit) per product, How do I prevent it from happening in future?
Moreso, How come the system calculates a cost that is higher that your selling price. How can I stop this from happening?
How do I make this current update void documents and do location transfer.
How do I upload my database into a new 2.4.7 installs seeing that my database is very large 150MB.

thanks Apmuthu in anticipation of your prompt response.

Popsicles12

Go to forum: Items and Inventory

55 Reply by popsicles12

(28 replies, posted in Items and Inventory)

Hello Apmuthu,
Thanks for your reply on rep304. I have upgraded from 2.4.3 to 2.4.7 but the problem still persist. I still have products that have negative profit due to the fact that the system calculated higher cost for the products.

My question is this.
1. How do the system calculate cost that it is now higher than the selling price?
2. How do i rectify this once and for all so that it does not reoccur again?
3. Do I need to put standard cost for all products or leave it blank?

Secondly, I try to upload the database of 130MB into a new installation of 2.4.7 but it is giving me database duplication error. I dont know why. It there another way to do this as I am using PhpMyAdmin cos from within Frontaccounting, it is giving me error. I suppose because the file is large.

Kindly help out apmuthu

thanks

Popsicles12

Go to forum: Items and Inventory

56 Topic by popsicles12

(3 replies, posted in Installation)

Hello apmuthu,

I tried restoring my database which is about 135MB but I have this error "Allowed memory size of 335544320 bytes exhausted (tried to allocate 24 bytes) in C:\xampp\htdocs\frontaccount\admin\db\maintenance_db.inc on line 326".

how do I correct this error to make sure my database is restored.

I have increase the max upload file size but to no avail.

kindly help.

thanks
Popsicles12

Go to forum: Installation

57 Reply by popsicles12

(28 replies, posted in Items and Inventory)

Hello Apmuthu,

Thanks for your prompt response. I am using Version 2.4.1. I dont know whether it is a bug. For example, standard Cost is say 250 per item. Purchase price is 250 for like One month, and on the third month it is 257 and maybe after another one month it is 260. I expect normally that it will take up the purchase price. On checking the report I discovered a negative contribution.
I went into the database to check and discovered that the products that have negative contribution has a standard cost of 850 when purchase price has never exceeded 280 per item.
Why this?

thanks and expecting more clarification.

Popsicles12

Go to forum: Items and Inventory

58 Topic by popsicles12

(28 replies, posted in Items and Inventory)

Hello All,

Thanks everyone for keeping frontaccounting flying higher. Kudos to Joe and his team.

There is this problem I have in frontaccouting.
1. When I generated the Inventory Sales Report, I discovered that the Cost is higher than the Sales therefore resulting in Negative Contribution.
2. The date picker on the Inventory Sales Report is not working

How do I correct this? Pls Joe & apmuthu kindly help.

Thanks
Popsicles12

Go to forum: Items and Inventory

59 Reply by popsicles12

(11 replies, posted in Reporting)

hello Joe,
Could you please help me resolve the question I asked apmuthu as regards getting the customer balances per location. That is getting the report of  customer balances and Aged customer analysis based on each location. He did help me to an extent but getting the filters into the rep101 and rep102 is what is remaining. If you can give me a clue or guide me through I will be most grateful.

Thanks in advance,

Popsicles12

Go to forum: Reporting

60 Reply by popsicles12

(11 replies, posted in Reporting)

Hello apmuthu,

I am still expecting your reply please.

thanks
Popsicles12

Go to forum: Reporting

61 Reply by popsicles12

(11 replies, posted in Reporting)

hello apmuthu,
thank for your prompt response.
I need you to help me with this as I am not good in sql programming.  kindly help with with the steps to accomplish this.
thanks so much. expecting your reply.

popsicles12

Go to forum: Reporting

62 Reply by popsicles12

(11 replies, posted in Reporting)

Hello apmuthu,
Thanks for the response. I did the change to the file but it did not work. I think there is something we must add to rep101 and 102.
Could you pls tell me what to correct and how to correct it.
Thanks.

Popsicles 12

Go to forum: Reporting

63 Reply by popsicles12

(11 replies, posted in Reporting)

Thanks apmuthu for your reply.
Could you please tell me how to insert the location filter  into the report? Or tell me what to do and how to do it. I will be expecting your reply.
Thanks.

Popsicles.

Go to forum: Reporting

64 Reply by popsicles12

(11 replies, posted in Reporting)

Thanks apmuthu for you reply. If you take a look at the customer balances and customer Aged receivables report, there is no option to select customer balances pee location. How do I insert this option in the report. Kindly assist.

Thanks.

Popsicles12

Go to forum: Reporting

65 Topic by popsicles12

(11 replies, posted in Reporting)

Hello all,

I created about 3 locations for our 3 different warehouses. We have customers that are supplied by the sales reps of each warehouse. i.e. each warehouse has its customers.

I want to be able to generate their balances based on the location. That is if I am printing customer balances/ Aged receivable I should have the option of saying I want the report for only location 1, or location 2. Moreso if I am printing customer balances for all the location I should be able to have them group and totalled per location.

thanks.

Popsicles12.

Go to forum: Reporting

66 Reply by popsicles12

(5 replies, posted in Accounts Receivable)

Hello Apmuthu,

Thanks for your continuous support.
I have another issue right now. When I raise an invoice because the rows of the invoice is much, it will get to point where when I try to add a new row, it will be looking at you and not respond. You click on add again, it will be same, after clicking like 3 to 4 times, it will now add the rows and add 4 rows indicating the number of times you clicked on add.

the slow nature of the software is alarming. sometime, when you click add, it will be there for like 5mins.

what do I do. How do I correct this anomaly. previous like 3 months back it used to be very fast. The Frontaccounting server is on a LAN with 5 users connected via LAN to the server.

Pls help.

Thanks
Popsicles12.

Go to forum: Accounts Receivable

67 Reply by popsicles12

(5 replies, posted in Accounts Receivable)

Hello Apmuthu,

Thanks for your reply. This I have been doing but it always reoccur and it is causing problems. How do I stop it completely. since it is not happening in the other company, only on this.

Kindly help as I do not want the reoccurence.

thanks
Popsicles12

Go to forum: Accounts Receivable

68 Topic by popsicles12

(5 replies, posted in Accounts Receivable)

Good day Joe,

I just discovered that when I raise an invoice and save in one of the companies I created, it will try to process the invoice but return with the error symbol of a triangle. when I click it to reprocess, it will do that and sometime completes the process.
When I go to check the invoice i will discover that it has duplicated the products on the invoice and created two delivery note for the duplicated products.

Eg. say this is the invoice:

10      Toothpaste                 2.5       25.00
5         Noodles                      1.0        5.00
                                                         30.00

after processing twice due to the error, i get this

10      Toothpaste                 2.5       25.00
5         Noodles                      1.0        5.00
10      Toothpaste                 2.5       25.00
5         Noodles                      1.0        5.00
                                                         60.00

How do I correct this error. It is really affecting our stock report as we have to manually check the invoices to see where the error is.

Kindly help.

Thanks

Popsicles12

Go to forum: Accounts Receivable

69 Reply by popsicles12

(27 replies, posted in FA Modifications)

Hello Anoopmb,I would also like to have the source code.  I have similar needs here for the license and expiry date too.
Kindly email me the link.corkernel@gmail.com

Thank you.

Go to forum: FA Modifications

70 Reply by popsicles12

(6 replies, posted in Setup)

Thanks for the reply.

The System I am using is a Core2 Duo CPU with 500GB Hard Drive and a 3GB RAM. I have about 6 users on it. So I do not think that is the cause of it. Is there any configuration in php.ini that I need to change so that this backup goes on. Cause I discovered that when I start backing up, it will continue until i stops by itself. sometime it show the error mark and sometime it does not.  What other options do I need to exploit.

thanks.

Popsicles12

Go to forum: Setup

71 Reply by popsicles12

(6 replies, posted in Setup)

Thanks apmuthu for your reply.

I had to delete my SQL audit trail using phpmyadmin and still I cannot back up. what do you advice that I do to even know what is causing the problem and solving it.

Thanks.

Popsicles12

Go to forum: Setup

72 Topic by popsicles12

(6 replies, posted in Setup)

Hello Joe,

Thanks for your continued support.

I tried to backup my database for version 2.2.24 and it did not backup. It will initialize backup and after a while it will stop without any indication of backup complete message.

I later discovered the database is big about 245MB. how do I correct and get my backup done.

thanks.

popsicles12

Go to forum: Setup

73 Topic by popsicles12

(1 replies, posted in Accounts Receivable)

Hello All,

I am confused about this allocate customer Payment option. There is a customer that is supposed to have a nil balance, but on checking it, it is showing -3500.00 which was allocated. how do I revert this and what is the function of allocate Customer Payment.
Secondly how do I make the forms update automatically. I am using ver. 2.3.11 and when I void a payment and try to post again, it will be telling me "the reference has been used before". how do I change this?

Thanks

Popsicles12

Go to forum: Accounts Receivable

74 Topic by popsicles12

(2 replies, posted in Accounts Receivable)

Hello All,

I have a situation right now. I upgraded from 2.2.11 to 2.3.11 and now when I enter invoice say 24511 which is deference from the what is setup (say 11522) in the system and save the invoice, when I open a fresh invoice, it is still showing me 11522. Previously, it automatically updates itself and brings 24512 which is the next number to the new invoice I just entered. How do I correct this as it so in the customer payment.

please help.

thanks.

Popsicles12

Go to forum: Accounts Receivable

75 Reply by popsicles12

(25 replies, posted in Installation)

Hello Janusz,
I commented out the default company but the login page will not display on the browser. it was showing error of not connecting to the default database.
If I may ask, since there is a difference on the database schema of the default company and the other companies as the default company has 79 tables while the other companies has 75 tables, how do I make the other companies upgrade to 79 tables. The missing tables as as follows; 0_crm_category, 0_crm_contacts, 0_crm_persons and 0_sys_prefs.

What if I create one of the companies with the 2.3 database schema and dump the database, will it upgrade? please help out.

thanks

Popsicles12.

Go to forum: Installation