VI General Journal total debits and assign credit account number

SUGGESTED

I'm trying to import a journal entry. I've calculated the Debit Account number by combining other fields to make the complete account and that works.

Now I need to total all the debits to get the credit amount and then assign the credit account number.

I tried in fields 16 and 17 to "Sum(debits)" and assign the account number if the credit amount <>0.

that does not work.

Parents
  • 0
    SUGGESTED

    You might want to change tactics a bit.  Add L.Temp006 right after L.Temp003 and make it a calculated field pointing to your amount column (23?), Assign on Line Records.  Then add L.Temp007 numeric calc. field and calculate as Temp007+Temp006. This will add the amounts of each line to Temp007 until completed.  

    I also noted you have L.AccountKey twice, it looks like you want to assign account 220 at the end.  That probably won't work the way you have it.  If you could identify the last record in the source file, you could use that value to put two conditionals in, one for (if the last record value is not there, assign debit L.AccountKey line)  and if the value is there, assign credit L.AccountKey, using the built up Temp007 amount., also with the same conditional.  They both can't be assigned on the same pass.  

    These things tend to lead to more questions, but wanted to get you thinking in a different direction.  Good Luck!

Reply
  • 0
    SUGGESTED

    You might want to change tactics a bit.  Add L.Temp006 right after L.Temp003 and make it a calculated field pointing to your amount column (23?), Assign on Line Records.  Then add L.Temp007 numeric calc. field and calculate as Temp007+Temp006. This will add the amounts of each line to Temp007 until completed.  

    I also noted you have L.AccountKey twice, it looks like you want to assign account 220 at the end.  That probably won't work the way you have it.  If you could identify the last record in the source file, you could use that value to put two conditionals in, one for (if the last record value is not there, assign debit L.AccountKey line)  and if the value is there, assign credit L.AccountKey, using the built up Temp007 amount., also with the same conditional.  They both can't be assigned on the same pass.  

    These things tend to lead to more questions, but wanted to get you thinking in a different direction.  Good Luck!

Children