Hi all, I'm an extremely new user to GP and my boss is looking for a solution to a situation we will have at the beginning of March. Our prices are changing for our items effective March 1, but he doesn't want to have someone take all day March 1 to go through and change them in GP. He is looking to make the new price list ahead of time, either on excell or word or whatever, and then on March 1 we can just import it to change the currently listed prices for our items. Is such a thing possible or are we going to have to do this on March 1? Thanks all for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question on importing price changes.
- Thread starter MattDante
- Start date
jazgeek
IS-IT--Management
- Jan 29, 2004
- 541
I do stuff like that in access all the time.
make your spreadsheet using an item number as a key column
bring it into access
link to the appropriate dynamics table
run an update statement
of course make a backup before you do this
-----------
and they wonder why they call it Great Pains!
jaz
make your spreadsheet using an item number as a key column
bring it into access
link to the appropriate dynamics table
run an update statement
of course make a backup before you do this
-----------
and they wonder why they call it Great Pains!
jaz
- Thread starter
- #3
Jazgeek, I appreciate the help so far, but as I said, I am completely new to using GP. I have the table made up in Access with the item number as a key column, but I don't know what you mean by linking the appropriate dynamics table or running an update statement. If you could do a step by step on those two items it would really clear things up. Thanks again.
jazgeek
IS-IT--Management
- Jan 29, 2004
- 541
The table you will be modifying is the IV00108 table
take a look at the table and it's structure. It will be different for the number of currencies you use, the number of price levels, the method of the price levels etc.
If you're having difficulty with writing an update statement, I'm afraid I can't write it for you because of the above differences that I've listed. So anything I put down here will be wrong for your environment.
As far as being new to GP, this has nothing to do with the update statement. An update statement is the same syntax for GP as it is for any other database, just the table and field names are changed.
If you are really uncomfortable with this, back your database up, or work on a sample company like TWO before you go out and make your changes. If you are still not comfortable, I highly recommend asking your VAR to help you out. If the groundwork is done for them, they'll be able to do the update in less than 15 minutes (if they're good)
-----------
and they wonder why they call it Great Pains!
jaz
take a look at the table and it's structure. It will be different for the number of currencies you use, the number of price levels, the method of the price levels etc.
If you're having difficulty with writing an update statement, I'm afraid I can't write it for you because of the above differences that I've listed. So anything I put down here will be wrong for your environment.
As far as being new to GP, this has nothing to do with the update statement. An update statement is the same syntax for GP as it is for any other database, just the table and field names are changed.
If you are really uncomfortable with this, back your database up, or work on a sample company like TWO before you go out and make your changes. If you are still not comfortable, I highly recommend asking your VAR to help you out. If the groundwork is done for them, they'll be able to do the update in less than 15 minutes (if they're good)
-----------
and they wonder why they call it Great Pains!
jaz
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question