WARNING: This is only for those that use an existing inventory program other then Mars for the 21st Century and you want this system to price per your inventory.
You must create a database and call it INV_IMP.DBF which most consist of the following data fields from your inventory;
FIELD NAME TYPE LENGTH DEC. 1. FILE CHARACTER 1 see 1 below 2. CUST CHARACTER 4 see 2 below 3. JOB CHARACTER 4 see 3 below 4. MATERIAL NUMBERIC 12 2 see 4 below 5. SET_PRICE NUMBERIC 12 2 see 5 below 6. PART_NO CHARACTER 20 see 6 below 7. TIME_STD NUMBER 6 3 see 7 below 8. LABOR NUMBER 12 2 see 8 below 9. SEQUENCE NUMBER 4 0 see 9 below 10. AVG_MATL NUMBER 12 2 see 10 below 11. NAME CHARACTER 50 see 11 below
Each record in your inventory file must calculate out to one record for each file type, customer and job code. Our system will first look at the file to make sure that all fields are named as they are above and that each field is of the proper type. If it is not, then the system will inform you and will not import the records. It will also validate that the records you show in the file are entered correctly and that each field that must be filled in does have a value.
Once you have created the above, then you must place the file in the directory where the Mars for the 21st Century is in. Before the system validates the data and structure as indicated above, it will make sure that the file was created on the current date. If it was not, the system will inform you when it was created and ask if you want to still continue. If you state YES, then the validation and importing will start.
NOTES:
1. FILE must consist of one of the follow letter; A=AAR, N=NitLeague, D=Default User Job Code, C=Customer Specific. If you use C then you must have created a customer specific job code file in order to use Customer Specific Inventory. All inventory job codes must be in the customer specific job code file.
2. If the FILE = C, then the CUST must have the initials of the Company that the inventory belongs too!
3. JOB is the Job Code that applies to the inventory. The job code must exist in the FILE that is designated.
4. MATERIAL is the total material charge of all items for that specific job code in the file selected.
5. SET_PRICE is what you want the system to charge for a single unit, if you designate that when creating a line of repair.
6. PART_NO is your part number for the specific item
7. TIME_STD is the time standard that you want to use for labor on this specific item where the item is not a multiple inventory item. (See Multiple Inventory below)
8. LABOR is the per unit charge for an item that is in the multiple inventory file. (See Multiple Inventory below)
9. SEQUENCE is the sequence number associated to a multiple inventory item. (See Multiple Inventory below)
10. AVG_MATL is the average cost to you for (material plus freight) of a specific item, job code file. The AVG_MATL is only for non-multiple inventory items. This field is used to populate total material in the inventory file.
11. NAME is the description or narrative of the repair part, such as "BRAKE SHOE 2 INCH COMP"
Multiple Inventory
If a job code can have multiple selections to it, then the SEQUENCE field must have a sequential number, 1 through 9999 for each item. However, there must
be one line with a 0 for the sequence number in order for the system to recognize the total number of items. The sequence numbers greater then 1 will
indicate that it is a multiple selection job code. The SET_PRICE field must show the unit material cost for this item and the LABOR field is unit labor
cost if any for multiple selections. The LABOR field is only used for multiple selection job codes.
Multiple Selection Job Codes are when a specific job code can have different description and prices. When this occurs and you use inventory in the billing repair card screen, a screen would appear asking you do select the description that you want.
REQUIRED FIELDS
FILE
CUST IF CUSTOMER JOB CODE
JOB
PART_NO
SET_PRICE IF MULTIPLE INVENTORY
SEQUENCE IF MULTIPLE INVENTORY
MATERIAL
AVG_MATL
NAME