#38194 - 08/14/13 12:17 PM
Changing Purchase Order number format
|
New Guy
Registered: 04/17/13
Posts: 6
Loc: Ottawa, Ontario
|
We are currently using Adagio Purchase Orders 8.1C. We are trying to change the amount of characters that the item number contains. We do not use Inventory Control at all so we really only need to change the Sundry item number format. We have purchased Adagio Toolkit and have the Item number changer, but that does not seem to be able to change the item format.
Any help would be much appreciated.
Thanks
|
Top
|
|
|
|
#38198 - 08/15/13 05:02 AM
Re: Changing Purchase Order number format
[Re: JesseB]
|
Adagio Conductor
Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
|
I wasn't aware that P/O could operate without I/C. This scenario will be supported on the next release of the Toolkit.
|
Top
|
|
|
|
#38201 - 08/15/13 05:24 AM
Re: Changing Purchase Order number format
[Re: Bob Wisener]
|
New Guy
Registered: 04/17/13
Posts: 6
Loc: Ottawa, Ontario
|
Just to be clear, we are not using PO for any items that will be re-sold but only for the budget function when purchasing services or supplies for the business.
|
Top
|
|
|
|
#38204 - 08/15/13 08:07 AM
Re: Changing Purchase Order number format
[Re: Brian Stief]
|
Adagio Conductor
Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
|
The format is stored in the global file, but you have to consider all of the items and documents that contain item fields. A change to the format might require a change to the content of each item field.
|
Top
|
|
|
|
#38207 - 08/15/13 09:17 AM
Re: Changing Purchase Order number format
[Re: Bob Wisener]
|
New Guy
Registered: 04/17/13
Posts: 6
Loc: Ottawa, Ontario
|
Sorry, I think there's a misunderstanding here, maybe I wasn't clear,
from Adagio PO go profile > auto-numbering> Purchase Order Number Format/Item Number Format. We need to change these two options from 3-3-3 to 1-1-1.
I've seen other posts that speak of people changing it, are you saying you can't do this anymore?
|
Top
|
|
|
|
#38210 - 08/15/13 09:44 AM
Re: Changing Purchase Order number format
[Re: JesseB]
|
Adagio Conductor
Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
|
Once you post something in PO, you won't be able to change the format of the documents or Sundry items. The Toolkit for Adagio can be used to change both, but you'll have to wait for the next release because your configuration was unexpected. ie. without Inventory.
|
Top
|
|
|
|
#38212 - 08/15/13 09:55 AM
Re: Changing Purchase Order number format
[Re: Bob Wisener]
|
Adagio Virtuoso
Registered: 06/02/04
Posts: 694
Loc: Prince George BC
|
Bob: In cases where no inventory control is required, PO can use just Sundry items. In my case, for example, I export my item descriptions and codes from Invoices and, after editing the price column, import them as Sundry items for PO.
_________________________
Ralph Allan Business Computer Centre Prince George BC Canada
|
Top
|
|
|
|
#38215 - 08/15/13 10:39 AM
Re: Changing Purchase Order number format
[Re: Ralph Allan]
|
Adagio Conductor
Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
|
While I have everyone's attention, the next release will include an A/R Territory Changer. That should complete the Toolkit code changers.
|
Top
|
|
|
|
#38225 - 08/16/13 06:00 AM
Re: Changing Purchase Order number format
[Re: Bob Wisener]
|
Waterloo Guy
Registered: 04/04/06
Posts: 1736
Loc: Waterloo, Ontario, Canada
|
We understood that the item codes were saved in Adagio tables, PO, IC, or OE as unformatted items.
If you change the item format, the format template just gets applied to the item codes already posted. If you need to change the items to a new formatted item and change the codes at the same time, then we understand that the next release will handle that function without having IC connected to PO.
If you are trying to change from 3-3-3 to 1-1-1 you will be dropping the last 6 digits of an unformatted number unless you have blanks or zeros in the last 6 digits. If this is not your direction, then you will need to wait for the next release of Toolkit, to correct the format and numbers of the items on posted orders, receipts, and invoices.
Best, Brian
|
Top
|
|
|
|
|
0 registered (),
82
Guests and
0
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14459 Topics
70635 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
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
|
|
|
|
|
|