06-11-2018, 03:25 PM
Two ideas come to mind:
1.- create a custom field of type currency, add some code to go to the invoice and fetch the value you need and save it in the field
2.- create a custom field of type relation pointing to the Inventory Details module. That will permit you to select the details of the exact line the product is on. That record has the prices and you will be able to select it on the list view. In this option, you could also add some code to filter the InventoryDetails and show only those related to the invoice, maybe even the product...
1.- create a custom field of type currency, add some code to go to the invoice and fetch the value you need and save it in the field
2.- create a custom field of type relation pointing to the Inventory Details module. That will permit you to select the details of the exact line the product is on. That record has the prices and you will be able to select it on the list view. In this option, you could also add some code to filter the InventoryDetails and show only those related to the invoice, maybe even the product...
Joe
TSolucio
TSolucio