Sage 100

I have a client that is watching the freight charges that Starship calculates on their invoices and comparing them to the actual charges that show up later on the FedEx bill. I am guessing there are package parameters (dimension, options, etc...) that are not being entered correctly in Starship, but which Fedex is correcting and reflecting on the bill. I suggested they reach out to FedEx for assistance, not sure how helpful they will be.

What I am looking for is an audit method. How does one go about tracking down the discrepancies? What reports/documents are available and what are the likely causes?

Has anyone run into this? How did you handle it?

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

I'm working on a similar request, but without StarShip in the mix.
What I'm advising is that the AP invoices include line detail with tracking # and charge, so we can link back to the original invoice through tracking history (for a cost comparison).  We're still in the planning stages though.  The courier / freight company has yet to provide the file we need to use for importing the AP invoices.
If you have a spreadsheet with tracking # and details I suppose you could import that into a UDT then do a custom report linked to invoice history tracking for a comparison.
​​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Thanks @Kevin Moyes I have created a report from Starship & Sage that does give that information and they are able to cross reference the shipments to the FedEx report, but determine why their are differences proves to be elusive.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 09-14-2020 14:38
From: Kevin Moyes
Subject: Auditing freight charges with Starship & FedEx Bill

I'm working on a similar request, but without StarShip in the mix.
What I'm advising is that the AP invoices include line detail with tracking # and charge, so we can link back to the original invoice through tracking history (for a cost comparison).  We're still in the planning stages though.  The courier / freight company has yet to provide the file we need to use for importing the AP invoices.
If you have a spreadsheet with tracking # and details I suppose you could import that into a UDT then do a custom report linked to invoice history tracking for a comparison.
​​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Greg, you might want to check which rate is being applied in Starship. As you probably know you can tell it to use the List rate or the customers contracted rate (their cost). Also, some customers add a markup percentage or amount to the calculated amount. They might have a rule that says to markup each shipment by $5.00 or 10% or something like that.

------------------------------
Kenny Daniel
TechnoClarity, Inc.
------------------------------

Original Message:
Sent: 09-15-2020 11:30
From: Greg Stiles
Subject: Auditing freight charges with Starship & FedEx Bill

Thanks @Kevin Moyes I have created a report from Starship & Sage that does give that information and they are able to cross reference the shipments to the FedEx report, but determine why their are differences proves to be elusive.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 09-14-2020 14:38
From: Kevin Moyes
Subject: Auditing freight charges with Starship & FedEx Bill

I'm working on a similar request, but without StarShip in the mix.
What I'm advising is that the AP invoices include line detail with tracking # and charge, so we can link back to the original invoice through tracking history (for a cost comparison).  We're still in the planning stages though.  The courier / freight company has yet to provide the file we need to use for importing the AP invoices.
If you have a spreadsheet with tracking # and details I suppose you could import that into a UDT then do a custom report linked to invoice history tracking for a comparison.
​​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON

Thanks @Kenny Daniel we've covered that ground already, Starship is using the Customer's contracted rates and they are not adding anything, in fact, Starship is less than the actual charge, on the FedEx bill.​

It's as though Fedex is the one not charging the customers contracted rates and Starship is!?

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 09-15-2020 11:42
From: Kenny Daniel
Subject: Auditing freight charges with Starship & FedEx Bill

Greg, you might want to check which rate is being applied in Starship. As you probably know you can tell it to use the List rate or the customers contracted rate (their cost). Also, some customers add a markup percentage or amount to the calculated amount. They might have a rule that says to markup each shipment by $5.00 or 10% or something like that.

------------------------------
Kenny Daniel
TechnoClarity, Inc.
------------------------------


Original Message:
Sent: 09-15-2020 11:30
From: Greg Stiles
Subject: Auditing freight charges with Starship & FedEx Bill

Thanks @Kevin Moyes I have created a report from Starship & Sage that does give that information and they are able to cross reference the shipments to the FedEx report, but determine why their are differences proves to be elusive.

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010


Original Message:
Sent: 09-14-2020 14:38
From: Kevin Moyes
Subject: Auditing freight charges with Starship & FedEx Bill

I'm working on a similar request, but without StarShip in the mix.
What I'm advising is that the AP invoices include line detail with tracking # and charge, so we can link back to the original invoice through tracking history (for a cost comparison).  We're still in the planning stages though.  The courier / freight company has yet to provide the file we need to use for importing the AP invoices.
If you have a spreadsheet with tracking # and details I suppose you could import that into a UDT then do a custom report linked to invoice history tracking for a comparison.
​​

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON