BAQ Shipto Table Missing Ship to entries?

Kinetic ERP
1

Very odd and concerning situation. We stumbled upon a shipto profile that does not show up in BAQs. I ran a few queries to verify it and the alternate ship to appears for other customers but not for one particular customer (as if the data doesn’t exist). Has anyone come across this?

1st query - Customer table filtered for customer and left join of shipto table
2nd query - Shipto table filtered for phantom shipto ID.

2

Can you share the text of the queries?

3

‘’'select
[ShipTo].[CustNum] as [ShipTo_CustNum],
[ShipTo].[ShipToNum] as [ShipTo_ShipToNum],
[ShipTo].[Name] as [ShipTo_Name],
[Customer].[CustID] as [Customer_CustID],
[Customer].[Name] as [Customer_Name]

from Erp.ShipTo as [ShipTo]
inner join Erp.Customer as [Customer] on
ShipTo.Company = Customer.Company
and ShipTo.CustNum = Customer.CustNum
and ( Customer.CustID = ‘PFM001’ )‘’’

4

‘’’
select
[ShipTo].[CustNum] as [ShipTo_CustNum],
[ShipTo].[ShipToNum] as [ShipTo_ShipToNum],
[ShipTo].[Name] as [ShipTo_Name]

from Erp.ShipTo as [ShipTo]
where (ShipTo.ShipToNum = ‘GIL001’)‘’’

5

In both cases if you remove the filter for CustID and ShipToNum the queries return the full dataset expected without this specific record and when you go to Customer Tracker for PFM001 you see the Ship To GIL001?

6

That’s correct, in customer tracker I can see the ship to GIL001 within PFM001 customer’s profile. All other ship tos appear within the Query (unless there are other ship tos that are affected just like GIL001)

7

Hmm, I don’t know then, I can’t say I’ve ever seen this but it is possible it happens and we don’t see it because, well we don’t see it.

The only other thought I have (other than being 100% sure that they are both spelt correctly and that it is not the case of a lower case L vs an upper case i kind of thing but I am assuming you are copy/pasting the values so that is unlikely) would be to run the two queries directly in SQL if you have that available as an option to see if there is something, somewhere in Epicor or the BAQ(s) that is blocking it.

8

Thanks for your time. We’re multi-tenant and this stumped support. I’m just hoping that it is not a bigger issue.