>>To all of you on the "vendor/supplier/manufacturer" side of the coin - are >>your systems so ... stupid ... that they can't do a simple calculation such >>as this?
I've whined about how "stupid" our ERP system is for years! Of course we could do the calculations in the map - there's no need for any amazing functionality in your business systems. However, in practice most of our customers require the SAC info returned (in it's exact original form) in the invoice. That can be more tricky, unless you're doing some kind of clunky turn-around document where you just copy what they sent and send it back out. (that comes with a lot of other negatives - so that shouldn't even count!) The SAC let's you use rates, percentages, quantity of free product, effective quantity for the discount...as well as stuff that may not be in the standards but your partner wants anyway...... Working with one type of discount would be easier than handling all possibilities. If your system's calculations round with different precision than your partner's, you might a penny off and have to work on that as well. All in all, yeah- it's not that hard, but in my opinion it can be a headache, too. From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dunham Craig E. Sent: Tuesday, December 09, 2008 8:58 AM To: [email protected] Subject: [EDI-L] Revision to the PO Map (850). [html] Importance: Low OK, I'm seeking advice from the group... My accounting department (ok, one guy) is saying that our vendor community can't seem to get the concept of figuring out allowances for invoices. Here's an example - Cost - $10.00 Allowance - 10% Quantity - 1000 Just using that simple concept - it's basic math - not far and above the 6th grade... You'd set it up like this: (C*A)*Q=Net Cost Right? I mean, am I over simplifying this...? To all of you on the "vendor/supplier/manufacturer" side of the coin - are your systems so ... stupid ... that they can't do a simple calculation such as this? But, I digress - as usual. Instead of putting the onus of the math on the vendor side, this genius in accounting wants us to transmit a total dollar value of the invoice (with allowances applied) and a total number of units being ordered. His thought process is that the vendor (i.e. you) would be able to balance the incoming dollar amount of the PO against your sales order and also against the invoice(s) generated by the sales order. So, I know that I can use the AMT segment for the total dollar value of the PO. That's kind of a given. But I can't seem to find a segment to use to populate the total quantity being ordered. I was thinking of using the "hash total" in the CTT segment, but that's having the translation process add up those numbers. Our programmers have captured the total value and quantity during the PO creation/printing process and populate some data fields that I can then map from - a fixed number, calculated by the program - and populate the 850 map to be sent. So, the question is - where do I put the data...? Your suggestions? Where do you see the data (if you receive a PO) or where do you put it (when you send a PO)....? Craig E. Dunham EDI Coordinator EYE Analyst [Non-text portions of this message have been removed] CONFIDENTIALITY NOTICE: This Email and any files transmitted with it are confidential and intended solely for the use of the individual or entity named to whom they are addressed. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. If you are not the intended recipient of this Email, please notify the Mail Administrator at [EMAIL PROTECTED] immediately. [Non-text portions of this message have been removed] ------------------------------------ ... 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 [Non-text portions of this message have been removed] ------------------------------------ ... 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/
