Questions and Answers

Q: When entering or voiding a orders, payables or invoices in Sage Pro ERP the following messages may appear:

• No default location exists Vendor receiving location, no valid account.
• Cannot void, the order has drop ship item.
• Invoice xxxx has a drop ship item and cannot be voided.

These errors appear when the receiving location and drop ship location have the same value.

Important
This issue affects both Multiple and Single Location companies. Below will be the resolution for both situations.

A: Important
Data edits should only be done by an Sage Certified Consultant or Business Partner. Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

To correct either errors, database edits may be required for both Multiple and Single Location companies as follows.

Multiple Location Companies:

1. Open the SYSDATA table.
2. Locate the Inventory Control (IC) record for the affected company.
3. Locate the Str2 field (characters 91-96) for that company. It stores the drop ship location.
4. Delete the drop ship location.
5. Save and close the table.
6. Launch Sage Pro.
7. Open IC.
8. Under the File menu, click Change Setup Information.
9. Proceed to the third screen and enter a drop ship location with a unique name.
10. Click Save.

Single Location Companies:

1. Open the SYSDATA table.
   • Locate the Inventory Control (IC) record for the affected company.
   • Locate the Str2 field (characters 91-96) for that company. It stores the drop ship location.
   • Delete the drop ship location.
   • Save and close the table.

This will update the ICSYSD table to reflect the new drop ship location and should prevent the messages from occurring.

© Copyright Sage Software