web-erp-developers

[WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Dear all:*

          I'm considering to add a feature to make warehouse preparing the
goods for sales orders and Accountant or Sales can know the goods are ready
to delivery or not more transparent. The scenario is like this:

          1. First Sales select those orders should be arranged to delivery. 

          2. Warehouse man check the order delivery schedule. And mark the
order lines when it's ready.

          3. Sales(Or accountant) confirm the delivery and issue invoice
according to the marked orders.
 
          4. warehouse actually delivery. 

         Not sure if it's a redundant feature. 

         Any comments are very welcome.

         Best regards!

         Exson

          

          



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Phil D. <ph...@lo...>]

This is a bit like the picking list - with stock availability displayed 
so you know which orders you can pick.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/03/14 22:33, ExsonQu wrote:
> *Dear all:*
>
>            I'm considering to add a feature to make warehouse preparing the
> goods for sales orders and Accountant or Sales can know the goods are ready
> to delivery or not more transparent. The scenario is like this:
>
>            1. First Sales select those orders should be arranged to delivery.
>
>            2. Warehouse man check the order delivery schedule. And mark the
> order lines when it's ready.
>
>            3. Sales(Or accountant) confirm the delivery and issue invoice
> according to the marked orders.
>   
>            4. warehouse actually delivery.
>
>           Not sure if it's a redundant feature.
>
>           Any comments are very welcome.
>
>           Best regards!
>
>           Exson
>
>            
>
>            
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Dear all,*

           Thank you for your comments.

           After investigate the processes, I found that webERP has not
provided a Dispatched Note with printed actual delivery quantity. There is
one which named packing note and dispatched notes in some interface. But the
actual delivery quantity can only be written manually. 

          In China and Hong Kong, lots of customers will not accept Delivery
Notes with handwriting number. Since the prices are not allowed shown in
Delivery Note, so the invoice cannot be used.

         So the dispatched note with actual delivery quantity is a must in
my opinion. I'll add it later. 

         And I've reviewed the picking lists too. It is designed concise and
great. A think a html view should be available, and the actual picked
quantity should also be recordable. Even we can use this to hold some goods
for special cases. 

         Thank you for the comments from Phil, Jo and Tim. 

         Any idea is still highly appreciated before I start to code it.

         Thanks and best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657326.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[rfthomas <rf...@as...>]

Exson,

I've attached a file with all of the patches that I have made to webERP
4.10.1  We only print invoices and packing slips in portrait mode.  We are
having problems with the newest versions.  I will document those later (they
all deal with creating bad PDF files - might be specific to our
installation).  We have also written a script that flattens multi-level BOMS
(attached).

patches.txt
<http://weberp-accounting.1478800.n4.nabble.com/file/n4657372/patches.txt>  
Flatten_BOMs.php
<http://weberp-accounting.1478800.n4.nabble.com/file/n4657372/Flatten_BOMs.php>  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657372.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

          Thank you for sharing this.

          I'll find sometime to study it. 

          Best regards!

          Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657374.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[icedlava <ice...@gm...>]

Hi Exson,

This would be useful to have as an option and would be used as main 
choice for the webERP installs we have.

While the picking list is useful, it would be beneficial to have 
Sales/accounts actually know the goods are actually picked  and be able 
to confirm delivery will go ahead, and then issue invoice.

Thanks for your good idea!

Cheers,




On 27 Mar 2014, at 20:03, ExsonQu wrote:

> *Dear all:*
>
>        I'm considering to add a feature to make warehouse preparing 
> the
> goods for sales orders and Accountant or Sales can know the goods are 
> ready
> to delivery or not more transparent. The scenario is like this:
>
>        1. First Sales select those orders should be arranged to 
> delivery.
>
>        2. Warehouse man check the order delivery schedule. And mark 
> the
> order lines when it's ready.
>
>        3. Sales(Or accountant) confirm the delivery and issue invoice
> according to the marked orders.
>
>        4. warehouse actually delivery.
>
>       Not sure if it's a redundant feature.
>
>       Any comments are very welcome.
>
>       Best regards!
>
>       Exson
>
>
>
>
>
>
>
> --
> View this message in context: 
> http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Phil D. <ph...@lo...>]

