Skip to main content
M
MrTee
April 3, 2024
Question

Fixing Shipping Address Errors in QuickBooks Reports

  • April 3, 2024
  • 1 reply
  • 0 views
In the Refunds function of QuickBooks Desktop Enterprise, when we input the customer's name in the customer job field along with their PO number, the shipping address that appears in the sales report is different from the one associated with the PO. It's a pain in the neck to correct the shipping address manually. Could you please advise?

1 reply

R
ReymondO
April 3, 2024

Thank you for raising your concern on the QuickBooks Community page, @MrTee.

 

I'd be glad to share info about the shipping address displayed on your sales reports in QuickBooks Desktop.

 

Before we proceed, could you please specify the exact sales report you're referring to when encountering the issue with the shipping address? By knowing the report name, I can better analyze the situation and provide appropriate troubleshooting steps to resolve the problem.

 

Upon checking various sales reports, I've noticed that most of their display columns can be filtered to show the 'Ship To Address'. Please be aware that the address appearing on the Refund window is set to the customer's invoice address. This could potentially explain why you're encountering a different address when running the report.

 

To ensure that the correct shipping address populates on the report, open the customer's account and enter the address entered in the 'Ship To' section. Let me show you how:

 

  1. Click Customers and select Customer Center.
  2. Double-click the name of the customer, then go to the Address Info.
  3. Under the Ship To drop-down list, enter the address.
  4. Click OK.

 

Furthermore, QuickBooks Desktop provides the capability to personalize reports to align with your unique preferences and tailor them to the specific needs of your business operations.

 

Please let me know if you have any additional questions regarding running reports within QuickBooks. I'm here to assist you. Have a wonderful rest of your day.

M
MrTeeAuthor
April 3, 2024
Thank you for your answer. I use a report named "Sales by Customer Detail" found in the Sales section. Most of our customers are distributors, and each one serves several end users where we directly ship products (noted as the Ship To Address). When I generate the report, the ship-to addresses listed in the credit section for each distributor seem to be chosen randomly from among the distributor's various ship-to addresses.
J
JamaicaA
April 3, 2024

Thank you for elaborating on your concern, MrTee. I've got some information to clarify the placement of your distributor's various ship-to addresses on the Sales by Customer Detail report.

 

You're right, the ship-to addresses listed in the report do not align with what you selected when creating an invoice. If you choose from the Ship to dropdown list when making a transaction, the system will randomly put it in the columns. However, the default address information entered from the customer's parent profile will fall under the right columns accordingly.

 

I'm adding some screenshots for reference:

 

 

Feel free to check out this reference to explore what more you can do with reports: Available reports in QuickBooks Desktop.

 

It's been a pleasure to have you here. Just mention my name in the comment section if you need help performing specific tasks in QuickBooks. I've got all the time to assist you.

Terms & ConditionsAccessibility statement