x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 142 subscribers
  • Views 761 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
Penny Mayo

Applying payments to Accounts Receivable

SUGGESTED
Posted By

Hello,

Currently we use Sage 100 to manually post payments to monthly recurring receivables.  These receivables are rentals. All payments are entered into an offline excel spreadsheet and then manually entered in 3-3-1, one by one.  Is there a way this excel spreadsheet can be uploaded into Sage and applied to each recievable?

Thank you,

  • 0
    SUGGESTED

    All you have to do is NOT use the display invoices button.  Instead, copy and paste the invoice numbers from your excel worksheet.  Sage will pull in the invoices.  Then you can copy and paste the check numbers into the check # field and the payment amounts.  You just can't do them all at once, do one column at a time, starting with invoice #.

*Community Hub is the new name for Sage City