A dispatch note with the quantities on is effectively an invoice.
If you wish to show the quantities but not the price/extending total 
amounts then it is just a modification of the invoice script.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 06/04/14 03:22, ExsonQu wrote:
> *Dear all,*
>
>             Thank you for your comments.
>
>             After investigate the processes, I found that webERP has not
> provided a Dispatched Note with printed actual delivery quantity. There is
> one which named packing note and dispatched notes in some interface. But the
> actual delivery quantity can only be written manually.
>
>            In China and Hong Kong, lots of customers will not accept Delivery
> Notes with handwriting number. Since the prices are not allowed shown in
> Delivery Note, so the invoice cannot be used.
>
>           So the dispatched note with actual delivery quantity is a must in
> my opinion. I'll add it later.
>
>           And I've reviewed the picking lists too. It is designed concise and
> great. A think a html view should be available, and the actual picked
> quantity should also be recordable. Even we can use this to hold some goods
> for special cases.
>
>           Thank you for the comments from Phil, Jo and Tim.
>
>           Any idea is still highly appreciated before I start to code it.
>
>           Thanks and best regards!
>
>           Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657326.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Hi, Phil,*

            You're right. And I've same comments from Tim too. Thank you
very much.

            But things a little difference in China. Usually the delivery
note is in B5 size, so we have to create a different layout. I think there
are other Asia country also need this size.

            Best regards!

            Exson

            



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657339.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Rafael C. <raf...@gm...>]

Hi all,

My two cents: Here, in a hardware store, we have several people in the
process with several documents (to prevent stealing):

Sales_man send >---(Authorised picking list)---> Warehouse_man >---(goods
delivery note)---> Freight_man >---(goods receiving note)---> Customer's_man

For a "goods delivery note" we use the webERP picking list, signed by the "
Freight_man".
For a "goods receiving note" we use the webERP invoice, signed by the "
Customer'".

But, so far, in this hardware store, all the quantities in the 3 documents
are the same.

Best regards, Rafael.


2014-04-05 15:34 GMT-06:00 Phil Daintree <ph...@lo...>:

> A dispatch note with the quantities on is effectively an invoice.
> If you wish to show the quantities but not the price/extending total
> amounts then it is just a modification of the invoice script.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 06/04/14 03:22, ExsonQu wrote:
> > *Dear all,*
> >
> >             Thank you for your comments.
> >
> >             After investigate the processes, I found that webERP has not
> > provided a Dispatched Note with printed actual delivery quantity. There
> is
> > one which named packing note and dispatched notes in some interface. But
> the
> > actual delivery quantity can only be written manually.
> >
> >            In China and Hong Kong, lots of customers will not accept
> Delivery
> > Notes with handwriting number. Since the prices are not allowed shown in
> > Delivery Note, so the invoice cannot be used.
> >
> >           So the dispatched note with actual delivery quantity is a must
> in
> > my opinion. I'll add it later.
> >
> >           And I've reviewed the picking lists too. It is designed
> concise and
> > great. A think a html view should be available, and the actual picked
> > quantity should also be recordable. Even we can use this to hold some
> goods
> > for special cases.
> >
> >           Thank you for the comments from Phil, Jo and Tim.
> >
> >           Any idea is still highly appreciated before I start to code it.
> >
> >           Thanks and best regards!
> >
> >           Exson
> >
> >
> >
> > --
> > View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657326.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Hi, Rafael,*

       Thank you for your 2 cents.

       I'm wondering the same quantity is printed from webERP directly? Or
it's hand writing?

       Best regards!

       Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657340.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Rafael C. <raf...@gm...>]

Hi Exson,

