web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Transaction Import - M...
Microsoft Dynamics SL (Archived)

Transaction Import - Multi Company/Multi Database

(0) ShareShare
ReportReport
Posted on by Kim Huggins 635

I am looking to use the transaction import to import both AP vouchers and GL transactions.  Our system includes multiple companies and multiple databases.  How would we handle writing the transactions to different db's and different companies?  Would we have to create separate import files, one for each db?  Or is there a way to modify the control file to tell SL which database needs to be hit?

 

Thanks in advance,

Kim

 

 

*This post is locked for comments

I have the same question (0)
  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

    You will need to break it up into separate processes per company since you are multidatabase.

  • Community Member Profile Picture
    Community Member on at

    Transactions can be imported in a multi-company DB if you intend the company used for the import to record an inter-company receivable.

    Nexvue has a program that can split entries from a CSV or Excel sheet into separate GL batches per company in a multi-company DB without creating inter-company receivables.

    Solomon's TI won't process separate batches for each company or each DB.  If this is a recurring event, a batch could probably be written to call Solomon's TI program once per DB/Company and pass the control file and data file names as variables in the batch - something that would take a bit of time to get working.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans