Working with Availalable Non-Stock Inventory


#1

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.


#2

We got a small mod from Infor that dumps the output from ICRON to a CSV file. We then import that to SQL Server.


#3

@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.


#4

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