Sage 100

V2014 Adv GL journal entry import. Trying to figure out a way to skip blank (zero debit AND ZERO credit) lines. Client has a template used each month for importing JE's. Not all of the lines are used every month. Currently, they are sorting the import to eliminate the blank lines. They would like to eliminate that pre sort but I can't figure out a way for the VI import to skip over the blank lines. They import with zero debit and zero credit fields. Not a major issue but seeing that resellers have some type A genes in them, there should be a way to eliminate this surplus line. I have tried the selection tab but Boolean logic isn't kicking in. Or's nor And's nor = nor <>. Is my logic faulty, is there a workable way or is this a WAD and we are SOL????? Either the line imports as zero's or all lines are skipped.

Is the same column used for debits and credits?

How about a Skip record on the Record tab??

Jeff, My first thought is to add a field to the excel spreadsheet that adds the debit and credit amounts for the one line. This will either return a positive or negative number OR 0. The select logic in VI could skip the lines where the single value is 0. If I understand you correctly, the logic may be failing when trying to compare the two figures (debit and credit equaling 0). Could be off base but who knows? Cooper

@ThereseLogeais beat me to it......... Also, on the data tab, you may have to include the credit and debit fields as the first lines so that your test logic precludes creating the header data. It's not that the record is importing zeros, it's just creating the header, your logic kicks in after the fact and is working so the line info doesn't get imported. As a result, but the default is zero since it can't be blank. Or calculate a temp field and make it the first line on the data tab and set your logic test to check that value first. I would try the skip record, though. You'll need two lines on that tab, I believe. I haven't tested any of it.............

It is my lucky day! @BethBowers - Yes, DB/CR is one column. @ThereseLogeais - You are the awesome winner by suggesting a skip record. A little tweaking and it works!!! If you are at MOTM 2016, your first drink is on me at the welcome reception. @CooperBlack since the both amounts were in one field, I did not have to combine them, but I couldn't get this to work because of my fixation on selecting the record, not skipping it. I was frustrated by the fact that you could not select records via a temp field. @LouWagner You snooze, you lose in this forum. A bit like Jeopardy where you are left thumbing the buzzer button... Thanks to everyone again.

So how about a drink for us all at the welcome reception. They are free right?? Cooper

At the rate I am going, I will owe everyone their first drink.....

I just hadn't had enough coffee yet. A cold motor has to warm up! LOL