It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by asaha
Pages 1
Assets are depreciated for number of years like 5 years, 10 years, etc. Now, if I have an item with a depreciation date in the financial year 2016-17, how can I process depreciation for that item for the current financial year, because only items with depreciation date falling in the active financial year are available to process.
I am sure I am getting something wrong here. Please help me out in this.
Thank you all in advance.
I think I may need to create a new post for my 2nd query. So I am closing this one.
Thank you all.
What about the 2nd query. Only items with depreciation date falling in current financial year are available. In that case how to process depreciation for items which we acquired say 2-3 years back?
Please help me in understanding this.
Thank you.
I am using FA 2.4.6 and trying to understand the 'Fixed Assets' module.
Followed instructions from wiki and set Categories, classes etc and then added Assets with 'Fixed Assets Purchases'.
When I clicked on 'Process Depreciation', I did not get the Fixed Assets items which I wanted to process. I enabled debugging to identify the issue. Now my queries are
1. In the 'Process Depreciation' page, I think, the 'Select an item' dropdown items comes from db_has_depreciable_fixed_assets function. In that function, items are filtered with till and from depreciation dates with 'depreciation_date < '".$y."-12-01' AND depreciation_date >= '".($y-1)."-12-01'") i.e. Month December. Only items with depreciation date between previous years December to this December (based on the active financial year from the setup) will be selected. For us in India, financial year starts from 1st April and ends on 31st March, so in that case shouldn't it be the month of March instead of December.
2. Assets are depreciated for number of years like 5 years, 10 years, etc. Now, if I have an item with a depreciation date in the year 2016, how can I process depreciation for that item for current financial year, because with our SQL query, only items with depreciation date falling in active financial year will be available to process. I am sure I am getting someting wrong here. Please help me out.
Thank you.
Upgraded to 2.4.6 and working fine. Thank you apmuthu.
View Sales Order # from 'Inquiry Drill down' won't show delivery and invoice details.
When changed 'if (!count_array($trans_no))' to 'if (!count($trans_no))' said details appear but throws error "count(): Parameter must be an array or an object that implements Countable in file: /sales/includes/sales_db.inc at line 366"
Testing 2.4.5 on PHP 7.2.
Joe, My query was with reference to 'List of Journal Entries' with 'rep702.php' file and so the issue is still there after this update.
Thank you Joe for your prompt response. I will check it. I am sorry for the late reply. Thank you once again.
Bug in Reports - Banking and Journal Ledgers - General Ledger - List of Journal Entries
If you raise this report and search for 'Work Order Production' you will find Work Order Production transactions.
If the work order is for 'Assembled items' then the the value of input items should be debited and the output / assembled item value should be credited. The issue is, instead of the assembled item here in this report the last input item listed is also named as the output or assembled item with credit value.
Item material costs (standard costs) are changing with each transaction even with same purchasing price. am i missing something?
hi jow, thank you for your fast reply. the issue has been resolved.
how can i hide restricted links from menu and application pages instead of just disabling them from un-authorized user.
please suggest me how could one handle items used in manufacturing like spare parts or oils or fuels etc. used for machines.
if i create a new warehouse for the same and then transfer them into that warehouse while issuing them for usage, they will show up when stocks are verified. is there any better way to manage these kind if items in FA.
thank you all for sharing such an exceptional product and support.
Hi,
past one month i have been using FA and am very much impressed the way it does things. past one week or 10 days, i have been working on customizing FA based on our organizations needs. while doing the customization work a thought suddenly came into my head - how does FA perform with huge data?
i work in a fruit and vegetable processing organisation where we buy fruits and vegetables from farm growers. we buy our raw material i.e. fruits and vegetables directly from farm growers (more than 2000 of them) who supply fruits and vegetables in very small quantities (on an average 50-60 KGs) twice or thrice a week. due to this we use to have a lot of transactions aprox. 1500-2000 transactions a day.
so, i wanted to know whether the FrontAccounting supports such a huge volume of data, I mean around 2000 transactions a day i.e more than 700,000 transactions a year. and don't forget, we will have to keep records of at least a couple of years old.
guys out there who have a knowledge about these issues or people who are already using FA under these circumstances please let me know FA's performance under such volume of data and if you could please suggest me what precautions i need to take.
thank you in advance.
hey guys,
while doing the customization work a thought suddenly came into my head - whether the FrontAccounting supports such a load I mean around 2000 transactions a day i.e more than 700,000 transactions a year. and don't forget, one need to keep records of at least a couple of years old.
so, what do you guys think. how does the FA perform with such a huge volumes of data? What precautions one should take?
please forgive me if this sounds like a a dumb question.
one more thing i wish to share with you guys. i completed the customization work and i must confess that it is pretty simple to do. hats off to all the FA developers and contributors and thank you all so much for making such a good application and making it so simple to customize.
thank you all once again.
hi tm,
you are right about creating a comprehensive API to read and write operations.
i will look into it and see what i can do and come back to you if i need any suggestions.
thank you.
hi barbarian,
let me try to explain the differences between the purchases and procurement activity we do in our organization.
1. prices
purchasing prices are different with different suppliers.
procurement prices are same for all suppliers.
2. placing order and invoicing
purchasing process starts from placing a purchase order -> GRN -> invoice (ofcourse, we can jump directly to GRN or to purchase invoice bipassing others).
we directly place procurement invoice (fortunately FA supports this).
3. No of Transactions:
we hardly make 5-10 purchases transactions a day.
on the other hand we make 1500-2000 procurement transactions a day.
4. Payments:
we make procurement payments every monday.
as you can see, though core functionality of both of them are same, the procurement activities are slightly different in the way we handle things. we need to make slight modifications
in procurement invoice generation. the major problem would be differentiating and tracking procurement invoices, due payments and cleared payments from thoses of purchases.
i wish the 'dimensions' feature support purchases and suppliers as extensively as it does with sales and customers.
anyway, i thought of creating a new item type and then cloning the core functionality of item type 'purchase' to new porposed item type 'procurement' and make the
necessary customization to procurement forms and reports. but as you mentioned in your post that it would be very hard to modify the core functionality the FA.
i take your word on that. and may be that is the reason why joe didnot respond for my request for creation of new 'Item Type'.
anyways, for now, as i mentioned in my previous post, i created a new purchase category as 'Procurement' and trying to make necessary customization to forms and reports.
i followed you suggestion (thank you for that) and created a 'Standard Procurement Price' for procurement products. in the purchase orders based on the item category, prices
will be displayed in purchase orders / invoices (i.e. supplier prices for purchased items and standard procurement prices for procurement items).
FA developers and contributors gave a meticulous attention to detail that, so far, the work on the customization has been prety easy (being a newbee in php, i didn't
expect i could reach so far). Hats off to them.
with that confidence, i will be adding a new field to the supplier table to differentiate regular supplier from the 'farm grower'. based on that, will be generating procurement
reports, payments, etc.
at least, that is the idea. any suggestions or ideas in this direction are more than welcome.
further, as i mentioned in my previous psot, i wish to develop a code to import procurement invoices in excel / csv format into FA. if you have any idea
in this regard, please guide me in this.
thank for your time and support.
hi joe,
at the moment i am customizing the code with Item Category along with Item Type. i have added an Item Category 'Procurement' with Item Type as 'Procurement' and based on the Item Category's category_id trying to customize invoices, procurement prices and other reports.
the problem in this is that the user may edit the 'Procurement' category and the whole idea will go down.
1. so, i wish to create a new Item Type as 'Procurement' which cannot be edited by the user.
if that is not possible, please suggest me how could i make the Item Category to be blocked from editing like Stock Location code (which i guess could only be updated by directly editing it in database, please let me know if i am wrong here).
2. i would be greatfull if you could let me know how can i control the supplier / item dropdown lists.
i have created a new procurement invoice entry form and i want to display only producers in the supplier list and only procurement items in items description dropdown list.
3. so far i completed adding procurement invoices and added procurement price list for procurement items. once all procurement related forms and reports are done i would like to develop an extension for the same and contribute it the FA forum with guidance from all you senior members of FA.
hi tm,
i am very much interested and thinking of developing such an extension. any suggestions in this direction will be appreciated.
hi swheeler,
i tried with dimensions without success. i guess, we cannot apply dimensions to the purchase order / purchase invoice just like we could with the sales order / sales invoice. and if we need to apply dimensions to supplier payments we need to make payments through banking and general ledger menu. i did go through a post in this regard in Accounts Receivable section but i could not find a solution for supplier invoices or payments. if i am missing some point here please point it out to me.
thank you all guys for your time.
dear joe,
thank you for your reply. but i am afraid, i completely missed your point.
let me explain.
we have a procurement activity which is slightly different with regular purchases activity as i mentioned in my above post. due this, we will have huge number of transactions every day in this category. so, wanted to differentiate procurement transactions with that of regular purchasing transactions. for this i wanted to add a new item type 'procurement', but i could not find where should i do that.
could you guide me in this directions? any other suggestions are also welcome.
further, as i mentioned in my previous post, we will have about 1500 to 2000 procurement transactions on a daily basis and we are already using an application from where we can export procurement invoices in excel / csv format. is it possible to import these procurement transactions into frontaccount. please guide me in this. thank you in advance.
most of the times both are same. But in the food processing industry there is a slight difference between them. let me explain.
purchasing department will take care of buying materials, cost control, find good vendor/supplier and negotiate the price, and so on and so forth. in the food processing industry and especially in the organisation where i work, there is another department called procurement department which works slightly differently then the purchase department does.
i work in a fruit and vegetable processing organisation where we buy fruits and vegetables from farm growers. purchasing price for these fruits and vegetables are fixed for all the farm growers and the price will vary by a couple of cents (fraction of a dollar) depend on the quality fruits or vegetables. due to this we have around 700 products (basically all are same only differentiated by quality) based on the prices as explained above.
now on the other side, we buy our raw material i.e. fruits and vegetables directly from farm growers (more than 2000 of them) who supply fruits and vegetables in very small quantities (on an average 50-60 KGs) twice or thrice a week.
due to this we use to have a lot of transactions of this sort.
now with FrontAccounting, we could do all these transactions with purchase module. only issue is that if we could differentiate the Farm Growes from regular Suppliers and the Raw Material (fruits and vegetables) from regular purchases, due to huge number of transaction it would be more convenient to track invoices, dues dates for payments, transactions, etc.
that is the reason why i wanted to add another Item Type - 'Procurement' through which i could differentiate transactions.
also, i wanted to add 'standard purchasing price' (as you mentioned in your advice and i thank you for that) field to only those products which are procured (cause here the price will be same for all farm growers).
any suggestions in this directions will be appreciated.
further, if i could mention it here in the Items & Inventory section, at the moment, we are handling all the procurement transactions with another application from which we can export them in excel / csv format. so, is it possible to import these procurement invoices in excel and csv format into FrontAccounting? what are the precautions i need to take to do that (importing procurement invoices) on a daily basis?
It seems that Item Types are built in. I need to add an item type 'Procured'. How can i do that? Someone please assist me in this.
Thank you 'barbarian'.
Your suggestion seems to work.
Though I am a newbie for php coding I would like to try myself to implement your suggestion and if i could complete the task successfully I would let you know.
Thanks again for your suggestion.
Is there a way to assign a default purchase price for a particular item?
I have more than 500 items and I buy these items from number of suppliers at same price.
For example, I buy item 'X' at $1 a piece from number of suppliers. Similarly, I have number of products which I buy from various suppliers at same price
So, I wish a single default purchase price to be applied to all the suppliers for these items. please let me know how could I do that.
Please help me in this.
Thank you in advance.
NOTE: started this topic in 'FA Modifications'. But then thought this is the right place for this topic so will be closing & deleting this topic in deleting 'FA Modifications'.
Pages 1
FrontAccounting forum → Posts by asaha
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.