Topic Options
#5892 - 04/27/06 07:03 PM alternate item list
Bruce Offline
Adagio Guru

Registered: 06/15/05
Posts: 117
Loc: langley
We have a few alternate price lists. With the multi currency & alternates working properly now (going to the default) we tried to clean up our data. I exported from the alternate price list the items that I needed. Saved that file. Made new template to import. Then went to alternate price list codes & deleted the one that I wanted. This deleted all items as planned. I then made a new alternate price list code using the exact same name & imported the saved items. This worked perfect. Tested the customers & all works as it should, defaults to base or picks up the alternate item if available. Good so far.
Now we go to edit alternate price list items and they do not show up. The other price lists display their items but not the imported one. We have not done a dayend yet. We tested by doing an export of that particular alternate price list & all items exported just fine.

Top
#5893 - 04/30/06 03:22 PM Re: alternate item list
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4413
Loc: Vancouver, BC
My guess would be that the index did not get rebuilt during import. An IC Data Integrity Check with Rebuild (if an error is found) should rebuild the index.

Top
#5894 - 05/03/06 10:13 AM Re: alternate item list
Bruce Offline
Adagio Guru

Registered: 06/15/05
Posts: 117
Loc: langley
we have done integrity checks & all is fine. Price list does not show up in Alternates. When you export items from alternate price lists the group does not show. When you invoice it picks up the right price.

Top
#5895 - 05/03/06 07:27 PM Re: alternate item list
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi Bruce,

I could not duplicate the behaviour that you described - when I delete a price list code (to remove all the alternate price list items), then re-create the price list code and import, I am able to see all of the imported records on the Edit Alternate Price List Item grid.

- Can I confirm that you are using Multi-currency and the database is enabled as such. You posted this initially but I want to make sure.

- Do you use Inventory, or is this importing directly into Adagio Order Entry (without IC)?

- After importing, you could use GridView to look at the Alternate Price List file to make sure the records are there.


Top
#5896 - 05/05/06 10:44 AM Re: alternate item list
Bruce Offline
Adagio Guru

Registered: 06/15/05
Posts: 117
Loc: langley
we re did the process & everything works now. I have no idea why it didn't the first time. We did three data bases without a hitch. Go figure????

Thanks for the help.. did anyone fid a fix for my negative inventory on PO that doesn't exist?


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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