SOLVED: Can't Insert Data Into Some of the Fields of the EstimateLine Table

aaronjwood — Fri, 07 Aug 2015 17:03:04 GMT

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?

Method:Classic General Q&A

SOLVED: Can't Insert Data Into Some of the Fields of the EstimateLine Table