Changing multiple cost and price figures
Options
lori_6951808
Member Posts: 15 ✭
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.
0
Comments
-
anyone??0
-
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
0 -
Thanks chandra, I'm just stepping out of the office but will call you this afternoon if that is ok?0
-
ok thks
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0 -
hi Lori
thanks send the info when you can, thks
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0 -
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
0 -
Ok Thanks Jon, Can you import the sorted file back without problems?0
-
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
0 -
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,
John0 -
HI Lori, How did you go with iif importation?
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 2.9K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community