So far, this hardware is lucky. Up today quantities are the same in:
* Sales_order,
* "Authorised Picking_list" (original Picking_list signed by salesmen
manager),
* "Goods delivery note" (2 copies of Picking_list. One to be signed by the
"Freight_man" and kept by "Warehouse_man" as proof of delivery; The second
signed by the "Warehouse_man" for "Freight_man"; the carrier must show this
document to the guard to be allowed to leave from the facility), and
* "Goods receiving note" (sales invoice to be signed by the customer).
So all are directly printed from webERP directly (or photocopied, --"Goods
delivery note"--).

But we expect that at some point they will be not (same quantities):
* Sales_order vs. Picking_list= if there are insufficient items in
inventory. {webERP can do? Not used yet.)
* "Authorised Picking_list" vs. "Goods delivery note"= if the goods are
sent by different trucks --carriers(*)-- {probably to hand write the
differences}

(*) Note: Carriers are individuals with a truck outside (not in payroll of)
the hardware store.

>From my point of view, it seems very complex for a small business. But they
had to do so to stop the thefts. Warehouse is audited with the Inventory >>
Inquiries and Reports >> List Inventory Status By Location/Category.
Differences are set against "Goods delivery note"s and
Goods_Received_Note's).

Best regards, Rafael.


----------
2014-04-05 20:02 GMT-06:00 ExsonQu <hex...@gm...>:

> *Hi, Rafael,*
>
>        Thank you for your 2 cents.
>
>        I'm wondering the same quantity is printed from webERP directly? Or
> it's hand writing?
>
>        Best regards!
>
>        Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657340.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Hi, Rafael,*

            Thank you for your suggestion. 

            I copy some other people's ideas from weberp forum:

Tim wrote
>                RE: Sales Order Processing
> The paper trail should go:
> 
> [Sales Order] -> [Picking Note] -> [Delivery note
> (AKA Dispatch Note)] -> [Invoice]
> 
> we have all this at the moment, but they are loosely connected. The
> process should be more rigorous. For example the organisation should
> choose what elements of the above trail they want, and then it should
> be impossible to do the next stage, until the previous one is done.
> 
> Tim 


I agree with the flow. Per my needs and to comment on the thread Exson
shared.
1) Pick List should show what needs to be picked AND what is available to be
picked (Current inventory and Lot/Serials if Item is controlled) with lines
for actual Qty Picked. Warehouse worker will write in the Qty picked of each
controlled item.
2) Shipping person will update in the system based on the picklist as
icedlava mentions in the thread (Update the table for the picking list) if
Picklist is reprinted shows this as "Already Picked Qty" and only show open
qty to pick if any
3) Packing slip is prepared based on the Pick Ticket and Qty/Batches in the
system. Other shipping paperwork (Shipping Labels for example which I am
developing). No inventory removed from system, no financial transactoin yet
but Packing Slip shows Real Qty going out door
4) Confirm Shipment (Based on Picked Quantities). Mark Pick List as closed.
Inventory reduced and Invoice ready to prepare. This is same as "Confirm
Shipment and Invoice" script now but I think we need an option from the
inventory menu because it might be a inventory/warehouse person that
performs the Shipment (Like "Receive Purchase Order" except "Ship Sales
Order")

Hope this helps. I am VERY interested in this functionality so I would be
willing to help code or especially test and provide feedback if needed.

Andrew 
</quotation>

Best regards!

Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657354.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[rfthomas <rf...@as...>]

Exson,

We are using the modification that you made to the cart that defaults to 0
for quantity shipped.  We cut an invoice using the quantity actually
shipped.  We have modified the Receivables : Print invoices and credit notes
to have a packing slip option.  It is the invoice with no pricing data.  I
can provide you with the modified scripts.

It is not as smooth a flow as people have described but it allows us to
generate proper packing slips and invoices.

We would really like the changes that have been outlined, especially
allowing quantities shipped to be entered, a packing slip generated and then
the invoice.  Right now everything is done backwards to our normal mode of
operation.

We rarely ship complete orders.  There are usually three or more shipments,
some of which are gated by weight and/or cost of total shipment.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657365.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew G. <aga...@re...>]

I'm interested in these modifications

Sent from my BlackBerry

