Thank you Joe and really hope to try the new 2.4 version and I hope to open new topic about "how we can make Frontaccounting the best" to get the ideas from the members that can help in this, and of course I'll share my ideas with you

Congratulations to you , I think we cooperated with you few years ago and I hope we can cooperate again and I hope your solution will be improved to be fully compatible with the IFRS and IFRS Taxonomy
Note: "if you want any help we are ready"

the email sent to you include all the required files for Arabic language along with new 8 digits Arabic and English Templates can be used directly by restoring them in a new company

Shortly we are going to update the Arabic translation language with updated chart of accounts compatible with GAAP English and Arabic

5

(10 replies, posted in Translations)

again I'm back

please submit to me the po file include the last terms I translated and the terms not translated

my email is hameed@infotechaccountants.com

for Arabic language Joe know my email , he can send me the poedit file and I'll take care about

best regards

I think there is some confusion here , to be accurate we have to call those costs other manufacturing costs not overheads or we can call it manufacturing overheads also , example of those costs , grease of machines that you are using in production stage or nuts or oil or any other expenses that will be allocated to the orders , the general overheads like cleaning expenses or office electricity expenses this is differ from the manufacturing overheads or other manufacturing costs which must be allocated to the particular orders , so what we talk about before is about the other manufacturing costs or manufacturing overheads not general overheads.

I hope that this will be clear now and actually I do respect investopedia website but this website is a definition website so if you need to refer to a reference you can refer to a cost accounting book .

Thank you for paying my attention for this , but you didn’t get the point that I referred to , what I meant here is the additional manufacturing costs or indirect costs must be allocated to the produced units because if you will not allocate those costs the cost of produced items will not be accurate and this will be reflected to the gross profit and as we studied the cost of production must be include direct labor and direct material and other manufacturing costs which is consists of indirect labor and indirect material and other manufacturing costs and this is what I referred to
So what I mentioned in the topic here is that we have to measure the cost of production in the best way and actually there are a lot of methods applied for this now a days like ABC , but in our case here we are talking about simple manufacturing procedures , so yes there are effects will be in gross profit if you will not measure your production costs in a proper way and if you will not allocate those indirect costs or other manufacturing cost to the work order .
Any way try to return back to any cost accounting reference and I’ll do the same and you are most welcome to discuss any accounting issues here , and if I’m right or wrong I’ll thank you .

Actually during the testing one important consideration related to the principles the must be rectified by the developer .

First of all I did a test of one work order to produce 10 pcs from one code FG-01

FG-01 = 3 pcs of RM-01 and 2 pcs of RM-02

if we have the cost 1 pc of RM-01 = 2.14 and cost of 1 pc of RM-02 = 1.57

according to the FrontAccounting process the cost of stock item code FG-01 = 3x2.14 + 2x1.57 = 9.56$

and this is the problem here ....... why this I'll answer in the next few lines

in cost accounting the cost of manufacturing consists of three main category of costs
1- material cost
2- labour cost
3- other manufacturing costs ( overheads )

actually in FrontAccounting all those three category can be as issuing the material will be loaded to work order automatically and the other costs can be allocated directly also through bank payment of work order which we can pay the labour and the overheads
but what we expected as accountants to find all those costs ( labour costs and overheads ) to be loaded or allocated to the stock of finished goods , for example if we have a labour cost of 3.5 per pc and overheads 2 per pc this mean what we expected to be in the inventory valuation report is a value of 15.06 as a cost of manufacturing for FG-01 , but instead of this the inventory valuation report just include the material cost and ignore the other important costs which must allocated to the manufactured goods

the effect of this will make a very big problem when calculating the gross profit at the end of the period and in estimation of cost of goods sold and profitability for each item

in our case here if we are selling FG-01 in price of 20$ so according to the current process in FrontAccounting the cost of goods sold for one pc will be 9.56 and the gross profit will be in our case here 10.44 , in the accurate case the gross profit per pc must be 4.94 making a difference of 5.5

Pleas try to review the process of the other costs loaded to the work order to be counted to the inventory valuation report generated .

