Sage 100

Hi All, I am working on a Visual Integrator Job to import GL Journal Entries. Easy right... These imports will be automated and the desire is to auto post. It is possible that the entries could be out of balance. We prefer to post the entry in balance and ""plug"" the difference to a specific account, this way we can quickly audit any OOB journals. Has anyone performed calculations like these using VI and have any guidance? We will have 9 source files, 7 days a week to be posted each morning. Our goal is to avoid any human steps in the process. TIA!

You could probably get someone like @AlnoorCassim to whip you up some perform logic that would do it.

You could use a temp variable to create a running total of the debits and credits. Assign the amount of the temp field to the ""Suspense"" GL account.

If an OOB entry is encountered, it'll require human intervention to move the values out of the suspense account. Wouldn't it take less time to just correct the entry prior to posting, or update it OOB and review General Journal results to identify which JE's need fixing?

@DougHiggs a running total is exactly what I was thinking. I am just not sure how to created that using a temp field. I don't see a function that provides a running total. Do you happen to know which function does that?

@DougHiggs Found what I was looking for. Simple! Create a Temp Numeric, Set it to Calculated. The calculation = Temp + {Field to be totaled)

@RebekahVeuger Glad you got it figured out.