Stock Count Entry Integration

(0) Share

Report

Posted on by Ramanan

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

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No