x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 143 subscribers
  • Views 5590 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
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
jrasche

How to Apply Vendor Credit to Vendor Invoices and leave partial credit open?

SOLVED
Posted By

I have been searching everywhere for an answer to this.

I have a credit from a Vendor  that is larger than the invoices from that same Vendor.  It's such a large credit that it may take a few weeks to gather enough invoices to clear the credit completely.   We also get a cash discount from this Vendor so I don't want to leave the Invoices Open on the books.

So how can I apply this large Vendor Credit to these multiple invoices, so that the invoices show paid, and still show a  balance for this credit that we can use on future invoices from this vendor?

Thank you!

  • 0

    Hi jrasche,

    When you are applying the credit invoice in 4-3-2, you only type in the amount of the credit you want to use (as a negative number) in the Set To Pay column for the credit invoice. You can apply the remaining later until the credit is used up. For more information, log into the Sage Customer Portal, go to the Sage Knowledgebase, and search for article ID 18160.

    Thank you,

    Greig Hollister

    Sage 100 Contractor Support

  • 0 in reply to ghollister

    I have done this, however I noticed that the Invoices that I am using the credit on remain in the Set To Pay grid, and then on the Pay Vendors, the Vendor is there with a zero dollar, of course if I try to go to print it tells me nothing to print.  

    Furthermore, the invoices remain open in the 4-4 Vendor screen.  I want them to go to a paid status.  I must be missing something here.

  • 0 in reply to jrasche
    verified answer

    Oh my goodness, I found the issue.  For anyone reading that has been confused-  once you do the above, in the Pay Vendor window be sure to click the "Print $0 Checks".  I use the date as a number and print the voucher.  Then it falls off the Set to Pay window, and off of the open AP invoices.

    thanks for your help!

  • 0

    Sounds like you've already done this part:

    In Menu 4-3-1 - you'll select the credit invoice that you want to use and that would appear in the Set to Pay column as a negative number.  

    Then you'll also go into the Set to Pay column on the invoice(s) that you want to apply this credit to and enter as a positive number.  One of the open invoices you may be applying the credit to may be a partial amount - the total of the invoices selected to pay should equal the amount of the credit you're trying to use up.  The end result in the bottom Set to Pay amount should be 0.  

    This is probably the part you're missing:

    When you go to Menu 4-3-2 Pay Vendors, the Set to Pay amount for that Vendor would be 0.  Go ahead and select that vendor Check to print; when the 4-3-5 Report Printing screen comes up, there is an option at the bottom of the printing criteria called "Print $0 Checks".  This will give the system a chance to apply the credit to the open invoices so that they are marked as paid.

    Kathy Gotzenberg

    Sage 100 Certified Consultant

*Community Hub is the new name for Sage City