There's a lot of truth in your comments. We usually don't make a habit of making requests of our customers, even though there definitely are times when it's the only appropriate solution. There's the "make it work" mentality to contend with.
We currently use the 812 (your option 2) with some customers, but not all support that method- since from the customer's perspective it amounts to letting someone hold on to thousands of your dollars for a month or two - when you could be earning returns on it in your own account. >>Finally, you might have to work with and educate your marketing management; Whoa! Now, let's not be hasty! We may need to replace this accounting system before we go there. :) Thank you Susan Travis- -----Original Message----- From: Susan Stecklair [mailto:[EMAIL PROTECTED] Sent: Saturday, April 21, 2007 1:56 PM To: [EMAIL PROTECTED]; [email protected] Subject: Re: Complex SAC segment handling in 850 & 810 Hi Travis -- I have several thoughts, but I had a similar dilemma when trying to automate a company that had a very complex pricing models. They called it configured pricing. Their pricing manager seemed almost proud that they had hired a consultant & he wasn't able to figure out how to download their pricing into an EXCEL spreadsheet based upon all of their configurations. Their distributors would get a set discount -- example of 20%. In addition, there might be special pricing based upon channel: DOD got another discount, educational institutions another, etc. Then there might be a special marketing program offer, "end of quarter get product out the door special", etc. My suggestion to you is: * have your distributors/customers send their net contract price on the PO1 To manage the other scenarios there were 2 options: * Option 1: Create unique skus for each part number/channel (solve most of the issues). Perhaps even create special SKU's for programs. * Option 2: Incorporate a Request for Credit/Response. So the orders are placed with the contract discounted price only. Then your distributor/customer or company places a separate request for credit which can be incorporated in a database, reviewed, & then the appropriate credits are issued. There are EDI transactions for this, but you could also first implement a comma delimited file. Then your order management/invoicing process is simple, and you are dealing with exception processing outside of the order management process. Finally, you might have to work with and educate your marketing management; that the company does not have a sophisticated system, and their marketing/pricing plans are not in synch with their strategic strategy of making your company easy to work with. Even though they were able to do this at Proctor & Gamble, you are a small operation. This gets delicate, but needs to be communicated. Frequently, companies have quarterly reviews with their key customers & this could be broached at this time with them. Naturally you would have to work a program with your customers, to understand their issues, too. Feel free to contact me offline if you wish to discuss further. It is difficult to assess the root cause of your problem with so little information, but this appears to be a broken business process, and not something you should try to fix with as only an EDI mapping issue. Good luck Susan Stecklair, President Electronic Commerce, Inc. <http://www.ecommerce-inc.com> Your Leader in EDI, Web 2.0, Integration Services and Products blog <http://www.ecommerce-inc.com/trends> on eCommerce Trends, Issues and Outsourcing ( 408.996.7492 Business Office ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
