ShipTo records not showing up consistently

Yahoo Archive
1
Hi Ernie,

Yes, I had the same problem.
ODBC reports showed the records, but BAQs don't.
In my case it had to do with bad territories (from a DMT upload).

I built a couple of ODBC reports to list the customers.
Then fixed them manually in Customer maintenance.
For E9 SQL, email me if you'd like copies.


--- In vantage@yahoogroups.com, "Elizabeth" <gracefulthreads@...> wrote:
>
> Within the last few weeks I've had some ShipTo table records "disappear". They are in the SQL database, they appear properly on customer records and orders and invoices, but when I run a BAQ on them they aren't there. When I run reports based on those BAQs the invoice or order doesn't appear on the report.
>
> If I re-create the ShipTo record and relink everything, the queries and reports work again.
>
> Any ideas why this would be happening, and what I can do to stop it?
>
> Ernie Lowell
> Diba Industries
>
2
Within the last few weeks I've had some ShipTo table records "disappear". They are in the SQL database, they appear properly on customer records and orders and invoices, but when I run a BAQ on them they aren't there. When I run reports based on those BAQs the invoice or order doesn't appear on the report.

If I re-create the ShipTo record and relink everything, the queries and reports work again.

Any ideas why this would be happening, and what I can do to stop it?

Ernie Lowell
Diba Industries