Menu
▾
▴
web-erp-developers
|
From: James P. <wer...@ya...> - 2011-11-20 15:50:56
Attachments:
GoodsReceivedphpScreenShot.JPG
|
We have been using weberp since I can remember..... I have made lots of changes and thought I would share one that has helped confusion while receiving goods. This change allow the person receiving to click on the part number and in a new tab or window it will open the photo to help them identify the part. The people in receiving do not always know what the part is that they are signing in so I changed the line in the GoodsReceived.php file from echo '<td>' . $LnItm->StockID . '</td> to //jwp jpalof added line to show the parts picture if you click on part number echo '<td><a href="' . $rootpath . '/' . $_SESSION['part_pics_dir'] . '/' . $StockID . '.jpg" target="_blank">'. $LnItm->StockID . '</a><br /></td> This has been very helpful to us. Hopefully you can use it as well. I uploaded a screenshot of the changes that I sent our receiving person. james |
|
From: Tim S. <ti...@we...> - 2011-11-20 16:28:52
|
Thanks James, Tim On 20 November 2011 15:50, James Palof <wer...@ya...> wrote: > We have been using weberp since I can remember..... I have made lots of changes and thought I would share one that has helped confusion while receiving goods. > > This change allow the person receiving to click on the part number and in a new tab or window it will open the photo to help them identify the part. > > The people in receiving do not always know what the part is that they are signing in so I changed the line in the GoodsReceived.php file from > > echo '<td>' . $LnItm->StockID . '</td> > > to > > //jwp jpalof added line to show the parts picture if you click on part number > echo '<td><a href="' . $rootpath . '/' . $_SESSION['part_pics_dir'] . '/' . $StockID . '.jpg" target="_blank">'. $LnItm->StockID . '</a><br /></td> > > > > This has been very helpful to us. Hopefully you can use it as well. I uploaded a screenshot of the changes that I sent our receiving person. > > james > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > -- WebERP Africa Ltd +447710427049 +254706554559 www.weberpafrica.com |
|
From: Phil D. <ph...@lo...> - 2011-11-20 23:19:27
|
Great to have you back on board Tim - will leave it to you to commit. -- Phil Phil Daintree +64 (0)275 567890 GMT+12 http://www.logicworks.co.nz Tim Schofield <ti...@we...> wrote: >Thanks James, > >Tim > >On 20 November 2011 15:50, James Palof <wer...@ya...> wrote: >> We have been using weberp since I can remember..... I have made lots >of changes and thought I would share one that has helped confusion >while receiving goods. >> >> This change allow the person receiving to click on the part number >and in a new tab or window it will open the photo to help them identify >the part. >> >> The people in receiving do not always know what the part is that they >are signing in so I changed the line in the GoodsReceived.php file from >> >> echo '<td>' . $LnItm->StockID . '</td> >> >> to >> >> //jwp jpalof added line to show the parts picture if you click on >part number >> echo '<td><a href="' . $rootpath . '/' . $_SESSION['part_pics_dir'] . >'/' . $StockID . '.jpg" target="_blank">'. $LnItm->StockID . '</a><br >/></td> >> >> >> >> This has been very helpful to us. Hopefully you can use it as well. >I uploaded a screenshot of the changes that I sent our receiving >person. >> >> james >> >------------------------------------------------------------------------------ >> All the data continuously generated in your IT infrastructure >> contains a definitive record of customers, application performance, >> security threats, fraudulent activity, and more. Splunk takes this >> data and makes sense of it. IT sense. And common sense. >> http://p.sf.net/sfu/splunk-novd2d >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> > > > >-- >WebERP Africa Ltd >+447710427049 >+254706554559 >www.weberpafrica.com > >------------------------------------------------------------------------------ >All the data continuously generated in your IT infrastructure >contains a definitive record of customers, application performance, >security threats, fraudulent activity, and more. Splunk takes this >data and makes sense of it. IT sense. And common sense. >http://p.sf.net/sfu/splunk-novd2d >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Phil D. <ph...@lo...> - 2011-11-21 00:08:49
|
Nice, these are the practical improvements that make the system great. Another thought might be a quality inspection criteria page on the wiki so the goods received guy can see the how the inspection sample size is calculated and which measurements need to be checked. -- Phil Phil Daintree +64 (0)275 567890 GMT+12 http://www.logicworks.co.nz James Palof <wer...@ya...> wrote: >We have been using weberp since I can remember..... I have made lots of >changes and thought I would share one that has helped confusion while >receiving goods. > >This change allow the person receiving to click on the part number and >in a new tab or window it will open the photo to help them identify the >part. > >The people in receiving do not always know what the part is that they >are signing in so I changed the line in the GoodsReceived.php file from > >echo '<td>' . $LnItm->StockID . '</td> > >to > >//jwp jpalof added line to show the parts picture if you click on part >number >echo '<td><a href="' . $rootpath . '/' . $_SESSION['part_pics_dir'] . >'/' . $StockID . '.jpg" target="_blank">'. $LnItm->StockID . '</a><br >/></td> > > > >This has been very helpful to us. Hopefully you can use it as well. I >uploaded a screenshot of the changes that I sent our receiving person. > >james |
|
From: Vitaly S. <vsh...@so...> - 2011-12-12 21:35:24
|
Hi guys,
There are still a couple things that need to be fixed in
Z_ChangeStockCode.php.
$result = DB_query("SELECT COUNT(*) FROM
mrpplannedorders",$db,'','',false,false);
if ($DB_error_no==0) {
need to be
$result = DB_query("SELECT COUNT(*) FROM
mrpplannedorders",$db,'','',false,false);
if (DB_error_no($db)==0) {
Looks like $sql = 'SET FOREIGN_KEY_CHECKS=0'; needs to move up to just
before updating BOM table.
Thanks,
Vitaly
|
|
From: Phil D. <ph...@lo...> - 2011-12-13 07:51:16
|
I have applied your fix thanks Vitaly. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 13/12/11 10:08, Vitaly Shevkunov wrote: > Hi guys, > > There are still a couple things that need to be fixed in > Z_ChangeStockCode.php. > > $result = DB_query("SELECT COUNT(*) FROM > mrpplannedorders",$db,'','',false,false); > if ($DB_error_no==0) { > > need to be > > $result = DB_query("SELECT COUNT(*) FROM > mrpplannedorders",$db,'','',false,false); > if (DB_error_no($db)==0) { > > > Looks like $sql = 'SET FOREIGN_KEY_CHECKS=0'; needs to move up to just > before updating BOM table. > > Thanks, > Vitaly > > > ------------------------------------------------------------------------------ > Learn Windows Azure Live! Tuesday, Dec 13, 2011 > Microsoft is holding a special Learn Windows Azure training event for > developers. It will provide a great way to learn Windows Azure and what it > provides. You can attend the event by watching it streamed LIVE online. > Learn more at http://p.sf.net/sfu/ms-windowsazure > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
|
From: Vitaly S. <vsh...@so...> - 2011-12-20 19:10:41
|
Hello all, I am a little confused about using stock category types. Are dummy and service/labor types the same? Is there a difference in how to use them? Do I need to set up any GL accounts for these category types? Does the stock item type need to be dummy if category type is dummy or it could be something else? Thank you Vitaly |
|
From: Phil D. <ph...@lo...> - 2011-12-20 21:31:14
|
You can issue labour type items to work orders. This is also useful for subcontract costs that you wish to allocate to a works order. There was a question about this recently that slipped past without answer sorry. -- Phil Phil Daintree +64 (0)275 567890 GMT+12 http://www.logicworks.co.nz Vitaly Shevkunov <vsh...@so...> wrote: >Hello all, > >I am a little confused about using stock category types. >Are dummy and service/labor types the same? Is there a difference in >how >to use them? >Do I need to set up any GL accounts for these category types? >Does the stock item type need to be dummy if category type is dummy or >it could be something else? > >Thank you > >Vitaly > > >------------------------------------------------------------------------------ >Write once. Port to many. >Get the SDK and tools to simplify cross-platform app development. >Create >new or port existing apps to sell to consumers worldwide. Explore the >Intel AppUpSM program developer opportunity. >appdeveloper.intel.com/join >http://p.sf.net/sfu/intel-appdev >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Phil D. <ph...@lo...> - 2011-12-20 21:34:09
|
The gl posting defined against each stock category is cruical and I think well described in the manual? The category type is used on some searches, the item type is the key. -- Phil Phil Daintree +64 (0)275 567890 GMT+12 http://www.logicworks.co.nz Vitaly Shevkunov <vsh...@so...> wrote: >Hello all, > >I am a little confused about using stock category types. >Are dummy and service/labor types the same? Is there a difference in >how >to use them? >Do I need to set up any GL accounts for these category types? >Does the stock item type need to be dummy if category type is dummy or >it could be something else? > >Thank you > >Vitaly > > >------------------------------------------------------------------------------ >Write once. Port to many. >Get the SDK and tools to simplify cross-platform app development. >Create >new or port existing apps to sell to consumers worldwide. Explore the >Intel AppUpSM program developer opportunity. >appdeveloper.intel.com/join >http://p.sf.net/sfu/intel-appdev >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Vitaly S. <vsh...@so...> - 2011-12-20 22:32:03
|
Phil, I think I am starting to get the idea how it is supposed to work. Please, correct me if I am wrong. -Labour category type can be issued only to work order. -Dummy category type can be issued to sales orders to sale non-tangible services. -Is there something similar for the purchase orders? Sometimes we need to order some additional service with our purchase, like hardware test or special labeling. Right now I can only add regular stock items to the PO or go through GL accounts. Thank you Vitaly On 12/20/2011 3:30 PM, Phil Daintree wrote: > You can issue labour type items to work orders. This is also useful for subcontract costs that you wish to allocate to a works order. There was a question about this recently that slipped past without answer sorry. |
|
From: Phil D. <ph...@lo...> - 2011-12-20 22:52:48
|
you can enter purchase order items with no stock item at all with order a non-stock item option. A gl code for the item or service ordered is required if creditor gl interface is active -- Phil Phil Daintree +64 (0)275 567890 GMT+12 http://www.logicworks.co.nz Vitaly Shevkunov <vsh...@so...> wrote: >Phil, > >I think I am starting to get the idea how it is supposed to work. >Please, correct me if I am wrong. >-Labour category type can be issued only to work order. >-Dummy category type can be issued to sales orders to sale non-tangible > >services. >-Is there something similar for the purchase orders? Sometimes we need >to order some additional service with our purchase, like hardware test >or special labeling. Right now I can only add regular stock items to >the >PO or go through GL accounts. > >Thank you >Vitaly > >On 12/20/2011 3:30 PM, Phil Daintree wrote: >> You can issue labour type items to work orders. This is also useful >for subcontract costs that you wish to allocate to a works order. There >was a question about this recently that slipped past without answer >sorry. > > >------------------------------------------------------------------------------ >Write once. Port to many. >Get the SDK and tools to simplify cross-platform app development. >Create >new or port existing apps to sell to consumers worldwide. Explore the >Intel AppUpSM program developer opportunity. >appdeveloper.intel.com/join >http://p.sf.net/sfu/intel-appdev >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Vitaly S. <vsh...@so...> - 2011-12-20 23:01:23
|
Phil, Am I correct that Dummy/Labor categories only need one profit/loss GL account? There is no need for balance sheet account here? I.e. Inventory GL Code and WIP GL Code are ignored. Thank you Vitaly On 12/20/2011 3:33 PM, Phil Daintree wrote: > The gl posting defined against each stock category is cruical and I think well described in the manual? > The category type is used on some searches, the item type is the key. |
|
From: Phil D. <ph...@lo...> - 2011-12-20 23:25:47
|
You will notice that they change their labels... For labour type categories the stock gl account becomes the labour recovery account. There can be no stock adjustments for labour or dummys. However, the usage var account becomes the labour efficiency variance account, the price variance account is also required for labour types. -- Phil Phil Daintree +64 (0)275 567890 GMT+12 http://www.logicworks.co.nz Vitaly Shevkunov <vsh...@so...> wrote: >Phil, >Am I correct that Dummy/Labor categories only need one profit/loss GL >account? There is no need for balance sheet account here? I.e. >Inventory >GL Code and WIP GL Code are ignored. > >Thank you >Vitaly > > >On 12/20/2011 3:33 PM, Phil Daintree wrote: >> The gl posting defined against each stock category is cruical and I >think well described in the manual? >> The category type is used on some searches, the item type is the >key. > > >------------------------------------------------------------------------------ >Write once. Port to many. >Get the SDK and tools to simplify cross-platform app development. >Create >new or port existing apps to sell to consumers worldwide. Explore the >Intel AppUpSM program developer opportunity. >appdeveloper.intel.com/join >http://p.sf.net/sfu/intel-appdev >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: Vitaly S. <vsh...@so...> - 2011-12-21 15:53:03
|
Phil, I enter the same GL code to the last 3 entries in categories setup for a dummy type. The first two I just ignore. This seems to work just fine. Thank you for your help. I also enabled adding dummy items to the PO. I did not see any problem with this so far. If it works it would be much easier to enter the POs that require non-stock items. I just do not fill comfortable when people work with GL directly. It is too easy to select wrong account. Plus you have to type a description for it every time. Thanks, Vitaly On 12/20/2011 5:25 PM, Phil Daintree wrote: > You will notice that they change their labels... > For labour type categories the stock gl account becomes the labour recovery account. There can be no stock adjustments for labour or dummys. However, the usage var account becomes the labour efficiency variance account, the price variance account is also required for labour types. |
|
From: Marcos G. T. <ad...@gm...> - 2011-12-22 20:12:00
|
Hi! I used the category concept in order to group my items because of its some use that it has: -- Wire & conductors - Hand tools - Batteries - Gloves etc. The GL account could be used for some disgregation of the costs: - Grocery - Clothing - Dairy & Milk - Deli - Vegetables etc. Of course, in a factory, you can use something like this: -- supplies -- oil & lubricants -- Glues -- Tools -- Machinery & equipment -- Vehicles etc. Saludos! 2011/12/21 Vitaly Shevkunov <vsh...@so...> > Phil, > > I enter the same GL code to the last 3 entries in categories setup for a > dummy type. The first two I just ignore. This seems to work just fine. > Thank you for your help. > > I also enabled adding dummy items to the PO. I did not see any problem > with this so far. If it works it would be much easier to enter the POs > that require non-stock items. I just do not fill comfortable when people > work with GL directly. It is too easy to select wrong account. Plus you > have to type a description for it every time. > > Thanks, > Vitaly > > > > On 12/20/2011 5:25 PM, Phil Daintree wrote: > > You will notice that they change their labels... > > For labour type categories the stock gl account becomes the labour > recovery account. There can be no stock adjustments for labour or dummys. > However, the usage var account becomes the labour efficiency variance > account, the price variance account is also required for labour types. > > > > ------------------------------------------------------------------------------ > Write once. Port to many. > Get the SDK and tools to simplify cross-platform app development. Create > new or port existing apps to sell to consumers worldwide. Explore the > Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join > http://p.sf.net/sfu/intel-appdev > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > -- Ing Marcos R Garcia Trejo (52) 9991-513412 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X