From: icedlava <ice...@gm...> - 2013-10-18 08:48:51
|
I have been looking at Internal Stock Requests to see if it can be used in a specific client case. I am unsure if the current Internal Stock Request script is meant to be finished or still requires some added functionality. Unfortunately it cannot be used for our specific problem as it currently is coded. From what I can see: 1. Stock request is made 2. Stock request is approved 3. Stock request is fulfilled - but at this point script seems only half done. a. Stock movement table is updated for RequestFrom location, b. stock location qty table is updated for Request From location (reducing stock), c. and the stock request table(s) are updated to reflect dispatched goods. There seems : - no way to print a dispatch docket (and each item is held with different reference in stock moves table) - no way to receive in stock at receiving branch - no stock in transfer state prior to receiving I thought that as a dispatch, this transaction should also be treated like any other stock transfer and intergrated more fully with existing functionality eg: - be inserted with a reference stock transfer id in the stock transfer table - a stock transfer docket can be produced - be able to be received in at receiving branch - stock transfer id can be viewed (similar to other 'normal' transfers) - stock moves and location quantities are updated accordingly However, perhaps i misinterpreted or do no understand the objective of this script. If this is something that has yet to be complete in internal stock transfer, I have to code this in any case, and could add it to the existing code. (As well as report of outstanding transfers at any specific time). In this case, I would appreciate any feedback to considerations that I should take to ensure maintaining of compatibility with existing possible scenarios. If the internal stock transfer function is complete - then unfortunately we cannot use it, and must look to another solution, or code it in custom branch. If there is anyone with some insight into the Internal Stock Request and possible solution to this problem, your feedback would be much appreciated. The general requirements we need to fulfill are outlined below. Cheers, Posted to forum and dev list --------------- We have a requirement for the following: 1. Branch requests stock transfer from main warehouse to fulfill some current requirements, or to fulfill requirements at a future date after planning 2. Stock transfer is approved by relevant department 3. Stock is transferred out from main warehouse to branch, at the required date which may be some months in future (or some other alternative such as put on backorder and shipped when in stock, or outstanding cancelled). Dispatch docket printed. 3. Branch is notified, and receives in stock on arrival. Transfer note generated and used to check for received items and head branch notified if there are discrepancies. 4. Usual stock moves, stock quantities at location and dispatch records are updated in relevant tables at dispatch and receipt (or GL records if stock GL on). 4. A report of outstanding stock transfer requests for a given branch should be provided when required. Note that I have added ability to print stock dispatch docket and transfer note at any time from an amended Inventory -> Stock Transfer Note report option to solve some of this issue. |
From: Phil D. <ph...@lo...> - 2013-10-18 21:13:10
|
This was one of Tim's initiatives - no doubt he will have replied off-list. I confess I have not messed about with this functionality... do you think we need to pull it out or re-do it? There are some notes in the manual. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 18/10/13 21:48, icedlava wrote: > I have been looking at Internal Stock Requests to see if it can be used in a specific client case. > > I am unsure if the current Internal Stock Request script is meant to be finished or still requires some added functionality. Unfortunately it cannot be used for our specific problem as it currently is coded. > > >From what I can see: > > 1. Stock request is made > > 2. Stock request is approved > > 3. Stock request is fulfilled - but at this point script seems only half done. > a. Stock movement table is updated for RequestFrom location, > b. stock location qty table is updated for Request From location (reducing stock), > c. and the stock request table(s) are updated to reflect dispatched goods. > > There seems : > - no way to print a dispatch docket (and each item is held with different reference in stock moves table) > - no way to receive in stock at receiving branch > - no stock in transfer state prior to receiving > > I thought that as a dispatch, this transaction should also be treated like any other stock transfer and intergrated more fully with existing functionality eg: > - be inserted with a reference stock transfer id in the stock transfer table > - a stock transfer docket can be produced > - be able to be received in at receiving branch > - stock transfer id can be viewed (similar to other 'normal' transfers) > - stock moves and location quantities are updated accordingly > > However, perhaps i misinterpreted or do no understand the objective of this script. > > If this is something that has yet to be complete in internal stock transfer, I have to code this in any case, and could add it to the existing code. (As well as report of outstanding transfers at any specific time). In this case, I would appreciate any feedback to considerations that I should take to ensure maintaining of compatibility with existing possible scenarios. > > If the internal stock transfer function is complete - then unfortunately we cannot use it, and must look to another solution, or code it in custom branch. > > If there is anyone with some insight into the Internal Stock Request and possible solution to this problem, your feedback would be much appreciated. The general requirements we need to fulfill are outlined below. > > Cheers, > > > Posted to forum and dev list > > --------------- > We have a requirement for the following: > > 1. Branch requests stock transfer from main warehouse to fulfill some current requirements, or to fulfill requirements at a future date after planning > > 2. Stock transfer is approved by relevant department > > 3. Stock is transferred out from main warehouse to branch, at the required date which may be some months in future (or some other alternative such as put on backorder and shipped when in stock, or outstanding cancelled). Dispatch docket printed. > > 3. Branch is notified, and receives in stock on arrival. Transfer note generated and used to check for received items and head branch notified if there are discrepancies. > > 4. Usual stock moves, stock quantities at location and dispatch records are updated in relevant tables at dispatch and receipt (or GL records if stock GL on). > > 4. A report of outstanding stock transfer requests for a given branch should be provided when required. > > Note that I have added ability to print stock dispatch docket and transfer note at any time from an amended Inventory -> Stock Transfer Note report option to solve some of this issue. > > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
From: Ricard A. <pak...@gm...> - 2013-10-19 01:16:06
|
Hi Jo: We are using this module and I agree with you, it's half done. It works in a very basic way, and lacks some functionality, but it works. 1. Branch requests stock transfer from main warehouse to fulfill some current requirements, or to fulfill requirements at a future date after planning. It works in a basic way. No option to modify a stock request once submitted. Also would be great a list of internal stock requested for that location but still not delivered, to avoid double input. Users in the destination location, now have no way to check if some intenal stock needs have been requested or not, thus leading to double requests. 2. Stock transfer is approved by relevant department. Done and works OK InternalStockRequestAuthorization.php. Also some user friendly functionality would be great, as print outs, partial authoritations- 3. Stock is transferred out from main warehouse to branch, at the required date which may be some months in future (or some other alternative such as put on backorder and shipped when in stock, or outstanding cancelled). Dispatch docket printed. Done at StockRequestFulfill. Nothing is printed out 3. Branch is notified, and receives in stock on arrival. Transfer note generated and used to check for received items and head branch notified if there are discrepancies. Not done at all... would be nice. 4. Usual stock moves, stock quantities at location and dispatch records are updated in relevant tables at dispatch and receipt (or GL records if stock GL on). Not sure if it's done. We use it only for consumable stock (business card, cleaning materials, shopping bags, etc) and don't control stock outside main location, so never checked it out, but I guess it's somehow done, as stock at main location gets properly updated. 4. A report of outstanding stock transfer requests for a given branch should be provided when required. Not done yet,and would minimize current human errors, as all works with screen printing. Note that I have added ability to print stock dispatch docket and transfer note at any time from an amended Inventory -> Stock Transfer Note report option to solve some of this issue. Hope it helps Regards, Ricard 2013/10/18 icedlava <ice...@gm...> > I have been looking at Internal Stock Requests to see if it can be used in > a specific client case. > > I am unsure if the current Internal Stock Request script is meant to be > finished or still requires some added functionality. Unfortunately it > cannot be used for our specific problem as it currently is coded. > > >From what I can see: > > 1. Stock request is made > > 2. Stock request is approved > > 3. Stock request is fulfilled - but at this point script seems only half > done. > a. Stock movement table is updated for RequestFrom location, > b. stock location qty table is updated for Request From location (reducing > stock), > c. and the stock request table(s) are updated to reflect dispatched goods. > > There seems : > - no way to print a dispatch docket (and each item is held with different > reference in stock moves table) > - no way to receive in stock at receiving branch > - no stock in transfer state prior to receiving > > I thought that as a dispatch, this transaction should also be treated like > any other stock transfer and intergrated more fully with existing > functionality eg: > - be inserted with a reference stock transfer id in the stock transfer > table > - a stock transfer docket can be produced > - be able to be received in at receiving branch > - stock transfer id can be viewed (similar to other 'normal' transfers) > - stock moves and location quantities are updated accordingly > > However, perhaps i misinterpreted or do no understand the objective of > this script. > > If this is something that has yet to be complete in internal stock > transfer, I have to code this in any case, and could add it to the > existing code. (As well as report of outstanding transfers at any specific > time). In this case, I would appreciate any feedback to considerations that > I should take to ensure maintaining of compatibility with existing possible > scenarios. > > If the internal stock transfer function is complete - then unfortunately > we cannot use it, and must look to another solution, or code it in custom > branch. > > If there is anyone with some insight into the Internal Stock Request and > possible solution to this problem, your feedback would be much appreciated. > The general requirements we need to fulfill are outlined below. > > Cheers, > > > Posted to forum and dev list > > --------------- > We have a requirement for the following: > > 1. Branch requests stock transfer from main warehouse to fulfill some > current requirements, or to fulfill requirements at a future date after > planning > > 2. Stock transfer is approved by relevant department > > 3. Stock is transferred out from main warehouse to branch, at the required > date which may be some months in future (or some other alternative such as > put on backorder and shipped when in stock, or outstanding cancelled). > Dispatch docket printed. > > 3. Branch is notified, and receives in stock on arrival. Transfer note > generated and used to check for received items and head branch notified if > there are discrepancies. > > 4. Usual stock moves, stock quantities at location and dispatch records > are updated in relevant tables at dispatch and receipt (or GL records if > stock GL on). > > 4. A report of outstanding stock transfer requests for a given branch > should be provided when required. > > Note that I have added ability to print stock dispatch docket and transfer > note at any time from an amended Inventory -> Stock Transfer Note report > option to solve some of this issue. > > > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most > from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > |
From: icedlava <ice...@gm...> - 2013-10-19 03:07:41
|
Hi Phil, Apparently the script is complete for the purpose intended so I've been told. It seems there are people using the script, although there has been suggestion by some to modify it in various areas. I'm not inclined to change the logic/functionality of a script in use unless there is general support and consensus by those that use it for any such changes. I have investigated the underlying functionality and not all tables are updated as would be required in this use case of mine. I've been thinking that for the requirements in question I could do something along the lines of Internal Stock Request integrated with the underlying functionality of the Bulk Inventory transfer dispatch/receive (all appropriate table updates/GL transactions as necessary) plus the reporting. This could be a separate script which I can put in the client custom code branch, or add here if there was demand for it. I'll keep working on it, appreciate your feedback. Cheers, On 19/10/2013, at 7:42 AM, Phil Daintree <ph...@lo...> wrote: > This was one of Tim's initiatives - no doubt he will have replied off-list. > I confess I have not messed about with this functionality... do you > think we need to pull it out or re-do it? > There are some notes in the manual. > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 18/10/13 21:48, icedlava wrote: >> I have been looking at Internal Stock Requests to see if it can be used in a specific client case. >> >> I am unsure if the current Internal Stock Request script is meant to be finished or still requires some added functionality. Unfortunately it cannot be used for our specific problem as it currently is coded. >> >>> From what I can see: >> >> 1. Stock request is made >> >> 2. Stock request is approved >> >> 3. Stock request is fulfilled - but at this point script seems only half done. >> a. Stock movement table is updated for RequestFrom location, >> b. stock location qty table is updated for Request From location (reducing stock), >> c. and the stock request table(s) are updated to reflect dispatched goods. >> >> There seems : >> - no way to print a dispatch docket (and each item is held with different reference in stock moves table) >> - no way to receive in stock at receiving branch >> - no stock in transfer state prior to receiving >> >> I thought that as a dispatch, this transaction should also be treated like any other stock transfer and intergrated more fully with existing functionality eg: >> - be inserted with a reference stock transfer id in the stock transfer table >> - a stock transfer docket can be produced >> - be able to be received in at receiving branch >> - stock transfer id can be viewed (similar to other 'normal' transfers) >> - stock moves and location quantities are updated accordingly >> >> However, perhaps i misinterpreted or do no understand the objective of this script. >> >> If this is something that has yet to be complete in internal stock transfer, I have to code this in any case, and could add it to the existing code. (As well as report of outstanding transfers at any specific time). In this case, I would appreciate any feedback to considerations that I should take to ensure maintaining of compatibility with existing possible scenarios. >> >> If the internal stock transfer function is complete - then unfortunately we cannot use it, and must look to another solution, or code it in custom branch. >> >> If there is anyone with some insight into the Internal Stock Request and possible solution to this problem, your feedback would be much appreciated. The general requirements we need to fulfill are outlined below. >> >> Cheers, >> >> >> Posted to forum and dev list >> >> --------------- >> We have a requirement for the following: >> >> 1. Branch requests stock transfer from main warehouse to fulfill some current requirements, or to fulfill requirements at a future date after planning >> >> 2. Stock transfer is approved by relevant department >> >> 3. Stock is transferred out from main warehouse to branch, at the required date which may be some months in future (or some other alternative such as put on backorder and shipped when in stock, or outstanding cancelled). Dispatch docket printed. >> >> 3. Branch is notified, and receives in stock on arrival. Transfer note generated and used to check for received items and head branch notified if there are discrepancies. >> >> 4. Usual stock moves, stock quantities at location and dispatch records are updated in relevant tables at dispatch and receipt (or GL records if stock GL on). >> >> 4. A report of outstanding stock transfer requests for a given branch should be provided when required. >> >> Note that I have added ability to print stock dispatch docket and transfer note at any time from an amended Inventory -> Stock Transfer Note report option to solve some of this issue. >> >> >> >> ------------------------------------------------------------------------------ >> October Webinars: Code for Performance >> Free Intel webinars can help you accelerate application performance. >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from >> the latest Intel processors and coprocessors. See abstracts and register > >> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
From: Phil D. <ph...@lo...> - 2013-10-19 04:28:10
|
I do like to keep the standards up though and if movements are not created and stock quantities are not created then this is a bug to be fixed irrespective of someone using it and trashing their db! I like the sound of your mods and think on the face of it they belong in the main trunk. As you are no doubt aware i am less sensitive to individual egos than i am about the quality of webERP. i am happy to weather any incoming flack:-) -- Phil Daintree +64(0)275 567890 Skype: daintree icedlava <ice...@gm...> wrote: >Hi Phil, > >Apparently the script is complete for the purpose intended so I've been >told. > >It seems there are people using the script, although there has been >suggestion by some to modify it in various areas. >I'm not inclined to change the logic/functionality of a script in use >unless there is general support and consensus by those that use it for >any such changes. > >I have investigated the underlying functionality and not all tables are >updated as would be required in this use case of mine. > >I've been thinking that for the requirements in question I could do >something along the lines of Internal Stock Request integrated with the >underlying functionality of the Bulk Inventory transfer >dispatch/receive (all appropriate table updates/GL transactions as >necessary) plus the reporting. > >This could be a separate script which I can put in the client custom >code branch, or add here if there was demand for it. > >I'll keep working on it, appreciate your feedback. > >Cheers, > > >On 19/10/2013, at 7:42 AM, Phil Daintree <ph...@lo...> wrote: > >> This was one of Tim's initiatives - no doubt he will have replied >off-list. > >> I confess I have not messed about with this functionality... do you >> think we need to pull it out or re-do it? >> There are some notes in the manual. >> >> Phil >> >> Phil Daintree >> Logic Works Ltd - +64 (0)275 567890 >> http://www.logicworks.co.nz >> >> On 18/10/13 21:48, icedlava wrote: >>> I have been looking at Internal Stock Requests to see if it can be >used in a specific client case. >>> >>> I am unsure if the current Internal Stock Request script is meant to >be finished or still requires some added functionality. Unfortunately >it cannot be used for our specific problem as it currently is coded. >>> >>>> From what I can see: >>> >>> 1. Stock request is made >>> >>> 2. Stock request is approved >>> >>> 3. Stock request is fulfilled - but at this point script seems only >half done. >>> a. Stock movement table is updated for RequestFrom location, >>> b. stock location qty table is updated for Request From location >(reducing stock), >>> c. and the stock request table(s) are updated to reflect dispatched >goods. >>> >>> There seems : >>> - no way to print a dispatch docket (and each item is held with >different reference in stock moves table) >>> - no way to receive in stock at receiving branch >>> - no stock in transfer state prior to receiving >>> >>> I thought that as a dispatch, this transaction should also be >treated like any other stock transfer and intergrated more fully with >existing functionality eg: >>> - be inserted with a reference stock transfer id in the stock >transfer table >>> - a stock transfer docket can be produced >>> - be able to be received in at receiving branch >>> - stock transfer id can be viewed (similar to other 'normal' >transfers) >>> - stock moves and location quantities are updated accordingly >>> >>> However, perhaps i misinterpreted or do no understand the objective >of this script. >>> >>> If this is something that has yet to be complete in internal stock >transfer, I have to code this in any case, and could add it to the >existing code. (As well as report of outstanding transfers at any >specific time). In this case, I would appreciate any feedback to >considerations that I should take to ensure maintaining of >compatibility with existing possible scenarios. >>> >>> If the internal stock transfer function is complete - then >unfortunately we cannot use it, and must look to another solution, or >code it in custom branch. >>> >>> If there is anyone with some insight into the Internal Stock Request >and possible solution to this problem, your feedback would be much >appreciated. The general requirements we need to fulfill are outlined >below. >>> >>> Cheers, >>> >>> >>> Posted to forum and dev list >>> >>> --------------- >>> We have a requirement for the following: >>> >>> 1. Branch requests stock transfer from main warehouse to fulfill >some current requirements, or to fulfill requirements at a future date >after planning >>> >>> 2. Stock transfer is approved by relevant department >>> >>> 3. Stock is transferred out from main warehouse to branch, at the >required date which may be some months in future (or some other >alternative such as put on backorder and shipped when in stock, or >outstanding cancelled). Dispatch docket printed. >>> >>> 3. Branch is notified, and receives in stock on arrival. Transfer >note generated and used to check for received items and head branch >notified if there are discrepancies. >>> >>> 4. Usual stock moves, stock quantities at location and dispatch >records are updated in relevant tables at dispatch and receipt (or GL >records if stock GL on). >>> >>> 4. A report of outstanding stock transfer requests for a given >branch should be provided when required. >>> >>> Note that I have added ability to print stock dispatch docket and >transfer note at any time from an amended Inventory -> Stock Transfer >Note report option to solve some of this issue. >>> >>> >>> >>> >------------------------------------------------------------------------------ >>> October Webinars: Code for Performance >>> Free Intel webinars can help you accelerate application performance. >>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the >most from >>> the latest Intel processors and coprocessors. See abstracts and >register > >>> >http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk >>> _______________________________________________ >>> Web-erp-developers mailing list >>> Web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >>> >> >> >> >------------------------------------------------------------------------------ >> October Webinars: Code for Performance >> Free Intel webinars can help you accelerate application performance. >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the >most from >> the latest Intel processors and coprocessors. See abstracts and >register > >> >http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > >------------------------------------------------------------------------------ >October Webinars: Code for Performance >Free Intel webinars can help you accelerate application performance. >Explore tips for MPI, OpenMP, advanced profiling, and more. Get the >most from >the latest Intel processors and coprocessors. See abstracts and >register > >http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
From: icedlava <ice...@gm...> - 2013-10-19 03:24:03
|
Hi Ricard, Thanks for your reply. I'm interested to have someone such as yourself that uses the module, to provide this feedback. You raised some practical points that would be important to implement: * Modifying a stock request - certainly would be useful in practice to be able to do this * Outstanding stock request listing/report - this is on my task list but for a different purpose than yours of avoiding double input. I hadn't thought of that, but certainly it's important. * The StockRequestFulfill is working but stock is only reduced from sending location. There are no transactions currently for receiving side. I can understand why this is so if this stock is only being distributed to an internal department, rather than an actual stock holding location. If it is a stock holding location such is in our use case, it does need the supporting stock moves/incremented stock amounts done. If I did modify the existing script, perhaps there could be some option switch here to turn on the appropriate transactions for the receiving location ? Would anyone find this a problem? There are some usability issues at stock fulfil eg if there is more than one outstanding request for a given location - it is very easy to accidentally click and fulfil all outstanding requests on the screen rather than just the one required. I'll try and address these if i work on this specific script. After your feedback Ricard, I'm more hopeful of being able to modify the existing script while leaving the default option to continue it to behave as it is, with additional switch to turn on the extra functionality required if receiving location needs underlying transactions for stock handled as well - those that are not done at the moment in the current script. Thank you and best regards! . On 19/10/2013, at 11:45 AM, Ricard Andreu <pak...@gm...> wrote: > Hi Jo: > > We are using this module and I agree with you, it's half done. It works in a very basic way, and lacks some functionality, but it works. > > 1. Branch requests stock transfer from main warehouse to fulfill some current requirements, or to fulfill requirements at a future date after planning. It works in a basic way. No option to modify a stock request once submitted. Also would be great a list of internal stock requested for that location but still not delivered, to avoid double input. Users in the destination location, now have no way to check if some intenal stock needs have been requested or not, thus leading to double requests. > > 2. Stock transfer is approved by relevant department. Done and works OK InternalStockRequestAuthorization.php. Also some user friendly functionality would be great, as print outs, partial authoritations- > > 3. Stock is transferred out from main warehouse to branch, at the required date which may be some months in future (or some other alternative such as put on backorder and shipped when in stock, or outstanding cancelled). Dispatch docket printed. Done at StockRequestFulfill. Nothing is printed out > > 3. Branch is notified, and receives in stock on arrival. Transfer note generated and used to check for received items and head branch notified if there are discrepancies. Not done at all... would be nice. > > 4. Usual stock moves, stock quantities at location and dispatch records are updated in relevant tables at dispatch and receipt (or GL records if stock GL on). Not sure if it's done. We use it only for consumable stock (business card, cleaning materials, shopping bags, etc) and don't control stock outside main location, so never checked it out, but I guess it's somehow done, as stock at main location gets properly updated. > > 4. A report of outstanding stock transfer requests for a given branch should be provided when required. Not done yet,and would minimize current human errors, as all works with screen printing. > > Note that I have added ability to print stock dispatch docket and transfer note at any time from an amended Inventory -> Stock Transfer Note report option to solve some of this issue. > > Hope it helps > > Regards, > Ricard > > > 2013/10/18 icedlava <ice...@gm...> > I have been looking at Internal Stock Requests to see if it can be used in a specific client case. > > I am unsure if the current Internal Stock Request script is meant to be finished or still requires some added functionality. Unfortunately it cannot be used for our specific problem as it currently is coded. > > >From what I can see: > > 1. Stock request is made > > 2. Stock request is approved > > 3. Stock request is fulfilled - but at this point script seems only half done. > a. Stock movement table is updated for RequestFrom location, > b. stock location qty table is updated for Request From location (reducing stock), > c. and the stock request table(s) are updated to reflect dispatched goods. > > There seems : > - no way to print a dispatch docket (and each item is held with different reference in stock moves table) > - no way to receive in stock at receiving branch > - no stock in transfer state prior to receiving > > I thought that as a dispatch, this transaction should also be treated like any other stock transfer and intergrated more fully with existing functionality eg: > - be inserted with a reference stock transfer id in the stock transfer table > - a stock transfer docket can be produced > - be able to be received in at receiving branch > - stock transfer id can be viewed (similar to other 'normal' transfers) > - stock moves and location quantities are updated accordingly > > However, perhaps i misinterpreted or do no understand the objective of this script. > > If this is something that has yet to be complete in internal stock transfer, I have to code this in any case, and could add it to the existing code. (As well as report of outstanding transfers at any specific time). In this case, I would appreciate any feedback to considerations that I should take to ensure maintaining of compatibility with existing possible scenarios. > > If the internal stock transfer function is complete - then unfortunately we cannot use it, and must look to another solution, or code it in custom branch. > > If there is anyone with some insight into the Internal Stock Request and possible solution to this problem, your feedback would be much appreciated. The general requirements we need to fulfill are outlined below. > > Cheers, > > > Posted to forum and dev list > > --------------- > We have a requirement for the following: > > 1. Branch requests stock transfer from main warehouse to fulfill some current requirements, or to fulfill requirements at a future date after planning > > 2. Stock transfer is approved by relevant department > > 3. Stock is transferred out from main warehouse to branch, at the required date which may be some months in future (or some other alternative such as put on backorder and shipped when in stock, or outstanding cancelled). Dispatch docket printed. > > 3. Branch is notified, and receives in stock on arrival. Transfer note generated and used to check for received items and head branch notified if there are discrepancies. > > 4. Usual stock moves, stock quantities at location and dispatch records are updated in relevant tables at dispatch and receipt (or GL records if stock GL on). > > 4. A report of outstanding stock transfer requests for a given branch should be provided when required. > > Note that I have added ability to print stock dispatch docket and transfer note at any time from an amended Inventory -> Stock Transfer Note report option to solve some of this issue. > > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk_______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
From: Ricard A. <pak...@gm...> - 2013-10-19 03:51:01
|
Hi Jo: it's Ok for me to use config switches to allow / disallow new functionalities. Will be happy to test your upgraded scripts ;-) Regards, Ricard 2013/10/19 icedlava <ice...@gm...> > Hi Ricard, > > Thanks for your reply. I'm interested to have someone such as yourself > that uses the module, to provide this feedback. > > You raised some practical points that would be important to implement: > > * Modifying a stock request - certainly would be useful in practice to be > able to do this > > * Outstanding stock request listing/report - this is on my task list but > for a different purpose than yours of avoiding double input. I hadn't > thought of that, but certainly it's important. > > * The StockRequestFulfill is working but stock is only reduced from > sending location. There are no transactions currently for receiving side. > I can understand why this is so if this stock is only being distributed > to an internal department, rather than an actual stock holding location. If > it is a stock holding location such is in our use case, it does need the > supporting stock moves/incremented stock amounts done. > > If I did modify the existing script, perhaps there could be some option > switch here to turn on the appropriate transactions for the receiving > location ? Would anyone find this a problem? > > There are some usability issues at stock fulfil eg if there is more than > one outstanding request for a given location - it is very easy to > accidentally click and fulfil all outstanding requests on the screen rather > than just the one required. I'll try and address these if i work on this > specific script. > > After your feedback Ricard, I'm more hopeful of being able to modify the > existing script while leaving the default option to continue it to behave > as it is, with additional switch to turn on the extra functionality > required if receiving location needs underlying transactions for stock > handled as well - those that are not done at the moment in the current > script. > > Thank you and best regards! > > . > On 19/10/2013, at 11:45 AM, Ricard Andreu <pak...@gm...> wrote: > > Hi Jo: > > We are using this module and I agree with you, it's half done. It works in > a very basic way, and lacks some functionality, but it works. > > 1. Branch requests stock transfer from main warehouse to fulfill some > current requirements, or to fulfill requirements at a future date after planning. > It works in a basic way. No option to modify a stock request once > submitted. Also would be great a list of internal stock requested for that > location but still not delivered, to avoid double input. Users in the > destination location, now have no way to check if some intenal stock needs > have been requested or not, thus leading to double requests. > > 2. Stock transfer is approved by relevant department. Done and works OK > InternalStockRequestAuthorization.php. Also some user friendly > functionality would be great, as print outs, partial authoritations- > > 3. Stock is transferred out from main warehouse to branch, at the required > date which may be some months in future (or some other alternative such as > put on backorder and shipped when in stock, or outstanding cancelled). > Dispatch docket printed. Done at StockRequestFulfill. Nothing is printed > out > > 3. Branch is notified, and receives in stock on arrival. Transfer note > generated and used to check for received items and head branch notified if > there are discrepancies. Not done at all... would be nice. > > 4. Usual stock moves, stock quantities at location and dispatch records > are updated in relevant tables at dispatch and receipt (or GL records if > stock GL on). Not sure if it's done. We use it only for consumable stock > (business card, cleaning materials, shopping bags, etc) and don't control > stock outside main location, so never checked it out, but I guess it's > somehow done, as stock at main location gets properly updated. > > 4. A report of outstanding stock transfer requests for a given branch > should be provided when required. Not done yet,and would minimize current > human errors, as all works with screen printing. > > Note that I have added ability to print stock dispatch docket and transfer > note at any time from an amended Inventory -> Stock Transfer Note report > option to solve some of this issue. > > Hope it helps > > Regards, > Ricard > > > 2013/10/18 icedlava <ice...@gm...> > >> I have been looking at Internal Stock Requests to see if it can be used >> in a specific client case. >> >> I am unsure if the current Internal Stock Request script is meant to be >> finished or still requires some added functionality. Unfortunately it >> cannot be used for our specific problem as it currently is coded. >> >> >From what I can see: >> >> 1. Stock request is made >> >> 2. Stock request is approved >> >> 3. Stock request is fulfilled - but at this point script seems only half >> done. >> a. Stock movement table is updated for RequestFrom location, >> b. stock location qty table is updated for Request From location >> (reducing stock), >> c. and the stock request table(s) are updated to reflect dispatched goods. >> >> There seems : >> - no way to print a dispatch docket (and each item is held with different >> reference in stock moves table) >> - no way to receive in stock at receiving branch >> - no stock in transfer state prior to receiving >> >> I thought that as a dispatch, this transaction should also be treated >> like any other stock transfer and intergrated more fully with existing >> functionality eg: >> - be inserted with a reference stock transfer id in the stock transfer >> table >> - a stock transfer docket can be produced >> - be able to be received in at receiving branch >> - stock transfer id can be viewed (similar to other 'normal' transfers) >> - stock moves and location quantities are updated accordingly >> >> However, perhaps i misinterpreted or do no understand the objective of >> this script. >> >> If this is something that has yet to be complete in internal stock >> transfer, I have to code this in any case, and could add it to the >> existing code. (As well as report of outstanding transfers at any specific >> time). In this case, I would appreciate any feedback to considerations that >> I should take to ensure maintaining of compatibility with existing possible >> scenarios. >> >> If the internal stock transfer function is complete - then unfortunately >> we cannot use it, and must look to another solution, or code it in custom >> branch. >> >> If there is anyone with some insight into the Internal Stock Request and >> possible solution to this problem, your feedback would be much appreciated. >> The general requirements we need to fulfill are outlined below. >> >> Cheers, >> >> >> Posted to forum and dev list >> >> --------------- >> We have a requirement for the following: >> >> 1. Branch requests stock transfer from main warehouse to fulfill some >> current requirements, or to fulfill requirements at a future date after >> planning >> >> 2. Stock transfer is approved by relevant department >> >> 3. Stock is transferred out from main warehouse to branch, at the >> required date which may be some months in future (or some other >> alternative such as put on backorder and shipped when in stock, or >> outstanding cancelled). Dispatch docket printed. >> >> 3. Branch is notified, and receives in stock on arrival. Transfer note >> generated and used to check for received items and head branch notified if >> there are discrepancies. >> >> 4. Usual stock moves, stock quantities at location and dispatch records >> are updated in relevant tables at dispatch and receipt (or GL records if >> stock GL on). >> >> 4. A report of outstanding stock transfer requests for a given branch >> should be provided when required. >> >> Note that I have added ability to print stock dispatch docket and >> transfer note at any time from an amended Inventory -> Stock Transfer Note >> report option to solve some of this issue. >> >> >> >> >> ------------------------------------------------------------------------------ >> October Webinars: Code for Performance >> Free Intel webinars can help you accelerate application performance. >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most >> from >> the latest Intel processors and coprocessors. See abstracts and register > >> >> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most > from > the latest Intel processors and coprocessors. See abstracts and register > > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk_______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most > from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
From: Phil D. <ph...@lo...> - 2013-10-19 04:22:17
|
I am not close enough to this to be sure but i am wondering if your mods which all sound very reasonable should just be part of the functionality and i cant see why any one would turn it off with a config switch. Possibly no config switch is needed -- Phil Daintree +64(0)275 567890 Skype: daintree icedlava <ice...@gm...> wrote: >Hi Ricard, > >Thanks for your reply. I'm interested to have someone such as yourself >that uses the module, to provide this feedback. > >You raised some practical points that would be important to implement: > >* Modifying a stock request - certainly would be useful in practice to >be able to do this > >* Outstanding stock request listing/report - this is on my task list >but for a different purpose than yours of avoiding double input. I >hadn't thought of that, but certainly it's important. > >* The StockRequestFulfill is working but stock is only reduced from >sending location. There are no transactions currently for receiving >side. >I can understand why this is so if this stock is only being distributed >to an internal department, rather than an actual stock holding >location. If it is a stock holding location such is in our use case, it >does need the supporting stock moves/incremented stock amounts done. > >If I did modify the existing script, perhaps there could be some option >switch here to turn on the appropriate transactions for the receiving >location ? Would anyone find this a problem? > >There are some usability issues at stock fulfil eg if there is more >than one outstanding request for a given location - it is very easy to >accidentally click and fulfil all outstanding requests on the screen >rather than just the one required. I'll try and address these if i work >on this specific script. > >After your feedback Ricard, I'm more hopeful of being able to modify >the existing script while leaving the default option to continue it to >behave as it is, with additional switch to turn on the extra >functionality required if receiving location needs underlying >transactions for stock handled as well - those that are not done at the >moment in the current script. > >Thank you and best regards! > >. >On 19/10/2013, at 11:45 AM, Ricard Andreu <pak...@gm...> wrote: > >> Hi Jo: >> >> We are using this module and I agree with you, it's half done. It >works in a very basic way, and lacks some functionality, but it works. >> >> 1. Branch requests stock transfer from main warehouse to fulfill some >current requirements, or to fulfill requirements at a future date after >planning. It works in a basic way. No option to modify a stock request >once submitted. Also would be great a list of internal stock requested >for that location but still not delivered, to avoid double input. Users >in the destination location, now have no way to check if some intenal >stock needs have been requested or not, thus leading to double >requests. >> >> 2. Stock transfer is approved by relevant department. Done and works >OK InternalStockRequestAuthorization.php. Also some user friendly >functionality would be great, as print outs, partial authoritations- >> >> 3. Stock is transferred out from main warehouse to branch, at the >required date which may be some months in future (or some other >alternative such as put on backorder and shipped when in stock, or >outstanding cancelled). Dispatch docket printed. Done at >StockRequestFulfill. Nothing is printed out >> >> 3. Branch is notified, and receives in stock on arrival. Transfer >note generated and used to check for received items and head branch >notified if there are discrepancies. Not done at all... would be nice. >> >> 4. Usual stock moves, stock quantities at location and dispatch >records are updated in relevant tables at dispatch and receipt (or GL >records if stock GL on). Not sure if it's done. We use it only for >consumable stock (business card, cleaning materials, shopping bags, >etc) and don't control stock outside main location, so never checked it >out, but I guess it's somehow done, as stock at main location gets >properly updated. >> >> 4. A report of outstanding stock transfer requests for a given branch >should be provided when required. Not done yet,and would minimize >current human errors, as all works with screen printing. >> >> Note that I have added ability to print stock dispatch docket and >transfer note at any time from an amended Inventory -> Stock Transfer >Note report option to solve some of this issue. >> >> Hope it helps >> >> Regards, >> Ricard >> >> >> 2013/10/18 icedlava <ice...@gm...> >> I have been looking at Internal Stock Requests to see if it can be >used in a specific client case. >> >> I am unsure if the current Internal Stock Request script is meant to >be finished or still requires some added functionality. Unfortunately >it cannot be used for our specific problem as it currently is coded. >> >> >From what I can see: >> >> 1. Stock request is made >> >> 2. Stock request is approved >> >> 3. Stock request is fulfilled - but at this point script seems only >half done. >> a. Stock movement table is updated for RequestFrom location, >> b. stock location qty table is updated for Request From location >(reducing stock), >> c. and the stock request table(s) are updated to reflect dispatched >goods. >> >> There seems : >> - no way to print a dispatch docket (and each item is held with >different reference in stock moves table) >> - no way to receive in stock at receiving branch >> - no stock in transfer state prior to receiving >> >> I thought that as a dispatch, this transaction should also be treated >like any other stock transfer and intergrated more fully with existing >functionality eg: >> - be inserted with a reference stock transfer id in the stock >transfer table >> - a stock transfer docket can be produced >> - be able to be received in at receiving branch >> - stock transfer id can be viewed (similar to other 'normal' >transfers) >> - stock moves and location quantities are updated accordingly >> >> However, perhaps i misinterpreted or do no understand the objective >of this script. >> >> If this is something that has yet to be complete in internal stock >transfer, I have to code this in any case, and could add it to the >existing code. (As well as report of outstanding transfers at any >specific time). In this case, I would appreciate any feedback to >considerations that I should take to ensure maintaining of >compatibility with existing possible scenarios. >> >> If the internal stock transfer function is complete - then >unfortunately we cannot use it, and must look to another solution, or >code it in custom branch. >> >> If there is anyone with some insight into the Internal Stock Request >and possible solution to this problem, your feedback would be much >appreciated. The general requirements we need to fulfill are outlined >below. >> >> Cheers, >> >> >> Posted to forum and dev list >> >> --------------- >> We have a requirement for the following: >> >> 1. Branch requests stock transfer from main warehouse to fulfill some >current requirements, or to fulfill requirements at a future date after >planning >> >> 2. Stock transfer is approved by relevant department >> >> 3. Stock is transferred out from main warehouse to branch, at the >required date which may be some months in future (or some other >alternative such as put on backorder and shipped when in stock, or >outstanding cancelled). Dispatch docket printed. >> >> 3. Branch is notified, and receives in stock on arrival. Transfer >note generated and used to check for received items and head branch >notified if there are discrepancies. >> >> 4. Usual stock moves, stock quantities at location and dispatch >records are updated in relevant tables at dispatch and receipt (or GL >records if stock GL on). >> >> 4. A report of outstanding stock transfer requests for a given branch >should be provided when required. >> >> Note that I have added ability to print stock dispatch docket and >transfer note at any time from an amended Inventory -> Stock Transfer >Note report option to solve some of this issue. >> >> >> >> >------------------------------------------------------------------------------ >> October Webinars: Code for Performance >> Free Intel webinars can help you accelerate application performance. >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the >most from >> the latest Intel processors and coprocessors. See abstracts and >register > >> >http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk >> _______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers >> >> >------------------------------------------------------------------------------ >> October Webinars: Code for Performance >> Free Intel webinars can help you accelerate application performance. >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the >most from >> the latest Intel processors and coprocessors. See abstracts and >register > >> >http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk_______________________________________________ >> Web-erp-developers mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > >------------------------------------------------------------------------ > >------------------------------------------------------------------------------ >October Webinars: Code for Performance >Free Intel webinars can help you accelerate application performance. >Explore tips for MPI, OpenMP, advanced profiling, and more. Get the >most from >the latest Intel processors and coprocessors. See abstracts and >register > >http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > >------------------------------------------------------------------------ > >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
From: ExsonQu <hex...@gm...> - 2013-10-20 02:59:40
|
Hi, Jo, Thank you for reviewing this feature. I suggest to add a field for the request which used as a tag. Then users can sort it out to check where those material goes. It can be for instance customer. Thanks and best regards! Exson -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Internal-Stock-Request-is-this-functionality-complete-tp4656812p4656820.html Sent from the web-ERP-developers mailing list archive at Nabble.com. |
From: icedlava <ice...@gm...> - 2013-10-20 03:22:55
|
Hi Exson, > suggest to add a field for the request which used as a tag Thank you for the suggestion. It is similar to the switch idea I had but on every transaction/request, I think, so offers more flexibility to the user. With this script, I was trying to determine what the functioning of this existing webERP script was, its objective and if it is finished as intended. Then, I could better determine what is/isn't available to me in webERP for this specific task I have to implement. I've had a lot of feedback now which has been very helpful. I will do some more detailed investigation now. Once I make the changes/additions I will provide them for review so it can be decided if it is useful or not to general webERP, or I keep it in the custom client branch which may be the case. Many thanks for your help, Cheers, Jo On 20/10/2013, at 1:24 PM, ExsonQu <hex...@gm...> wrote: > Hi, Jo, > > Thank you for reviewing this feature. > > I suggest to add a field for the request which used as a tag. Then > users can sort it out to check where those material goes. It can be for > instance customer. > > Thanks and best regards! > > Exson > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Internal-Stock-Request-is-this-functionality-complete-tp4656812p4656820.html > Sent from the web-ERP-developers mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk > _______________________________________________ > Web-erp-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |