×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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.

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:

  • 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.

Hey,
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.

(OP)
Thanks for the reply! You mentioned Crystal, and it got me thinking, I think that modifying the Existing "Print Work Orders" report (PP04P1SQL.RPT)would the best way to continue. The way I see it, is it will be a built in function of progression and would be accessible at any time, as long as the end user has the barcode font installed on his machine I can't see a downside to this. I will update as I progress.

RE: Attempting to put (Print, stick or any way attach) a POP Number on OE Pick Ticket.

(OP)
Okay, well my idea above will not work. I overlooked the fact that embedded crystal reports get the font re-formatted by Progression. Worst case scenario I am going to create a Crystal report and just put a shortcut to the Progression menu as a "Work Order".

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.

Instead of formatting the existing field as a barcode, add a new field and see if that works. You could also run the report in crystal itself external to Macola.

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close