Hello,

We have an interm account for our COGS account that has a balance in it and just printed this report in session tfacr1432m000 and have a balance on the report that is different then on the G/L History.

When working with some of the orders dating back to 2000 I see that if a purchased item is being sold and the standard cost changes from the time of issue to the time of invoice a variance is left in the account. I beleive the same thing is occuring for a manufactured item but I am still checking on this.
Cost Items do not seem to be a problem since we maped them to expense accounts.

I wanted to know how others are using this session or it you have any workarounds to this problem.

Thank you in advance for your help.

Doug

Doug -
I'm not a big finance person, but I think you are talking about the GRINYA (Goods Recieved, invoice not yet available or some such), where there is specific accounting solutions and new sessions in Baan to handle them. Try a search on these boards and an Baan support site for GRINYA, and you should find some docs.

Thank you for the input. I am very familiar with GRINYA in AP but the GTBI (Goods to Be Invoiced) is in AR. Same Idea but they don't have the Financial report, Logistical report or checklist as well as all of the finalization/archive sessions.

Doug

Ok I see, I'll have to add that to my list of finance acronyms!

Hi,
I know of a problem concerning not clearing the COGS account.
The function that creates the clearing transactions is
tdsls4223 - Process Delivered Sales Orders.

It computes the COGS value by getting the cost price of the item from the cost price master data (ticpr300) that is relevant to the delivery date.
This is usually OK, but if you happen to compute a new cost price for the item, later, but still on the same day of delivery, it does not fetch the same cost price which was used at the delivery moment, but the new one.

By the way, I do not see why the cost price is not taken from the delivery table itself (tdsls045).

Moshe

Moshe,

That is what I am finding is hapening. For example inventory issued at a cost of 1.00 on the 10th, roll up done and invoiced on the 11th. but now the cost is 1.25, this is leaving a variance in the interim account.

I guess I will need to do journal entrys until we get it fixed. A correction program would be great for this problem.

Doug

Hi!

the variance being discussed here is standard functionality and correct as per accounts..

while making deliver

ITR Debit
Inventory Credit

While matching...

Customer Debit
ITR Credit...

Now in case invoicing is at higher value an extra entry would come in

Customer Ac Debit
Variance Credit.

The entry would also come in finance integration transactions as

Variance Debit
Inventory credit..

Now problem occurs when the varaince account in integration and ACR are different... so entry may be required to be passes between the two variance accounts ....

But .. the net Inventory / ITR / Customer A/c effect are correct....

Hope this Helps.

Regards,

Himanshu

I just got an update on my case from Baan. They have a situation with Maintain Deliveries (tdsls4120m000) that say's:

If the cost price for an item is changed after the order has been released, but before the delivery has been maintained, the new cost price is picked up and sent to finance through the integration.

They also have a correction program for this, but it's still in testing.

Doug

well but thats the correct functionality ... in case f ftp item the inventory should be hit with latest cost price.....

Hi Himanshu,
There is a problem in Baan functionality as I explained in my previous answer and I understand from Doug that it is being fixed now by BaaN.

The Invoices To be Sent account should be cleared with the cost price (FTP) that was last on the delivery moment and not with the last of that day, which was computed after the delivery.

Moshe