Hello All,
Do you know the options to import Sales Invoices and/or Sales Returns to History without touching Inventory as we are migrating from another ERP system to GP?
Thank you,
= CJ =
*This post is locked for comments
As Mahmoud states, most sites when migrating will do open transactions only and at a balance level.
In order to get the best information possible from the network, can you clarify what you are trying to achieve?
Do you want sales history for customers as well? And is the sales history at a line level - i.e. you want to see which items to sold to a customer when?
You can't import directly to history unless you are using methods that fiddle around directly in the database. I do not think I would be alone in stressing that this should NOT be done. The reason for importing into work and posting is so that the system uses all the inbuilt business rules to validate all the data.
Importing history can greatly increase the amount of time it takes to get the data right. You have all the apply records to worry about as well. Most people take the option of open remaining balances and then either retain their old system for enquiry or move the relevant data out to Excel or another small database for historical lookup information.
Cheers
Heather
When migrating from another ERP, usually customer opening balances are recorded roughly to the system through Receivable Management, which affects the customer balance without affecting Inventory Module.
In your case, you might be looking to migrate your historical transactions into the new system, you can still follow the same method to import customer balances (Invoices and Returns) from Receivable Management.
Please feel free to share any further inquiries,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (