Skip to main content
Question

Matching supplier invoice with PO

  • May 9, 2022
  • 10 replies
  • 280 views

Forum|alt.badge.img+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

Ralph Gericke
Superhero (Employee)
Forum|alt.badge.img+13
  • Superhero (Employee)
  • 220 replies
  • May 9, 2022

Hi Marcin,

what valuation method are you using for this part?

Regards

Ralph


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • 34 replies
  • May 9, 2022

Hi Ralph

Weigted Average AV

BR

Marcin


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • 34 replies
  • May 12, 2022

Hi Ralph, Any news?


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • 440 replies
  • June 24, 2022

Have you validated the valuation on the individual parts?    

 

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • 34 replies
  • June 24, 2022

No i did not. How can I do it?


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • 440 replies
  • June 24, 2022

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • 34 replies
  • June 24, 2022

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

 


Ralph Gericke
Superhero (Employee)
Forum|alt.badge.img+13
  • Superhero (Employee)
  • 220 replies
  • June 24, 2022

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


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • 440 replies
  • June 24, 2022

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.

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • 34 replies
  • June 25, 2022

Thank you very much! I will check it.

BR

Marcin