Changing multiple cost and price figures

Options
lori_6951808
lori_6951808 Member Posts: 15 ✭
edited September 2018 in Accounts Hosted
We have thousands of items/products that we sell and we buy from multiple suppliers.  Is there an easy way we can change the buy and sell price of a certain supplier, by adding a percentage increase?  I know you can change prices via items activity - change prices, but this brings up all items in our inventory not just the ones by a single supplier.  

Comments

  • lori_6951808
    lori_6951808 Member Posts: 15 ✭
    edited May 2016
    Options
    anyone??
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,075 ✭✭✭
    edited September 2018
    Options
    Hi Lori, i do wish to discuss on your inquiry,
    call me any time :02 95411338, 0407068942

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • lori_6951808
    lori_6951808 Member Posts: 15 ✭
    edited September 2018
    Options
    Thanks chandra, I'm just stepping out of the office but will call you this afternoon if that is ok?
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,075 ✭✭✭
    edited September 2018
    Options
    ok thks

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • cosmic
    cosmic Reckon Developer Partner Posts: 1,075 ✭✭✭
    edited December 2016
    Options
    hi Lori
    thanks send the info when you can, thks

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Reckon FAQs
    Reckon FAQs Reckon Staff Posts: 357 Reckon Staff
    edited September 2018
    Options
    Hi Lori,

    If you have a preferred supplier listed for your item, you can export your item list to an IIF file (File>Utilities>Export>Lists to IIF>Item list, open it in Excel and sort the file by Preferred Supplier (PREFVEND).  You'll have all Preferred Suppliers' items together and you can use excel formulae to change the price.  Then import back into your company file.  

    Hope this is useful.


    regards,
    John

  • lori_6951808
    lori_6951808 Member Posts: 15 ✭
    edited May 2016
    Options
    Ok Thanks Jon,  Can you import the sorted file back without problems?
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,075 ✭✭✭
    edited December 2016
    Options
    Lori, try it , its not as easy process, will still require your manual handling sorting out right mapping, since you got lots of items, you will need to spend time in this.

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

  • Reckon FAQs
    Reckon FAQs Reckon Staff Posts: 357 Reckon Staff
    edited August 2015
    Options
    Hi Lori,

    When you save the file make sure you choose to keep it in its original format - IIF.  If it gets saved as a .txt file, then rename the file from .txt to .iif.

    When sorting, make sure you sort just the Items and their associated columns across the whole file, and leave all other parts of the file as is.  

    When you import, the IIF content will overwrite the Item Record content. 

    Hope this helps.

    regards,
    John
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,075 ✭✭✭
    edited December 2016
    Options
    HI Lori, How did you go with iif importation?

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009

Categories