-----Original Message-----
From: rfthomas <rf...@as...>
Date: Thu, 24 Apr 2014 15:15:09 
To: <web...@li...>
Reply-To: webERP Developers <web...@li...>
Subject: Re: [WebERP-developers] More convenient feature for preparing goods
 in warehouse and confirm delivery

Exson,

We are using the modification that you made to the cart that defaults to 0
for quantity shipped.  We cut an invoice using the quantity actually
shipped.  We have modified the Receivables : Print invoices and credit notes
to have a packing slip option.  It is the invoice with no pricing data.  I
can provide you with the modified scripts.

It is not as smooth a flow as people have described but it allows us to
generate proper packing slips and invoices.

We would really like the changes that have been outlined, especially
allowing quantities shipped to be entered, a packing slip generated and then
the invoice.  Right now everything is done backwards to our normal mode of
operation.

We rarely ship complete orders.  There are usually three or more shipments,
some of which are gated by weight and/or cost of total shipment.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657365.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew G. <aga...@re...>]

I'm interested in these modifications

Sent from my BlackBerry

-----Original Message-----
From: rfthomas <rf...@as...>
Date: Thu, 24 Apr 2014 15:15:09 
To: <web...@li...>
Reply-To: webERP Developers <web...@li...>
Subject: Re: [WebERP-developers] More convenient feature for preparing goods
 in warehouse and confirm delivery

Exson,

We are using the modification that you made to the cart that defaults to 0
for quantity shipped.  We cut an invoice using the quantity actually
shipped.  We have modified the Receivables : Print invoices and credit notes
to have a packing slip option.  It is the invoice with no pricing data.  I
can provide you with the modified scripts.

It is not as smooth a flow as people have described but it allows us to
generate proper packing slips and invoices.

We would really like the changes that have been outlined, especially
allowing quantities shipped to be entered, a packing slip generated and then
the invoice.  Right now everything is done backwards to our normal mode of
operation.

We rarely ship complete orders.  There are usually three or more shipments,
some of which are gated by weight and/or cost of total shipment.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657365.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

         Thank you for like sharing your modification. 
         Please send me your scripts modified at your convenience. When I
start to considering the improvement, I'm wondering how can I align those
new features with current design. It seems redundant for some businesses.

         I'll manage to prepare a spec in May.

        Thanks and best regards!

        Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657369.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Dear all,*

       I've prepared a table schema.  The work flow is the sales can create
a Picking Request to Warehouse, the pr can includes multiple orders order
lines. The only limit that they must be delivery from same location. The
warehouse can pick after the pr is approved. When the pr is fulfilled,
sales(A/R client) can invoice from these fulfilled pr. The pr can be
fulfilled several times.

       Any comments are welcome!

       
        

           CREATE table pickrequest (prid int not null,
			initiator varchar(20) not null default '',
			initdate date not null default '0000-00-00',
			approvedate date not null default '0000-00-00',
			status varchar(12) not null default '',
			comments text default null,
			closed tinyint not null default '0',
			loccode varchar(5) not null default '',
			PRIMARY KEY (`prid`),
			key (`initiator`),
			key (`initdate`),
			key (`requestdate`),
			CONSTRAINT FOREIGN KEY(`loccode`) REFERENCES `locations`(`loccode`))
Engine=InnoDB DEFAULT CHARSET=utf8;

