In my situation I have a Order Header which contains info like order date, expected ship date, expected arrival date, vendor, buyor, etc... and that is my PO dimension. I have an Order Detail that contains the line items with qty and cost. I have a Receiver Header that includes receipt date and receipt status, and I have a Receiver Detail that includes qty and cost of received goods.
For Orders I calculate things like Avg Lead Time, Fill Rate %, and show current On Order.
Depending on how you handle your accounting, a discount that is applied to an order and NOT the line items on the order can skew your margin reporting. If I had that situation, I would likely allocate the order-level discount to the cost of the line items on a pro-rata basis.
.
social.technet.microsoft.com/Forums
No comments:
Post a Comment