We have POS transactions with "Matched" Invoice status. When we try to approve them we get a "tfacps0107" error message "Ledger account in integration table not found".

What do we need to do to fix this?

U have specified some accounts in tdinv8150m000/ tipcs8150m000 for purchase/receipt-material costs -results , which does not exist in tfgld0108m000. U can check the ledger account in tfgld4510m000 also for the related purchase order / project .

We matched line 21 completely. Then approved. We put in acct# 205-0900 (Registered Invoices). We get error message “Ledger account in integration table not found”.

For your reference:
PO Line item 21 shows Cost Price Component = CSO, Warehouse = NPW. We added this warehouse and cost component for Transaction Origin=”Purchase”, Financial Transaction = “Receipt” in tdinv8150m000. This account is already in tfgld0108m000.

What are we doing wrong?

Screenprints have been attached to this post to show what we did.

Picture 1 – Matched completely line 21

Picture 2 – Approved

Picture 3 – Entered in ledger account. Is this the right account to use?

Picture 4 – Got error message “Ledger account in integration table not found”

Picture 5 – This is what PO line #21 looks like

Picture 6 – We added the account here to see if we wouldn’t get the error message “Ledger account not found in intergration table” but we still get it.

We added this warehouse and cost component for Transaction Origin=”Purchase”, Financial Transaction = “Receipt” in tdinv8150m000. This account is already in tfgld0108m000.

Hello,

I think you have to add the Transaction Origin="Purchase" with the Financial Transaction ="Result" in tdinv8150m000 for that warehouse and Cost Price Component. Then it should be possible to approve the invoice.

As pegasus suggested do u have purchase / result mapping in tdinv8150m000 . For ftp valued items . invoice approval generates purchase/result only.

We have added Warehouse NPW, Cost Comp. CSO for Purchase/Result in tdinv8150m000 (see attached screenprint), but we still get the error message. Do we also have to add something in "Maintain Project Transaction Accounts Table"?

If the purchase order is related to a project then you have to add it there as well. Otherwise I don't think so.

By adding Cost type= Materials, Trans Origin=Project, Financial Trans=Hard Pegged Invoiced (PO), Warehouse=NPW to the Maintain Project Transaction Accounts Table fixed the problem.

We just need to have a better understanding of transaction types and where they are used. Do you know where we can get that information?

Thank you very much for all of your help.