Print Page | Close Window

importing data into ABC

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Inventory Control
Forum Discription: Inventory operations
Printed Date: 26 Feb 2021 at 5:01pm
Software Version: Web Wiz Forums 10 -

Topic: importing data into ABC
Posted By: rzimmer
Subject: importing data into ABC
Date Posted: 23 Feb 2012 at 10:23am
I've been testing out the free version to see if it fits our needs.
It is overkill for our use but the best I've seen.
We have two lists to import;
we have a master list from the supplier with:
part numbers, descriptions, cost price, retail price, suspersession part numbers

then we have our old inventory with:
part number, description, location, and up to four separate supersession part numbers

I think I can merge them by doing the Mfg. list first, the adding the local list that will match the "in stock" part number list with the master and overwrite it with our local information (correct?).

The problem I've having is getting the "quantities on hand" put into the system.
Using "ITEM MASTER LIST" to import my data does most of the work but is missing quantity and my supersession lists which are for my info only so they don't have to linked to anything, just shown.
Is there a way to do this?

Posted By: BillD
Date Posted: 24 Feb 2012 at 11:06am

To import inventory catalog, use your format with  part numbers, descriptions, cost price, retail price

import it into the Item Master.
To import your current inventory position, use format part number, location, quantity, (serial), etc.
import it into the Inventory Units.
The part number (item ID in Almyta) is a unique identifier.
Supersession part number can be imported into serial 1, serial 2, or Remark.
Almyta also supports Alternate Part numbers, but using this function or not depends on your particular business application.

Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 -
Copyright ©2001-2011 Web Wiz Ltd. -