# Working with Availalable Non-Stock Inventory **URL:** \ **Category:** Ask the Community\ **Created:** [November 16, 2018, 9:34pm UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800 "2018-11-16T21:34:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![aaron.roma](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/aaron.roma/32/285_2.png) [@aaron.roma](https://pug.phocassoftware.com/u/aaron.roma)\ **Post date:** [November 16, 2018, 9:34pm UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800/1 "2018-11-16T21:34:37Z")
Are there any other SX customers that are working with available non-stock inventory in Phocas? Basically the information you see in ICEAN. I’m in the process of trying to sync this data over, and I’m trying to figure out the best way of going about it. From what I can tell, this data only resides in the ICENL table, and will need to do some sort of calculation or logic to exclude what’s was actually sold vs what was left behind in inventory. ---
**Author:** ![WayneK](https://avatars.discourse-cdn.com/v4/letter/w/97f17d/32.png) [@WayneK](https://pug.phocassoftware.com/u/WayneK)\ **Post date:** [November 22, 2018, 12:39pm UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800/2 "2018-11-22T12:39:17Z")
We got a small mod from Infor that dumps the output from ICRON to a CSV file. We then import that to SQL Server. ---
**Author:** ![aaron.roma](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/aaron.roma/32/285_2.png) [@aaron.roma](https://pug.phocassoftware.com/u/aaron.roma)\ **Post date:** [November 26, 2018, 8:06pm UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800/3 "2018-11-26T20:06:32Z")
@WayneK Yeah, I may end up having to resort to a mod. I’m not quite ready to give up on it just yet! I’d love to tackle it without the mod, but may not be able to. ---
**Author:** ![WayneK](https://avatars.discourse-cdn.com/v4/letter/w/97f17d/32.png) [@WayneK](https://pug.phocassoftware.com/u/WayneK)\ **Post date:** [November 26, 2018, 8:21pm UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800/4 "2018-11-26T20:21:59Z")
I should warn you about trying to reconcile ICENH, ICENL, etc. – it’s a mess. The mod was cheap (2-3 hours?), as it’s only a report mod. **Wayne Kessler** Chief Information Officer **Billows Electric Supply Co.** 1813 Underwood Blvd., Delran, NJ 08075 P: 856-751-2200 x512 D: 856-544-3714 F: 856-424-3642 M: 609-670-3526 ---
**Author:** ![JordanS](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/jordans/32/796_2.png) [@JordanS](https://pug.phocassoftware.com/u/JordanS)\ **Post date:** [December 14, 2019, 7:47am UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800/5 "2019-12-14T07:47:25Z")
@aaron.roma We’re a new Phocas user. Curious to know if you got this working in Phocas without an SX.e mod? I was going to post this same question on here regarding nonstock in SX.e. Our old tool was DataPA and I had a non stock inventory report in there with data from ICENL and ICENH. I could get current nonstock inventory in DataPA to balance but when getting into the transaction details it was a bit messy. ---
**Author:** ![aaron.roma](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/aaron.roma/32/285_2.png) [@aaron.roma](https://pug.phocassoftware.com/u/aaron.roma)\ **Post date:** [December 16, 2019, 3:06pm UTC](https://pug.phocassoftware.com/t/working-with-availalable-non-stock-inventory/800/6 "2019-12-16T15:06:06Z")
Unfortunately, no. Worked on it for a bit, but finally got frustrated and set it aside. Other project ended up jumping up the queue. If I ever get back around to the non-stock data, I’ll probably go with the mod as Wayne pointed out.