Hello,
I need to import daily data form my POS report into GP. I can get it into Excel and map it to the correct account codes, but how do I handle the bank transactions? I can see how to get these into the GL using integration manager, but I don't get how I can tell integration manager which codes need to post as bank transactions. Any assistance would be appreciated.
Regards, Dave
*This post is locked for comments
I tried using 2 different detail source files (DB & CR) with the same header, I still get the same distribution error. Oddly, when I use the type, "decrease adjustment' for integrations, the integration works perfectly but, when I use the type 'Increase Adj' with DB and 'Decrease Adj with CR, I get the error message. Any assistance would be appreciated.
Hi Dave,
The Integration Manager can import Bank Transactions. Why not create a separate integration for Bank Transactions by filtering the codes. You could use the same Excel Spreadsheet as the source for both transaction types.
Kind regards,
Leslie
Dave,
We have done a similar QB POS -sales & bank transaction daily data import into GP for our client using a custom application development without using IM. If you are interested in learning custom solution approach please let me know.
Regards,
Sam
samr (at) expsoltech.com
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 (
