Automatically update Unit Cost in Goods Received Notes

Created by QNE Software Sdn bhd, Modified on Tue, 19 Sep, 2023 at 12:44 PM by QNE Software Sdn bhd


Scenario: 


The unit cost column in Goods Received Notes is empty because some users don't have permission to view unit costs 



When it's transferred to the Purchase Invoice, the accounting user updates the unit 

cost, but the system doesn't update the unit cost column in Goods Received Notes.



Because the system takes unit cost information from Goods Received notes instead of the Purchase Invoice in Stock Inquiry and most costing reports, so this will cause the wrong costing. Is there any setting we can set that system will display unit cost as per updated in purchase invoice?



Solution 


Maintenance > System Options > Purchases > Automatically update Unit Cost in Goods Received Notes. Tick this option 



1. For existing transactions, you need to resave the Purchase Invoice in order to take the effect 


2. Go back to the Goods Received Notes, the unit cost will be update automatically


3. Finally, the unit cost will be updated in Stock Inquiry 



Notes

By activate this setting, If I have a unit cost of RM 300 in Goods Received Notes, and transferring to the Purchase Invoice change it to RM 400, how will the system record the unit cost?


Answer: System will capture the unit cost as RM 400 because system will update RM 400 to Goods Received Notes 



Note: 

For Sales, please set under Maintenance > System Option > Sales > Automatically update unit price in Delivery Order 



Kindly refer to attachment for the PDF file

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article