Can you look in Visual Integrator to see what fields these map to?

We found it under Import Job Maintenance, and that definitely cleared up some things. Thank you!

I'm still a little unclear on how the "EntryNo" works though. I don't know if there's an upper limit on it. Is there somewhere that shows what the fields mean?

Thanks again for that suggestion.

What version of MAS are you on?

What table is the Visual Integrator Import importing to?

Depending on the version you might have a option in mas 90 for resources,  go there and at the bottom you will find file layouts and program information

Sorry, it took a little while to find that info.

version: Sage 100 Standard ERP 2013 (5.00.2.0)

table: GL_GeneralJournalHeader

When we look at the GL_GeneralJournalHeader, the 1st store shows [005897] for the EntryNo. The number our script is attempting to insert would be 1 digit larger, for example, 0058971, so it appears that Mas90 is truncating the number to 6 digits. We have over 20 stores and the script generates a separate import file for each store. It increments the EntryNo for each store every time it runs. Does this number need to be different for each store for each day?

Thank you!

Journal EntryNo's do not need to be unique and yes you can start over with 000001. I would recommend fixing your number to be six digits.

The advantage of a somewhat unique number for each import file is that you have trace-ability in case you need to reconcile. If you import everything everyday under the number 0000001 it makes it harder to reconcile.

We tried playing around the the EntryNo's and we couldn't get it to work with anything other than the current highest amount. If we try something like 070000 says:

"HS Record Invalid or Write Failed. This entry already exists in batch 00000."

But I don't see how it could already exist because the current highest number appears to be 59008. Is there somewhere we can look to find what the highest number is?

Here's a few lines to see what one of the files looks like:

SJ,0059008,042914,<gl code>,Catering,Catering,123.00,

SJ,0059008,042914,<gl code>,Food Sales,Food Sales,1234.56,

SJ,0059008,042914,<gl code>,MISC,MISC,10.00,

Thanks!

Yes - I can run a Source Journal History report, export it and sort it by entry number. The only reason I can think of for you getting that error is that you tried to import it multiple times as a test. It isn't even looking to see if that number has been used in the past. It's looking to see if it's sitting in General Journal Entry.

See what is sitting there, open General Journal Entry and click on the flashlight.

I got with one of our senior accountants and she said that the other accountant I was working with was using an older version of the import file and it also was some sort of permissions/user id issue. It worked on her computer, so everything is working now.

I tried having it reset the EntryNo to 000001 and it worked.

Thanks so much for your help!!

You're welcome! Please mark this as resolved.