Skip to main content
Question

Matching supplier invoice with PO


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
Hero (Employee)
Forum|alt.badge.img+11

Hi Marcin,

what valuation method are you using for this part?

Regards

Ralph


Forum|alt.badge.img+9

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)
  • 439 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)
  • 439 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
Hero (Employee)
Forum|alt.badge.img+11
  • Hero (Employee)
  • 201 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)
  • 439 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

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings