Ok, That works great. Now say the some segments are divided by a "X" instead of a "-" could I put a what if type statement to either look at the "-" or the "x". For part numbers that have "-" I am adding a suffix to the grouping name such as "X-X-S" and for the "x" i would like to add a...
I am trying to attach an object such as a picture or drawing to an inventory item. according to the help files there is a button for Ole objects within the note for items, but no such button found. Any ideas how to atttach pictures to inventory items.
Thanks
I would like to group a series of part#'s by the prefix of the part #. The format of the records are similar to this.
1111-222-3s-3s, 1111-222-4s-4s, etc. I am looking to group these records based on the characters proceding the first dash.
Any help would greatly be apprciated.
Thanks
I am thinking about using a pocket pc type device to do physical inventory. I created an application were the barcode is scanned and the operator would input the quanity available. This is in a access database that was originaly created from exporting the items from the inventory tables. My...
jazgeek,
I tried that, but get a linking error in crystal.
I have the item # in sop10100 linked to item # in sop 60300. If I try linking the custmr # in 60300 to custmr # in sop10100 this is when i get the error. I am using the following tables sop50200, sop50300,iv00101, rm00102, sop60300, sop...
I have designed a packaging label in crystal that prints a label for every line item on an order. The problem that I am having is that the field for the Customer Item # is not printing correctly. The customer's Item # prints but is not the # that applies to that particular customer. I suspect it...
I need to generate a monthly report that shows sales taxes paid based on customer. I have been experimenting with crystal reports and think I am close. The tables i am using our rm30502, rm00401,rm30201,rm30101,rm00101. I would like the report to show colum of invoices paid by cutomer name and...
Same printer as you z4m Plus.
3"x3" label size. This will be a label to placed on a bag or box. It will have the customer's Name, Customer's PO, Item #, Customers's Item #, Quanity of items. One label per line item of packing slip, but need to have the option of having additional labels per line...
Additionally when i look at the table via the sql server manager. They look identical to the tools> table descriptions. They only have the added charactors when viewing through the odbc connection.
I am pretty much a newbie in sql. I have located the tables within the odbc connection within crystal reports. The table look close but they have some prefixes such as zd_sop10100_1.1. Then when i look at the fields in those tables they also have some additional Prefixes such as @.
Thanks Tim
It a Zebra printer. I have there free software Barone lite software. Which would create the format. I don't know if this limited version would allow an export. How about a solution for printing these labels along with the packing list. I have Forms Printer by Accountable which I believe will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.