Skip to content
+1-888-319-3663

COMMUNITY FORUM

Inventory Trx Map

callen@bkd.com asked 8 years ago
I have created a mapping to import inventory adjustments.  The one problem I'm having is I get a separate transaction for every item instead of one transaction with many items. 

The source file has these columns:
Batch
Date
Item No
Location
Qty

I've tried various grouping options. 

I'm using a rolling column to get the next document number, which might be the problem.

What would be causing multiple transactions to be created?
Answers
Best Answer
lorren answered 8 years ago
Callen,

What are your Key Fields for the data source?  I would assume that if you want one transaction with multiple lines you would need to use Batch or Date as your key field.

The trick is to think about how you would enter the data manually into GP to get those multiple lines.  Is that Batch?  Is it Date? or both?

Once you have the key fields set on your data source then use the same grouping for the Transaction Header.  You would not have any grouping for the Add Line Items node.

Here are some links to blog articles discussing grouping SmartConnect.

http://eonesolutions.blogspot.com/2013/04/tech-tuesday-smartconnect-key-fields.html
http://eonesolutions.blogspot.com/2013/07/tech-tues-setting-key-fields-and.html


Lorren

If you would like to submit an answer or comment, please sign in to the eOne portal.