Maybe this because of my browser , I'll try it

there is some strange behavior happening , the assemble type worked with me and then giving me the same message again “The work order cannot be processed because there is an insufficient quantity for component: RM-01 - Raw Material - 01. Location: Warehouse – 01”


I think there is some thing wrong , can you check please one time more and try this maybe you will find bugs

12

(7 replies, posted in Items and Inventory)

yes it is comming again , but why this behavior comming ?

13

(7 replies, posted in Items and Inventory)

also check the demo located in your website you will find the same problem

14

(7 replies, posted in Items and Inventory)

demouser
password

15

(7 replies, posted in Items and Inventory)

Dear Joe

Please check /inventory/manage/items.php? , I can't edit the items , check in demo link http://infotechaccountants.com/fatraining

When choosing advanced manufactured as a type of work order every thing going fine but what about the other two options in the type list “assemble , unassemble” ?
Because when I’m choosing assemble as a type of work order it is showing me that message “The work order cannot be processed because there is an insufficient quantity for component: RM-01 - Raw Material - 01. Location: Warehouse – 01”

Thank you Joe , Continuing in Testing .........

During testing procedures and after passing through all the steps of work order till the producing step every thing seems to be OK , but when I went through producing by pressing the button of "produce" one general ledger transaction must be done which I guess it is predefined , and here is the transaction I found


By 14000 Stock 95.59
    To 14000 Stock 64.29
    To 14000 Stock 31.30

but what it should be is


By 14002 Finished Goods 95.59
                To 14000 Stock 64.29
                To 14000 Stock 31.30

and if we want to be more accurate we have to add more procedure when the material and the costs loaded to the work order by doing this transaction for the raw material issuance


By 14001 Work In Process 95.59
                To 14000 Stock 64.29
                To 14000 Stock 31.30

then when the production finished

By 14002 Finished Goods 95.59
                To 14000 Stock 64.29
                To 14000 Stock 31.30

and the transaction of the other cost should be

By 14001 Work In Process 50
                To 11000 Bank 50
               
you have to note that we are as accountants some times using intermediate accounts for the purpose of internal control so we can do the previous transaction like this

By Wages xxx
To Bank xxx

By Work in Process xxx
to Wages xxx


so please try to fix the transaction that will be processed when producing the finished goods in the light of the last notes

the bank accounts changed in the sql script

The trial balance which you can get from Inquiries and Reports not designed in a good way and this is the remarks about it :

1- the brought forward columns must show the net not the movements in both debit and credit side , I mean it must show the difference between the debit and credit side and if the debit greater than credit then the difference must be in debit side and if the debit less than credit then the difference must be in credit side

2- this period columns OK as it is showing the total of transactions activities in both sides debit and credit

3- the balance columns must be the same way I described in No. 1

Best regards
Hameed

Thank you Joe , I'm testing now again

Again Joe

If the case that we are having here is that the requirements of the work order will be obtained from bom , at least once the work order get the raw material according to the bom then the activity of this must be reflected to the inventory status and inventory activity , which it doesn't in our case
I tried the reports related to inventory "inventory valuation report " showing me the same quantities I purchased without any deduction , on the other side the "stock check sheets " showing me zero balance for inventory for all the material that I purchased

now I need from you to have a look again in this because the flow chart must be as I'm going to update the work order the material must be shipped to the work order and must be minus from the inventory and all of this activities must appear to me in the inventory item movements query and inventory item status query also

so can you please try to generate the process again , if there is anything I'm missing you can tell me here

Best regards

I don't think so , because I checked the activity of the raw material and no activity done , this mean there is something must be adjusted

Thanks for your great efforts

When I'm trying the manufacturing module I made the purchasing of the raw material and I checked the inventory status and also I setup the BOM , but when I'm going to process the work order by doing the second step after placing the work order which is Issue Items to Work Order this strange message came to me

" The issue cannot be processed because an entered item would cause a negative inventory balance : - "

Best Regards

Thank you My Friend Joe

I'm continuing in checking the solution , purchasing operations done , now I'm in Manufacturing

Best Regards