CREATE table pickrequestdetails (detailno int not null auto_increment,
	                         prid int not null default '1',
				orderno int not null default '1',
				orderlineno int not null default '0',
				stockid varchar(20) not null default '',
				qtyexpected double not null default '0',
				qtypicked double not null default '0',
				invoicedqty double not null default '0',
				shipqty double not null default '0',
				completed tinyint not null default '0',
				requestdate date not null default '0000-00-00',
				PRIMARY KEY (`detailno`),
				key (`prid`),
				key (`orderno`),
				key (`pickdate`),
				key (`shipdate`),
				constraint foreign key (`stockid`) REFERENCES stockmaster(`stockid`),
				constraint foreign key (`orderno`) REFERENCES salesorders(`orderno`),
				constraint foreign key (`prid`) REFERENCES
pickrequest(`prid`))Engine=InnoDB DEFAULT CHARSET=utf8;
CREATE table pickfulfill (pickno int not null auto_increment,
			   detailno int not null default '0',
			   stockid varchar(20) not null default '',
			   pickqty double not null default '0',
			   invoqty double not null default '0',
			   shipqty double not null default '0',
			   pickdate date not null default '0000-00-00',
			   invodate date not null default '0000-00-00',
			   shipdate date not null default '0000-00-00',
			   pickby varchar(20) not null default '',
			   shipby varchar(20) not null default '',
			   PRIMARY KEY (`pickno`),
			   KEY (`detailno`),
			   KEY (`pickdate`),
			   KEY (`shipdate`),
			   KEY (`invodate`),
			   CONSTRAINT FOREIGN KEY (`stockid`) REFERENCES stockmaster(`stockid`),
			   CONSTRAINT FOREIGN KEY (`detailno`) REFERENCES
pickrequestdetails(`detailno`))Engine=InnoDB DEFAULT CHARSET=utf8;
				
	

CREATE table pickserialmoves (serialmoveid int not null auto_increment,
				pickno int not null default '0',
				stockid varchar(20) not null default '',
				serialno varchar(30) not null default '',
				moveqty double not null default '0',
				PRIMARY KEY (`serialmoveid`),
				key (`pickno`),
				key (`stockid`,`serialno`),
				key (`serialno`),
				CONSTRAINT FOREIGN KEY (`pickno`) REFERENCES pickfullfill(`pickno`),
				CONSTRAINT FOREIGN KEY (`stockid`,`serialno`) REFERENCES
`stockserialitems`(`stockid`,`serialno`))Engine=InnoDB DEFAULT CHARSET=utf8;

Best regards!

Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657484.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew G. <aga...@re...>]

I like this.  1 Comment, Currently there is a pick list function - I am not 100% sure it works but it attempts to do something similar.  This should probably be disabled or replaced with this.  The output of that function is very nice though - something similar should be available for picking in the warehouse.  Also - another document (same format ok) but called Packing List should be able to be generated based on what is picked (including lot/serial)

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com


-----Original Message-----
From: ExsonQu [mailto:hex...@gm...] 
Sent: Thursday, May 29, 2014 3:42 AM
To: web...@li...
Subject: Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

*Dear all,*

       I've prepared a table schema.  The work flow is the sales can create a Picking Request to Warehouse, the pr can includes multiple orders order lines. The only limit that they must be delivery from same location. The warehouse can pick after the pr is approved. When the pr is fulfilled, sales(A/R client) can invoice from these fulfilled pr. The pr can be fulfilled several times.

       Any comments are welcome!

       
        

           CREATE table pickrequest (prid int not null,
			initiator varchar(20) not null default '',
			initdate date not null default '0000-00-00',
			approvedate date not null default '0000-00-00',
			status varchar(12) not null default '',
			comments text default null,
			closed tinyint not null default '0',
			loccode varchar(5) not null default '',
			PRIMARY KEY (`prid`),
			key (`initiator`),
			key (`initdate`),
			key (`requestdate`),
			CONSTRAINT FOREIGN KEY(`loccode`) REFERENCES `locations`(`loccode`)) Engine=InnoDB DEFAULT CHARSET=utf8;

