ARTran table vs. INTran table

Hi @mikeho 

It depends what info you are looking for to use the Generic Inquiry for. What are you trying to accomplish?

I usually use INTran when looking directly at inventory transactions and ARTran for Receivable transactions. 

Hi @kbeatty21 

I’m trying to look at shipped sales. Specifically sales revenue vs. product cost.

Hi @mikeho  

Have you looked at the Sales Profitability Analysis report? That may have a good bit of what you are looking for and you can create a new GI based off that. 

@kbeatty21 Great suggestion on the Sales Profitability Analysis Report! @mikeho The Invoiced Items Inquiry in Receivables is also a good inquiry to review. Depending on the level of detail needed for reporting, you can look at the INItemSalesHist table, it is not used in any out-of-the-box inquiries (2021R1) but it’s a powerful table.

Thanks everyone. I guess the main thing I’m still unclear on is what is the difference between these tables and the data they are returning? Is there a simple description for the INTran table? The ARTran table at least has a description when you use it in a GI: 

The INTran table does not. Again, they seem to provide similar data but sometimes the TranAmt and TranCost fields don’t match between the tables on the same transaction.

Thank you for the clarification, @RoyceLithgo! Sounds like Sales Orders would be tied to the ARTran table so reporting anything regarding Sales Orders/Shipments should originate there.

Thanks everyone for your input!

Sales Invoices live in ARTran. Sales Orders (SOOrder, SOLine) and Shipments (SOShipment, SOShipLine) are referenced from ARTran. 

BTW, if you don’t know this, to find the DAC behind a page, hold down Ctrl + Alt and click on UI component on any page. You should get a popup revealing the properties of the object you clicked on. For example, I do this on Sales Order, Order Nbr field and get this:

This should help you identify the various DACs (ie. tables) used on a page and also help you understand where the data lives for each page. 

And then the DAC browser will give you even more information on each object:

https://help.acumatica.com/dacBrowser/PX.Objects.AR/ARTran