RE: Customer Product Codes on Invoices

We had the mod/bespoke done as our 'full' style SKU can be ordered by
several customers and therefore there is no one to one relationship between
our SKU and a SINGLE Customer. We also have built an extensive X-Ref table
whose initial purpose was to support EDI Order Processing as we don't use a
UPC Catalog. We needed to relate our FULL SKU to a specific Customer SKU.
This table is maintained by Customer. We have since expanded its use to
assign a Salesman for each SKU, the warehouse/depot, price and case quantity
validation, etc.


-------------------------------------------
Arthur Weiner
Manager, Information Systems
S. Goldberg & Co., Inc.
20 E. Broadway
Hackensack, NJ 07601
V. 201-342-1200
F. 201-342-4405
arthur@sgfootwear.com


> -----Original Message-----
> From: owner-jbausers-l@midrange.com
> [mailto:owner-jbausers-l@midrange.com]On Behalf Of Dan Thomas
> Sent: Wednesday, September 13, 2000 9:44 AM
> To: 'JBAUSERS-L@midrange.com'
> Subject: RE: Customer Product Codes on Invoices
>
>
> So do different customer's have their own different item numbers for a
> single item# in your system?  And where are you storing this
> information in
> JBA?
>
> We've dealt with this situation by loading the customer item#s as
> alternative item reference numbers (F17 in Item Maintenance).  We also
> modified AOE so that when you enter an order for a particular
> customer, that
> item references that include a customer# will only "work" for
> that customer.
> Item references without a customer# will work for anyone.  We
> have AOE setup
> defaulting to item entry method 4=Alternative Item reference.
>  This does
> require you have an item reference for each item even if it
> is the same as
> your item#.  We specify a type of "I" to indicate this
> reference is the one
> that should print on the invoice.
>
> Dan Thomas
> Sr. VP Information Systems
> MDI
> 4500 Progress Blvd.
> Louisville, KY  40218-5058
> Phone (502) 454-9013 ext. 120
> www.mdiweb.com
>
>
> -----Original Message-----
> From: JonWadey@mst-ltd.co.uk [mailto:JonWadey@mst-ltd.co.uk]
> Sent: Wednesday, September 13, 2000 9:04 AM
> To: JBAUSERS-L@midrange.com
> Subject: Customer Product Codes on Invoices
>
>
>
>
> Hi folks
>
> Does anybody currently / or know anyway of showing their
> customers Part No
> on a
> sales invoice instead of their own part No.  If so is this standard
> functionality or did you have it bespoked.
>
> Thanking you all in anticipation
>
>
> Jon.
>
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---