Method:Classic General Q&A

Re: Clarification on Fields in EstimateLine Table

Method_Jason — Thu, 11 Apr 2013 17:33:11 GMT

IsRatePercent is the % field in the stock Estimate screen. It can be used for items such as a discount item that perform a calculation to the item above it. See my screenshot for an example. In this example, the "Prepay Discount" item is calculating 10% off the "3 1/2 stone" item. If we uncheck the % field, it will calculate $10 off instead of 10%.

You can find the sales price in the SalesPrice field in the ItemService table.

Everything else seems to be pretty accurate. Thanks for the detailed post!

- Jason

Re: Clarification on Fields in EstimateLine Table

JohnnyW — Thu, 11 Apr 2013 04:22:46 GMT

Jason,

Thank you for the clarification. Just to recap, here is my understanding so far based on what you've said and information gathered from other forum threads:

Rate: This is automatically populated with the item's cost (as in cost to our company) from QuickBooks. However, if there is no cost information in QuickBooks, this field will be automatically populated with the sales price (as in the amount we sell it for).

MarkupRate: This is either a dollar amount or a percentage (as indicated by IsMarkupPercent) that is used to adjust the Rate. If I understand correctly, Method retrieves the item's cost directly from Quickbooks. If there is also a sales price in QB, Method automatically adjusts the MarkupRate to reflect this difference. However, there seems to be no field to store the sales price in. It seems that the original cost is stored in the Rate field and the markup rate is stored in MarkupRate. The result of those two fields will give the ultimate unit sales price. However, the value does not seem to be stored in the table anywhere.

If there is no cost, only a sales price stored in QB, I'm guessing the MarkupRate is set to 0 and the sale price is stored in the Rate field as mentioned above.

IsMarkupPercent: "Yes" value let's Method know to calculate percentage markup to the Rate. "No" value simply adds the MarkupRate as a dollar amount to the Rate.

Amount: The actual calculation seems to work in the following ways:

If IsMarkupPercent = Yes, Rate x (1+MarkupRate/100) x Quantity (Dividing the MarkupRate by 100 turns the percent to a decimal)
If IsMarkupPercent = No, (Rate + MarkupRate) x Quantity
If MarkupRate = 0 Rate x Quantity

TotalAmount: Used for totaling all amounts of items that belong to a group. I haven't tried this out yet so I'm not exactly sure about it's behavior.

IsRatePercent: I'm not sure about this one. What does this do?

Please let me know if any of this information is inaccurate. Hopefully it will help anyone else trying to navigate the EstimateLine mapping between Method and QB.

Re: Clarification on Fields in EstimateLine Table

Method_Jason — Tue, 09 Apr 2013 20:50:34 GMT

Hi Johnny,

If you're using the stock Estimate screen, you'll see fields in the grid called Quantity, Cost, and Amount. The Cost field on the grid is actually attached to the Rate field in the table. The workflow should be: Quantity X Rate(Cost) = Amount. See my screenshot below.

The TotalAmount field is hidden by default from the stock screens. It is used to calculate the total of a group item.

- Jason

Clarification on Fields in EstimateLine Table

JohnnyW — Tue, 09 Apr 2013 19:30:00 GMT

Does anyone know what the difference is between Rate, Amount, and TotalAmount in the EstimateLine table? Originally I thought that Rate corresponds to the unit price we pay for a product or service, Amount is the unit price we sell the product for, and TotalAmount was like the sales extension (Quantity x Amount). However, while working with these fields it appears as if the Amount and TotalAmount are being calculated the same way. Does anyone know how these field correspond to QB estimate lines?