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]
------------------------------------
...
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/