CREATE table pickrequestdetails (detailno int not null auto_increment,
	                         prid int not null default '1',
				orderno int not null default '1',
				orderlineno int not null default '0',
				stockid varchar(20) not null default '',
				qtyexpected double not null default '0',
				qtypicked double not null default '0',
				invoicedqty double not null default '0',
				shipqty double not null default '0',
				completed tinyint not null default '0',
				requestdate date not null default '0000-00-00',
				PRIMARY KEY (`detailno`),
				key (`prid`),
				key (`orderno`),
				key (`pickdate`),
				key (`shipdate`),
				constraint foreign key (`stockid`) REFERENCES stockmaster(`stockid`),
				constraint foreign key (`orderno`) REFERENCES salesorders(`orderno`),
				constraint foreign key (`prid`) REFERENCES pickrequest(`prid`))Engine=InnoDB DEFAULT CHARSET=utf8; CREATE table pickfulfill (pickno int not null auto_increment,
			   detailno int not null default '0',
			   stockid varchar(20) not null default '',
			   pickqty double not null default '0',
			   invoqty double not null default '0',
			   shipqty double not null default '0',
			   pickdate date not null default '0000-00-00',
			   invodate date not null default '0000-00-00',
			   shipdate date not null default '0000-00-00',
			   pickby varchar(20) not null default '',
			   shipby varchar(20) not null default '',
			   PRIMARY KEY (`pickno`),
			   KEY (`detailno`),
			   KEY (`pickdate`),
			   KEY (`shipdate`),
			   KEY (`invodate`),
			   CONSTRAINT FOREIGN KEY (`stockid`) REFERENCES stockmaster(`stockid`),
			   CONSTRAINT FOREIGN KEY (`detailno`) REFERENCES pickrequestdetails(`detailno`))Engine=InnoDB DEFAULT CHARSET=utf8;
				
	

CREATE table pickserialmoves (serialmoveid int not null auto_increment,
				pickno int not null default '0',
				stockid varchar(20) not null default '',
				serialno varchar(30) not null default '',
				moveqty double not null default '0',
				PRIMARY KEY (`serialmoveid`),
				key (`pickno`),
				key (`stockid`,`serialno`),
				key (`serialno`),
				CONSTRAINT FOREIGN KEY (`pickno`) REFERENCES pickfullfill(`pickno`),
				CONSTRAINT FOREIGN KEY (`stockid`,`serialno`) REFERENCES `stockserialitems`(`stockid`,`serialno`))Engine=InnoDB DEFAULT CHARSET=utf8;

Best regards!

Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657484.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download
http://p.sf.net/sfu/restlet
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[rfthomas <rf...@as...>]

We generally bill (invoice) based on the items actually shipped.  We have
provided previously a modification to the invoice/credit note printing in
the Receivables Reports that generates a packing slip that is the invoice
without the prices.

Would it make some sense to treat the picks made as the data entry for the
invoice, i.e. have a separate function that would enter such to then be
edited/approved by the staff responsible for generating invoices?

Would the following flow be reasonable:

1) Generate Pick List from open items on invoice, showing qty on-hand at
location.
2) Using pick list and modifications due to actual picks, create packing
slip and preliminary invoice.
3) Edit/approve packing slip and preliminary invoice.  Very occasionally a
shipment is cancelled somewhere in the process prior to shipment.  We need
to be able delete/cancel the pick list, preliminary packing slip and
preliminary invoice.
4) Print packing slip, generate invoice.

Based on the organization these might need to be handled by multiple people.

In our case, we don't have repeating orders so once the packing slip is
generated, the inventory has been shipped.   The picking list should then be
automatically deleted.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657486.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Dear Andrew and Bob,*

           Thank you for your comments. 

            But I'm still feel uncertain of this solution. It's not so
simple and powerful to meet webERP's style.  I've coded part of them and
we've developing a similar solution for a client. But it seems not so
generic. 

            The purpose of this feature is to improve the communication
between sales and warehouse, accountant and warehouse. 
            The original one in webERP now from Tim has provide a very smart
solution. The weak point is that there is no place for warehouse to provide
the picked items data. 
            A simple solution maybe like this:

            1. System automatically create a batch of Picking lists
according to some rules. The most important data is Serial/Batch No, A FIFO
rules maybe followed. But sometime this cannot be followed for those
warehouse keeping not so great, to pick according to serial no will be quite
time consuming. 
            2. Then warehouse people can modify those auto generated one to
confirm it. 
            3. Sales or accountants invoice it according to the confirmed
