Hello All -
We are running into an issue affecting Margins and Average Selling Price (ASP) calculations due to the kind of PO's we received and then book from one of our sales channels. I'm in order management so asking from the booking side of things but open to any suggestions either from booking side or invoicing side that can help.
Situation is this sales rep channel often quote projects on a total project price and do not reflect price per units of individual items in their proposals. The PO's that we, as a supplier, receive are also purchased in this "Lot Price" so end users are not seeing the breakdown of each item. Therefore when we book a sales order, the value for each inventory item is booked at $0 price per unit and we use a catch all part number (Customer Project that has no COGs) to book a line for the total order value. Therefore the sales order booked value matches the PO value, but the line pricing for each item is not visible on invoicing or the order acknowledgements.
The first and most important issue is that when mgmt. pulls reports, the ASP and Margin are negatively impacted for often these deals are large so the $0 per unit "price" is driving down ASP and Margin calculations.
What I need to be able to do is either book this in a way that still matches the PO to the purchasing entity / end user (not showing price per unit) but internally showing PPU for reporting but ensuring that it doesn't show up on any customer facing acknowledgements / statements or invoices.
The 2nd issue is the billing side is tricky when shipping partials as we should be billing ideally at a % of the total order value based on the price per unit compared to total order value, but we end up billing based off PPU calculations.
Any thoughts on the first or 2nd part of this would be greatly appreciated.
-Erin