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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Stock Count Entry Integration

(0) ShareShare
ReportReport
Posted on by 242

Hi,

We had a requirement on importing counted qty information against the Stock Count Entry in GP. As there are no eConnect Schema to Push the counted qty data into GP for the started stock count entry.

Using SQL, I had decided to insert the counted qty details directly in to the following stock count tables IV10300, IV10301, IV10302, IV10303. It is working fine and we can able to process the stockcount and variance are creating correctly (if any). 

We are facing issue with the stock count clear option, when we perform the stock count entry manually in GP, then the clear process works perfect. But for the stock records inserted manually, clear doesn't clear the StockCount Line table but it updates and clears the header, Stock Count Serial Lot and the Stock Count U of M tables correctly. 

Please let me know if any solution for the same. 

Regards,

Ramanan

*This post is locked for comments

  • Verified answer
    L Vail Profile Picture
    65,271 on at

    If you are interested in purchasing an ISV product that will allow you to import count amounts from Excel spreadsheet(s), take a look at CompleteCount by Willoware. willoware.com/.../complete-count

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans