Mas90 Visual Integrator

[Tp56]

I'm trying to import a csv file I create into Mas90. I know the format of the CSV file is correct since I've done this for other customers in the past.

I selected the destination table as the AR.Invoice and added all the required fields, but when I do the import, it passes but the Sales area information is missing. (EX. Sales code, Sales account, qty, price, amount) It's not like it fails, it just doesn't appear. I have the box selected that says header information included in detail line but nothing.

I'm not sure what version of mas90 I'm using, since when I go to the help it only lists the year... and that's 2001.

I'm thinking it's some sort of bug, I have no idea why it won't work. I exported an Invoice record and created a CSV file with the exact information and the same thing happened to me still.

Any help would be apperciated.

 

[BigLouie]

It is not a bug and I have an idea why it isn't working. On the Records tab you do not have it set correctly.

 

[Tp56]

I thought about that, but everything appears but the sales information. I've tried removing parts of the line area that are not required but it still doesn't work. I know the information it's picking up for the line sales area is correct, except for the Cost_Sale_Accnt and Inventory_accnt because those are left blank since they are not used.

The rest of the fields in that area I'm using are: Sales Code, Sales_Accnt, Quantity, Price, Amount

 

[Tp56]

Oh I see what you mean now. I'm looking at the records tab right now.
I see a Sales Code Lines, Misc Charge Lines, and comment lines in the box to the right.
When I double click on them, it's checked to perform logic only. When I uncheck it, I can specify certain things, but looking at it I don't know what it all means exactly.

 

[BigLouie]

Never attended the VI class? You need to promise me that you will go to class after I post this.

On the records tab you are telling VI how to identify the various record types. If you leave it blank then only the header is imported in. IF all lines are sales code lines you would then need to change the operation to <> and leave the default box blank. This means that as long as the first character is populated it is a sales code line.

You reall need to go to class. VI is a great help in bringing in data but you can also corrupt files if you don't know what you are doing. And in your case you seem to need some teaching on the topic.

 

[Tp56]

It looks it's now reading the additional fields.
I've got one more question though, Cost_sale_accnt and Inventory_accnt in the sales code tables are all blank, but when I'm importing an Invoice it requires those two fields to have a value. I don't what to enter anything in there, I tried leaving it blank, setting it to 0, and even null.

Thanks for your help. I was stuck on that part for so long lol. I even contacted someone else about it, but I don't think they're having any better luck than I did.

 

[BigLouie]

And why do you think it requires those two fields to have a value and why don't you want to enter anything there?

Another prime example of the need for class. How do you think I learned all this stuff I post about, I went to class.

 

[BigLouie]

OK here is the deal. VI is making you include the sales and cost of sales GL account numbers because otherwise you would not be able to post the invoice. You would receive an error message at some point. And why you do not want to include the GL account numbers is a mystery. How do you think it is going to hit the GL if you don't have these numbers? Now you can file assign them by telling VI to go get the values from the sales code.

 

[Tp56]

Thanks for the help. I know what you mean about the class, but I'm only on it for this specific customer. I was pulled off a few days ago to do some QuickBooks integration.

Now I'm back on Mas.
I did the file assign thing, looks like I can get it to work. I was just wondering about the Cost_of_salesAcct and the InventoryAcct because in the sales code table, that area is blank for those entire two columns. I guess they're just going to have to give me some value to enter.

Anyway, thanks again.