Hello Jujuk,
Please try to be a little more detailed when illustrating the case. We have worked hardly on the average material costing lately, together with Chaitanya from India. So I really hope this works now.
/Joe
3,276 03/31/2011 09:52:45 pm
Re: GL on the sale of "Average Price/Standar Costs" (3 replies, posted in Banking and General Ledger)
3,277 03/31/2011 09:46:59 am
Re: search in customer reports (9 replies, posted in Reporting)
Yes, we are releasing 2.3.3 today and it is included here.
/Joe
3,278 03/30/2011 12:07:45 pm
Re: Entry purchase in a closed fiscal year (3 replies, posted in Accounts Payable)
If you enter Supplier Invoice (on the right side of the Purchase tab) and select the supplier, you will see received items. You can remove the line(s) that were included in the wrongly entered GRN. You must have access to this (you probably already have).
By removing the line(s) it will dispear and the GL transactions will be counterbooked.
This should cure it and you can enter the GRN under the correct fiscal year.
The bug is fixed and will be included in 2.3.3
/Joe
3,279 03/30/2011 07:19:44 am
Re: Entry purchase in a closed fiscal year (3 replies, posted in Accounts Payable)
You should not be allowed to enter a supplier invoice on a closed year. This is a bug. Thanks.
/Joe
3,280 03/29/2011 07:23:59 am
Re: income statement / year end (3 replies, posted in Banking and General Ledger)
Well, if you have sophisticated subgrouping under Expense, then create another group with a higher ID than Expense and call this group Net Result or something. Change the group for account year p/l result to this new one. Then everything will be shown correctly.
/Joe
3,281 03/28/2011 09:12:17 am
Re: Qestions about Official Company Number, GSTNo Add Price from Std Cost (4 replies, posted in Setup)
Hi and welcome.
The GSTNo is the Tax ID and yes is eualent to your RFC. This ID is by default printed on the invoices. The company number is the company registration number from the authorities.
If you enter a percent in 'Add Price from Std Cost' you will get this percent increase on the prices from the average purchase price. Otherwise you can also setup the prices in Items and Inventory.
/Joe
3,282 03/28/2011 07:10:21 am
Re: income statement / year end (3 replies, posted in Banking and General Ledger)
You are not doing anything wrong. Your net income is now in the your newly create account. If you followed the instructions to place this account as your last expense account, you should have your income stamement ok.
/Joe
3,283 03/27/2011 07:23:45 am
Re: Determination Suggestions Order in Inventory Planning Report (4 replies, posted in Items and Inventory)
I open for better algorithms. Though very busy right now. Please do some research and eventually either tell me the new algorithm that should replace the existing one or change the file and send it me.
/Joe
3,284 03/26/2011 11:49:22 pm
Re: How to get warning when selling under cost price ? (6 replies, posted in Accounts Receivable)
This is a good idea. Will be implemented in next release, 2.3.3, shipping next week.
/Joe
3,285 03/26/2011 10:30:18 pm
Re: How to include sales price in inventory transfer report? (3 replies, posted in Items and Inventory)
No, it is really not neeed. The prices are independent of any locations.
/Joe
3,286 03/26/2011 10:21:31 pm
Re: Shortage in Stock Check Sheets Report (6 replies, posted in Items and Inventory)
8. No not needed.
I see the problem you have.
I will try to explain how FA works.
Stock moves are created on Sales Deliveries, PO Receivals, Work Order (simple), Work Order Advances - Production and Adjustments.
Sales orders create 'Demand', POs and WOs advanced before Production create 'On Order'.
So as you see, as long as you have not done any Production of the Work Order, the QOH will not be correct.
I hope you understand me. To avoid these things, I recommend to Produce the items before putting them on the Sales Orders. You will, however, not be able to deliver the items (or even produce them) if you get negativ stock (with the accept negative stock unmarked).
/Joe.
3,287 03/26/2011 04:15:07 pm
Re: Whats is "Branch" (6 replies, posted in Accounts Receivable)
A branch is normally not a legal entity like a subsidiary. This is the reason for not allowing statements by branch.
You should consider use Customers for these branches and eventually group them together to easy see their belongings.
/Joe
3,288 03/26/2011 02:55:50 pm
Re: Shortage in Stock Check Sheets Report (6 replies, posted in Items and Inventory)
Please try to explain exactly everything you have done so I can monitor the process.
Without a work order the demand is as you describe. The work order is needed to handle the stock correctly. But after the work order is created it is correct.
/Joe
3,289 03/26/2011 08:43:47 am
Re: Shortage in Stock Check Sheets Report (6 replies, posted in Items and Inventory)
1. you have 'Allowed negative stock' enabled.
2. You made a sales order, but you forgot to make a work order of 3. If you do that, you will see that everything is ok.
/Joe
3,290 03/24/2011 10:27:22 am
Re: Determination Suggestions Order in Inventory Planning Report (4 replies, posted in Items and Inventory)
This algorithm was there already when we took over the project. I am not sure of the origin. If you have a better algorithm, then please share it with us.
/Joe
3,291 03/24/2011 07:44:09 am
Re: Modules Add on (8 replies, posted in Modules Add-on's)
I have sent you the package by email. The repository is not updated yet.
/Joe
3,292 03/23/2011 02:19:11 pm
Re: SQL script execution failure (4 replies, posted in Installation)
Depending on if you selected demo data, the file is /sql/en_US-demo.sql, otherwise, en_US-new.sql.
/Joe
3,293 03/23/2011 07:13:34 am
Re: SQL script execution failure (4 replies, posted in Installation)
I guess you are using a new MySQL database version. Open the SQL script in a text editor and replace 'TYPE=' with 'ENGINE='
MySql is no longer backwards compatible in newer versions.
/Joe
3,294 03/21/2011 10:05:10 am
Re: Volunteer translators for installaion wizard messages needed (48 replies, posted in Translations)
The back link in various windows should be translated.
/Joe
3,295 03/20/2011 09:21:16 am
Re: Volunteer translators for installaion wizard messages needed (48 replies, posted in Translations)
No these are special kind of characters for a new line, new page and tab. You should just use the same characters, i.e. \n
/Joe
3,296 03/20/2011 09:18:24 am
Re: change font size of pdf (1 replies, posted in Reporting)
You can set the default $fontsize = 9 to another value (take care of the column margins) in the constructor function FrontReport in file /reporting/includes/pdf_report.inc.
/Joe
3,297 03/16/2011 01:14:05 pm
Re: New suppliers are not saved (2 replies, posted in Accounts Payable)
Please check that you don't have the checkbox marked in Company Setup, Search Supplier List. In that case you see no suppliers but have to search for them (with space bar and fragments).
/Joe
3,298 03/16/2011 07:12:05 am
Re: How to add opening stock ?? (1 replies, posted in Items and Inventory)
Please make a forum search about this. This has been handled in several places. Search on Open balance or something like that.
Also look in the https://frontaccounting.com/fawiki
/Joe
3,299 03/16/2011 07:10:03 am
Re: How to enter a invoice in back date ?? (1 replies, posted in Items and Inventory)
Please try for yourself on the Training Co.
It is ok with back date and invoices can be edited in certain situations. You will see in Customer Transactions which invoices are editable.
/Joe
3,300 03/15/2011 11:10:55 pm
Re: Requisition Module (4 replies, posted in Modules Add-on's)
Hi Dennis,
Thanks for your contributions. However there are some issues with the module.
1. In the hooks.php the link should be $path_to_root . "/modules/requisition_details.php"
2. In the /sql/update.sql file, the IF EXISTS after DROP FUNCTION should be there.
3. In the /sql/update.sql file, the table prefix should be for function get_item_tax
4. In the /sql/update.sql file, the reference in 0_generate_po to get_item_tax should have a table prefix.
Could you describe how to use this module, because I couldn't get it to work. I first entered a requisition and then moved to Requisition Allocation and added a new. When Generating PO nothing happened.
Anyhow the module looks promissing, but please tell us a little about what and how this module operates.
/Joe