We run SAGE 100, and recently I purchased BizNet 5, but I also have BizNet 7 datasets - A/R, A/P and IM.

The BizNet tool works well when I am pulling general ledger information, but for our inventory, accounts receivable and accounts payable there is additional information in SAGE that I believe I can bring into my BizNet file, such as inventory by warehouse. I do get our inventory dollars in total via the BizNet general ledger, but I would also like to be able to see the inventory by warehouse that add up to the total general ledger inventory dollars.

I am hoping someone that has experience with the IM dataset can tell me what field(s) in the IM dataset has the inventory amounts by warehouse OR does it even exist in the IM dataset. I want to do a similar thing with A/R and A/P.

I am not looking for anyone to do this for me, I can get expert assistance, but I was hoping one of the super users for BizNet would be able to tell me if what I am trying to do is possible and save me a lot of time by being able to direct me to the correct fields in the dataset.

Thanks,

Ron Partner 918-445-4488