Skip to content
+1-888-319-3663

COMMUNITY FORUM

AP Import Question

Shawn asked 7 years ago
I am attempting to import AP Invoices into Dynamics GP from a single text file.  The file includes header and distribution information on a single line.  I want to combine the records with the same invoice number into one AP Invoice but have the distributions not be combined.  If I group on Invoice number it wants to roll up my distributions.  I am new to SmartConnect.  With Integration Manager, I would just join the file back to itself for the distribution details.  Not seeing a way to do that with SmartConnect.  
 
Here’s a sample line that I want to combine:



Invoice_Number
PO_Number
Vendor_Name
Vendor_Number
Invoice_Date
Due_Date
Amount
Department
Invoice_Status
GL_Code
Item_Description
Quantity
Unit_Price
Extended_Amount


56789
5
1099 Pro Inc
TENNINET01
00:00.0
00:00.0
567.91
Professional Services
Approved
0205908-0000-12900-4288
Item
1
567.89
567.89


56789
5
1099 Pro Inc
TENNINET01
00:00.0
00:00.0
567.91
Professional Services
Approved
0205908-0000-12900-4288
Item 2
2
0.01
0.02



 
Answers
Chris answered 7 years ago
Shawn,
You would group the header node by the invoice number as you were saying, but when you map the distribution node you would have to group by some additional fields to keep it from being rolled up. You could include the item number and account number fields in the grouping, or whatever combination that would keep it unique. That way you get the one payable invoice but it leaves the distributions broken out into their individual amounts.
Chris

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