Skip to main content
Solved

Carrier Plugin - Customer - Carrier Account - Add to Report


nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1

I am trying to add [CarrierPluginCustomer.CarrierAccount] to the SO641010 report in report designer.

Based on https://watertrucks.acumatica.com/dacBrowser/PX.Objects.CS/CarrierPluginCustomer

I added the table CarrierPluginCustomer to get [CarrierPluginCustomer.CarrierAccount]

 

Relationships:

Parent Field Link Condition Child Field
BAccountID Equal CustomerID

 

 

 

I get no errors and added the value to the report, but when testing the report on a sales order that used a Customer’s Carrier Account, it displayed nothing.

We are using the EasyPost Carrier Plugin

Any ideas what I am missing?

I attached the test rpx file as a zip for reference.

Best answer by nathantrauscht

In case anyone would also like the report modification I have figured out the issue.

Relationship should be:

Using this relationship will pull the customer’s carrier account number, from the plugin, based on their LocationID selected at the document level. However, if you have a carrier account number assigned to the customer, but have not assigned a LocationID it will not display. So the current limitation of this setup is you must have the account number assigned to each LocationID.

 

If you don’t have customer’s that have multiple carrier accounts based on the ship to location, then you can remove the CustomerLocationID relationship.

 

I am trying to build this relationship so that it will look for the carrier account by LocationID of the document. If it doesn’t exist then look for carrier account by CustomerID. If anyone has advice on how to set this up in the relationship please reply.

 

 

View original
Did this topic help you find an answer to your question?

2 replies

nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 174 replies
  • Answer
  • April 6, 2023

In case anyone would also like the report modification I have figured out the issue.

Relationship should be:

Using this relationship will pull the customer’s carrier account number, from the plugin, based on their LocationID selected at the document level. However, if you have a carrier account number assigned to the customer, but have not assigned a LocationID it will not display. So the current limitation of this setup is you must have the account number assigned to each LocationID.

 

If you don’t have customer’s that have multiple carrier accounts based on the ship to location, then you can remove the CustomerLocationID relationship.

 

I am trying to build this relationship so that it will look for the carrier account by LocationID of the document. If it doesn’t exist then look for carrier account by CustomerID. If anyone has advice on how to set this up in the relationship please reply.

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • April 6, 2023

Thank you for sharing your solution with the community @nathantrauscht !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings