The last time I did a GP to BC migration it did not bring over any history. Is that still true? What does get brought over?
The last time I did a GP to BC migration it did not bring over any history. Is that still true? What does get brought over?
Thanks Andrea. It has been 6 months since I last toyed with BC. I will go see if my old tenant is still active and try to upgrade TWO one more time.
Hi Richard,
I think what they mean by ‘historical data I kept in extensions’ is that the GP historical data is stored in GP specific tables within the Business Central product. You can view/access this historical data within Business Central and no, you don’t have to use a different application. These historical tables are populated automatically as part of the migration process. If that doesn’t occur for some reason, then that tells me there was a problem with the migration.
Here’s an example of how you can see historical GP data in Business Central for Receivables Management:
In BC, click on Customers >> All >> Dynamics GP Historical Receivables Transactions:
Here’s what the historical RM information looks like when I do that:
Another way to look at this historical GP data while logged into Business Central is to do the following:
https://businesscentral.dynamics.com/?table=xxxxx
https://businesscentral.dynamics.com/?table=4057
In reference to Payroll: No, there are not currently plans to add Payroll data to the GP to BC Migration tool. There is not a Payroll module within the core in Business Central product. With that said, there are Payroll 3rd party apps available that can be used with Business Central.
Here’s a link to the App Store that lists all the different apps available for Business Central (if you search on US Payroll here you’ll see all the various apps available):
Business Apps – Microsoft AppSource
Hope this helps!
Andrea, what do they mean that historical data is kept in extensions? Is historical data accessible right from within BC just like GP or there some other application that needs to be used? Once you start using BC historical data is kept. Is there anyway to populate these historical tables with the data from GP. I also do not see any payroll tables. Are there any plans for payroll in BC?
Hi Richard,
Yes, the GP to BC migration should bring over historical GP data from Receivables, Payables, Sales Order Processing, Purchase Order Processing, and Inventory.
The following documentation talks about what gets brought over to BC from GP during the migration process. Specifically #5 talks about the historical information.
Migrate from Dynamics GP to Business Central online - Business Central | Microsoft Docs
With that said, it does not bring that historical data into BC in such a way that you can 'report' on that data as you would for historical Business Central Information. Rather, this historical data is stored in specific GP historical tables in Business Central.
These are the Business Central tables that store GP specific data:
4090 | GP Account |
40100 | GP Bank MSTR |
40099 | GP Checkbook MSTR |
40101 | GP Checkbook Transactions |
4025 | GP Codes |
4044 | GP Company Migration Settings |
4024 | GP Configuration |
4093 | GP Customer |
4048 | GP Customer Address |
4094 | GP Customer Transactions |
4092 | GP Fiscal Periods |
4091 | GP GLTransactions |
4095 | GP Item |
4016 | GP Item Location |
4104 | GP Item Transactions |
4015 | GP Migration Errors |
4026 | GP Payment Terms |
40102 | GP POPPOHeader |
40103 | GP POPPOLine |
4027 | GP Posting Accounts |
4040 | GP Segment Name |
4028 | GP Segments |
4096 | GP Vendor |
4049 | GP Vendor Address |
4097 | GP Vendor Transactions |
4031 | GPForecastTemp |
4035 | GPIVBinQtyTransferHist |
4036 | GPIVDistributionHist |
4081 | GPIVLotAttributeHist |
4038 | GPIVSerialLotNumberHist |
4039 | GPIVTrxAmountsHist |
4050 | GPIVTrxBinQtyHist |
4051 | GPIVTrxDetailHist |
4052 | GPIVTrxHist |
4053 | GPPMHist |
4054 | GPPOPBinQtyHist |
4055 | GPPOPDistributionHist |
4056 | GPPOPLandedCostHist |
4057 | GPPOPPOHist |
4058 | GPPOPPOLineHist |
4059 | GPPOPPOTaxHist |
4060 | GPPOPReceiptApply |
4061 | GPPOPReceiptHist |
4062 | GPPOPReceiptLineHist |
4063 | GPPOPSerialLotHist |
4064 | GPPOPTaxHist |
4065 | GPRMHist |
4066 | GPRMOpen |
4067 | GPSOPBinQuantityWorkHist |
4068 | GPSOPCommissionsWorkHist |
4069 | GPSOPDepositHist |
4070 | GPSOPDistributionWorkHist |
4071 | GPSOPLineCommentWorkHist |
4072 | GPSOPPaymentWorkHist |
4073 | GPSOPProcessHoldWorkHist |
4074 | GPSOPSerialLotWorkHist |
4075 | GPSOPTaxesWorkHist |
4076 | GPSOPTrackingNumbersWorkHist |
4077 | GPSOPTrxAmountsHist |
4078 | GPSOPTrxHist |
4079 | GPSOPUserDefinedWorkHist |
4080 | GPSOPWorkflowWorkHist |
As a side note, here's a link to the GP to BC landing page where you'll find all sorts of good resources around the GP to BC migration process:
Landing Page for GP to BC Migration Information - Dynamics 365 Business Central Community
I hope this helps!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,554 Super User 2024 Season 2
Martin Dráb 228,588 Most Valuable Professional
nmaenpaa 101,148