Sage 100

Trying to create VI job for General Journal import , but the problem is the GL Account is broken down among two columns in the spreadsheet (one for Main account and one for Department). The department is not showing on every line. Is there a way I can have VI reference that last line imported if it's blank? Or do they just have to go in and manually enter those accounts before import? Any other thoughts? @Sage100Routine

How about reading the dept into a temp field, but NOT resetting the temp field on each record. This should maintain the dept # until a different one is read in.

I use the Excel function Concatenate things like this. In a new column, click the function icon in Excel and it will show the steps, but basically for Text1, you would choose cell L1, for Text2, type in whatever the divider is (like a -) and then in Text3 choose cell O1. I would replace the blank fields with 00 in Cost Center. Copy the formula down and then highlight all the formulas, choose Copy and then Paste Special, Values right over the top so that the formulas and replaced with text. Then reference the new value for your import.

@JaneCavanaugh Thanks for the suggestion, but we are trying to keep them out of the csv file to eliminate the possiblity of errors (too many cooks in the kitchen) :) @MarkKotyla the Reset=N (clear on each Record) is not checked on the temp, is that what you mean? It's still not working :(

@MichelleBennion Yes. Can you attach the job?

The problem is that when you read in TEMP004, it replaces the previous value with a blank. Let me think on this a minute.

@MichelleBennion Try this job.

Perfect!!! Thanks!