Search options (Page 3 of 6)

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

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

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

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.

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

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.

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

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.

Hello Janusz,

Thanks for your response.

I followed the procedure you gave me by going to the *_sys_pref table to manually change the Version number to 2.3rc. On changing it, the default company worked but the other companies are still showing the error "Access to application has been blocked until database upgrade is completed by system administrator."
How do I make the other companies work since it is a multi-company setup.

Thanks so very much

Popsicles12

Hello Janusz,
thanks for your support.
Could you please tell me how I can locate the fix the database scheme respectively. What I mean is how to I go about the fixing of the database to allow for the upgrade.
Pls, kindly help out.

thank you

Popsicles12