web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Link outgoing freight ...
Microsoft Dynamics GP (Archived)

Link outgoing freight (POP doc) to customer invoice (SOP doc)

(0) ShareShare
ReportReport
Posted on by Community Member

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?

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    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

  • Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at

    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.

  • Chris Isbell Profile Picture
    Chris Isbell on at

    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.

  • Suggested answer
    Ron Wilson Profile Picture
    Ron Wilson 6,010 on at

    JCohen,

    I have just added a script to my blog that should address this for you.  Please let me know if you need anything else.

    Ron

    rldu.wordpress.com/.../sql-scriptssop-to-pop-freight-analysis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans