-
What is the field value for 'Average Cost' of cost estimate type in an invoice?
Hi Gurus, I tested a script to set the value of the "Cost Estimate Type" of line item as 'Average Cost' when creating an invoice. However, an error message returned suggesting that 'Average Cost' is not a valid value. I tried 'Average' and it was not valid neither. What would be the valid value for 'Average Cost' as the…
-
Quote Gross Profit Calculation
Hi All, Anyone know how the Est.Gross profit is calculated for the below-mentioned quote record?
-
How to set Cost Estimate Type once Class field has been set via Workflow?
Is there a way to have this be automatically chosen based on the item classification? For example, if the classification is "stocking" I would like the cost estimate type to be "item defined cost". If the classification is "nonstock I would like it to be auto set to "Purchase order rate"
-
How to populate Custom Est. Cost and PO Rate on Sales Order lines?
We're dealing with an issue that seems like it would affect lots of users, but I haven't found anything posted about it. Oftentimes when we create a sales order, the cost estimate type on the line is "Custom". But when we go to create a PO from that order (by clicking the Spec. Order or Drop Ship link), the rate on the PO…
-
NSC | Setting Default Cost Estimate Type Per Item Type
Scenario Users may need to set different default Cost Estimate Types at the Item Type level. For example, an Inventory Item might need to be Last Purchase Price, while an Assembly or Kit might be best with an Average Cost. Solution Currently, there is no preference to set this up per Item type, but as an alternate…
-
Quick view of component costs for quoting/estimates
Hi, New to Netsuite. Looking for how to view the total component costs of a new assembly item so that we can us that cost to create a price list and quotes. An Example: Create new assembly item 1-01000 Components Are: 1-10000 (standard cost 100$) quantity of 0.1 (100 x 0.1 = 10) 43-00500 (standard cost 321.43$) quantity of…
-
Cost Estimate Type -> Can the Purchase Order Rate type include the landed costs
Hello, So we used Special Order in Sales Order to generate a linked Purchase Order. In Suiteanswers "Cost Estimate Type Descriptions", the Purchase Order Rate is described as best to used when we are using special order. However, we also use landed cost and we would like it included in the estimated cost as well. But the…
-
Sales order invoice not showing correct "purchase order price" rate
This is kind of tricky to explain but I will try my best. We have noticed on multiple occasions that when one of our reps enters a sales order with products at the price level of "purchase order price" upon invoicing the price is incorrect and instead is the part purchase price, not the purchase order price. The purchase…
-
Custom Cost Estimate type not copying from Estimate to Sales Order
We have a number of instances where the EST. UNIT COST did not copy from the Estimate to the Sales Order. Most are Custom COST ESTIMATE TYPE, but some are Last Purchase Price. We are using ARM, the items ALLOCATION TYPE is Normal. Any ideas why the costs don't copy?