We sell time. We use Price Levels for different rates for different types of work, for example Standard, Digital, Pre-media etc.
Our projects can last over a year also depending on the when the project was started, the sell rate of account management can change (we do rate changes yearly in Oct). We need to track our cost/sell of each timesheet line prepared.
I have been able to add the Cost Rate to the timeseheet form (weekly timesheet) but the Sell Rate is eluding me. I can only seem to find the "Base Price" which is basically our Standard Rate, not the Price Level rates.
As I have changed rates by importing, I know that the rates are in fields called itemPriceLine1_itemPrice, itemPriceLine2_itemPrice2, etc, but I cannot find these at all.
Any idea where these live? I have spent hours, changing up my source, source fields, type, etc, cannot find anything.
Am I thinking of this backwards, is there a better way to do this?
I've uploaded some screenshots to help.