Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.
Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.
(OP)
Hello all.
We are using Progression 7.7.500. We have Flex, and make use of it a lot, though I know nothing about it.
We are a custom manufacturing facility and are developing an in house solution to keep track of employee activity on POP orders. Currently, when we sell a piece of equipment to a customer, we write an OE ticket and also a POP order. Then the sales person who sold and printed the OE ticket, simply hand writes the POP order number on the ticket.
With the Time keeping application I am working on, I need to somehow provide a barcode of the POP order number that accompanies the OE Pick Ticket. A couple options I have thought of were:
Thanks for any feedback you all may have.
We are using Progression 7.7.500. We have Flex, and make use of it a lot, though I know nothing about it.
We are a custom manufacturing facility and are developing an in house solution to keep track of employee activity on POP orders. Currently, when we sell a piece of equipment to a customer, we write an OE ticket and also a POP order. Then the sales person who sold and printed the OE ticket, simply hand writes the POP order number on the ticket.
With the Time keeping application I am working on, I need to somehow provide a barcode of the POP order number that accompanies the OE Pick Ticket. A couple options I have thought of were:
- Print the barcode representing the POP order number on the OE Pick ticket. I am not sure of this method for a couple reasons though. Can I even link a POP number to OE Pick Ticket? Another issue is will a 24 pin Dot Matrix printer reliably print a barcode?
- Another option would be to print a separate label with the barcode needed for the POP order number to a separate label printer for the salesman to peel and stick it. Could this be done automatically using flex? how would I go about starting this?
- Provide the salesmen with pre-printed barcode labels and let them create the POP number manually rather using F5 to get the next sequential number. I realize this is probably an archaic way to do it, but if the above 2 option would work I am out of ideas.
Thanks for any feedback you all may have.
RE: Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.
You can link the tables like this:
PPORDFIL_SQL.Src_Ord_Type = OEORDLIN_SQL.Ord_Type and
PPORDFIL_SQL.Src_Ord_No = OEORDLIN_SQL.Ord_No and
PPORDFIL_SQL.Src_Line_No = OEORDLIN_SQL.Line_No
or for order history
PPORDFIL_SQL.Src_Ord_Type = OELINHST_SQL.Ord_Type and
PPORDFIL_SQL.Src_Ord_No = OELINHST_SQL.Ord_No and
PPORDFIL_SQL.Src_Line_No = OELINHST_SQL.Line_No
Make sure you choose the PPORDFIL.Src_Pkg_Id = 'OE'
Do you have Crystal Reports? You could make barcodes with it and print to laser printer.
RE: Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.
RE: Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.
DBergkamp10, Do you know if there is there a way I can edit the query for the Pick Ticket form, this way I can include the query you provided?
RE: Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html