Re: [U2] EDI Question...
We are using Dataflo from epicor, Unidata, Kore Kourier electronic forms rand Redback for our storfront application - Original Message - From: da...@sysmarkinfo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, January 02, 2014 6:50 PM Subject: Re: [U2] EDI Question... Robert, What database are you running your backend software on? What's more affordable as an inhouse product or cloud-based service? Happy New Year, Dave On 2013-12-31 08:46, Robert Frailey wrote: EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
Like George, we also bypassed the VAN in favor of direct ftp transfers with our trading partners around 10 years ago. We're using flat, delimited files loosely defined to match the traditional EDI document specs - 850, 810, and 997 in our case. We've also run into the issue of having to tweak things for each individual partner, but have found that things eventually run smoothly once we've been in production for a while. Fortunately for us, we only have a handful of large customers and vendors so we're not constantly adding new partners into the mix. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, December 31, 2013 8:46 AM To: U2 Users List Subject: Re: [U2] EDI Question... EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
Robert, What database are you running your backend software on? What's more affordable as an inhouse product or cloud-based service? Happy New Year, Dave On 2013-12-31 08:46, Robert Frailey wrote: EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
Hi Rob, I have a couple of options for you that will let you handle EDI in-house. Not MV specific but we do have serveral MV and U2 customers. Please email me at craig.benn...@flowsoftware.com.au if you are interested. Craig On 3 January 2014 12:50, da...@sysmarkinfo.com wrote: Robert, What database are you running your backend software on? What's more affordable as an inhouse product or cloud-based service? Happy New Year, Dave On 2013-12-31 08:46, Robert Frailey wrote: EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
Yes Each trading partner should have their own ISA counter. The GS Counter for each transaction set and each trading partner should have their own counter. This is one way to tell if you are missing a record. Jon Card VP Special Projects Combined Transport, Inc. 541-618-6565 Fax 541-826-9787 www.combinedtransport.com Division of Combined Transport Logistics Group, Inc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, December 31, 2013 7:40 AM To: U2 Users Subject: [U2] EDI Question... The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
Thanks. I should be good then. Just making sure it didn't need to be on a VAN level. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter S. Goldberger Sent: Tuesday, December 31, 2013 10:56 AM To: U2 Users List Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Card Sent: Tuesday, December 31, 2013 10:54 AM To: U2 Users List Subject: Re: [U2] EDI Question... Yes Each trading partner should have their own ISA counter. The GS Counter for each transaction set and each trading partner should have their own counter. This is one way to tell if you are missing a record. Jon Card VP Special Projects Combined Transport, Inc. 541-618-6565 Fax 541-826-9787 www.combinedtransport.com Division of Combined Transport Logistics Group, Inc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, December 31, 2013 7:40 AM To: U2 Users Subject: [U2] EDI Question... The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
We are using custom software that is integrated to our current order processing. Luckily we are only doing 850/855 and 810 at the moment. And I'm sure 856 in the future. Where it's getting difficult (at the expense of expense) - is doing direct ftp with partners to bypass the VANs and The IMO absolutely outrageous transmissions costs. So we are doing a combination of XML with our VAN, and edi with our direct partners - the XML side doesn't need 997's Whereas the edi side does. What our system does is converts the XML - edi , then converts the edi to an internal multivalued format Our order entry, and billing is based off that internal format. Then when we need to send out a document The internal format is converted back to either edi or xml and then FTP'd to each of the appropriate servers. It's annoying in every time we gain a new partner, the software needs to be tweeked to each of their uniqueness Within their document requirements. As standards go, EDI is the most non standardized standard I have seen. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, December 31, 2013 11:46 AM To: U2 Users List Subject: Re: [U2] EDI Question... EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EDI Question...
Thank You Robert - Original Message - From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 9:56 AM Subject: Re: [U2] EDI Question... We are using custom software that is integrated to our current order processing. Luckily we are only doing 850/855 and 810 at the moment. And I'm sure 856 in the future. Where it's getting difficult (at the expense of expense) - is doing direct ftp with partners to bypass the VANs and The IMO absolutely outrageous transmissions costs. So we are doing a combination of XML with our VAN, and edi with our direct partners - the XML side doesn't need 997's Whereas the edi side does. What our system does is converts the XML - edi , then converts the edi to an internal multivalued format Our order entry, and billing is based off that internal format. Then when we need to send out a document The internal format is converted back to either edi or xml and then FTP'd to each of the appropriate servers. It's annoying in every time we gain a new partner, the software needs to be tweeked to each of their uniqueness Within their document requirements. As standards go, EDI is the most non standardized standard I have seen. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, December 31, 2013 11:46 AM To: U2 Users List Subject: Re: [U2] EDI Question... EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users