Topic Options
#22785 - 06/15/10 10:19 AM OE MARK UP PERCENT
Riddell Offline
Stranger

Registered: 06/04/10
Posts: 2
Loc: Ontario
We currently have Cost + PST + different markups for A-E in Markup Percent. With the HST coming into effect, is there a way to change all of the item's mark up percentages at once, instead of each item individually?

Top
#22786 - 06/15/10 10:25 AM Re: OE MARK UP PERCENT [Re: Riddell]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4419
Loc: Vancouver, BC
You could export them to a spreadsheet, make the necessary changes and then import the changes.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#22808 - 06/16/10 07:09 AM Re: OE MARK UP PERCENT [Re: Douglas Dickie]
Riddell Offline
Stranger

Registered: 06/04/10
Posts: 2
Loc: Ontario
Could we get some guidance on how to go about exporting all of our items to a spreadsheet and changing the mark up percents and then importing them back into OE? File Format automatically says - ASCII CSV (Delimited) - Leave as that? Field Selection - Markup Factor? Selected Field - Item #? After we export them to the spreadsheet, how do you change the mark up percents there?

Top
#22809 - 06/16/10 07:24 AM Re: OE MARK UP PERCENT [Re: Riddell]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
You want training on how to use Excel? Import/Exports are covered in the Fundamentals manual.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
2 registered (Tanya_Belanger, Warren Karges), 58 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14477 Topics
70707 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31