Sage 100

 View Only
  • 1.  I have a Cash Receipts VI import that has two tran

    Posted 07-10-2015 13:33
    I have a Cash Receipts VI import that has two transactions per deposit (A debit and a credit) on the same line of the CSV. The debit is the amount of the transaction, and the credit is the fee taken out by the credit card company, (so they do not want to use the discount column - it needs to hit a different GL). Anyone know of perform logic or some other magic that can force VI to read the same line twice, or a way to get that second transaction in there. I tried chaining two reports together, but it bombs out because the deposit is out of balance. Thoughts?


  • 2.  RE: I have a Cash Receipts VI import that has two tran

    Posted 07-10-2015 14:54
    What if you did the first import with the invoice total as the deposit total and then a second negative import with the credit card fee as the deposit total and a GL distribution?


  • 3.  RE: I have a Cash Receipts VI import that has two tran

    Posted 07-10-2015 14:56
    So two deposits? That might work! Thanks! I will give it a shot