Can someone please offer some advice?

I was originaly taught that when setting up integrations, purchase receipts should be set up for all types of items, inventoried or not.

Also, it was explained to me that only inventoried items should have a purchase results, thus posting to a purchase price variance account.

Today, my integrations are not posting.

Problem 1) An item was posted (none inventory) in purchase receipts, but it did not post to purchase results. Do I need to add a non inventory item to purchase results. If so please help me understand why?

Problem 2) An item is not posting to purchase receipts (error is cannot define account), BUT the itegration has been set up.

I checked the "Maintain Inventory & WIP Transaction Accounts" and that item group is there for Purchase Receipts by all the correct cost price components.

If anyone can help, or offer advice please reply or email me.

larkin_jack2@hotmail.com

Thank you,

Jack,
I had a similar error working with integrations. It turned out that I had to use session tfgld109m000 Maintain Dimension ranges by ledger acount. The range was not set correctly for the account I wanted my transactont to post to.
hope this helps!
Regards,
BB

Baanboozeled, I just tried your suggestion but to no avail.

If you or someone else out there has any ideas, please respond.

Thankyou!

The dimension ranges per ledger account are normally created when you create a new ledger account. Did you copy it using the table maintenance session - that might explain why the dimension range is not there.

The results are posted when you process delivered purchase orders; thus not at the moment of receipt. Did you process?

Next you talk about the integration (WOH) setup for Purchase/Receipt. Did you also set up Purchase/Result?

I checked the dimension ranges, and all is OK.

Purchase orders have been processed.

All items that are material items, or purchased items have Purchase / Result integrations setup.

The problem is that the items that are coming through when received are cost items. If these are cost items, why does a purchase result need to be setup?

I was thinking, maybe in purchasing when the item was setup that it was copied from a material, or purchased item, and then changed to a cost item. This could possibly affect some tables??

If this is the case, how do I correct it. Do I push through the integrations, even though they are incorrect?????


:confused:

Hi All,

I think it goes like this;

On a pur.order several items are entered including a line for a cost item ad price EUR 100

This order goes via integrations to finance and a pur.invoice is received and maintained in finance

On the invoice the line of the cost item is stated as EUR 120 and after negotiation this is the price agreed upon by the purchase person.

So on matching order vs. invoice a partial match is made for the quantity (order = invoice), but price = EUR 120

No additional posting in finance is required, but for instance last pur.price in the item file is updated to EUR 120 for that item.

This difference of EUR 20 is posted from distribution to finance (via the integrations) to finance as a purchase result.

So there u go. Therefore this result posting option should be set up.

i hope this helps.

Regards,
Michel:D

Then on the integration side, is it correct to say that for purchase receipts & purchase/results;

Purchase / Receipts

Inventory Items : Debit - Inventory Account
Credit - Accounts Payable Accrual

Cost Items : Debit - Expense Account
Credit - Accounts Payable Accrual

Purchase / Results

Inventory Items : Debit - Accounts Payable Accrual
Credit - Purchase Price Variance

Cost Items : Debit - Accounts Payable Accrual
Credit - Expense Account

Thankyou for your help!

The file will be very helpful.

I also have another integration question if that's ok!

I have an integration error which just arose.

The error is a Purchase/Receipt! "cannot define ledger account"

Steps Followed:

1) I look at the item first and check to see if an integration by that item group was created, and it has.

2) I than checked to see if the cost price components matched, and they did

What should I do next?

Originally posted by mdruijter
Sounds ok to me. If there is no need to split results on regular items and cost items, u could also create an integration rule in the integrations scheme on the highest level (so not on item- or item group level). In that case all non specified integrations transactions of any purchase result will be posted on those legder acc. specified on general level.

Maybe this xl sheet is helpfull.

good luck.:D

Hello mdruijter,

but be careful with a general integration scheme.
OK, you don't have any error in the integration log. But perhaps a lot of mistaken accounts.
In the error log you notice when something is wrong, but to control each time the accounts produces much more work.

Bye, Juli

Off course! U R absolutely right regarding that matter. I could not agree more on that. One should be very aware of that.

Regards,
Michel

Hi -

Is it possible that somebody has changed item information between the time that the item was received and the time that you reviewed the item when fixing your integration error? I have had that happen to me.

My purchase receipt integrations for non-cost items look at a combination of warehouse and item group in order to drive them to the correct ledger account. I have come across situations where a user will create an item with an invalid warehouse/item group combination and put the item on a PO. When the item is received, the integration that is created will be erroneous. However, the item data gets corrected before I look to see its setup. It looks as though it should post, but is erroneous.

In the tdpur041 table, you can see the item group that was on the item at the time that the PO line was created.

You can then build a "temporary" integration, post the transaction, then delete your temporary integration setup.

Also, I agree with Juli that creating one general integration for your purchase result transactions can be dangerous. If I've learned anything about integrations, it's that the more specific you are in their setup, the less journal entries you'll need to make later to move costs to correct accounts.


Hope this helps - if you'd like to discuss this in greater detail, please contact me

Regards,

Linda Nulph
Manager, Finance Systems