Menu
▾
▴
Re: [WebERP-developers] Internal Stock Request - is this functionality complete?
|
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 |
