Non Job Receivable / Vendor Receivable

SUGGESTED

Hello!

I am new to this forum. I was not able to find any recent discussions or threads to help me answer my question, but hopefully someone here can help me out.... (this is in Sage 100 Contractor)

1. I have not found a way to create a receivable that is not tied to a job. If anyone has some info for this, please let me know.

2. The issue I am having has to do with refunds from a vendor. Since I have been using Sage (March 2021) here is what I have done.

Example - vendor shorts us a widget; We buy the widget and charge it to the job cost code 000. I create a memo receivable and tie it to that cost code so they offset and use very detailed notes. I print that receivable invoice and my project manager uses Bluebeam to edit the "billed" to information to change it from the project owner/client to the sub-contractor. Pros - it shows in the receivable reports; Cons - it appears as a receivable from the wrong person 

I was able to find an article from 9 years ago that discusses processing a vendor refund. In short, you create a negative payable invoice to that vendor and use the cost code you want reduced. You then create a positive amount payable invoice for that same amount and post it to a "clearing account". You then pay both of these invoices with a dummy/manual check which ends up being a $0 amount (invoices will then show as paid). Then whenever you receive the check from the vendor, you post it against the clearing account. The problem with this is 1. there is no way to actually print an invoice to send to the vendor that shows the correct info, 2. it seems like a long work around that can cause other issues, 3. It still does not actually create a receivable (simply just creates a debit entry in a clearing account).

I feel like there has to be a way to create an invoice that is not tied to a job, and also a way to handle these vendor receivables.

Any tips or suggestions would be greatly appreciated!

Parents Reply Children
  • 0 in reply to SAM I AM
    SUGGESTED

    To create a vendor credit, its the same window as the invoices but you put a negative qty.  That creates a credit.

  • 0 in reply to Char DeLange

    Thank you, Char, but I know how to create the credit.  I'm trying to figure out how to create an INVOICE to send to the Vendor for that credit.  When you said "print it," I thought you meant there was a form that would create an invoice you could send to the vendor, showing how much they owe us.  But when I print it, it comes up as an invoice billed to us (not the vendor), asking to pay a negative amount - which looks like a credit memo. Neither our vendor nor I want to subtract what they owe us from another invoice that I owe them.  They want a separate invoice from us.    Sage only allows me to create an invoice that bills a JOB.  I need to bill a VENDOR, about a job.  

  • 0 in reply to SAM I AM
    SUGGESTED

    OK sorry.  You will likely need to modify the AP invoice form for it to look right, but that would be from the printing screen.  Be sure to include the yellow notepad at the top of the window as part of your form so the vendor gets enough information to process it on their end.

    Otherwise, send them the 4-1-2 AP invoice list for that vendor highlighting the credit.