SOLVED: I determined through trial and error that the fields that don't show up are calculated fields.
Hello,
I am writing a customization to the Estimate screen that allows a grid of non-synced items to be selected as estimate line items. Once selected the user can convert these over to regular items that will sync with QuickBooks. The steps are as follows.
- Loop through my custom table (ATSEstimateLine)
- For each record that has the same EstimateRecordID as the current estimate
- Insert the item into the Item table
- Insert the item into the EstimateLine table
I am able to do everything but the second bullet point for step 2. For some reason when I select the "Insert Records Into Table" action and select the EstimateLine table many of the field that I need to insert data into, such as the "Amount" field, do not show up in the dropdown list. Why is this happening?