Go Back > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 58

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 27th November 2007, 08:28
Protea Protea is offline
Junior Member
Join Date: Sep 2007
Posts: 3
Protea is on a distinguished road
Baan: ERP LN 6.1 FP3 - DB: Oracle - OS: Windows NT
Integration transactions for project purchase orders
Baan: ERP LN 6.1

is there anybody who understands the integration transactions for a project purchase order from the moment of matching the purchase invoice in ERP Ln?

In BaaN IV there were 4 integration document types for project purchase order
1.Commitment Entry = Soft Commitment
2.Commitment Entry (Order) = GRN
3. Commitment Reverse Entry = Reversal after AP matching
4. Invoice (Purchase Order) = Acc Payable Entry (Actual Cost)

The steps in Ln are as follows
1. Project Purchase Order creates Soft Commitment in Material Commitments --> no entry in integration transaction

2. Warehouse Receipt creates the reversal of Soft Commitment and creates hard commitment in Material commitments --> logical integration transactions

3. Purchase Order match and approval

The process seems to stop stops with step 2 in ERP Ln. Where are the integration transactions for step 3? I expect the reversal of the GRINYA account 166090 (Goods received invoice not yet approved)and an entry in the Actual WIP (Work in process) account ?
And which project transactions and integration entries represent the material price difference in the event of unbalanced purchase invoices (purchase order amount varies fro purchase invoice)?

Reply With Quote
Old 28th November 2007, 19:52
ulrich.fuchs's Avatar
ulrich.fuchs ulrich.fuchs is offline
Join Date: Aug 2001
Location: Germany
Posts: 517
ulrich.fuchs is on a distinguished road
Baan: IV, LN6.1 - DB: --- - OS: ---
In short: LN separates the purchase process from the warehouse process. For a receipt you get two integration transactions: Purchase/Receipt (Interim account against GRNYIA) and Warehouse/Receipt (Stock against Interim account). Purchase order approval does not generate any integration transaction concerning GRINYA. In Baan IV it did so only for purchase price variances. There is a different concept now in LN, those differences create "stock difference" (not sure about the english name, ist "Bestandsabweichung" in german) records in the whina module. Those difference have to be processed and create new integration transactions types, but it depends on how the valuation price is determined (against MAUC, FTP...), what transactions occur.

Dipl. Ing. Ulrich Fuchs
- ERP consulting and software development -
Widumestra├če 18 - 44787 Bochum - Germany - (Blog zu Infor LN))

New hotness: Call from Infor LN 4GL into any database using BfIA-JDBC (binds JDBC into LN 4GL)
Reply With Quote
Old 29th November 2007, 02:24
Protea Protea is offline
Junior Member
Join Date: Sep 2007
Posts: 3
Protea is on a distinguished road
Baan: ERP LN 6.1 FP3 - DB: Oracle - OS: Windows NT
Integration Transactions - FTP versus MAUC

Hi Ulrich,
thanks for your reply and some clarification about the different concepts of Ln and BaaN IV.
I will continue to test and see if I get anywhere with the new information.

I found quite interesting to read that the warehouse valuation method triggers different integration transactions.
Currently the standard items in our system are maintained as Fixed Transfer prices. However in light of implementing project warehousing and achieving the correct financial results, the valauation method for standard items used in project purchase orders might change to MAUC. And that in turn results as I have just learned in differnt integration transaction......

Would you mind giving me a second lesson in English or German. Both languagea are fine for me.
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Consignment payment purchase orders (Baan ERP 5.0b) aardvark Distribution, Transportation & Warehousing 2 31st December 2007 01:30
Purchase Integration Transactions - Approval Sai_krishna Finance, Invoicing and Integration 14 14th July 2003 13:01
Large No. of Integration Transactions despite Compression turned on baaniac Finance, Invoicing and Integration 5 16th January 2002 03:20
Traceability of Purchase Invoices after running Process Delivered Purchase Orders Neal Matthews Finance, Invoicing and Integration 15 27th November 2001 12:12

All times are GMT +2. The time now is 08:41.

©2001-2018 - -