Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
We are looking for a way to associate outgoing freight
charges from 3rd party carriers (not invoiced to customers) with applicable
sales invoices in order to better track the profitability of customers. It seems, to me, that it is the flip-side of
landed costs but I have not found a way to link them. Any suggestions?
Are these freight charges receive/entered via POP? Or through Payables? If POP, I had a similar situation where LC would not work to receive these bills for many PO's, so we are going to try to (about to start testing) use the user=defined fields in POP receiving to list the BOL so we could link the receipts together. I would assume you could do something similar. With existing functionality, that is all I can think of. Custom would probably be the cleanest route, but would be a costlier solution.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
We had the same issue. I use the word "had" because we gave up trying to associate the outbound freight costs back to SOP even though it would be extremely useful from a margin review perspective. One of the largest problems with the idea for us was the UPS and FedEx bills include non-SOP shipments which just added another level of complexity to an already difficult idea (not to mention how to allocate the cost if more than one item is shipped because we wanted to see margin down to the item level as well as rolling up to an overall customer level margin). Great idea, but I don't know of a solution.
If your Sales Orders and Purchase Orders are related to each other, like a SOP-POP link, it is possible to get that info and put it in a report.
Another option I have used is Extender, to relate a sales order to a purchase order, in order to track the POP freight and SOP freight.
These two are basically two ways to do the same thing, but are useful when the sales orders are directly related to a purchase order.
I have just added a script to my blog that should address this for you. Please let me know if you need anything else.
Business Applications communities