Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where is the table that holds the contract information being used for a line item on the sales order/invoice?

April 26, 2017contract holds invoice line sales Table Used

0

10 Posted

Where is the table that holds the contract information being used for a line item on the sales order/invoice?

1 Answer

0

10 Posted

There is no table that actually stores the pricing because it is calculated on the fly by using the rules defined on the Contract. However, there is a SQL API that comes with the product download that can be used in development. Note that if you are just trying to show the Contract that is being used on each line item, then you can use the Alternate SOP Entry window that is in the Omni Price dictionary. The purpose for providing this window is to show the Contract ID used in the bottom of the expanded line item.