You can subscribe to this list here.
2003 |
Jan
(1) |
Feb
|
Mar
(20) |
Apr
(24) |
May
(7) |
Jun
(5) |
Jul
(4) |
Aug
(35) |
Sep
(34) |
Oct
(21) |
Nov
(39) |
Dec
(15) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(11) |
Feb
(30) |
Mar
(60) |
Apr
(98) |
May
(61) |
Jun
(33) |
Jul
(44) |
Aug
(102) |
Sep
(59) |
Oct
(152) |
Nov
(86) |
Dec
(39) |
2005 |
Jan
(96) |
Feb
(117) |
Mar
(75) |
Apr
(144) |
May
(78) |
Jun
(47) |
Jul
(58) |
Aug
(87) |
Sep
(89) |
Oct
(120) |
Nov
(43) |
Dec
(15) |
2006 |
Jan
(142) |
Feb
(55) |
Mar
(67) |
Apr
(79) |
May
(44) |
Jun
(62) |
Jul
(104) |
Aug
(90) |
Sep
(38) |
Oct
(70) |
Nov
(17) |
Dec
(80) |
2007 |
Jan
(108) |
Feb
(121) |
Mar
(33) |
Apr
(17) |
May
(18) |
Jun
(60) |
Jul
(62) |
Aug
(101) |
Sep
(94) |
Oct
(117) |
Nov
(44) |
Dec
(23) |
2008 |
Jan
(106) |
Feb
(67) |
Mar
(169) |
Apr
(73) |
May
(101) |
Jun
(112) |
Jul
(125) |
Aug
(149) |
Sep
(139) |
Oct
(162) |
Nov
(92) |
Dec
(88) |
2009 |
Jan
(199) |
Feb
(219) |
Mar
(372) |
Apr
(246) |
May
(146) |
Jun
(159) |
Jul
(276) |
Aug
(146) |
Sep
(143) |
Oct
(76) |
Nov
(65) |
Dec
(208) |
2010 |
Jan
(129) |
Feb
(76) |
Mar
(127) |
Apr
(131) |
May
(90) |
Jun
(237) |
Jul
(108) |
Aug
(75) |
Sep
(39) |
Oct
(92) |
Nov
(118) |
Dec
(63) |
2011 |
Jan
(96) |
Feb
(146) |
Mar
(190) |
Apr
(141) |
May
(142) |
Jun
(109) |
Jul
(112) |
Aug
(182) |
Sep
(115) |
Oct
(100) |
Nov
(278) |
Dec
(169) |
2012 |
Jan
(134) |
Feb
(156) |
Mar
(161) |
Apr
(81) |
May
(16) |
Jun
(72) |
Jul
(99) |
Aug
(64) |
Sep
(90) |
Oct
(47) |
Nov
(86) |
Dec
(49) |
2013 |
Jan
(29) |
Feb
(14) |
Mar
(12) |
Apr
(25) |
May
(10) |
Jun
(26) |
Jul
(12) |
Aug
(17) |
Sep
(6) |
Oct
(3) |
Nov
(13) |
Dec
(27) |
2014 |
Jan
(18) |
Feb
(14) |
Mar
(17) |
Apr
(17) |
May
(23) |
Jun
(25) |
Jul
(25) |
Aug
(12) |
Sep
(7) |
Oct
(33) |
Nov
(39) |
Dec
(12) |
2015 |
Jan
(21) |
Feb
(39) |
Mar
(41) |
Apr
(9) |
May
(16) |
Jun
(7) |
Jul
(8) |
Aug
(2) |
Sep
|
Oct
|
Nov
(24) |
Dec
(12) |
2016 |
Jan
(15) |
Feb
(17) |
Mar
(23) |
Apr
(11) |
May
(3) |
Jun
(7) |
Jul
(3) |
Aug
|
Sep
(5) |
Oct
(5) |
Nov
(2) |
Dec
|
2017 |
Jan
|
Feb
(12) |
Mar
(14) |
Apr
|
May
(1) |
Jun
(10) |
Jul
(7) |
Aug
(5) |
Sep
(3) |
Oct
(1) |
Nov
|
Dec
|
2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2019 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2020 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2021 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(27) |
Nov
|
Dec
(5) |
2025 |
Jan
|
Feb
(56) |
Mar
(28) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Regal R. <reg...@gm...> - 2017-03-31 16:05:39
|
Anxiously interested in the feedback. Russ On Wed, Mar 29, 2017 at 2:40 PM, Dale Scott <dal...@sh...> wrote: > Is anyone on the list using webERP in Canada for a SME? Can you explain > the general involvement of webERP, and how it was that webERP was accepted > by the accountant? > > > > I’ve heard this now from several people in Canada (accountants and IT > people who work with accountants), that SME-type businesses here absolutely > require a QBO connector so their accountant can close the books in QB, even > though the business may be run on webERP. Is this true? Are there > work-arounds? Sorry my background is engineering and manufacturing, not > finance. > > > > Many thanks, > Dale > > > > --- > > Dale R. Scott, P.Eng. > > Chief Engineer > > dalescott.net > > *Transparency with Trust* > > Blog: http://www.dalescott.net > > LinkedIn: https://ca.linkedin.com/in/dalescott > > > > ------------------------------------------------------------ > ------------------ > 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 > > -- Regal Products Ltd 18 Freeman Rd. St. Augustine, Trinidad & Tobago tel- 868-663-1740 / 1 fax- 868-645-0330 |
From: Dale S. <dal...@sh...> - 2017-03-29 18:40:20
|
Is anyone on the list using webERP in Canada for a SME? Can you explain the general involvement of webERP, and how it was that webERP was accepted by the accountant? I've heard this now from several people in Canada (accountants and IT people who work with accountants), that SME-type businesses here absolutely require a QBO connector so their accountant can close the books in QB, even though the business may be run on webERP. Is this true? Are there work-arounds? Sorry my background is engineering and manufacturing, not finance. Many thanks, Dale --- Dale R. Scott, P.Eng. Chief Engineer dalescott.net Transparency with Trust Blog: http://www.dalescott.net <http://www.dalescott.net/> LinkedIn: https://ca.linkedin.com/in/dalescott |
From: Dale S. <dal...@sh...> - 2017-03-20 18:27:25
|
Hi, no replies from posting to the users list last week so I'm also posting here in the hope someone will enjoy pointing out the error of my ways ;-) I'm getting "empty" work order "Paperwork" and "Labels", with only the company logo on each page. I expect the answer will be suitably and annoyingly obvious in hindsight, but until I get this sorted I can't really give any manufacturing demos. I would also very much appreciate some guidance explaining the overall work order process, and how the paperwork and labels were intended to be used. Many thanks! Dale P.S. I updated the manufacturing walkthrough I'm working on to show what I've done so far. http://www.dalescott.net/manufacturing-using-weberp From: "dalescott" <dal...@sh...> To: "For the general discussion of webERP project" <web...@li...> Sent: Friday, March 17, 2017 12:20:48 PM Subject: Printed work order and work order labels are blank pages?!? BQ_BEGIN Hi, I tried printing the work order "Paperwork" and "Labels", but the generated PDFs only have company logos on the pages, nothing else. I created a work order, issued raw material, and received the output back into stock (but didn't close the work order). I searched again for the work order, and then followed the "Print W/O" link to print the Paperwork and Labels. Are the PDFs blank because I have already essentially completed the work order? The manual is great for explaining the impact on accounts, but can anyone clarify some basics for me? (I expect this would be more obvious if the printed docs had ended up with content in them) * When would I typically print the work order? * Is the intent to use the printed work order as a traveller for the WIP? * What are the work order labels for? * What do I use for a pick list? (for picking the raw materials from the stock shelves) Fwiw, if you want to see pics, you can see a skeleton draft skeleton of my manufacturing tutorial here: http://www.dalescott.net/manufacturing-using-weberp/ Many thanks, Dale BQ_END |
From: Dale S. <dal...@sh...> - 2017-03-17 18:20:57
|
Hi, I tried printing the work order "Paperwork" and "Labels", but the generated PDFs only have company logos on the pages, nothing else. I created a work order, issued raw material, and received the output back into stock (but didn't close the work order). I searched again for the work order, and then followed the "Print W/O" link to print the Paperwork and Labels. Are the PDFs blank because I have already essentially completed the work order? The manual is great for explaining the impact on accounts, but can anyone clarify some basics for me? (I expect this would be more obvious if the printed docs had ended up with content in them) * When would I typically print the work order? * Is the intent to use the printed work order as a traveller for the WIP? * What are the work order labels for? * What do I use for a pick list? (for picking the raw materials from the stock shelves) Fwiw, if you want to see pics, you can see a skeleton draft skeleton of my manufacturing tutorial here: http://www.dalescott.net/manufacturing-using-weberp/ Many thanks, Dale |
From: Phil D. <ph...@lo...> - 2017-03-17 03:23:39
|
I am not sure it makes a big difference with innodb tables to be brutal. Given the delay I've stopped using it. Adding the commands to a cron job directly on the server at some off peak time seems more sensible. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 16/03/17 09:43, Dale Scott wrote: > > Thanks Gilberto and Phil. > > Can you say anything about how big a deal it is to run OPTIMIZE TABLE > periodically? How “bad” does it get if you don’t OPTIMIZE TABLE > periodically, and in what sort of context? (e.g. number of > users/items/orders). How long can it take OPTMIZE TABLES take to run? > I’m aware I’m asking a loaded question and “it depends”, but any > generalities? Fwiw, my server is an old dual-core desktop with 8GB > RAM. I just forced DB_Maintenance to run now and the delay until > “fully logged in” was long enough I might have appreciated a “sorry > for the delay” notice. > > Also, the manual recommends scheduling DB_Maintenance as a cron job, > but doesn’t say how. I can use wget and a URL to execute a *.php file, > but how do you execute just one function from within an *.inc file? Or > would you put a mysql command directly into the cron table (with the > query given as an argument to the mysql command)? > > Thanks, > Dale > > *From:*Phil Daintree [mailto:ph...@lo...] > *Sent:* Tuesday, March 14, 2017 11:02 PM > *To:* For the general discussion of webERP project > *Subject:* Re: [webERP-users] how to prevent access during upgrade > > Yes there is a configuration (webERP/System Parameters.php) setting > for this - under perform database maintenance at logon > > Phil > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 15/03/17 14:50, Dale Scott wrote: > > How do you prevent user access when you require sole access to the > webERP app or the database server for some reason. E.g. upgrade, > patch, restore database backup, etc. > > Is there any built-in facility for dealing with "temporarily out > of order, please come back later." Can anyone share a procedure > that works for them? Is anyone bringing up a new server, > synchronizing databases, and cutting over live? Not that I want > to, but I'd like to know in case I need to some day. > > Cheers! > > Dale > > > > > ------------------------------------------------------------------------------ > > 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... > <mailto: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 |
From: gilberto d. s. a. <gs...@gm...> - 2017-03-16 14:31:24
|
hi. global providers already take care for this kind of infra-estructure. hostgator.com are very ok with shared hosts only about US 7,00 by month. Any way, you do not need run any concerns about performance related about mysql 5.5 or 5.6 or 5.7. for local pc or intranet pc allways pain is pc or server that run this main if are running all this on windows. triple checks. -- gilberto dos santos alves +5511986465049 2017-03-15 17:43 GMT-03:00 Dale Scott <dal...@sh...>: > Thanks Gilberto and Phil. > > > > Can you say anything about how big a deal it is to run OPTIMIZE TABLE > periodically? How “bad” does it get if you don’t OPTIMIZE TABLE > periodically, and in what sort of context? (e.g. number of > users/items/orders). How long can it take OPTMIZE TABLES take to run? I’m > aware I’m asking a loaded question and “it depends”, but any generalities? > Fwiw, my server is an old dual-core desktop with 8GB RAM. I just forced > DB_Maintenance to run now and the delay until “fully logged in” was long > enough I might have appreciated a “sorry for the delay” notice. > > > > Also, the manual recommends scheduling DB_Maintenance as a cron job, but > doesn’t say how. I can use wget and a URL to execute a *.php file, but how > do you execute just one function from within an *.inc file? Or would you > put a mysql command directly into the cron table (with the query given as > an argument to the mysql command)? > > > > Thanks, > Dale > > > > > > *From:* Phil Daintree [mailto:ph...@lo...] > *Sent:* Tuesday, March 14, 2017 11:02 PM > *To:* For the general discussion of webERP project > *Subject:* Re: [webERP-users] how to prevent access during upgrade > > > > Yes there is a configuration (webERP/System Parameters.php) setting for > this - under perform database maintenance at logon > > Phil > > > > Phil Daintree > > Logic Works Ltd - +64 (0)275 567890 > > http://www.logicworks.co.nz > > On 15/03/17 14:50, Dale Scott wrote: > > How do you prevent user access when you require sole access to the webERP > app or the database server for some reason. E.g. upgrade, patch, restore > database backup, etc. > > > > Is there any built-in facility for dealing with "temporarily out of order, > please come back later." Can anyone share a procedure that works for them? > Is anyone bringing up a new server, synchronizing databases, and cutting > over live? Not that I want to, but I'd like to know in case I need to some > day. > > > > Cheers! > > Dale > > > > > > > ------------------------------------------------------------------------------ > > 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 > > |
From: Dale S. <dal...@sh...> - 2017-03-15 20:43:19
|
Thanks Gilberto and Phil. Can you say anything about how big a deal it is to run OPTIMIZE TABLE periodically? How "bad" does it get if you don't OPTIMIZE TABLE periodically, and in what sort of context? (e.g. number of users/items/orders). How long can it take OPTMIZE TABLES take to run? I'm aware I'm asking a loaded question and "it depends", but any generalities? Fwiw, my server is an old dual-core desktop with 8GB RAM. I just forced DB_Maintenance to run now and the delay until "fully logged in" was long enough I might have appreciated a "sorry for the delay" notice. Also, the manual recommends scheduling DB_Maintenance as a cron job, but doesn't say how. I can use wget and a URL to execute a *.php file, but how do you execute just one function from within an *.inc file? Or would you put a mysql command directly into the cron table (with the query given as an argument to the mysql command)? Thanks, Dale From: Phil Daintree [mailto:ph...@lo...] Sent: Tuesday, March 14, 2017 11:02 PM To: For the general discussion of webERP project Subject: Re: [webERP-users] how to prevent access during upgrade Yes there is a configuration (webERP/System Parameters.php) setting for this - under perform database maintenance at logon Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 15/03/17 14:50, Dale Scott wrote: How do you prevent user access when you require sole access to the webERP app or the database server for some reason. E.g. upgrade, patch, restore database backup, etc. Is there any built-in facility for dealing with "temporarily out of order, please come back later." Can anyone share a procedure that works for them? Is anyone bringing up a new server, synchronizing databases, and cutting over live? Not that I want to, but I'd like to know in case I need to some day. Cheers! Dale ---------------------------------------------------------------------------- -- 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 |
From: Phil D. <ph...@lo...> - 2017-03-15 05:03:38
|
Yes there is a configuration (webERP/System Parameters.php) setting for this - under perform database maintenance at logon Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 15/03/17 14:50, Dale Scott wrote: > How do you prevent user access when you require sole access to the > webERP app or the database server for some reason. E.g. upgrade, > patch, restore database backup, etc. > > Is there any built-in facility for dealing with "temporarily out of > order, please come back later." Can anyone share a procedure that > works for them? Is anyone bringing up a new server, synchronizing > databases, and cutting over live? Not that I want to, but I'd like to > know in case I need to some day. > > Cheers! > Dale > > > > ------------------------------------------------------------------------------ > 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 |
From: gilberto d. s. a. <gs...@gm...> - 2017-03-15 02:06:29
|
hi. see manual docs, source and you will see that weberp alreary have flags that controls when update (soon after login) and if is setup in config panel for automatic update. in my installs i use .htaccess file for setup a message with aditional locale messages for restricted access (only users that have user/password created for apache2 .htaccess) can reach on weberp login screen. -- gilberto dos santos alves +5511986465049 2017-03-14 22:50 GMT-03:00 Dale Scott <dal...@sh...>: > How do you prevent user access when you require sole access to the webERP > app or the database server for some reason. E.g. upgrade, patch, restore > database backup, etc. > > Is there any built-in facility for dealing with "temporarily out of order, > please come back later." Can anyone share a procedure that works for them? > Is anyone bringing up a new server, synchronizing databases, and cutting > over live? Not that I want to, but I'd like to know in case I need to some > day. > > Cheers! > Dale > > > ------------------------------------------------------------ > ------------------ > 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 > > |
From: Dale S. <dal...@sh...> - 2017-03-15 01:50:09
|
How do you prevent user access when you require sole access to the webERP app or the database server for some reason. E.g. upgrade, patch, restore database backup, etc. Is there any built-in facility for dealing with "temporarily out of order, please come back later." Can anyone share a procedure that works for them? Is anyone bringing up a new server, synchronizing databases, and cutting over live? Not that I want to, but I'd like to know in case I need to some day. Cheers! Dale |
From: Dale S. <dal...@sh...> - 2017-03-13 06:06:28
|
Hi Gilberto, thanks for the feedback, and sorry for the bad link. The "big picture" is http://www.dalescott.net/purchasing-using-weberp/ I think I understand what you mean, but I need to work more examples to be sure. It was the manual that said there were two types, but looking at the form now, I still don't know how it makes a difference. Is the top part of the page the info for the cheque, and the bottom part pertains to where the money comes from? Now that I have fixed the "big picture" link, could you give an example of something that would be appropriate for each field? E.g. Cheque Reference? Cheque Narrative? Supplier Reference Notation? Supplier Narrative? Supplier Reference? Transaction Text? --- Dale R. Scott, P.Eng. Transparency with Trust Blog: http://www.dalescott.net LinkedIn: https://ca.linkedin.com/in/dalescott GitHub: https://github.com/dalers > On Mar 12, 2017, at 10:37 PM, gilberto dos santos alves <gs...@gm...> wrote: > > hi. seems link 1 and 2 are same. > my suggestion is make payment using vendor payments and leave that module produce general ledger events. > IMHO this could give advantage from what type of vendors and material that you are using (row material, finish goods, workman ship, freight, taxes). > > with this method you could use lot of payments to compose one bordero and then make one bank check for pay that bordero that sum all transactions for a day or a period or a sucursal. > > regards. > > -- > gilberto dos santos alves > +55(11)9-8646-5049 > sao paulo - sp - brasil > > > > > > 2017-03-13 0:28 GMT-03:00 Dale Scott <dal...@sh...>: >> Hello list, when is a general ledger payment preferred to a payment to a supplier, or vice versa? I read the manual, but I don't understand why. If it makes any difference, I'm looking for the simplest overall procedure >> >> I'm trying to follow a full purchasing cycle but the accounting stuff has me stuck again. I created and and printed a PO, received the stock and created a vendor invoice. Now I want to pay the vendor, but I don't know if I should be making a "general ledger payment", or a "payment to a supplier". >> >> Here's the screen I'm looking at: http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png >> >> I'm documenting the big picture here: http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png >> >> >> Thanks in advance, >> Dale >> >> --- >> Transparency with Trust >> Blog: www.dalescott.net >> Resume: www.linkedin.com/in/dalescott/ >> >> ------------------------------------------------------------------------------ >> Announcing the Oxford Dictionaries API! The API offers world-renowned >> dictionary content that is easy and intuitive to access. Sign up for an >> account today to start using our lexical data to power your apps and >> projects. Get started today and enter our developer competition. >> http://sdm.link/oxford >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> > > ------------------------------------------------------------------------------ > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
From: Phil D. <ph...@lo...> - 2017-03-13 05:08:19
|
if youve created the supplier/vendor and the purchase is for stock/inventory then you want the system to maintain stock/inventory values you must enter the supplier/vendor invoice - as this updates the PO and inventory with the actual cost. To do this you need to make the invoice match against purchase order receipts of stock/inventory by clicking on the purchase orders button. This shows all the purchase orders received items for you to select. http://yourhost/webERP/doc/Manual/ManualContents.php?ViewTopic=AccountsPayable#SupplierInvoice Given that you now have a supplier/vendor invoice in the system you will have it orphaned and showing a creditor amount unless you enter a creditor payment. Payables->Select Supplier->Enter Invoice Payables->Select Supplier->Enter Payment to Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 13/03/17 17:21, gilberto dos santos alves wrote: > hi. seems link 1 and 2 are same. > my suggestion is make payment using vendor payments and leave that > module produce general ledger events. > IMHO this could give advantage from what type of vendors and material > that you are using (row material, finish goods, workman ship, freight, > taxes). > > with this method you could use lot of payments to compose one bordero > and then make one bank check for pay that bordero that sum all > transactions for a day or a period or a sucursal. > > regards. > > -- > gilberto dos santos alves > +55(11)9-8646-5049 > sao paulo - sp - brasil > > > > > > 2017-03-13 0:28 GMT-03:00 Dale Scott <dal...@sh... > <mailto:dal...@sh...>>: > > Hello list, when is a general ledger payment preferred to a > payment to a supplier, or vice versa? I read the manual, but I > don't understand why. If it makes any difference, I'm looking for > the simplest overall procedure > > I'm trying to follow a full purchasing cycle but the accounting > stuff has me stuck again. I created and and printed a PO, received > the stock and created a vendor invoice. Now I want to pay the > vendor, but I don't know if I should be making a "general ledger > payment", or a "payment to a supplier". > > Here's the screen I'm looking at: > http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png > <http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png> > > I'm documenting the big picture here: > http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png > <http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png> > > > Thanks in advance, > Dale > > --- > Transparency with Trust > Blog: www.dalescott.net <http://www.dalescott.net> > Resume: www.linkedin.com/in/dalescott/ > <http://www.linkedin.com/in/dalescott/> > > ------------------------------------------------------------------------------ > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up > for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > _______________________________________________ > web-ERP-users mailing list > web...@li... > <mailto:web...@li...> > https://lists.sourceforge.net/lists/listinfo/web-erp-users > <https://lists.sourceforge.net/lists/listinfo/web-erp-users> > > > > > ------------------------------------------------------------------------------ > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > > > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
From: gilberto d. s. a. <gs...@gm...> - 2017-03-13 04:22:07
|
hi. seems link 1 and 2 are same. my suggestion is make payment using vendor payments and leave that module produce general ledger events. IMHO this could give advantage from what type of vendors and material that you are using (row material, finish goods, workman ship, freight, taxes). with this method you could use lot of payments to compose one bordero and then make one bank check for pay that bordero that sum all transactions for a day or a period or a sucursal. regards. -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil 2017-03-13 0:28 GMT-03:00 Dale Scott <dal...@sh...>: > Hello list, when is a general ledger payment preferred to a payment to a > supplier, or vice versa? I read the manual, but I don't understand why. If > it makes any difference, I'm looking for the simplest overall procedure > > I'm trying to follow a full purchasing cycle but the accounting stuff has > me stuck again. I created and and printed a PO, received the stock and > created a vendor invoice. Now I want to pay the vendor, but I don't know if > I should be making a "general ledger payment", or a "payment to a supplier". > > Here's the screen I'm looking at: http://www.dalescott.net/wp- > content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_ > newark_from_bank_account.png > > I'm documenting the big picture here: http://www.dalescott. > net/wp-content/uploads/2017/03/weberp-item-90000001-00_ > purchase-023_payment_to_newark_from_bank_account.png > > > Thanks in advance, > Dale > > --- > Transparency with Trust > Blog: www.dalescott.net > Resume: www.linkedin.com/in/dalescott/ > > ------------------------------------------------------------ > ------------------ > Announcing the Oxford Dictionaries API! The API offers world-renowned > dictionary content that is easy and intuitive to access. Sign up for an > account today to start using our lexical data to power your apps and > projects. Get started today and enter our developer competition. > http://sdm.link/oxford > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > |
From: Dale S. <dal...@sh...> - 2017-03-13 03:28:42
|
Hello list, when is a general ledger payment preferred to a payment to a supplier, or vice versa? I read the manual, but I don't understand why. If it makes any difference, I'm looking for the simplest overall procedure I'm trying to follow a full purchasing cycle but the accounting stuff has me stuck again. I created and and printed a PO, received the stock and created a vendor invoice. Now I want to pay the vendor, but I don't know if I should be making a "general ledger payment", or a "payment to a supplier". Here's the screen I'm looking at: http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png I'm documenting the big picture here: http://www.dalescott.net/wp-content/uploads/2017/03/weberp-item-90000001-00_purchase-023_payment_to_newark_from_bank_account.png Thanks in advance, Dale --- Transparency with Trust Blog: www.dalescott.net Resume: www.linkedin.com/in/dalescott/ |
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 > > |
From: Steven T. <st...@sh...> - 2017-02-21 01:50:25
|
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... > <mailto: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... > <mailto: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. > > Imagen integrada 1 > > > 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... > <mailto:web...@li...> > https://lists.sourceforge.net/lists/listinfo/web-erp-users > <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... > <mailto:web...@li...> > https://lists.sourceforge.net/lists/listinfo/web-erp-users > <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 |
From: gilberto d. s. a. <gs...@gm...> - 2017-02-21 01:39:54
|
hi Antonio. 1 - please tell us detailed mode what is "but I am having trouble to set it up correctly" 2 - If you think that is necessary i could provide [adhoc] environment for your tests. let me know. -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil |
From: cd d. <cdd...@gm...> - 2017-02-20 22:33: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 > > |
From: ExsonQu <hex...@gm...> - 2017-02-15 01:53:19
|
*Hi,* I cannot reproduce the problem you described. Since accounts can be authorized, it maybe you have no authority for it. You can check the demo again. If any problem, please post the operation step. Best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Sub-accounts-tp4658741p4658742.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
From: gilberto d. s. a. <gs...@gm...> - 2017-02-15 00:11:37
|
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 |
From: Belinda E. <bel...@se...> - 2017-02-14 22:45:47
|
Please unsubscribe this email address Kindest regards B On 15 Feb 2017, at 9:03 am, cd delmundo <cdd...@gm...> wrote: 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.png> <image.png> 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 |
From: cd d. <cdd...@gm...> - 2017-02-14 18:03:50
|
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 |
From: ExsonQu <hex...@gm...> - 2017-02-02 22:49:57
|
Hi, Bob, You can use inventory adjustment to correct this problem. It's currently the only method available in weberp. I've developed some scripts to improve the serial no control facility before but it's not available now since i'm out of office in the following weeks. Best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Changing-a-serial-number-tp4658735p4658738.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
From: rfthomas <rf...@as...> - 2017-02-02 14:39:37
|
Our version is 4.13.1. We do have phpmyadmin. Currently it would be for 4 items. Unfortunately, we did not catch this problem early enough in our manufacturing so we need to have some means of updating history or formally noting that a serial number was changed. Also we are seeing inventory counts that are incorrect when adds and removes are performed of serial numbered items. The user attempted to correct the problem by deleting the part with wrong serial number and then adding parts with correct serial number. He did this 3 times and the stated quantity on-hand is 12 instead of 4. HE was using the ability to make a notation when removing and inserting items so that there was an audit trail. -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Changing-a-serial-number-tp4658735p4658737.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
From: gilberto d. s. a. <gs...@gm...> - 2017-02-02 00:10:19
|
hi. please what is your version? are you using phpmyadmin? how many itens? -- gilberto dos santos alves +55(11)9-8646-5049 sao paulo - sp - brasil 2017-02-01 15:44 GMT-02:00 rfthomas <rf...@as...>: > Is there a means/utility to changing the serial number of an inventory > item? > If we receive/create a serialized item and the user mistypes the serial > number there is no obvious way to correct the error. So far the only > mechanism is to delete the item and re-enter it. The problem occurs when > there is significant activity involving the mis-serialized item. Deleting > the item does correct/update the item's history. > > > > -- > View this message in context: http://weberp-accounting. > 1478800.n4.nabble.com/Changing-a-serial-number-tp4658735.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------ > ------------------ > 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 > |