Additional Data

[wwwedward]

I have three new data fields related to picking infomation. Picking start time, stop time, and number of pallets. This information is from an order pulling environment. The information will be hand written on the bottom of a picking ticket. I would like to build this into the order header and then on to header history. I only have one userer field open? Does anyone have a suggestion on the best method for tying this information into macola?

sql 2000 macola 7.5103f

 

[kscheeler]

It would depend on how that data is going to get into Macola. If someone is going to enter it, you could use Flex to pop up a box listing out 3 fields. Once they entered the information in, Flex would write it to the open UDF field leaving 10 characters per segment. You could then use a view to parse it out for viewing purposes.

If you are going to populate it automatically, you could do almost the same thing. If there is enough space, you could put some type of spacer between the fields.

Kevin Scheeler

 

[dgillz]

There are 5 user defined fields in the order header, and the info in them will automatically post to the header history when the invoices post.

Do you own the screen designer? If so just unhide these fields, place them where desired, change the tab order and give them a descriptive label.

If this is a problem, please let me know.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

If you are hand writing the info on the picking ticket, who is going to key the information into macola? The person doing the billing? If so, you have three lines of comments on the billing screen for data entry & you can create literals on the pick ticket form itself such as:
pick time start _________ complete ________ # pallets ______
It sounded like you only had one user field left in order header.

 

[wwwedward]

Yes I only have one use field left in oe header. Capturing at the time of billing would be ideal. The comment fields do they write to oeheader history in billing? Do you see a probelm if the data is entered without a time format: For instance: start: 1:20 pm end 3:00 pm. This entered as 120 and 300 just to avoid stripping the data later in crystal. I do not own flex at this time.. I think the billing comments might work if they go to a proper history file with the order number attached.

 

[MacolaHelp]

billing comments write to the order header file. You also have reference (which defaults to customer po/order number) and batch id fields. You can't change the formatting on any of these fields, so you would need to be consistent on how you enter the data. You can retitle the field names & unhide the comment 2 & 3 literals.