Hi,

When a receipt is approved for the received quantity (rejection = 0) does it trigger any transaction in finance integration.

I was told of a scenario where on maitain approval the original receipt transactions are reversed and a new transaction is passed for the receipt even though the rejection quantity is 0.

Is this standard functionality ???


Regards

Sai Krishna

Hi,
When a purchase invoice is approved after beeing matched with a receipt a transaction is generated, the credit account indicated in tdinv850 for purchase/receipt is debited and the invoice receipt account defined in the ledger accounts by financial supplier group is credited.
Hope this will help.
Pedro

Hi,

Let me make by query more specific:

If I make a purchase receipt for quantity 10 of an item and approve the 10 items, what will be the transactions that will be passed on receipt and on approval.

One entry is passed on receipt:

Stock Dr
To ITBR

On approval will this entry be reversed and a new entry be passed ??

Regards

Sai Krishna

I don't think Baan should be posting anything when you receive the items when inspection is used, the posting should not be created until you approve the goods. That's in Baan IV, not sure about V though.

Hi,

In Baan IV the bookings for receipts and approvals are as follows:

Purchase/ Receipt (Goods are received)

Debit: Stock
Credit: Items received pending Invoice from Supplier (this account is defined in tdinv850)

When the invoice is received:
Debit: Invoices Pending Approval (Invoice Receipt Account in Financial Supplier Group)
Credit: Supplier Control Account

When the invoice is approved:

Debit: Items Pending Invoice from Supplier
Credit: Invoices Pending Approval.

Regards,
Pedro

Hi,

Two things:

Firstly, my query is about approval of receipts (distribution) and not about approval of invoices (finance)

Secondly, BaaN passes an entry on receipt of goods in BaaN iv. The entry is

Goods Dr
To Invoice Accruals

The question whether this entry is reversed and an other entry passed when approvals are maintained and there is no rejectionof items.


Regards

Sai krishna

Yes . Purchase / receipt trx are generated at the time of purchase approval also (tdpur4121m000 / tdilc4123s000).

Portion of help attached .

DEFINITION OF FINANCIAL TRANSACTIONS
This transaction is the registration of the receipts of goods on a
purchase order.

WHERE AND WHEN CREATED
These transactions are created after entering the arrivals of
anonymous materials, in the sessions:
- Maintain Receipts (ILC) (tdilc4113s000)
- Maintain Approvals (tdilc4123s000)
- Maintain Purchase Orders (Direct Delivery) (tdpur4102m000)
- Maintain Purchase Order (Direct Line Entry) (tdpur4105m000)
- Maintain Purchase Order Lines (Fast Input) (tdpur4107m000)
- Maintain Receipts (tdpur4120m000)
- Maintain Approvals (tdpur4121m000)
- Approve Purchase Invoices (tfacp1140s000)

DEFINING LEDGER CHART
- debit : Goods
- credit: To invoices to be received

USE OF TRANSACTIONS IN GROUP OF FINANCIAL COMPANIES
- debit : Warehouse company
- credit: Purchase order company

LINKING KEY ELEMENTS WITH DIMENSIONS
The following key elements are available for this transaction:
- Item Data
- Purchase Order Data
- Supplier Data
- Warehouse Data

Hi

Yes when approving and purchase receipt original receipt entry is reversed and a new receipt entry is passed

Hi,

But I have seen sites wherein this doesnt happen. In other words the original receipt is not reversed if there is no rejection. Is this dependent on any parameter ?

Sai Krishna

Hello -

The session that creates the receipt will vary, depending on whether Location Control is turned on, and/or whether
the goods must be inspected. Here's the breakdown:

No ILC or inspection: session tdpur4120m000 (Maintain Receipts) will cause the Purchase Receipt transaction to occur.

No ILC, but inspection required: session tdpur4121m000 (Maintain Approvals) will cause the Purchase Receipt transaction to occur.

ILC on, no inspection: session tdilc4113s000 (Maintain Receipts) will cause the Purchase Receipt transaction to occur.

ILC on, inspection required: session tdilc4123s000 (Maintain Approvals) will cause the Purchase receipt transaction to occur.

I have seen the original receipt transaction be reversed and re-entered only when the Change Prices/Discounts after "Maintain Receipts" session has been run (tdpur4122m000)

Hope this helps.

Regards,
Linda

Please check fast approval procedure in maintain receipts (tdpur4120m000) . If u carry out this step ,u don't need to go into tdpur4121m000 and hence no integration trx .

Hi,

I had a feedback frm the site where the transactions are duplicated i.e original receipt transactions are reversed and fresh receipt transactions are posted on approval (even though complete quantity received is approved).

The feedback is that this is due to the compression parameter in the integration parameters (tfgld4150m000). I am still trying to find out the effect of this parameters on receipt entries in integration.

Regards

Sai Krishna

Hi,

I'm not sure if I can add to the previous informative answers. So before I do, can you explain what you are trying to resolve, or objective you are wanting to acheive, as this may have a bearing on what answer you need.

P

Hi

The objective is to find out the parameter / setting that triggers reversal of purchase receipt and posting of fresh receipt transactions on approval even though ther is no rejection of material.

This has an impact on the size of tfgld410 and other integration tables since for each purchase receipt line four additional records are added to this table.

Regards

Sai Krishna

Hi,

The trigger point will vary depending on how the parameters are set up for the business type etc. Also wether you have a cost item or purchase item etc.

In our system for example purchase items are put into stock and consumed by warehouse issue.

On receipt
Debit: Stock
Credit: GRNI a/c
On stock issue
Debit: Cost of sales
Credit: Stock

Registering the invoice posts the transactions onto the balance sheet Approving the invoice moves the postings on the balance sheet but also completes the transactions

On registering
Debit: Invoices registered
Credit:Creditor a/c
On approval
Credit: Invoices registered
Debit: GRNI a/c

As you can see in our set-up there are only three integration transactions (although multi posting within that)

Cost items are expensed at receipt and reversal only happens on approving.

Try following a couple of examples from order to approval you should be able to pin point the triggers for the reversals etc.

Hope this helps or at least points you in the right direction.

P