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

I have the same question (0)

All responses (7)

Answers (0)

Sort by

MattPaulen 6,912 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kdraper on at

Like
a
(0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like
a
(0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No