invoice. 
           
             Any idea are appreciated!

              Best regards!

              Exson
           
 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657489.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Phil D. <ph...@lo...>]

Hi Bob,

Where we can I prefer webERP to adopt least effort/data entry work 
flows. I accept that there are places where more data entry is required 
if you wish to build in double checks/authorisation. However, many 
businesses cannot afford additional personnel to double key and separate 
layers of staff to authorise picks etc... webERP is more aimed at 
businesses where the personnel doing the picking are also producing the 
invoice. I like the idea of the invoice without prices for a packing 
slip with actual quantities where the hand written quantities on the 
packing slip are not sufficient.

The scenario you propose, I think this is a worthy modification but 
possibly one that should be either an option in config or perhaps a 
special case for your business. It is adding significant complexity that 
I would rather avoid in the standard version.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 30/05/14 02:14, rfthomas wrote:
> We generally bill (invoice) based on the items actually shipped.  We have
> provided previously a modification to the invoice/credit note printing in
> the Receivables Reports that generates a packing slip that is the invoice
> without the prices.
>
> Would it make some sense to treat the picks made as the data entry for the
> invoice, i.e. have a separate function that would enter such to then be
> edited/approved by the staff responsible for generating invoices?
>
> Would the following flow be reasonable:
>
> 1) Generate Pick List from open items on invoice, showing qty on-hand at
> location.
> 2) Using pick list and modifications due to actual picks, create packing
> slip and preliminary invoice.
> 3) Edit/approve packing slip and preliminary invoice.  Very occasionally a
> shipment is cancelled somewhere in the process prior to shipment.  We need
> to be able delete/cancel the pick list, preliminary packing slip and
> preliminary invoice.
> 4) Print packing slip, generate invoice.
>
> Based on the organization these might need to be handled by multiple people.
>
> In our case, we don't have repeating orders so once the packing slip is
> generated, the inventory has been shipped.   The picking list should then be
> automatically deleted.
>
> Bob Thomas
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657486.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Time is money. Stop wasting it! Get your web API in 5 minutes.
> www.restlet.com/download
> http://p.sf.net/sfu/restlet
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew G. <aga...@re...>]

Exson,
Is there any update on this work?
I am considering adding a simple function to  allow this separation of pick/pack/invoice but I do not want to do the work if you have already done it.

Best Regards,
Andrew Galuski
ResMart LLC.
817.615.2038 (Office)
817.821.0544 (Cell)
www.resmart.com


-----Original Message-----
From: ExsonQu [mailto:hex...@gm...] 
Sent: Thursday, May 29, 2014 3:42 AM
To: web...@li...
Subject: Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[Andrew Galuski] 

Dear Andrew and Bob,

           Thank you for your comments. 

            But I'm still feel uncertain of this solution. It's not so simple and powerful to meet webERP's style.  I've coded part of them and we've developing a similar solution for a client. But it seems not so generic. 

            The purpose of this feature is to improve the communication between sales and warehouse, accountant and warehouse. 
            The original one in webERP now from Tim has provide a very smart solution. The weak point is that there is no place for warehouse to provide the picked items data. 
            A simple solution maybe like this: 

            1. System automatically create a batch of Picking lists according to some rules. The most important data is Serial/Batch No, A FIFO rules maybe followed. But sometime this cannot be followed for those warehouse keeping not so great, to pick according to serial no will be quite time consuming. 
            2. Then warehouse people can modify those auto generated one to confirm it. 
            3. Sales or accountants invoice it according to the confirmed invoice. 
            
             Any idea are appreciated! 

              Best regards! 

              Exson



