Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Doubts on "Internal Stock"
07-23-2012, 06:30 PM,
RE: Doubts on "Internal Stock"

Just commited. Please check if it's OK.
Pak Ricard
07-24-2012, 05:34 PM,
RE: Doubts on "Internal Stock"
OK then.... From my POV and my tests seems the module is OK for production sites.
Thanks Tim!
Pak Ricard
07-30-2012, 12:51 PM,
RE: Doubts on "Internal Stock"
Hi Tim:

After running it live, we realize a report is needed after fulfilling the internal request. One user fulfills it in webERP and should handle a paper to someone on the warehouse to prepare the goods.

The report could be the same as the one produced at StockDispatch.php or PDFStockLocTransfer.php, but I don't know how to get it working.

The InternalStockRequestFulfill.php allows fulfilment of different request going TO different departments, but records into the database line by line, not request by request, so how to get one PDF printed for each department? Or for each request?
I guess the forach at line 15 should be done differently, but how?

Could we use the same DPFStockLocTransfer.php? Where to call it?

Thanks! I'm lost ;-(

Pak Ricard
08-06-2012, 11:59 AM,
RE: Doubts on "Internal Stock"
Hi Tim:

We discovered a bug on InternalStockRequestFulfill.php as some of the stockrequest maintains the flag closed = 0 even if it should be 1 because all the stockrequestitems associated are flagged as completed = 1 .

I guess it has to do with stockrequest with more than 1 item.

Could you pls check it? Thanks!
Pak Ricard
08-13-2012, 10:13 AM,
RE: Doubts on "Internal Stock"
(08-07-2012, 05:04 AM)tim_schofield Wrote: Hi Ricard,

I have fixed this in svn. Can you check that it works for you?

I am aware that I still have the report to do, things have been insanely busy for me recently but it is on my list :-)


Hi Tim:

Sorry for the delay.

It still has the same issue. Some requests are still shown but no items to be fulfilled. I attach a screen capture.

I guess it has to do with the completion flag at request table. Isn't it a redundant field, so when not in sync creates these issues. I think the completion flag at item level is enough. A request is completed once all its items have been flagged as completed.

Could this work (psuedo code only as I'm away from my developing machine)?

UPDATE internalrequests SET completed = 1 WHERE NOT EXISTS (SELECT *
FROM internalrequestitems
WHERE completed = 0
AND internalrequest.requestid = internalrequestitems.requestid)

Many thanks!

Attached Files Thumbnail(s)
Pak Ricard
08-30-2012, 06:36 PM,
RE: Doubts on "Internal Stock"

An using webERP version 4.08.4
I have a system set up with chart, customer, supplier, items and item quantities
all parts work well but there seems to be a problem with <b>Fulfill Internal Stock request</b>
I have created 2 departments and am successfully able to <b>Create A New Internal Stock Request</b>
the <b>Authorize Internal Stock Request</b> but when I try to <b>Fulfill Internal Stock request</b>
I just get a blank browser screen with <b>http://localhost/webERP4084/InternalStockRequestFulfill.php</b>
on the location bar and I can only use the browser back button to go back to inventory menu.
the tables <b>departments, stockrequest, stockrequestitems</b> contain all the correct data for the stock request

Any ideas what I may be doing wrong ?

Thanks in advance

08-31-2012, 12:20 AM,
RE: Doubts on "Internal Stock"
Fulfill Internal Stock request problem solved here : http://weberp-accounting.1478800.n4.nabb...55574.html
09-11-2012, 07:20 AM,
RE: Doubts on "Internal Stock"
I have read all the threads on internal stock and finding it difficult to understand how this feature helps companies who need to manage internal requisitions. Correct me if I am wrong, but below is what I think is a more suitable purpose for setting up internal stocks transfer.

a) Internal stock or internal requisition is so called because the stock requested by a department is available from the store or warehouse and does not need to be be ordered from a supplier (or at least a check is done internally before a purchase request is sent to vendors)
b) User department makes a request for a stock item. Request is approved by head of department and then forwarded to stores or a procurement department. The request will include quantity and expected date of delivery (more like the date the item will be required to be delivered)
c) stores or procurement dept checks if the item is in stock (it is not the user department that checks the item if its in store). I see that in the current method the user is able to select items, see quantities etc which shouldn't be the case really.
d) If the item requested is in store and in the demanded quantity, stores or procurement will issue the item to the user's department (at this point, the stock has only changed location from stores to the user department). Depending on how the accounting is to be setup, the stock can remain as an inventory item but in a different location, or written off because it is now supplied to a user
e) If the item requested is partially in store or not in store at all and the request from the user department cannot be fully fulfilled, then a Purchase Order is raised to a vendor or vendors who will then quote for the items.
f) The user department will need to know that the request cannot be fulfilled and that an order has been placed with suppliers
g) The user department will need to know the timing of delivery based on the PO that will be processed to suppliers
h) Stores or procurement department must have a way to know that the item once received from the supplier should be delivered to the user department that has made the request. In order words, delivery to the user department will be pending in Stores or Procurement. Once the stores has received sufficient stocks that can meet the request or the pending items, these will then be issued to the user department that made the request originally. If need be, we could fulfil requests partially, leave the request open until fully fulfilled or close the request due to inability to fulfil it.
i) We need to manage multiple requests for same items so that some requests are not left too long while others are attended to promptly. Perhaps something that manages the requests on the basis of first come, first served (FIFO)

There are a few other stuff like "Stocks to be returned". Here I mean, a user is issued a stock item perhaps to do a job but after completing the job, that item needs to be returned back to stores or warehouse. We can think more about what needs to be included.

And finally, the accounting for these transactions needs to be figured out.

In my opinion, this will be a more desirable flow for internal stocks or internal requisitions. Reactions are welcome.
09-11-2012, 08:00 PM,
RE: Doubts on "Internal Stock"
I just set up a department and tried to initiate a new internal stock request...


I definitely have got stock categories defined - in the normal demo database
Phil Daintree
webERP Admin
Logic Works Ltd

Forum Jump:

Users browsing this thread: 1 Guest(s)