Endicia Mapping

Epicor ERP 10
1

So, if you install Dazle to endicia it wipes your old mapping to Epicor. How nice. So I am working an reestablishing that, not a big deal. Except, i am at a loss how I can use only one table for the entire Shipping data for Endicia. I know this may be a childish question, but I am frustrated and needing to get this working. At least someone can get a good laugh! LOL!

2

Is it possible to use more than one table with Endicia to map the fields to Epicor? Because for me it’s only letting me do 1 table and I understand I could be missing the whole boat here.

@josecgomez Do you have any insights on this by chance?

3

I don’t know what Endicia is… :frowning:

1 Like
4

Gotcha… Its the USPS shipping software that it seems a lot of people use with Epicor. Me personally, i hate it.

Answer is, use the advanced editor and write your own SQL statement. Wasn’t sure so didn’t try and took them 2 hours to get back to me.

1 Like
5

Ok, I 'm not real good with SQL yet and Endicia requires a SQL statement. Although theirs looks a little unusual to me. Mostly because I prob don’t know exactly what I am doing! LOL! Anyway, here is what Endicia has, as a pure example of how they are writing it, and what I have.
SELECT [OrderNum] FROM [Erp].[OrderHed] WHERE [OrderNum]=$ORDERNUMBER

And this is what I have.

select 
	[OrderHed].[OrderNum] as [OrderHed_OrderNum],
	[ShipTo].[Name] as [ShipTo_Name],
	[ShipTo].[Address1] as [ShipTo_Address1],
	[ShipTo].[Address2] as [ShipTo_Address2],
	[ShipTo].[Address3] as [ShipTo_Address3],
	[ShipTo].[City] as [ShipTo_City],
	[ShipTo].[State] as [ShipTo_State],
	[ShipTo].[ZIP] as [ShipTo_ZIP],
	[ShipTo].[Country] as [ShipTo_Country],
	[Customer].[EMailAddress] as [Customer_EMailAddress],
	[Customer].[Name] as [Customer_Name],
	[Customer].[Address1] as [Customer_Address1],
	[Customer].[Address2] as [Customer_Address2],
	[Customer].[City] as [Customer_City],
	[Customer].[State] as [Customer_State],
	[Customer].[Zip] as [Customer_Zip]
from Erp.Customer as Customer
inner join Erp.OrderHed as OrderHed on 
	Customer.Company = OrderHed.Company
And
	Customer.CustNum = OrderHed.BTCustNum

inner join Erp.ShipTo as ShipTo on 
	OrderHed.CustNum = ShipTo.CustNum
And
	OrderHed.ShipToNum = ShipTo.ShipToNum
6

figured it out. Just had to stop and think a bit. Here is what I did and it works not issues.

SELECT [orderhed].[ordernum], 
       [shipto].[name], 
       [shipto].[address1], 
       [shipto].[address2], 
       [shipto].[address3], 
       [shipto].[city], 
       [shipto].[state], 
       [shipto].[zip], 
       [shipto].[country], 
       [customer].[emailaddress], 
       [customer].[name], 
       [customer].[address1], 
       [customer].[address2], 
       [customer].[city], 
       [customer].[state], 
       [customer].[zip] 
FROM   ((([Erp].[customer] 
          INNER JOIN [Erp].[orderhed] 
                  ON [customer].[company] = [orderhed].[company] 
                     AND [customer].[custnum] = [orderhed].[btcustnum]) 
         INNER JOIN [Erp].[shipto] 
                 ON [orderhed].[custnum] = [shipto].[custnum] 
                    AND [orderhed].[shiptonum] = [shipto].[shiptonum]) 
        INNER JOIN [Erp].[shiphead] 
                ON [orderhed].[custnum] = [shiphead].[custnum] 
                   AND [orderhed].[shiptonum] = [shiphead].[shiptonum]) 
WHERE  [ordernum] = '$ORDERNUMBER' 
GROUP  BY [orderhed].[ordernum], 
          [shipto].[name], 
          [shipto].[address1], 
          [shipto].[address2], 
          [shipto].[address3], 
          [shipto].[city], 
          [shipto].[state], 
          [shipto].[zip], 
          [shipto].[country], 
          [customer].[emailaddress], 
          [customer].[name], 
          [customer].[address1], 
          [customer].[address2], 
          [customer].[city], 
          [customer].[state], 
          [customer].[zip]