Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

How can I get a report of what was charged for shipping?

Posted on by 60

We have been adding shipping charges to phone and eBay orders by Shift F1 and clicking "over-ride shipping calculation" and putting in the amount calculated by eBay.  Unfortunately, now our register reports show a "cash over" by this amount.  In other words, sales plus sales tax does not match the amount tendered because of shipping charges.  Is there any way to get a summary of what has been added as shipping to our register sales?

*This post is locked for comments

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: How can I get a report of what was charged for shipping?

    Are you seeing the shipments in the Pending report?  If not, then I believe you are not selecting a Shipper when you override.

    If you are seeing them on the Pending report, are you marking the orders as processed/shipped with a Ctrl + Shift + F8 from POS?

    Finally, if you can now see the items in the Shipping Log report, drag the Charges column to the left and select grouping icon on the top to total the column

  • Shawn Meade Profile Picture
    Shawn Meade on at
    Re: How can I get a report of what was charged for shipping?

    Hello Mary,

    In testing this, I am able to use the Shift F1 and overwrite the amount for a transaction.  I select the customer and tender it.

    I then run a Z report and I see the correct amount in the Shipping section at the top of the Z report.  

    What version of Store Operations are you using (example: 2.0.0126)?

    What Shipping Carrier are you using?

    When did the issue start happening?

    What tender method are you using?

    What is your SQL version?

    What is your Operating System Version?

    Are you using any third party customizations?

    Also, for future reference if you do ever put a support request into Microsoft and we find that it is a product defect on our end, then you will not be charged for that case.  

    Best Wishes,

    Shawn with MIcrosoft Retail Support.

  • MaryP Profile Picture
    MaryP 60 on at
    Re: How can I get a report of what was charged for shipping?

    Dear Shawn,

    The Miscellaneous reports come back empty, even when I search for shipping charges that are not equal to zero.  The shipping charges clearly display on the X and Z reports for the day, but I don’t really want to manually look at the last year’s worth of Z reports manually in the journal viewer.  The Register analysis crystal reports inexplicably includes the shipping amounts in the “Over/Short” category, and we can’t differentiate between shipping income and register errors.

    We had been adding shipping to the transaction by Shift F1, clicking the “over-ride” box and entering in our shipping charge.  Now we have created a non-inventory part for shipping and are adding the income that way to the transactions.  

    I am opposed to calling Microsoft for help, because this is a clear flaw in the software that I don’t feel I should have to pay for support to get it resolved.

    Sincerely,

    Mary Pat McCurdie  

  • Shawn Meade Profile Picture
    Shawn Meade on at
    Re: How can I get a report of what was charged for shipping?

    Hello Mary,

    You should be able to see this information if you go into Store Operations Manager and click Reports | Miscellaneous | Shipping Log.  

    If this does not have the information you are looking for then you can check Reports Library (linked below for your convenience) or contact a partner or enter a support request for Microsoft, and we can see if this is possible.

    mbs.microsoft.com/.../ModifiedReports

    Best Wishes,

    Shawn with MIcrosoft Retail Support.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans