Multi-Entity Management (MEM) Import Process Using Fidesic

Preparation

Fidesic's Dynamics GP Module is designed to be used in combination with enhanced scripts on your company database setup in SQL. For Info on how to initially set up Fidesic for MEM, click here. 

You will also need access to view the Payables Batch Entry window in GP. 

 

Also, if you'd prefer, we have a Video format overview. 

https://www.youtube.com/watch?v=ZRbh5pEBayQ

 

Payables Batch Entry

Open the payables batch entry window. 

You'll need to pick a temporary entity ID on this window. This batch will act as a placeholder for importing transactions in your Fidesic batch into the correct entity batch in GP. 

You'll also need to select a Batch ID and Origin 

After adding this info, select Get Fidesic Vouchers from the Additional menu in GP at the top of the window. 

mceclip0.png

 

Fidesic Login and Import

After selecting Get Fidesic Vouchers in the previous step a login window will pop up. You will log into this using your existing Fidesic email and password (this will be the same login you use to normally access the site). 

mceclip1.png

After logging in you will see all invoices currently in approved status and ready to import into GP. You'll be able to manually select invoices if you need to segment batches for any reason. 

After selecting the invoices you'd like to import, click Import. 

Note: Invoices do not need to be segmented by entity ID. Fidesic will split invoices into the correct entity batch based on the GL coding within Fidesic. 

 

Finding Fidesic Created Batches

After importing, Fidesic will split the invoices into their correct entity ID for probably GL entity coding. 

The initial batch you created to initiate the import becomes a placeholder batch. Any transaction without a proper intercompany setup in MEM will be sent to this initial batch. All successfully processed transactions will be put into individual entity batches. 

mceclip3.png

 

To find your other Fidesic Created batches, hit clear on the payables batch entry window, then lookup the batch ID. Fidesic will affix the Entity coding on the end of the batch name you created. 

Ex. If you name a batch "Fidesic" and it's split into Entity "001", the batch name we create will be called "Fidesic001" 

Imported transactions can be reviewed and posted as if they were manually created within GP. 

If you're having any issues, make sure to check out the Fidesic MEM Troubleshooting documentation or contact Fidesic Support. 

 

 

MEM Import Logic for Picking the Pay GL line. 

 

To Enable Intercompany Pay GL Substitution, first you need to make sure Enable Cash Account Substitution

is enabled on your Multi-Entity Management Setup Acct Subst Tab. 

mceclip0.png

 

 

Account substitution override setup

To pay out of a different entity than the originating transaction, you can set this up using the MEM Account Substitution Override Setup. 

Navigate to MS dynamics GP -> Tools ->Setup ->Multi-Entity Management -> Company ->Account Substitution Override. 

 

Make sure to select Payable as the Module and Pay as the Distribution Type.   

Input your destination as the Entity you'd like to pay out of. 

 

Example, if you'd like to pay every Entity 500 invoices out of 400 instead, you'd modify the destination segment so it reads 400 on the originating 500 line. 

mceclip1.png

If this is configured properly, Fidesic will automatically move invoices into their destination batches on import and pay them out of the correct entity. 

 

Note: you may also need to configure to/from accounts in MEM for this to function properly. If you import a transaction without the proper to/from accounts set up, this will show you an error on the notes field of the invoice. If this is the case, it will stay in the original batch you created for import with the error in notes. 

 

To configure to/from accounts navigate to: MS dynamics GP -> Tools ->Setup ->Multi-Entity Management -> Company ->Basic Intercompany Accounts Setup

 

mceclip2.png