Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th June 2003, 14:07
Sai_krishna Sai_krishna is offline
Member
 
Join Date: Jan 2002
Location: Pune
Posts: 95
Sai_krishna is on a distinguished road
Baan: IV,V,LN - DB: Oracle,SQL - OS: NT,UNIX
Purchase Integration

I would like to know when the following transaction is triggered in integration :

Purchase + Inventory Adjustment

Regards

Sai Krishna
Reply With Quote
Sponsored Links
  #2  
Old 4th June 2003, 15:34
sajitkrishnan's Avatar
sajitkrishnan sajitkrishnan is offline
Member
 
Join Date: Nov 2001
Location: Dubai
Posts: 59
sajitkrishnan is on a distinguished road
Baan: BaaN IV c 4, BaaN Vc,LN 6.1a - DB: Oracle, Sql Server - OS: Windows NT, UNIX
Thumbs up

hi,

There cannot be a combination of Purchase/Inventory Adjustment and if it is triggered then it should be a bug.

The only place where the Inventory is gained or losed is at the Warehouse level and not at the Purchase level.

hope this clears your query..

regards

Sajit
Reply With Quote
  #3  
Old 4th June 2003, 15:53
MariaC's Avatar
MariaC MariaC is offline
Guru
 
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
Actually there is such a transaction. This is a a short explanation I found:

The integration Purchase + Inventory adjustment is triggered when a Lot controlled item with lot price is taken on a purchase order and when an inventory adjustment is done and the invoice is approved for a higher amount.
__________________
Regards
Maria
Reply With Quote
  #4  
Old 6th June 2003, 14:33
lindan's Avatar
lindan lindan is offline
Member
 
Join Date: Mar 2002
Location: Pittsburgh, PA
Posts: 78
lindan is on a distinguished road
Baan: IVc4, SP10 - DB: Oracle 8i - OS: Unix
backdating receipt will trigger

Hi -

We have also experienced this type of integration transaction. It has been triggered when somebody backdates a purchase receipt of a lot controlled item whose standard cost has been recalculated after the item was placed on a purchase order.

For example: Item "A" is ordered on June 1. At the time of the order, the standard cost of the item is $3.00. On June 3, the standard cost is recalculated to $5.00. On June 4, somebody logs a receipt for the item, but puts June 2 as the receipt (transaction) date. At that time, you will get a Purchase/Receipt integration transaction for $3.00, and a Purchase/Inventory Adjustment transaction for $2.00.

We have had similar situations occur with non lot-controlled items; the only difference being that the type of integration transaction generated is Purchase/Revaluation instead of Purchase/Inventory Adjustment.

Hope this helps.

Regards
Linda
Reply With Quote
  #5  
Old 9th June 2003, 19:47
baanmanindia69 baanmanindia69 is offline
Member
 
Join Date: Dec 2002
Posts: 60
baanmanindia69 is on a distinguished road
Baan: BaaN IV -
Purchase + Inventory Adjustment

Hi Sai_krishna/lindan,

What you are telling is purchase + Lot result, not purchase + Inventory adjustment. But yes, purshase + Inventory adjustment happens even when a purchase is back dated, but not in all such cases. Please read on.

Basically an inventory Adjustment entry occurs when inventory is written down or written up by way of inventory adjustment. This entry is the regular inventory adjustment which we see under the combination Warehouse order + Inventory adjustment.

Now coming to the combination Purchase + Inventory adjustment:

1. We match & approve an invoice in Finance for higher or lower price, but the lot has already been inventory adjusted (of course, at the original lot price). The subsequent matching changes the lot price. The original inventory adjustment aught to have been at this lot price, but when inventory adjustment happened, this new lot price did not exist. This scenario gives raise to two entries in integration.

a). Purchase + Receipt (for the price dif. between the purchase order + matched price). This will debit the inventory & credit the receivable invoice (or the reverse).

b). But you may note that the inventory itself is already adjusted in the books, and no more present in stock. So this differential entry as above should also be moved from the inventory. So the system passes one more entry to nullify the inventory and debit/credit the inventory adjustment accrual account (essentially the same as under warehouse order + inventory adjustment)

2. A similar entry will get passed when we change price using the session "change price after maintain receipt", for a lot which is already inventory adjusted.

3. When an Inventory adjustment itself is backdated and matched/price changed later (I have not tested if backdating inventory adjustment itself is possible or not)

If you find the above a bit tricky, please email me, I will send clear illustration. You may simulate this and test it in your test company also.

Best regards.
Reply With Quote
Reply


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
Help on Purchase Integrations. JosephA Distribution, Transportation & Warehousing 8 22nd May 2006 15:29
Error in Purchase Integration manusatsangi Finance, Invoicing and Integration 2 9th June 2004 14:03
purchase result integration jpadilla Finance, Invoicing and Integration 3 1st January 2004 06:47
Purchase data for Sales Tax Purposes baanmanindia69 Finance, Invoicing and Integration 0 19th September 2003 11:14
Purchase, Currency & Integration das_k_tushar Finance, Invoicing and Integration 2 10th August 2003 15:49


All times are GMT +2. The time now is 16:54.


©2001-2018 - Baanboard.com - Baanforums.com