Custom Records
Record Types
FQ APM Async Execution Request
customrecord_fq_apm_async_exec_request
This is a Custom Record used to store instruction for Asynchronous Processing.
Callback Parts
custrecord_fq_apm_aer_callback_txt
This stores the Callback Parts for the function that needs to be executed.
Text
Error
custrecord_fq_apm_aer_error_txt
In case of Error during the Async Execution Request, the message is stored here.
Text
Module Path
custrecord_fq_apm_aer_modulepath_txt
This stores the Module Path for the File that contains the function that needs to be processed.
Text
Parameters
custrecord_fq_apm_aer_params_ltxt
This stores the Parameters for the function that needs to be executed.
Clobtext
Processed
custrecord_fq_apm_aer_processed_cb
This indicates if the Async Execution Request has been processed.
Check Box
Record ID
custrecord_fq_apm_aer_recordid_int
This stores the Record ID for which this AER executes.
Integer
Record Type
custrecord_fq_apm_aer_recordtype_txt
This stores the Record Type for which this AER executes.
Text
Task ID
custrecord_fq_apm_aer_taskid_txt
This stores the Task ID that executes for this AER.
Text
FQ FoodQloud Cost Calculation Method
customrecord_fq_apm_cost_calc_method
The Cost Calculation Method records defines the algorithms or formulas used to compute costs for items in transactions. It specifies how costs like freight, duties, and taxes are allocated ensuring accurate and consistent cost distribution.
Available for Landed Costs?
custrecord_fq_apm_ccm_lc_available_cb
If checked, the cost calculation method is available to be selected during landed cost processing.
Check Box
Available for Sales Costs?
custrecord_fq_apm_ccm_sc_available_cb
If checked, the cost calculation method is available to be selected during sales cost processing.
Check Box
Description
custrecord_fq_apm_ccm_description_txt
The ';Description' field provides a detailed explanation of the selected cost calculation method, illustrating how costs are allocated within a transaction.
Textarea
Requires Sustainable Packaging?
custrecord_fq_apm_ccm_requires_sp_cb
If checked, the cost calculation method is available only if the sustainable Packaging App is installed
Check Box
FQ Landed Cost Budget
customrecord_fq_apm_lc_budget
The 'Landed Cost Budget' record is designed for planning and managing anticipated additional costs on purchases, including duties, freight, and taxes. It aligns projected expenses with actuals, incorporating details like source transactions, budgeted amounts in local and source currencies, and exchange rates, ensuring effective cost control and financial oversight.
Auto-Apply Transactions
custrecord_fq_apm_lcb_autoappltrans_mlst
Specify transactions to which the budget record should be automatically applied to.
Multiselect
Calculation Method
custrecord_fq_apm_lcb_calc_method_lst
Describes the formula or method used to allocate landed costs to items/transactions.
Select
Currency
custrecord_fq_apm_lcb_currency_lst
Specifies the currency in which the landed costs are calculated and applied.
Select
Description
custrecord_fq_apm_lcb_description_txt
Provide an overview or details about the budget record. This is shown on the Landed Cost Purchase Order.
Textarea
Item
custrecord_fq_apm_lcb_item_lst
Identifies the specific item within transactions that the landed cost is associated with.
Select
Landed Cost Category
custrecord_fq_apm_lcb_lc_category_lst
This is the landed cost item category. This is sourced from the landed cost item.
Select
Landed Cost Filters
custrecord_fq_apm_lcb_lcbfilters_ltxt
Aggregates the LCB Filters that should apply during the Landed Cost Process. Filled in by script.
Clobtext
Landed Cost Item
custrecord_fq_apm_lcb_lc_item_lst
Specifies the item which is used on the landed Cost Purchase Order.
Select
Landed Cost Vendor
custrecord_fq_apm_lcb_lc_vendor_lst
Designates the vendor responsible for additional landed costs. This can be the same as the Vendor.
Select
Percent
custrecord_fq_apm_lcb_percent_per
Denotes the percentage used in the calculation of landed costs, relevant for certain calculation methods.
Percent
PO Creation Method
custrecord_fq_apm_lcb_po_createmeth_lst
Defines the approach for generating Purchase Orders for landed costs.
Select
Primary Landed Cost Variance Method
custrecord_fq_apm_lcb_privarmeth_lst
Select a Primary method for handling discrepancies between estimated and actual landed costs.
Select
Rate
custrecord_fq_apm_lcb_rate_flt
Indicates the rate to use in the cost calculation.
Float
Secondary Landed Cost Variance Method
custrecord_fq_apm_lcb_secvarmeth_lst
Select a Secondary method for handling discrepancies between estimated and actual landed costs. This is mandatory if the primary method is Update Inventory Cost (Open Period Only).
Select
Vendor
custrecord_fq_apm_lcb_vendor_lst
Identifies the primary vendor associated with the goods or services being procured.
Select
FQ Landed Cost Filter
customrecord_fq_apm_lcb_filter
The Landed Cost Filter record is designed to enhance the filtering capability of Landed Cost Budget records that are applied from Entity / Item to the Transaction during the Landed Cost process.
Applied Items
custrecord_fq_apm_lcfltr_applyitems_ltxt
This field displays the Applied Items for this Filter.
Clobtext
Auto-Apply Transactions
custrecord_fq_apm_lcfltr_appltrans_mlst
This field displays the Autoapply Transactions from Landed Cost Budget Record.
Multiselect
Calculation Method
custrecord_fq_apm_lcfltr_calc_method_lst
This field displays the Calculation Method from Landed Cost Budget Record.
Select
Currency
custrecord_fq_apm_lcfltr_currency_lst
This field displays the Currency from Landed Cost Budget Record.
Select
Description
custrecord_fq_apm_lcfltr_description_txt
This field displays the Description from Landed Cost Budget Record.
Textarea
Field Data Type
custrecord_fq_apm_lcfltr_flddatatype_lst
This field displays the Filter Field Data Type.
Select
Field Data Type ID
custrecord_fq_apm_lcfltr_flddatatype_int
This field displays the Filter Field Data Type ID.
Integer
Field Script ID
custrecord_fq_apm_lcfltr_fldscriptid_txt
This field displays the Filter Field Script ID.
Text
Filter Type
custrecord_fq_apm_lcfltr_filtertype_lst
This field displays the Filter APM Field Type.
Select
Item Saved Search
custrecord_fq_apm_lcfltr_itemss_lst
This field displays the Item Saved Search.
Select
Item Table Data HTML
custrecord_fq_apm_lcfltr_itemdata_ltxt
This field displays the Item Data Table HTML Definition.
Clobtext
Landed Cost Budget
custrecord_fq_apm_lcfltr_lcb_lst
This field displays the parent Landed Cost Budget Record.
Select
Landed Cost Category
custrecord_fq_apm_lcfltr_lc_category_lst
This field displays the Landed Cost Category from Landed Cost Budget Record.
Select
Landed Cost Item
custrecord_fq_apm_lcfltr_lc_item_lst
This field displays the Landed Cost Item from Landed Cost Budget Record.
Select
Landed Cost Vendor
custrecord_fq_apm_lcfltr_lcvendor_lst
This field displays the Landed Cost Vendor from Landed Cost Budget Record.
Select
Operator
custrecord_fq_apm_lcfltr_operator_txt
This field displays the Filter Operator.
Text
Percent
custrecord_fq_apm_lcfltr_percent_per
This field displays the Percent from Landed Cost Budget Record.
Percent
PO Creation Method
custrecord_fq_apm_lcfltr_pocrtmeth_lst
This field displays the PO Creation Method from Parent Landed Cost Budget Record.
Select
Primary Landed Cost Variance Method
custrecord_fq_apm_lcfltr_privarmeth_lst
This field displays the Primary Landed Cost Variance Method from Landed Cost Budget Record.
Select
Rate
custrecord_fq_apm_lcfltr_rate_flt
This field displays the Rate from Landed Cost Budget Record.
Float
Record Type ID
custrecord_fq_apm_lcfltr_rectype_txt
This field displays the Filter Record Type ID.
Clobtext
Secondary Landed Cost Variance Method
custrecord_fq_apm_lcfltr_secvarmeth_lst
This field displays the Secondary Landed Cost Variance Method from Landed Cost Budget Record.
Select
Value
custrecord_fq_apm_lcfltr_value_txt
This field displays the Filter Value.
Text
Value List ID
custrecord_fq_apm_lcfltr_valuelist_txt
This field displays the Filter Value Field List ID.
Text
Value To
custrecord_fq_apm_lcfltr_valueto_txt
This field displays the Filter Value To.
Text
Vendor
custrecord_fq_apm_lcfltr_vendor_lst
This field displays the Vendor from Landed Cost Budget Record.
Select
FQ Landed Cost Filter Item Application
customrecord_fq_apm_lcb_lcfltr_itemapply
The Landed Cost Filter Item Application record is designed to enhance the Item filtering capability on the Landed Cost Filter.
Apply
custrecord_fq_apm_lcfltria_apply_cb
This field displays whether the Item is applied to the Landed Cost Filter.
Check Box
Item
custrecord_fq_apm_lcfltria_item_lst
This field displays the Item.
Select
Landed Cost Budget
custrecord_fq_apm_lcfltria_lcbudget_lst
This field displays the parent Landed Cost Budget Record.
Select
Landed Cost Filter
custrecord_fq_apm_lcfltria_lcfilter_lst
This field displays the parent Landed Cost Filter Record.
Select
FQ Transaction Landed Cost
customrecord_fq_apm_lc_trans_rec
This custom record is used to store transaction landed costs records.
Applied To Items
custrecord_fq_apm_tlc_appltoitems_mlst
This Field displays the Items to which this Transaction Landed Cost is exclusively applied. If this Field is empty, the Transaction Landed Cost Budget is not filtered based on Items.
Multiselect
Automatically Created
custrecord_fq_apm_tlc_autocreated_cb
If this is checked, when the Landed Cost Vendor Bill was processed, the variance has been automatically processed.
Check Box
Base Currency
custrecord_fq_apm_tlc_currency_bsc_lst
Specifies the base currency in the NetSuite account (sourced from Company Information).
Select
Base Exchange Rate
custrecord_fq_apm_tlc_exchrate_bsc_flt
Indicates the exchange rate between the Base Currency and the Landed Cost Currency at time of creation.
Float
Billed Amount
custrecord_fq_apm_tlc_amt_billed_flt
Represents the total billed amount for landed costs in the landed cost currency.
Float
Billed Amount (Base Currency)
custrecord_fq_apm_tlc_amt_billed_bsc_flt
Represents the total billed amount for landed costs in the base currency.
Float
Billed Amount (Source Currency)
custrecord_fq_apm_tlc_amt_billed_sc_flt
Represents the total billed amount for landed costs in the source transaction currency.
Float
Budgeted Amount
custrecord_fq_apm_tlc_amt_budget_flt
Represents the budgeted / total amount for landed costs in the landed cost currency.
Float
Budgeted Amount (Source Currency)
custrecord_fq_apm_tlc_amt_budget_sc_flt
Represents the budgeted / total amount for landed costs in the source transaction currency.
Float
Budgeted Amount (Base Currency)
custrecord_fq_apm_tlc_amt_budget_bsc_flt
Represents the budgeted / total amount for landed costs in the base currency.
Float
Calculation Data
custrecord_fq_apm_tlc_calcdata_ltxt
Shows the Calculation Data as an outcome of the Landed Cost Process.
Clobtext
Calculation Method
custrecord_fq_apm_tlc_calc_method_lst
Describes the method used to allocate landed costs to items/transactions.
Select
Currency
custrecord_fq_apm_tlc_currency_lst
Specifies the currency in which the landed costs are calculated and applied.
Select
Date/Time Posted
custrecord_fq_apm_tlc_posted_dt
This field stores the date and time when the landed cost reconciliation record was created.
Date/Time
Description
custrecord_fq_apm_tlc_description_txt
Provide an overview or details about the landed cost record. This is shown on the Landed Cost Purchase Order.
Textarea
Filter Data
custrecord_fq_apm_tlc_filterdata_ltxt
Aggregates the LCB Filters that should apply during the Landed Cost Process. Filled in by script.
Clobtext
Item Table Data HTML
custrecord_fq_apm_tlc_itemdata_ltxt
This field displays the Item Data Table HTML Definition.
Clobtext
Landed Cost Budget
custrecord_fq_apm_tlc_lcb_lst
Identifies the original landed cost budget record from which the transaction landed cost was created.
Select
Landed Cost Category
custrecord_fq_apm_tlc_lc_category_lst
This is the landed cost item category. This is sourced from the landed cost item
Select
Landed Cost Item
custrecord_fq_apm_tlc_lc_item_lst
Specifies the item which is used on the landed Cost Purchase Order. The item must be Other Charge for Purchase and cannot be fulfilled / received.
Select
Landed Cost PO
custrecord_fq_apm_tlc_lcpo_lst
This links the Transaction Landed Cost to the Landed Coost Purchase Order.
Select
Landed Cost Source
custrecord_fq_apm_tlc_lc_source_lst
This field displays the landed cost source
Select
Landed Cost Status
custrecord_fq_apm_tlc_lcstatus_lst
The status field indicates the current stage of the Transaction Landed Cost record in its lifecycle, from creation to resolution. It helps manage and track the progress of landed cost applications, variance handling, and billing.
Select
Landed Cost Vendor
custrecord_fq_apm_tlc_lc_vendor_lst
Designates the vendor responsible for additional expenses such as freight, duties, or taxes that comprise the landed costs.
Select
Landed Cost Vendor Bills
custrecord_fq_apm_tlc_vbills_mlst
This links the Transaction Landed Cost record to the Vendor Bills
Multiselect
Line Unique Key
custrecord_fq_apm_tlc_lineuniquekey_int
Line Unique Key from the Transaction Line.
Integer
Percent
custrecord_fq_apm_tlc_percent_per
Denotes the percentage used in the calculation of landed costs, relevant for certain calculation methods.
Percent
PO Creation Method
custrecord_fq_apm_tlc_po_createmeth_lst
PO Creation Method Defines the approach for generating Purchase Orders for landed costs.
Select
Primary Landed Cost Variance Method
custrecord_fq_apm_tlc_privarmeth_lst
Select a Primary method for handling discrepancies between estimated and actual landed costs.
Select
Quantity
custrecord_fq_apm_tlc_quantity_flt
Specifies the quantity for the landed cost. This is the quantity on the landed cost purchase order and is always calculated by the script.
Float
Rate
custrecord_fq_apm_tlc_rate_flt
Indicates the rate to use in the cost calculation.
Float
Secondary Landed Cost Variance Method
custrecord_fq_apm_tlc_secvarmeth_lst
Select a Secondary method for handling discrepancies between estimated and actual landed costs. This is mandatory if the primary method is Update Inventory Cost (Open Period Only)
Select
Source Exchange Rate
custrecord_fq_apm_tlc_exchrate_sc_flt
Indicates the exchange rate between the Source Currency and the Landed Cost Currency at time of creation.
Float
Source Transaction
custrecord_fq_apm_tlc_sourc_trans_lst
Identifies the original transaction to which the landed costs are being applied.
Select
Source Transaction Currency
custrecord_fq_apm_tlc_currency_sc_lst
Specifies the currency used in the Source Transaction.
Select
Supply Order
custrecord_fq_apm_tlc_inorder_lst
Refers to the specific supply order linked to the landed costs.
Select
Updated Manually
custrecord_fq_apm_tlc_updated_man_cb
This field indicates if the landed cost has been updated manually by a user
Check Box
Variance Amount
custrecord_fq_apm_tlc_amt_var_flt
Represents the variance in the landed cost currency.
Float
Variance Amount (Base Currency)
custrecord_fq_apm_tlc_amt_var_bsc_flt
Represents the variance in the base currency.
Float
Variance Amount (Source Currency)
custrecord_fq_apm_tlc_amt_var_sc_flt
Represents the variance in the source transaction cost currency.
Float
Variance Transaction
custrecord_fq_apm_tlc_vartrans_mlst
This provides a link to the variance transaction(s).
Multiselect
Vendor
custrecord_fq_apm_tlc_vendor_lst
Specifies the primary vendor from whom the goods are purchased, related to the source transaction.
Select
FQ Transaction Landed Cost Allocation
customrecord_fq_apm_lc_trans_alloc
The Transaction Landed Cost Allocation record documents the distribution/allocation of each Transaction Landed Cost to individual line items within a transaction. It provides granular details on how landed are apportioned across items, ensuring precise cost tracking and financial accuracy in inventory valuation.
Applied Item Receipt
custrecord_fq_apm_tlca_ir_mlst
Indicates the Item Receipt that the landed cost allocation has been applied to, confirming the receipt of goods and the associated costs.
Multiselect
Automatically Created
custrecord_fq_apm_tlca_autocreated_cb
If this is checked, when the Landed Cost Vendor Bill was processed, the variance has been automatically processed.
Check Box
Base Currency
custrecord_fq_apm_tlca_currency_bc_lst
Specifies the base currency.
Select
Base Exchange Rate
custrecord_fq_apm_tlca_exchrate_bc_flt
Indicates the exchange rate between the Base Currency and the Landed Cost Currency at time of creation.
Float
Billed Amount
custrecord_fq_apm_tlca_amt_billed_flt
Shows the amount billed for the landed costs in transaction landed cost currency.
Float
Billed Amount (Base Currency)
custrecord_fq_apm_tlca_amt_billed_bc_flt
Shows the amount billed for the landed costs in base currency.
Float
Billed Amount (Source Currency)
custrecord_fq_apm_tlca_amt_billed_sc_flt
Shows the amount billed for the landed costs in transaction source currency.
Float
Billed Rate
custrecord_fq_apm_tlca_rat_billed_flt
Shows the rate billed for the landed costs in transaction landed cost currency.
Float
Billed Rate (Source Currency)
custrecord_fq_apm_tlca_rat_billed_sc_flt
Shows the rate billed for the landed costs in transaction source currency.
Float
Billed Rate (Base Currency)
custrecord_fq_apm_tlca_rat_billed_bc_flt
Shows the rate billed for the landed costs in base currency.
Float
Budgeted Amount
custrecord_fq_apm_tlca_amt_budget_flt
Shows the amount initially budgeted for the landed costs in transaction landed cost currency.
Float
Budgeted Amount (Base Currency)
custrecord_fq_apm_tlca_amt_budget_bc_flt
Shows the amount initially budgeted for the landed costs in the base currency.
Float
Budgeted Amount (Source Currency)
custrecord_fq_apm_tlca_amt_budget_sc_flt
Shows the amount initially budgeted for the landed costs in transaction source currency.
Float
Budgeted Rate
custrecord_fq_apm_tlca_rat_budget_flt
Shows the rate initially budgeted for the landed costs in transaction landed cost currency.
Float
Budgeted Rate (Base Currency)
custrecord_fq_apm_tlca_rat_budget_bc_flt
Shows the rate initially budgeted for the landed costs in the base currency.
Float
Budgeted Rate (Source Currency)
custrecord_fq_apm_tlca_rat_budget_sc_flt
Shows the rate initially budgeted for the landed costs in transaction source currency.
Float
Calculation Data
custrecord_fq_apm_tlca_calcdata_ltxt
Shows the Calculation Data as an outcome of the Landed Cost Process.
Clobtext
Currency
custrecord_fq_apm_tlca_currency_lst
Specifies the currency in which the landed costs are calculated and applied.
Select
Date/Time Posted
custrecord_fq_apm_tlca_posted_dt
This field stores the date and time when the landed cost reconciliation record was created.
Date/Time
Item
custrecord_fq_apm_tlca_item_lst
Identifies the specific item to which the landed cost is allocated, linking the cost directly to the affected inventory
Select
Landed Cost Budget
custrecord_fq_apm_tlca_lcb_lst
Identifies the original landed cost budget record from which the transaction landed cost distribution was created.
Select
Landed Cost PO
custrecord_fq_apm_tlca_lcpo_lst
References the Purchase Order created specifically for the landed costs being allocated, ensuring traceability of the expenses.
Select
Landed Cost Vendor Bills
custrecord_fq_apm_tlca_vbills_mlst
Indicates the Vendor Bill that the landed cost allocation has been billed on.
Multiselect
Line Unique Key
custrecord_fq_apm_tlca_lineuniquekey_int
A unique identifier for the transaction line within the allocation record, ensuring precise tracking and differentiation of cost allocation
Integer
Quantity
custrecord_fq_apm_tlca_quantity_int
Displays the quantity for the landed cost allocation.
Integer
Source Exchange Rate
custrecord_fq_apm_tlca_exchrate_sc_flt
Indicates the exchange rate between the Source Currency and the Landed Cost Currency at time of creation.
Float
Source Transaction
custrecord_fq_apm_tlca_sourc_trans_lst
Identifies the original transaction to which the landed costs are being applied.
Select
Source Transcation Currency
custrecord_fq_apm_tlca_currency_sc_lst
Specifies the currency used in the Source Transaction.
Select
Supply Order
custrecord_fq_apm_tlca_inorder_lst
Denotes the incoming order or shipment to which the landed costs apply.
Select
Supply Order Line
custrecord_fq_apm_tlca_inorderln_lst
Specifies the particular line within the Incoming Order that is associated with the allocated cost.
Select
Transaction Landed Cost
custrecord_fq_apm_tlca_tlc_lst
Associates this allocation with a specific Transaction Landed Cost record, detailing the landed costs incurred
Select
Variance Amount
custrecord_fq_apm_tlca_amt_var_flt
Represents the variance in the landed cost currency.
Float
Variance Amount (Base Currency)
custrecord_fq_apm_tlca_amt_var_bc_flt
Represents the variance in the base currency.
Float
Variance Amount (Source Currency)
custrecord_fq_apm_tlca_amt_var_sc_flt
Represents the variance in the source transaction cost currency.
Float
Variance Transaction
custrecord_fq_apm_tlca_vartrans_mlst
This provides a link to the variance transaction(s).
Multiselect
FQ Cost Record Status
customrecord_fq_apm_costrec_status
The status record indicates the current stage of the Transaction Landed / Sales Cost record in its lifecycle, from creation to resolution. It helps manage and track the progress of landed cost applications, variance handling, and billing.
Description
custrecord_fq_apm_costrec_stat_desc_txt
The 'Description' field provides a detailed explanation of the Landed / Sales Cost Status.
Textarea
TQ Sales Cost Budget
customrecord_fq_apm_sc_budget
The Sales Cost Budget record is designed for planning and managing anticipated additional costs on sales, including duties, freight, and taxes. It aligns projected expenses with actuals ensuring effective cost control and financial oversight.
Budgets can be loaded against customers, items or a combination of both to automate the processing of sales costs.
Auto-Apply Transactions
custrecord_fq_apm_scb_autoappltrans_mlst
Specify transactions to which the budget record should be automatically applied to.
Multiselect
Calculation Method
custrecord_fq_apm_scb_calc_method_lst
Describes the calculation method used to allocate sales costs to items/transactions.
Select
Currency
custrecord_fq_apm_scb_currency_lst
Defines the currency to use on the generated Purchase Order.
Select
Custom Price Calculation Method
custrecord_fq_apm_scb_cpm_lst
This setting allows for the differentiation between custom pricing derived from customer master data and custom pricing set on a transaction by a user.
Select
Customer
custrecord_fq_apm_scb_customer_lst
Identifies the customer associated with the goods or services being sold.
Select
Description
custrecord_fq_apm_scb_description_txt
Provide an overview or details about the budget record. This is shown on the Sales Cost Purchase Order.
Textarea
Item
custrecord_fq_apm_scb_item_lst
Identifies the specific item within transactions that the sales cost is associated with.
Select
Percent
custrecord_fq_apm_scb_percent_per
Denotes the percentage used in the calculation of sales costs, relevant for certain calculation methods.
Float
Percentage Increase Rate Calculation Method
custrecord_fq_apm_scb_perinccm_lst
Select the default value to use as the starting value when a Sales Cost is used to increase the rate.
Select
Percentage Decrease Rate Calculation Method
custrecord_fq_apm_scb_perdeccm_lst
Select the default value to use as the starting value when a Sales Cost is used to decrease the rate.
Select
PO Creation Method
custrecord_fq_apm_scb_po_createmeth_lst
Defines the approach for generating Purchase Orders for sales costs.
Select
Rate
custrecord_fq_apm_scb_rate_flt
Indicates the rate to use in the cost calculation.
Float
Sales Cost Item
custrecord_fq_apm_scb_sc_item_lst
Specifies the item to be used for costing. This item will appear on transactions and impacts the general ledger. The item must be Other Charge for Resale OR Service for Resale and the native field ‘Can Be Fulfilled / Received’ should be set to FALSE.
Select
Sales Cost Filters
custrecord_fq_apm_scb_scbfilters_ltxt
Aggregates the SCB Filters that should apply during the Sales Cost Process. Filled in by script.
Clobtext
Sales Cost Processing Method
custrecord_fq_apm_scb_processmeth_lst
The Sales Cost Processing defines the method for processing the Transaction Sales Cost record.
Select
Sales Cost Vendor
custrecord_fq_apm_scb_sc_vendor_lst
Designates the vendor responsible for additional sales costs. This can be the same as the Vendor.
Select
TQ Sales Cost Filter
customrecord_fq_apm_scb_filter
The Sales Cost Filter record is designed to enhance the filtering capability of Sales Cost Budget records that are applied from Entity / Item to the Transaction during the Sales Cost process.
Applied Items
custrecord_fq_apm_scfltr_applyitems_ltxt
This field displays the Applied Items for this Filter.
Clobtext
Auto-Apply Transactions
custrecord_fq_apm_scfltr_appltrans_mlst
This field displays the Autoapply Transactions from Sales Cost Budget Record.
Multiselect
Calculation Method
custrecord_fq_apm_scfltr_calc_method_lst
This field displays the Calculation Method from Sales Cost Budget Record.
Select
Currency
custrecord_fq_apm_scfltr_currency_lst
This field displays the Currency from Sales Cost Budget Record.
Select
Custom Price Handling
custrecord_fq_apm_scfltr_cpm_lst
This field displays the Custom Price Handling from Sales Cost Budget Record.
Select
Customer
custrecord_fq_apm_scfltr_customer_lst
This field displays the Customer from Sales Cost Budget Record.
Text
Description
custrecord_fq_apm_scfltr_description_txt
This field displays the Description from Sales Cost Budget Record.
Textarea
Field Data Type
custrecord_fq_apm_scfltr_flddatatype_lst
This field displays the Filter Field Data Type.
Select
Field Data Type ID
custrecord_fq_apm_scfltr_flddatatype_int
This field displays the Filter Field Data Type ID.
Integer
Field Script ID
custrecord_fq_apm_scfltr_fldscriptid_txt
This field displays the Filter Field Script ID.
Text
Filter Type
custrecord_fq_apm_scfltr_filtertype_lst
This field displays the Filter APM Field Type.
Select
Item Saved Search
custrecord_fq_apm_scfltr_itemss_lst
This field displays the Item Saved Search.
Select
Item Table Data HTML
custrecord_fq_apm_scfltr_itemdata_ltxt
This field displays the Item Data Table HTML Definition.
Clobtext
Operator
custrecord_fq_apm_scfltr_operator_txt
This field displays the Filter Value Field List ID.
Text
Percent
custrecord_fq_apm_scfltr_percent_per
This field displays the Percent from Landed Cost Budget Record.
Float
Percentage Decrease Rate Calculation Method
custrecord_fq_apm_scfltr_perdeccm_lst
This field displays the Percentage Decrease Rate Calculation Method from Sales Cost Budget Record.
Select
Percentage Increase Rate Calculation Method
custrecord_fq_apm_scfltr_perinccm_lst
This field displays the Percentage Increase Rate Calculation Method from Sales Cost Budget Record.
Select
PO Creation Method
custrecord_fq_apm_scfltr_pocrtmeth_lst
This field displays the PO Creation Method from Parent Sales Cost Budget Record.
Select
Rate
custrecord_fq_apm_scfltr_rate_flt
This field displays the Rate from Sales Cost Budget Record.
Float
Record Type ID
custrecord_fq_apm_scfltr_rectype_txt
This field displays the Filter Record Type ID.
Clobtext
Sales Cost Budget
custrecord_fq_apm_scfltr_scb_lst
This field displays the parent Sales Cost Budget Record.
Select
Sales Cost Item
custrecord_fq_apm_scfltr_sc_item_lst
This field displays the Sales Cost Item from Sales Cost Budget Record.
Select
Sales Cost Processing Method
custrecord_fq_apm_scfltr_processmeth_lst
This field displays the Sales Cost Processing Method from Sales Cost Budget Record.
Select
Sales Cost Vendor
custrecord_fq_apm_scfltr_scvendor_lst
This field displays the Sales Cost Vendor from Sales Cost Budget Record.
Select
Value
custrecord_fq_apm_scfltr_value_txt
This field displays the Filter Value.
Text
Value List ID
custrecord_fq_apm_scfltr_valuelist_txt
This field displays the Filter Field Data Type ID.
Text
Value To
custrecord_fq_apm_scfltr_valueto_txt
This field displays the Filter Value To.
Text
TQ Sales Cost Filter Item Application
customrecord_fq_apm_scb_scfltr_itemapply
The Sales Cost Filter Item Application record is designed to enhance the Item filtering capability on the Sales Cost Filter.
Apply
custrecord_fq_apm_scfltria_apply_cb
This field displays whether the Item is applied to the Sales Cost Filter.
Check Box
Item
custrecord_fq_apm_scfltria_item_lst
This field displays the Item.
Select
Sales Cost Filter
custrecord_fq_apm_scfltria_scfilter_lst
This field displays the parent Sales Cost Filter Record.
Select
Sales Cost Budget
custrecord_fq_apm_scfltria_scbudget_lst
This field displays the parent Sales Cost Budget Record.
Select
TQ Sales Cost Percentage Change Method
customrecord_fq_apm_sc_perchangemeth
This record defines the calculation methods available when using percentage change calculation methods.
Description
custrecord_fq_apm_sc_perchm_description
The Description field provides a detailed explanation of the Sales Cost Percentage Change Method
Textarea
Net Rate
val_fqapm_scpchm_netrate
This is the rate of selling the item plus/minus all the applicable costs required to deliver it to the customer. The Net Rate provides a more accurate reflection of what the company has spent to sell the item. It is calculated as the (Gross Amount - Sales Costs) / Quantity.
Instance
Rate
val_fqapm_scpchm_rate
The price charged to the customer for a single unit of product / service. Sales Costs can increase or decrease the rate.
Instance
Starting Rate
val_fqapm_scpchm_startrate
The starting price for Sales Cost Calculations. This is sourced from the customer or item but could be changed on a transaction.
Instance
TQ Sales Cost Processing Method
customrecord_fq_apm_sc_processmeth
The TQ Sales Cost Processing defines strategy for processing the Sales Cost record when transacting.
Add as Line Item - Individual
val_fqapm_scpm_addasindividual
This method adds each sales cost budget as a separate line item on the transaction.
Instance
Add as Discount Item
val_fqapm_scpm_addasdiscount
This method applies the sales cost as a discount item, inserting a discount line underneath each applicable line item. This can be an increase or decrease.
Instance
Add as Line Item - Grouped
val_fqapm_scpm_addasgrouped
This method groups each sales cost budget per sales cost and then combines into a transaction line.
Instance
Change Rate
val_fqapm_scpm_changerate
This method changes the rate on the transaction to include the sales cost, directly altering the transaction amount.
Instance
Change Rate and Custom GL Posting
val_fqapm_scpm_changerategl
This method adjusts the rate on the transaction and posts the sales cost as a custom GL posting based on the item selected.
Instance
Custom GL Posting
val_fqapm_scpm_changegl
This method posts the sales cost to the general ledger based on the item selected, without altering the transaction amount or rates.
Instance
Description
custrecord_fq_apm_sc_pm_description
The 'Description' field provides a detailed explanation of the selected sales cost processing, illustrating how costs are processed within a transaction.
Textarea
No GL Posting
val_fqapm_scpm_nogl
This method processes the sales cost without posting any entries to the General Ledger, ensuring no financial impact.
Instance
TQ Transaction Sales Cost Allocation
customrecord_fq_apm_sc_trans_alloc
The Transaction Sales Cost Allocation record documents the distribution/allocation of each Transaction Sales Cost to individual line items within a transaction. It provides granular details on how landed are apportioned across items, ensuring precise cost tracking and financial accuracy in inventory valuation.
Automatically Created
custrecord_fq_apm_tsca_autocreated_cb
If this is checked, when the Sales Cost Vendor Bill was processed, the variance has been automatically processed.
Check Box
Base Currency
custrecord_fq_apm_tsca_currency_bc_lst
Specifies the base currency.
Select
Base Exchange Rate
custrecord_fq_apm_tsca_exchrate_bc_flt
Indicates the exchange rate between the Base Currency and the Landed Cost Currency at time of creation.
Float
Billed Amount
custrecord_fq_apm_tsca_amt_billed_flt
Shows the amount billed for the sales costs in transaction sales cost currency.
Float
Billed Amount (Base Currency)
custrecord_fq_apm_tsca_amt_billed_bc_flt
Shows the amount billed for the sales costs in base currency.
Float
Billed Amount (Source Currency)
custrecord_fq_apm_tsca_amt_billed_sc_flt
Shows the amount billed for the sales costs in transaction source currency.
Float
Billed Rate
custrecord_fq_apm_tsca_rat_billed_flt
Shows the rate billed for the sales costs in transaction landed cost currency.
Float
Billed Rate (Base Currency)
custrecord_fq_apm_tsca_rat_billed_bc_flt
Shows the rate billed for the sales costs in base currency.
Float
Billed Rate (Source Currency)
custrecord_fq_apm_tsca_rat_billed_sc_flt
Shows the rate billed for the sales costs in transaction source currency.
Float
Budgeted Rate
custrecord_fq_apm_tsca_rat_budget_flt
Shows the rate initially budgeted for the sales costs in transaction landed cost currency.
Float
Budgeted Amount
custrecord_fq_apm_tsca_amt_budget_flt
Shows the amount initially budgeted for the sales costs in transaction sales cost currency.
Float
Budgeted Amount (Base Currency)
custrecord_fq_apm_tsca_amt_budget_bc_flt
Shows the amount initially budgeted for the sales costs in the base currency.
Float
Budgeted Rate (Base Currency)
custrecord_fq_apm_tsca_rat_budget_bc_flt
Shows the rate initially budgeted for the sales costs in the base currency.
Float
Budgeted Rate (Source Currency)
custrecord_fq_apm_tsca_rat_budget_sc_flt
Shows the rate initially budgeted for the sales costs in transaction source currency.
Float
Budgeted Amount (Source Currency)
custrecord_fq_apm_tsca_amt_budget_sc_flt
Shows the amount initially budgeted for the sales costs in transaction source currency.
Float
Calculation Data
custrecord_fq_apm_tsca_calcdata_ltxt
Shows the Calculation Data as an outcome of the Sales Cost Process.
Clobtext
Currency
custrecord_fq_apm_tsca_currency_lst
Specifies the currency in which the sales costs are calculated and applied.
Select
Date/Time Posted
custrecord_fq_apm_tsca_posted_dt
This field stores the date and time when the sales cost reconciliation record was created.
Date / Time
Demand Order Line
custrecord_fq_apm_tsca_outorderln_lst
Specifies the particular line within the demand order that is associated with the distributed cost.
Select
Demand Order
custrecord_fq_apm_tsca_outorder_lst
Denotes the demand order or shipment to which the landed costs apply.
Select
Item
custrecord_fq_apm_tsca_item_lst
Identifies the specific item to which the sales cost is allocated, linking the cost directly to the affected inventory.
Select
Line Unique Key
custrecord_fq_apm_tsca_lineuniquekey_int
A unique identifier for the transaction line within the allocation record, ensuring precise tracking and differentiation of cost allocation.
Integer
Quantity
custrecord_fq_apm_tsca_quantity_int
Displays the quantity for the sales cost allocation.
Integer
Sales Cost PO
custrecord_fq_apm_tsca_scpo_lst
References the Purchase Order created specifically for the sales costs being distributed, ensuring traceability of the expenses.
Select
Sales Cost Vendor Bills
custrecord_fq_apm_tsca_vbills_mlst
Indicates the Vendor Bill that the landed cost allocation has been billed on.
Multiselect
Sales Cost Budget
custrecord_fq_apm_tsca_scb_lst
Identifies the original sales cost budget record from which the transaction sales cost allocation was created.
Select
Source Exchange Rate
custrecord_fq_apm_tsca_exchrate_sc_flt
Indicates the exchange rate between the Source Currency and the Landed Cost Currency at time of creation.
Float
Source Transcation Currency
custrecord_fq_apm_tsca_currency_sc_lst
Specifies the currency used in the Source Transaction.
Select
Source Transaction
custrecord_fq_apm_tsca_sourc_trans_lst
Identifies the original transaction to which the sales costs are being applied.
Select
Transaction Sales Cost
custrecord_fq_apm_tsca_tsc_lst
Associates this allocation with a specific Transaction Sales Cost record, detailing the sales costs incurred
Select
Variance Amount
custrecord_fq_apm_tsca_amt_var_flt
Represents the variance in the sales cost currency.
Float
Variance Amount (Source Currency)
custrecord_fq_apm_tsca_amt_var_sc_flt
Represents the variance in the source transaction cost currency.
Float
Variance Transaction
custrecord_fq_apm_tsca_vartrans_mlst
This provides a link to the variance transaction(s).
Multiselect
Variance Amount (Base Currency)
custrecord_fq_apm_tsca_amt_var_bc_flt
Represents the variance in the base currency.
Float
TQ Transaction Sales Cost
customrecord_fq_apm_sc_trans_rec
This custom record is used to store transaction sales costs records
Applied To Items
custrecord_fq_apm_tsc_appltoitems_mlst
This Field displays the Items to which this Transaction Sales Cost is exclusively applied. If this Field is empty, the Transaction Sales Cost Budget is not filtered based on Items.
Multiselect
Automatically Created
custrecord_fq_apm_tsc_autocreated_cb
If this is checked, when the Sales Cost Vendor Bill was processed, the variance has been automatically processed.
Check Box
Base Currency
custrecord_fq_apm_tsc_currency_bsc_lst
Specifies the base currency in the NetSuite account (sourced from Company Information).
Select
Base Exchange Rate
custrecord_fq_apm_tsc_exchrate_bsc_flt
Indicates the exchange rate between the Base Currency and the Sales Cost Currency at time of creation.
Float
Billed Amount
custrecord_fq_apm_tsc_amt_billed_flt
Represents the total billed amount for sales costs in the sales cost currency.
Float
Billed Amount (Base Currency)
custrecord_fq_apm_tsc_amt_billed_bsc_flt
Represents the total billed amount for sales costs in the base currency.
Float
Billed Amount (Source Currency)
custrecord_fq_apm_tsc_amt_billed_sc_flt
Represents the total billed amount for sales costs in the source transaction currency.
Float
Budgeted Amount
custrecord_fq_apm_tsc_amt_budget_flt
Represents the budgeted / total amount for sales costs in the sales cost currency.
Float
Budgeted Amount (Base Currency)
custrecord_fq_apm_tsc_amt_budget_bsc_flt
Represents the budgeted / total amount for sales costs in the base currency.
Float
Budgeted Amount (Source Currency)
custrecord_fq_apm_tsc_amt_budget_sc_flt
Represents the budgeted / total amount for sales costs in the source transaction currency.
Float
Calculation Data
custrecord_fq_apm_tsc_calcdata_ltxt
Shows the Calculation Data as an outcome of the Sales Cost Process.
Clobtext
Calculation Method
custrecord_fq_apm_tsc_calc_method_lst
Describes the method used to allocate sales costs to items/transactions.
Select
Currency
custrecord_fq_apm_tsc_currency_lst
Specifies the currency in which the sales costs are calculated and applied.
Select
Custom Price Calculation Method
custrecord_fq_apm_tsc_cpm_lst
This fields defines how Sales Cost should handle custom pricing. It allows for the differentiation between custom pricing derived from customer master data and custom pricing set on a transaction by a user. This setting only applies when: - The transaction line has ‘Custom’ set as the price level - A Sales Cost applies that has ‘Change Rate set to TRUE The following options are available: - Always Change Custom Rate - If selected, Sales Cost will modify the rate in all scenarios. - Change Manually Entered Rates Only - If selected, Sales Cost will modify the rate if a user/script has manually changed the rate on the transaction. - Change Customer/Item Specific Pricing - if selected, Sales Cost will modify the rate if the rate is sourced from the Customer Item Pricing record. Never Change Custom Rate - if selected, Sales Cost will never modify the rate.
Select
Customer
custrecord_fq_apm_tsc_customer_lst
Specifies the customer related to the source transaction
Select
Date/Time Posted
custrecord_fq_apm_tsc_posted_dt
This field stores the date and time when the sales cost reconciliation record was created.
Date / Time
Demand Order
custrecord_fq_apm_tsc_outorder_lst
Refers to the specific demand order linked to the sales costs.
Select
Description
custrecord_fq_apm_tsc_description_txt
Provide an overview or details about the sales cost record. This is shown on the Sales Cost Purchase Order.
Textarea
Filter Data
custrecord_fq_apm_tsc_filterdata_ltxt
Aggregates the SCB Filters that should apply during the Sales Cost Process. Filled in by script.
Clobtext
Item Table Data HTML
custrecord_fq_apm_tsc_itemdata_ltxt
This field displays the Item Data Table HTML Definition.
Clobtext
Line Unique Key
custrecord_fq_apm_tsc_lineuniquekey_int
Line Unique Key from the Transaction Line.
Integer
Percent
custrecord_fq_apm_tsc_percent_per
Denotes the percentage used in the calculation of sales costs, relevant for certain calculation methods.
Percent
Percentage Decrease Rate Calculation Method
custrecord_fq_apm_tsc_perdeccm_lst
Select the default value to use as the starting value when a Sales Cost is used to decrease the rate.
Select
Percentage Increase Rate Calculation Method
custrecord_fq_apm_tsc_perinccm_lst
Select the default value to use as the starting value when a Sales Cost is used to increase the rate.
Select
PO Creation Method
custrecord_fq_apm_tsc_po_createmeth_lst
PO Creation Method. Defines the approach for generating Purchase Orders for sales costs.
Select
Quantity
custrecord_fq_apm_tsc_quantity_flt
Specifies the quantity for the sales cost. This is the quantity on the sales cost purchase order and is always calculated by the script.
Float
Rate
custrecord_fq_apm_tsc_rate_flt
Indicates the rate to use in the cost calculation.
Float
Sales Cost Budget
custrecord_fq_apm_tsc_scb_lst
Identifies the original sales cost budget record from which the transaction sales cost was created
Select
Sales Cost Item
custrecord_fq_apm_tsc_sc_item_lst
Specifies the item which is used on the Sales Cost Purchase Order. The item must be Other Charge / Service for Purchase and cannot be fulfilled / received.
Select
Sales Cost PO
custrecord_fq_apm_tsc_scpo_lst
This links the Transaction Sales Cost to the Sales Cost Purchase Order.
Select
Sales Cost Processing Method
custrecord_fq_apm_tsc_processmeth_lst
The Sales Cost Processing defines the method for processing the Transaction Sales Cost record.
Select
Sales Cost Source
custrecord_fq_apm_tsc_sc_source_lst
This field displays the sales cost source
Select
Sales Cost Status
custrecord_fq_apm_tsc_scstatus_lst
The status field indicates the current stage of the Transaction Sales Cost record in its lifecycle, from creation to resolution. It helps manage and track the progress of sales cost applications, variance handling, and billing.
Select
Sales Cost Vendor
custrecord_fq_apm_tsc_sc_vendor_lst
Designates the vendor responsible for additional expenses such as freight, duties, or taxes that comprise the sales costs.
Select
Sales Cost Vendor Bills
custrecord_fq_apm_tsc_vbills_mlst
This links the Transaction Sales Cost record to the Vendor Bills.
Multiselect
Source Exchange Rate
custrecord_fq_apm_tsc_exchrate_sc_flt
Indicates the exchange rate between the Source Currency and the Sales Cost Currency at time of creation.
Float
Source Transaction
custrecord_fq_apm_tsc_sourc_trans_lst
Identifies the original transaction to which the sales costs are being applied.
Select
Source Transaction Currency
custrecord_fq_apm_tsc_currency_sc_lst
Specifies the currency used in the Source Transaction.
Select
Updated Manually
custrecord_fq_apm_tsc_updated_man_cb
This field indicates if the sales cost has been updated manually by a user
Check Box
Variance Amount
custrecord_fq_apm_tsc_amt_var_flt
Represents the variance in the sales cost currency.
Float
Variance Amount (Base Currency)
custrecord_fq_apm_tsc_amt_var_bsc_flt
Represents the variance in the base currency.
Float
Variance Amount (Source Currency)
custrecord_fq_apm_tsc_amt_var_sc_flt
Represents the variance in the source transaction cost currency.
Float
Variance Transaction
custrecord_fq_apm_tsc_vartrans_mlst
This provides a link to the variance transaction(s).
Multiselect
Last updated