Question

Matching supplier invoice with PO


Userlevel 4
Badge +9

Please help me of error verification:
In the inventory transaction history window, there are this year's items with the transaction code
ARRIVAL and property "company property" valued at 0.
We currently have 3 such items:
Transaction ID 5597794,5597795 and 5662343.
However, each of these items has been decreed and valued on purchase invoices.
For example, transaction 5597794 was assigned to FV 55/01/2022, Supplier JBCELECTRONIC.
The item was measured on the invoice at PLN 81.06,
while the value on the history of warehouse transactions is 0

I have already thougt that eventually revauation transactions should be created during matching
process, but there are no any transactions with original_transaction_id: 5597794,5597795 and 5662343

Please help me to explain that.


10 replies

Userlevel 5
Badge +11

Hi Marcin,

what valuation method are you using for this part?

Regards

Ralph

Userlevel 4
Badge +9

Hi Ralph

Weigted Average AV

BR

Marcin

Userlevel 4
Badge +9

Hi Ralph, Any news?

Userlevel 6
Badge +14

Have you validated the valuation on the individual parts?    

 

 

Userlevel 4
Badge +9

No i did not. How can I do it?

Userlevel 6
Badge +14

 

Userlevel 4
Badge +9

I will check this settings. I understand  they should look like above, yes?

 

Userlevel 5
Badge +11

Hi Marcin,

as you already said you use weighted average. In this case the system will usually use the po price as arrival cost. If the price was 0 the arrival cost are also 0 and a new average inventory value is calculated.

So please check the PO Price first :).

Regards

Ralph

Userlevel 6
Badge +14

I cannot realistically say what the settings should be for your particular instance & business practices.

Some rules from what I understand of your description:

If you are weight average, it will say weighted average where standard cost is per the snip.

Zero Cost forbidden disallows parts from having a zero cost.

Cost Level is dependent upon your specific business needs.

Supplier Invoice Consideration largely defines whether or not you get PPV postings.

If these settings are defined on the parts, it is possible someone calculated purchase costs and then rolled that to cost set one in the midst of the parts/invoices you have defined were received.   If there is no purchase order history in IFS, the calculated purchase cost will be zero for last/average cost.   

I hope this is helpful.

 

Userlevel 4
Badge +9

Thank you very much! I will check it.

BR

Marcin

 

Reply