Skip to main content
Question

Matching supplier invoice with PO

  • May 9, 2022 11:24 AM UTC
  • 10 replies
  • 340 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+14
  • Superhero (Employee)
  • May 9, 2022 12:00 PM UTC

Hi Marcin,

what valuation method are you using for this part?

Regards

Ralph


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • May 9, 2022 12:14 PM UTC

Hi Ralph

Weigted Average AV

BR

Marcin


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • May 12, 2022 12:50 PM UTC

Hi Ralph, Any news?


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • Jun 24, 2022 11:53 AM UTC

Have you validated the valuation on the individual parts?    

 

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • Jun 24, 2022 2:21 PM UTC

No i did not. How can I do it?


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • Jun 24, 2022 2:23 PM UTC

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • Jun 24, 2022 3:42 PM UTC

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

 


Ralph Gericke
Superhero (Employee)
Forum|alt.badge.img+14
  • Superhero (Employee)
  • Jun 24, 2022 3:47 PM UTC

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)
  • Jun 24, 2022 3:48 PM UTC

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)
  • Jun 25, 2022 7:20 AM UTC

Thank you very much! I will check it.

BR

Marcin