*Dear all,*

       I've prepared a table schema.  The work flow is the sales can create a Picking Request to Warehouse, the pr can includes multiple orders order lines. The only limit that they must be delivery from same location. The warehouse can pick after the pr is approved. When the pr is fulfilled, sales(A/R client) can invoice from these fulfilled pr. The pr can be fulfilled several times.

       Any comments are welcome!

       
        

           CREATE table pickrequest (prid int not null,
			initiator varchar(20) not null default '',
			initdate date not null default '0000-00-00',
			approvedate date not null default '0000-00-00',
			status varchar(12) not null default '',
			comments text default null,
			closed tinyint not null default '0',
			loccode varchar(5) not null default '',
			PRIMARY KEY (`prid`),
			key (`initiator`),
			key (`initdate`),
			key (`requestdate`),
			CONSTRAINT FOREIGN KEY(`loccode`) REFERENCES `locations`(`loccode`)) Engine=InnoDB DEFAULT CHARSET=utf8;

CREATE table pickrequestdetails (detailno int not null auto_increment,
	                         prid int not null default '1',
				orderno int not null default '1',
				orderlineno int not null default '0',
				stockid varchar(20) not null default '',
				qtyexpected double not null default '0',
				qtypicked double not null default '0',
				invoicedqty double not null default '0',
				shipqty double not null default '0',
				completed tinyint not null default '0',
				requestdate date not null default '0000-00-00',
				PRIMARY KEY (`detailno`),
				key (`prid`),
				key (`orderno`),
				key (`pickdate`),
				key (`shipdate`),
				constraint foreign key (`stockid`) REFERENCES stockmaster(`stockid`),
				constraint foreign key (`orderno`) REFERENCES salesorders(`orderno`),
				constraint foreign key (`prid`) REFERENCES pickrequest(`prid`))Engine=InnoDB DEFAULT CHARSET=utf8; CREATE table pickfulfill (pickno int not null auto_increment,
			   detailno int not null default '0',
			   stockid varchar(20) not null default '',
			   pickqty double not null default '0',
			   invoqty double not null default '0',
			   shipqty double not null default '0',
			   pickdate date not null default '0000-00-00',
			   invodate date not null default '0000-00-00',
			   shipdate date not null default '0000-00-00',
			   pickby varchar(20) not null default '',
			   shipby varchar(20) not null default '',
			   PRIMARY KEY (`pickno`),
			   KEY (`detailno`),
			   KEY (`pickdate`),
			   KEY (`shipdate`),
			   KEY (`invodate`),
			   CONSTRAINT FOREIGN KEY (`stockid`) REFERENCES stockmaster(`stockid`),
			   CONSTRAINT FOREIGN KEY (`detailno`) REFERENCES pickrequestdetails(`detailno`))Engine=InnoDB DEFAULT CHARSET=utf8;
				
	

CREATE table pickserialmoves (serialmoveid int not null auto_increment,
				pickno int not null default '0',
				stockid varchar(20) not null default '',
				serialno varchar(30) not null default '',
				moveqty double not null default '0',
				PRIMARY KEY (`serialmoveid`),
				key (`pickno`),
				key (`stockid`,`serialno`),
				key (`serialno`),
				CONSTRAINT FOREIGN KEY (`pickno`) REFERENCES pickfullfill(`pickno`),
				CONSTRAINT FOREIGN KEY (`stockid`,`serialno`) REFERENCES `stockserialitems`(`stockid`,`serialno`))Engine=InnoDB DEFAULT CHARSET=utf8;

Best regards!

Exson





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657484.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download
http://p.sf.net/sfu/restlet
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] More convenient feature for preparing goods in warehouse and confirm delivery

[ExsonQu <hex...@gm...>]

*Hi, Andrew,*

           Sorry for the late reply. 
           We've spent a lots of time to develop this parts. But it seems
more complex than what we thought before. And we cannot release it now due
to it's too complex and customized. It's not webERP's style-simple and
practical. 
            
           I think the big problem for webERP now is that these users in
warehouse and users in sales team have no channel to communicate which
lots/serial no have picked for those orders. A users from Britain has donate
some code to add those lots/serial no to sales orders comments. It seems a
big idea to solve this problem. But the version of he used is quite old, I
have to review those codes and ask other developers' opinion before I can
commit it to the trunk. 

           Best regards!

           Exson
            



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/More-convenient-feature-for-preparing-goods-in-warehouse-and-confirm-delivery-tp4657290p4657635.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.