Search options (Page 1 of 3)

So I just tried it with == but then the suppliers description becomes blank. If I just use one = the suppliers description remains intact.

And another really irritating change that happens during this order process is that the purchase price is truncated to the default number of decimal points.

I put the price in at 2.569879 but after processing the order it becomes 2.57 - which is wrong.

These names and prices were put in randomly. In my actual business I have several products that I buy in lots of 42. The per item price is e.g. 13.6904761905 X 42 = 575

When the price is truncated I get a decimal amount, and the supplier's currency does not use decimals.

Right. But the supplier code is changed to $description everytime the supply order is processed (purchase order entry -> receive purchase order items -> enter supplier invoice)

Please see the attached screen shots. I created a product called "General Settings name"  with the suppliers description = "supplier's code"

After processing the order, the suppliers description becomes "General Settings name".

Having misunderstood standard cost, I now have a year's worth of transactions with the incorrect values, as shown in my Inventory GL.

Sales are recorded in one currency and purchases are recorded in the home currency.

Is there any way to re-calculate standard cost for transactions which are already recorded?

purchasing/includes/purchasing_db.inc

Line 113

    if ($description != "")
        $sql .= ",supplier_description=".db_escape($description);
    $sql .= " WHERE stock_id=".db_escape($stock_id)." AND supplier_id=".db_escape($supplier_id);

Why???

This means if the description is not empty e.g. already has data, change the supplier description.

If there is a reason for this, it does not work for me, as every time I receive an order my supplier description changes.

If I change the first line to 

if ($description = "")

then the supplier data remains intact.

I think it would make more sense to scrap this section of code and simply check that the description is not empty when creating a product, which I'm pretty sure FA does already.

kvvaradha thanks for your help. Here are the first two lines of my csv file:

"Date","Time","TimeZone","Name","Type","Status","Currency","Gross","Fee","Net","From Email Address","To Email Address","Transaction ID","Shipping Address","Address Status","Item Title","Item ID","Shipping and Handling Amount","Insurance Amount","Sales Tax","Option 1 Name","Option 1 Value","Option 2 Name","Option 2 Value","Reference Txn ID","Invoice Number","Custom Number","Quantity","Receipt ID","Balance","Address Line 1","Address Line 2/District/Neighborhood","Town/City","State/Province/Region/County/Territory/Prefecture/Republic","Zip/Postal Code","Country","Contact Phone Number","Subject","Note","Country Code","Balance Impact"

"01/01/2021","02:32:38","EST","Rxxxxx Txxxxxxx","Express Checkout Payment","Completed","USD","120.20","-4.99","115.21","xxxxxxxx@gmail.com","xxxxxxxx@teafromtaiwan.com","5C638500WR1159345","Rxxxxx, Txxxxxxx, PO Box xxx, xxxxxxx, New South Wales, xxxx, Australia","Confirmed","Rui Feng Jin Xuan Milk Oolong Tea [101] Weight:: 75 grams, Dong Ding Ming Xiang Oolong Tea [2] Weight:: 75 grams, Four Season Oolong Tea [12] Weight:: 150 grams, Tsuei Luan Oolong Tea [14] Weight:: 150 grams, Shi Zuo Oolong Tea [13] Weight:: 75 grams","瑞峰金萱茶, 凍頂蜜香烏龍茶, 阿里山四季烏龍茶, 翠巒高級烏龍茶, 阿里山石棹烏龍茶","0.00","","0.00","","","","","","6120-1609486367-[TeaFromTaiwan]","EC-6120-1609486367","5","","221.56","PO Box xxx","","xxxxxxx","New South Wales","xxxx","Australia","xxxxxxxxx","Rui Feng Jin Xuan Milk Oolong Tea [101] Weight:: 75 grams","","AU","Credit"

OK - I see. I just made a payment in CAD and it updated the exchange rate.

Thanks for all your help. I misunderstood this function - I thought it would update the rate everyday without any action on my part.

So my question is - What kind of transaction that will trigger this?

I did what you suggested about unticking the autoupdate box, saving and then reticking. This makes no difference.

I enter a few sales orders in USD, all the way through to customer payment, and the rate does not update.

I also did a transfer from a USD bank account to a CAD account, which did not update the rates.

So perhaps I have to do Payment or Deposit on the Banking and General Ledger tab, which seems to be the only places where exchange rates are included in the transactions. Is that correct?