Menu
▾
▴
Re: [webERP-users] Sub accounts
|
From: cd d. <cdd...@gm...> - 2017-02-22 17:01:35
|
Steven: I am ashamed I could not explain myself on this matter. Sorry for introducing unnecessary noise in this listserver. The issue was not on P/L itself but the printout. Hope the following clarify my problem. BTW the solution is very neat. Gilberto dos santos alves was kind enough to set me up a weberp instance with all kind of permissions, so I can configure it to my like. Result: There is no way to make sub-accounts in weberp. The alternative is to make sub-groups and I like the result. For those interested , here is a snapshot of the P/L report I was looking to tailor. I wanted to put it in the weberp demo site for the benefit of the visitor, but group editing is disabled for the moment. Below you may see "L2 Fretes Vendas" which I make it a subgroup of "L1 Fretes Vendas" which in turn is a subgroup of "Fretes Vendas". Account are conveniently numbered 5611, 5610 , 5600 , to follow old school numbering, which make them more familiar for accountants, *but there is no need for that* since grouping can dot it in a much neater way than hard-coding the account numbers. I added prefixes in the group names, to point out that you are entering sub-group (I1) or sub-sub-group (I2) ... the subgroup totals do have underscore indentation for the same intention though, and add-up correctly. [image: Imagen integrada 1] Once again thank you all for your help. Antonio Vega. 2017-02-20 19:26 GMT-06:00 Steven Tang <st...@sh...>: > Hi Antonio, > > I think your question is, you would like to input an "expenses" as > production cost. Right? I am not sure if I understand correctly. > > Actually, WebERP not really allow to doing like this. All the GL account, > only can be in or out by setting GL account as a Bank account. > > If you you want to put and expenses cost, you need to set it in "items". > When you adding a new type of "Item" in "Inventory Categories Maintenance", > you need to set the account information for that type. > > When the item you move, it will be put in to related GL. > > In your case, you need to Make a type of inventory categories for your > P001. and add an "item" for P001. And setting the account GL when this > type Action. > > If your want it to be count in 5100. You need to figure how you stock > issue. If you use Work order, than you need the WIP GL Code to 5100 or > 5110 as you like. But if you issued P001 by internal issue, than set there. > > If you try to us "Quantity Adjustments" to issue items from warehouse, it > is a wrong action. this is just for stock adjust. However, you can also > set GL code to 5100. But it is not a good solution. Normally, it should > be set as "Inventory Adjustment" in GL. > > I hope I understand correctly your question and you understand what I said. > > > Best Regards, > > Steven Tang > ✉: ste...@gm... > > > > > cd delmundo 於 21/02/2017 6:33 寫道: > > gsavix: > Indeed, P/L statement is a report. It shows the accumulative amount > (between two dates) of those accounts marked as P/L accounts. That is not > in doubt. > > > Specifically my dobuts on the demo site would be two: > a)How to set up "5110 Production expenses on P001" to be a sub-account > of "5100 Production expenses" > b)Once that is done, I will ask for P/L report to see how setup will > it be rendered > > > I was trying to fool around account groups to achieve that, but somehow > "admin" user is not set up to edit them. > I installed weberp in my computer, but I am having trouble to set it up > correctly...so is of no use until I install it correctly..that is why I am > waiting for some help from the community. > > Regads > Antonio Vega > > 2017-02-14 18:11 GMT-06:00 gilberto dos santos alves <gs...@gm...>: > >> hi. p & l are result account. imo jornal transactions are for daily >> operations that will be led to final profis or losses. if i get the point >> from your question. >> >> Em 14/02/2017 20:04, "cd delmundo" <cdd...@gm...> escreveu: >> >> Hi: >> I am evaluating webERP to confirm its functionality and to decide if it >> will be sufficient for the intended job. >> Looks very good,congratulations, but I stumble into a issue that I >> guess. it is because I am doing something wrong. >> >> On webERP demo I introduced an account 5110 "Production expenses on >> P001" >> It 5110 account is a P/L type that belongs to "COGonP001 group" >> "COGonP001" parent group is "Cost of Goods Sold" >> >> I would say , so far so good. You will correct me if not. >> >> Then I wanted to type a Jounal Entry for that account in order to see >> how is rendered in the Profit&Loss statement. >> To my surprise, I was not able register the Journal Entry (nor >> manually nor via drop down listing) because webERP says "The account code >> 5110 doesnt exist" ...tough, as you can see, is is listed on >> LGAccounts.php 's Demo Site. Below a snapshot. >> >> [image: Imagen integrada 1] >> >> >> [image: Imagen integrada 2] >> >> So my petition would be if anyone can guide me on how to achieve >> sub-accounts on webERP, how to control its display on the P/L or >> BalanceSheet printout & a way to regiter a Journal Entry for such an >> account. >> >> I guess a correction in the Demo Site for that setup will be helpful >> for everybody since seems to be a lack of such functionality on it to show >> to the interested visitors. >> >> Regards >> Antonio Vega >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> >> >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, SlashDot.org! http://sdm.link/slashdot >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> >> > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > > _______________________________________________ > web-ERP-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-users > > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > |
