<div dir="ltr"><div><div><div><div><div><div>Hi Sandre,<br><br></div>The current replacement/rrp field is used for two things:<br></div><br>1 - passing through from the orders as the items.replacementprice field<br></div>2 - the basis for calculating prices (minus discount, plus tax, etc)<br><br></div>Splitting the replacement cost out will allow proper discount/tax calculation while allowing manual edit to the replacement cost to add fees etc.<br><br></div>I believe our proposal works for your workflow.<br><br></div>-Nick<br></div><br><div class="gmail_quote"><div dir="ltr">On Tue, May 16, 2017 at 5:40 PM Sandre Cunha <<a href="mailto:cunha@monterey.org">cunha@monterey.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Before you add yet another price field to acquisitions, I would like to understand the intended function of the "replacement/rrp" field. <div><br></div><div>I realize that not all libraries operate the same and that they have a variety of needs and restraints. For Monterey Public Library, the only reason to even have replacement cost in the order screen is to streamline processing when the item gets to cataloging, i.e., so they don't have to enter it. </div><div>For us, the replacement cost is the price we charge the customer if they lose or damage the item. Is this the intended purpose of this field?</div><div><br></div><div>Our
replacement cost used to be the list price plus $10 for processing, but never included tax. </div><div><br></div><div><div>Example 1:</div><div>Retail price: $27.99 Actual cost: $15.34 Sales tax:$1.34 In this scenario, the replacement price = $37.99 [27.99 + $10.00 processing]</div></div><div><br></div><div>Now, we use
our actual cost [the price discounted from retail]; the only time it is different is when the cost is less
than our maximum fine, in which case the maximum fine fee becomes the replacement price.<br></div><div><br></div><div><div>Example 2:</div><div>Retail price: $27.99 Actual cost: $15.34 Sales tax: $1.34 Replacement price = $15.34</div></div><div><br></div><div><div>Example 3:</div><div><br></div><div>Retail price: $18.00 Actual cost: $9.86 Sales tax: $0.83 Replacement price: $10.00 [our maximum late fine for this collection is $10.00, which is more than 9.86]</div><div><br></div><div>Other drawbacks to the new way "replacement/rrp" is handled: when you need to create an order for which the cost is $0 (gift, credit
allocation, or pre-order for next fiscal year) but you want to have a
replacement cost recorded.<br></div></div><div><br></div><div>Additionally, please note that we do not enter discounts in our vendor records, as even with our largest two vendors the discount varies depending on the type of material and source. With one vendor our contract specifies a 42% discount for many items, but for some we get less, some no discount, and every once in a while we pay more than retail due to a surcharge.</div><div><br></div><div>I would be interested to know the methods acquisitions staff at other libraries use. It would be useful to have a better understanding of usage and needs before adding yet another field to the order details.</div><div class="gmail_extra"><br clear="all"><div><div class="m_6237886434854006539m_7956485763448162986gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div style="font-family:arial;font-size:small">________________________</div><div style="font-family:arial;font-size:small">Sandre Cunha</div><div style="font-family:arial;font-size:small">Technical Services Supervisor</div><div style="font-family:arial;font-size:small">Monterey Public Library</div><div style="font-family:arial"><div style="font-size:13px;font-family:arial,sans-serif">625 Pacific Street</div><div style="font-size:13px;font-family:arial,sans-serif">Monterey, CA 93940</div><div style="font-size:13px;font-family:arial,sans-serif">Tel. <a href="tel:(831)%20646-3740" value="+18316463740" target="_blank">831-646-3740</a></div><div style="font-size:13px;font-family:arial,sans-serif"><br></div><div style="font-family:arial,sans-serif"><span style="color:rgb(51,51,51);font-family:"FF Meta Serif W01",serif"><font size="2">“If you want to build a ship, don’t drum up your men to collect wood and give orders and distribute the work. Instead, teach them to yearn for the vast and endless sea." -- </font></span><span style="color:rgb(51,51,51);font-family:"FF Meta Serif W01",serif"><font size="2">Antoine de Saint-Exupéry</font></span><br></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote"></div></div></div><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Tue, May 9, 2017 at 1:44 PM, Nick Clemens <span dir="ltr"><<a href="mailto:nick@bywatersolutions.com" target="_blank">nick@bywatersolutions.com</a>></span> wrote:<br></div></div></div><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div>Hello All,<br><br></div>With the current versions of Koha there have been some changes in <span class="m_6237886434854006539m_7956485763448162986m_7368670570005030622inbox-inbox-lG">acquisitions</span> and how prices are calculated and there seems to be some confusion in terms and how things are currently being used.<br><br></div>We wanted to clarify what is happening, propose a change and get feedback on what needs to happen.<br><br></div>When placing an order there are several price fields:<br></div>Vendor price (listprice in db)<br>-This is used to populate the Replacement cost and budgeted cost on the order page. It is not used against the budget<br><br></div>Replacement cost (rrp in db) <br>-This
is used to calculate the 'budgeted cost/ecost' in the budget - it also
populates the replacement price in the item created by the aqc process
once received<br><br></div>Budgeted cost (ecost in db)<br></div>-This is
the replacement/rpp minus any discount on the order - this is the value
that will be encumbered when the order is placed<br><br></div>Actual cost (unitprice)<br></div>-This is the eventual 'price' of the item and is the encumbered amount once the item has been received.<br><br></div>With
the changes that were made one can no longer adjust the
'Replacement/RRP' once an order is placed - this is because this value
is adjusted for tax in the db (rrp_tax_excluded, rrp_tax_included) and
used for calculating the ecost tax adjusted (ecost_tax_excluded,
ecost_tax_included)<br><br></div>Some libraries have been having issues
as they use 'Replacement' cost mostly for populating items and are not
used to it being unable to be edited and/or affecting budgets.<br><br></div>We
are proposing to rename the current 'Replacement cost' field to match
the db value - 'Recommended retail price' (RRP) and add a new
'Replacement cost' field, editable at any point, that is only used for
populating the item field.<br><br></div>We think this will clear up how the other values are being used and restore functionality that changed.<br><br></div>Please let us know if this works or what other suggestions you have here.<br><br></div>Thank you,<br></div>Nick, Kyle, Jonathan</div>
<br></blockquote></div></div></div><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">_______________________________________________<br>
Partners mailing list<br>
<a href="mailto:Partners@lists.bywatersolutions.com" target="_blank">Partners@lists.bywatersolutions.com</a><br>
<a href="http://lists.bywatersolutions.com/mailman/listinfo/partners" rel="noreferrer" target="_blank">http://lists.bywatersolutions.com/mailman/listinfo/partners</a><br>
<br></blockquote></div></div></div></blockquote></div>