web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Purchase Variance post...
Microsoft Dynamics NAV (Archived)

Purchase Variance posted in Value Entry when receiving the order not after invoicing

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I am the group controller for a group of companies that have Nav with std costing. 


Our adjust cost procedure writes the purchase variance in value entry after the invoice is posted.

Is it possible in Nav to have 2 variances: first is between std cost and receipt value (ie what is in original purchase order) and then between receipt and invoice?



This can help closing the month faster, since now we have to wait untill all the invoices are posted before closing the month. If I get purchase variance from the order, I can even close my month the very first day of the month.

 

Any help?

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    You can use the setup the "Expected Cost Posting" field value =  TRUE in Inventory setup.

    This would pass the interim inventory entries in G/L at the time of receiving the orders. However this would be purely based on the standard cost and would not pass any variance entries, as required by you.

    This entries would get reversed during the invoice posting and system would pass the actual entries (Both Inventory & Variance).

    In case, if you need to pass the variance entries at the time of receipt, you would require to go for customizations. However this would not be advisable as it would depend on lot of parameters and would require someone really expert to do the same. You need to consider the charges, multi-currency, returns etc. while doing the modifications. This would be bit complex and off-course would need require some time to develop it.

    Hope this helps you.

    Regards,

    Vishal Salot

    //Pl. mark this answer as verified, if it helps you.

  • Community Member Profile Picture
    Community Member on at

    Thank you for your quick and precise reply

    We do have the expected cost flag on, but as you said, this does not post any variances

    It sound very strange to me that is not possible to post the variances at the time of the receipt, that would be of great benefit for a fast closing process...

    No other solution out there? Only customizing?

    Regards

    Lorenzo

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    I do not see any other solution except customizations.

    The system has been developed in such a way that, it would post only variance entries at the time of Purchase Invoice posting and not during receipt posting.

    I would suggest that, avoid doing customization, instead ask your supplier to deliver the invoices along with the goods and try to post the invoice on daily basis.

    This should solve your problem.

    Best Regards,

    Vishal Salot

    //Pl. mark this answer as verified, if it helps you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans