Sage 100

Has anyone been able to merge customers that have ship to addresses???
I dont wish to mix the ship to codes??? Any way to renumber the ship to codes before the merge????


PS... I am on a roll today!!!!!

------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------

You could always export the ship to codes and then use a VI import job with Delete functionality embedded in it to delete the old ship to records. Then renumber them in your source and import them again with how the Delete functionality.
Refer to this post https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/125437/im_pricecode_bus-doesnt-have-a-delete-function and this post https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=ffa58120-01a0-4f09-a2d5-48470b2c384a for examples of using VI Import to delete records.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Interesting idea @David Speck II​​.  But not having a high level understanding of advanced Vi functions, I would just query everything in the table table to Excel, make the changes there, reinitialize the shipto table and reimport.  More kludgy but for a one off, but effective.  I will check out your links and perhaps this ol dog might learn a new trick this weekend.  Getting hard to run with the young dogs these days!!!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 11-22-2019 15:53
From: David Speck II
Subject: Ship To renumber

You could always export the ship to codes and then use a VI import job with Delete functionality embedded in it to delete the old ship to records. Then renumber them in your source and import them again with how the Delete functionality.
Refer to this post https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/125437/im_pricecode_bus-doesnt-have-a-delete-function and this post https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=ffa58120-01a0-4f09-a2d5-48470b2c384a for examples of using VI Import to delete records.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Yea, you could initialize and re-import all the ship to records but if you are just trying to renumber a small percentage of the total number of records but still a large enough number to not want to do it manually, you can export the data using any method you want, Excel and ODBC query, Crystal Reports, Vi Export, etc. The export step is just to get the records that need to be renumbered so the primary key can be renumbered in Excel.
The posts i referenced detail how to use VI Import to bulk delete records where all you need is the primary key in the source file.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 11-22-2019 19:03
From: Jeff Schwenk
Subject: Ship To renumber

Interesting idea @David Speck II​​.  But not having a high level understanding of advanced Vi functions, I would just query everything in the table table to Excel, make the changes there, reinitialize the shipto table and reimport.  More kludgy but for a one off, but effective.  I will check out your links and perhaps this ol dog might learn a new trick this weekend.  Getting hard to run with the young dogs these days!!!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 11-22-2019 15:53
From: David Speck II
Subject: Ship To renumber

You could always export the ship to codes and then use a VI import job with Delete functionality embedded in it to delete the old ship to records. Then renumber them in your source and import them again with how the Delete functionality.
Refer to this post https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/125437/im_pricecode_bus-doesnt-have-a-delete-function and this post https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=ffa58120-01a0-4f09-a2d5-48470b2c384a for examples of using VI Import to delete records.

------------------------------
David Speck II
Tennessee Software Solutions

What I am worried about is all the historical files. If at some point tgey run recalculate item history. The ship to history will be all messed up...


---------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
---------------------------------



Original Message:
Sent: 11-22-2019
From: David Speck II
Subject: RE: Ship To renumber

Yea, you could initialize and re-import all the ship to records but if you are just trying to renumber a small percentage of the total number of records but still a large enough number to not want to do it manually, you can export the data using any method you want, Excel and ODBC query, Crystal Reports, Vi Export, etc. The export step is just to get the records that need to be renumbered so the primary key can be renumbered in Excel.
The posts i referenced detail how to use VI Import to bulk delete records where all you need is the primary key in the source file.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 11-22-2019 19:03
From: Jeff Schwenk
Subject: Ship To renumber

Interesting idea @David Speck II​​.  But not having a high level understanding of advanced Vi functions, I would just query everything in the table table to Excel, make the changes there, reinitialize the shipto table and reimport.  More kludgy but for a one off, but effective.  I will check out your links and perhaps this ol dog might learn a new trick this weekend.  Getting hard to run with the young dogs these days!!!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Valid point, you would have to deal with the ShipToCode in the following tables.

• SO_ShipToAddress
• SO_SalesOrderHistoryHeader
• SO_SalesOrderHeader
• SO_InvoiceHeader
• CI_ItemTransactionHistory
• IM_ItemTransactionHistory
• IM_LotSerialTransactionHistory
• IM_ItemCustomerHistoryByPeriod
• AR_InvoiceHistoryHeader

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 11-23-2019 19:47
From: Lourdes Sobrino
Subject: Ship To renumber

What I am worried about is all the historical files. If at some point tgey run recalculate item history. The ship to history will be all messed up...


---------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
---------------------------------




Original Message:
Sent: 11-22-2019
From: David Speck II
Subject: RE: Ship To renumber

Yea, you could initialize and re-import all the ship to records but if you are just trying to renumber a small percentage of the total number of records but still a large enough number to not want to do it manually, you can export the data using any method you want, Excel and ODBC query, Crystal Reports, Vi Export, etc. The export step is just to get the records that need to be renumbered so the primary key can be renumbered in Excel.
The posts i referenced detail how to use VI Import to bulk delete records where all you need is the primary key in the source file.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 11-22-2019 19:03
From: Jeff Schwenk
Subject: Ship To renumber

Interesting idea @David Speck II​​.  But not having a high level understanding of advanced Vi functions, I would just query everything in the table table to Excel, make the changes there, reinitialize the shipto table and reimport.  More kludgy but for a one off, but effective.  I will check out your links and perhaps this ol dog might learn a new trick this weekend.  Getting hard to run with the young dogs these days!!!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 11-22-2019 15:53
From: David Speck II
Subject: Ship To renumber

You could always export the ship to codes and then use a VI import job with Delete functionality embedded in it to delete the old ship to records. Then renumber them in your source and import them again with how the Delete functionality.
Refer to this post https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/125437/im_pricecode_bus-doesnt-have-a-delete-function and this post https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=ffa58120-01a0-4f09-a2d5-48470b2c384a for examples of using VI Import to delete records.

------------------------------
David Speck II
Tennessee Software Solutions