Sage 100

Importing GL journals - can you use one file with multiple company codes or best to break it up into separate files?

Can you do a conditional from a temp file? Doesn't hurt to try. Are the rows in order? Are you auto numbering the JE's. I would worry that the JE number changes and the journal is not in balance because of a straggling line.

Make temp one a file assign where user keys in company code. Have the company code in the import file import as temp 2? Condition the account # based on the comparison between temp 1 and temp 2? Just a thought.

Agree, we just have a conditional statement based on the field that holds the company code and compare either a runtime value or hard-coded value.

Good ideas, thank you.