Saving a Transaction in a Batch Through Importing

(0) Share

Report

Posted on by Community Member

Hi:

I'm having to use a direct import of data into SQL from an Excel source file. This includes an import into (a) the unposted transaction table and (b) the SY00500 table to create the Batch ID.

The one transaction imports just fine, as I review it in GP.

But, when I look at the Batch ID that the transaction is supposed to be in, the window shows 0 transactions and $0.00.

Sure, I could create the batch before the import and the batch would be properly updated to "reflect" the transaction. But, I'd prefer not making the end user create the Batch ID beforehand.

I need to "put something" into this import to get the transaction properly saved into the Batch ID.

Is there T-SQL scripting that can be used to automatically save a transaction into a batch that is already in GP?

Thanks!

John

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: Saving a Transaction in a Batch Through Importing

Hi Dave!

eConnect doesn't have a node for the type of unposted transaction that I'm importing.

John
Suggested answer

David Musgrave MVP ... 13,965 Most Valuable Professional on at

Like (0)

Report

RE: Saving a Transaction in a Batch Through Importing

Hi John

Why do you use a tool like eConnect. You can call eConnect scripts from SQL if you want and they do all the business logic checks and will update the batch totals.

Regards

David