Hello,

I have a question regarding the inventory transaction updated by charges; I added charges to the PO and received the inventory, but the inventory transaction amount does not include charges added to PO.  How to enable it?

The inventory valuation method for purchases part on the site is “weighted average”

Thanks

Tanya

Hello @MelTanyaS,

How is defined the Purchase Charge Type used? What’s the option selected on the field Distribute Charge by?

If you want, you can send a screenshot of Purchase Charge Type (that you’ve used on the PO).

Thanks,

Joao

Hello, thank you for your quick answer.

I just went on the charge type and enabled the “distribute at arrival” toggle + added the charge before arrival registration and it worked fine - i connected the charge line to a PO line number. In the inventory transactions I have 4 lines : M1 (2times) + M10 + M189 

Here is a screenshot of the charge type : 

In general, the customer registers arrival and some weeks later, when receiving the invoice, they know how much the freights charges are, so charges are added after arrival in this case; I tried the process but the inventory transaction does not get updated once charges are added to PO after arrival.

Do you have any idea on how to set this up ? 

Thank you,

Tanya

Hello,

Fill the Distribute Charge by with Per Amount for example.

because in your test you’ve this field empty:

Hello, 

Thank you, I tried to fill the distribution type and it worked, but if I register arrival before adding charges, I still can’t get the right figures on the inventory transaction. Do you by any chance know how to tackle this and allow system to calculate value of inventory transaction when charges are added after arrival registration ? 

Thanks

Hi,

You can do a “workaround”, that is:

• Add charge on PO creation (=0.01eur, for example)
  • you can specify it on supplier, and then will be inherited in every PO’s

• 

  on arrival you already have a charge registered, but “without real value”

• after the arrival you can go to the PO and change the value/amount of the charge to “real value” (change from 0.01 to 250eur). this change will be reflected on Inventory transaction, even after the arrival.

let me know if this helped you.

Thanks,

Joao

Hi, thanks for sharing a new idea, just tried and unfortunately, the inventory transaction is not updated after I change the PO charge : 

I modified charge to 100 euros

The inventory transaction stays the same ‘(with initial charge of 0,01)

 
Have you already tried this process and if yes did it work ? if yes, maybe i’m missing some basic company setup or order setup 

Thanks

Hi,

Register the Manual Supplier Invoice, and then the inventory transaction history should be updated and add new lines with the diferrence between initial charge value and the new one.

like this:

Hi, just tried to create the invoice : charge line appears on invoice (first line) and posted invoice as well - but inventory transaction did not get updated. Did you allow some update toggle somewhere? 

Thanks,

Tanya

NB : the supplier invoice consideration is enabled at the site level

Hi,

Do you have “Transaction Based” on Inventory part Supplier Invoice Consideration?

After all set up and after the Man Supp Invoice, you should be able to see Inv Trans Hist changed and you can also see Transaction Revaluation Event for the Purchase Order

Thanks,

Joao