How to integrate AP invoice with purchase account from source and remaining as default

(0) Share

Report

Posted on by mebenz

3,815

We have the same Trade Discount and AP account on all of our vendors. We would like to integrate AP invoices with the user choosing which expense account. Is it not possible to have the expense be driven by the source and the others to be default?

*This post is locked for comments

All responses (28)

Answers (1)

L Vail 65,271 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

I'm so glad! Thank you for letting me know. Please be sure to mark this question as 'answered'.

Kind regards,

Leslie
luvsql 60 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

Oh geez sorry that was a silly mistake I should have checked. It WORKED! You are my hero.
L Vail 65,271 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

Hi,

The Purchases field is a numeric. This is the field where your dollar amount goes. The Purchases field comes from the header.

The account number (which is in the Distribution) goes to Distribution Account from the Distribution source.

Kind regards,

Leslie

PS, I did add the group by fields manually because I need fields from the header to map to the Payables Transaction node.
mebenz 3,815 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

I have one source text file and created 2 sources in IM (Header and Detail). This is how I've always integrated transactions. The header has the invoice number as key, which then hides all the other fields. The detail shows all the fields and is sorted by the same as the header.

When I create the header file and sort by the InvNumber, there is nothing grouped. Did you manually add each field into the Group by? Is that required?

I've redone the header to have all the extra groupings and now my header and detail have the same fields.

I ran the integration and now it fails. Not sure why it's trying to convert my account number to a numeric field?

DOC 1 ERROR: Cannot convert field 'PurchAccount' Value '4340-200-120-000' to numeric value. Destination Field ID: Purchases.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

Hi,

My source also only has one line for the particular transaction I am importing. My raw data source looks like this:

My Header Query looks like this:

My Distribution Query looks like this:

They both come from the same source file.

The header mapping looks like this:

The distribution mapping looks like this:

You only need the distribution type for purchases, because the rest will default in.

Here's what the imported transaction looks like (I added Trade Discount and Freight to the source file):

The imported distributions look like this:

I think this is exactly what you wanted. You only import the PURCH amount and the rest will default from the header.

Kind regards,

Leslie
mebenz 3,815 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default
mebenz 3,815 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

I don't have a debit and credit column as I'm using the subtotal that I used in the payables transactions. I also don't have a separate distribution source. Your settings appear to require 3 rows for each transaction (if have tax). I only have a source with 1 row per transaction as I only have 1 distribution account I'm integrating.
L Vail 65,271 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

Here's the base screen:

Now I'll go down each field:

Are these settings different from yours?

Leslie
mebenz 3,815 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

I'm not able to insert an attachment or screenshot. On the Payables Transactions, I have the Purchases and Trade Discount linked to my detail source InvAmount and TDAmount fields. On the Distributions, I have the Distribution Account linked the purchaccount column, type is default, Debit Amount is linked to the same field as is on the Payables Transactions (InvAmount), credit it default.
L Vail 65,271 on at

Like (0)

Report

RE: How to integrate AP invoice with purchase account from source and remaining as default

I got mine to work, so we're missing something else. Do you have the record source set on the options window? I'll try and take a screenshot of my settings.