Import bulk invoices into multiple GP companies at once

(0) Share

Report

Posted on by Community Member

Hello. We had someone recently go into the hospital who was the only one who knows the process on how to do this and we cannot figure it out. We would like to know how to create invoices for the same amount over multiple companies in bulk. For instance:

We have 300 companies/SQL databases for different properties we manage

We have an excel file similar to the below that outlines the invoice doc number, amount, companyID and description. Below shows only 3 but the excel file is roughly 200 rows long with different doc numbers and company ids.

IncDocNumb InvAmt InvCompanyId Descr

883748 196.65 A51 Monthly

883749 196.65 B89 Monthly

883750 196.65 C23 Monthly

We need to import all of the excel file into each individual company at once rather than having to key each invoice in manually. We cannot use integration manager since you can only integrate in the company you are logged into. Is there a way to manually do this in SQL?

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

Could you check if you have any customization? or any 3rd party dictionary installed? because it could be done by that by any 3rd party window interface (definitely SQL procedures running at the backend).
Suggested answer

Community Member on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

Hi LEDIC,

Agreed with Sanjay kumar.

If you have planning to use integration tool, you can refer the following my post.

http://bit.ly/1pyvrlK

-Brian
kdraper on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

If you do not have access to a developer skilled with eConnect you would need SmartConnect from eOne or something equivalent. It is designed for this.

http://www.eonesolutions.com/smartconnect/overview/
Community Member on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

I'm not sure I follow. How would I use this to import from an excel sheet?
Suggested answer

Community Member on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

e Connect call can be made through direct SQL Calls.

For example below call to create RM distribution.....

DECLARE @return_value int,
@O_iErrorState int,
@oErrString varchar(255)

EXEC @return_value = [dbo].[taRMDistribution]
@I_vRMDTYPAL = 1,
@I_vDOCNUMBR = N'SALES000000000037',
@I_vCUSTNMBR = N'100001',
@I_vSEQNUMBR = 1005,
@I_vDISTTYPE = 9,
@I_vDSTINDX = 125,
@I_vDEBITAMT = 0,
@I_vCRDTAMNT = 1000,
@O_iErrorState = @O_iErrorState OUTPUT,
@oErrString = @oErrString OUTPUT

SELECT @O_iErrorState as N'@O_iErrorState',
@oErrString as N'@oErrString'

SELECT 'Return Value' = @return_value

EXEC @return_value = [dbo].[taRMDistribution]
@I_vRMDTYPAL = 1,
@I_vDOCNUMBR = N'SALES000000000037',
@I_vCUSTNMBR = N'100001',
@I_vSEQNUMBR = 1006,
@I_vDISTTYPE = 3,
@I_vDSTINDX = 125,
@I_vDEBITAMT = 1010,
@I_vCRDTAMNT = 0,
@O_iErrorState = @O_iErrorState OUTPUT,
@oErrString = @oErrString OUTPUT

SELECT @O_iErrorState as N'@O_iErrorState',
@oErrString as N'@oErrString'

SELECT 'Return Value' = @return_value

EXEC @return_value = [dbo].[taRMDistribution]
@I_vRMDTYPAL = 1,
@I_vDOCNUMBR = N'SALES000000000037',
@I_vCUSTNMBR = N'100001',
@I_vSEQNUMBR = 1007,
@I_vDISTTYPE = 13,
@I_vDSTINDX = 125,
@I_vDEBITAMT = 0,
@I_vCRDTAMNT = 10,
@O_iErrorState = @O_iErrorState OUTPUT,
@oErrString = @oErrString OUTPUT

SELECT @O_iErrorState as N'@O_iErrorState',
@oErrString as N'@oErrString'

SELECT 'Return Value' = @return_value
GO

Cheers!

Sanjay
Community Member on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

Not that I know of. I don't know of any other way it can be done other than straight through SQL, but it was being done somehow.
MattPaulen 6,912 on at

Like (0)

Report

RE: Import bulk invoices into multiple GP companies at once

Do you own something like Smartconnect? That can do multiple databases simultaneously. I'd be surprised if that was done straight through SQL since that would bypass the business logic.