Non Job Receivable / Vendor Receivable

Question

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!

Char DeLange · Answer

Use the vendor credit invoice. Enter it and print it. You can customize the form it prints on. And if it was for a job then credit job costs.

Char DeLange · Answer

Out software is centered around jobs, so no there is not a way to book an AR invoice that is not tied to a job. 
 That being said, your info is a bit confusing. When the vendor shorts you a widget, you short pay their invoice for the correct amount. End of story. If you didn't catch it until later, then enter a credit against the job and the vendor and take that credit on the next check. 
 No entries or fake checks to clearing account. If you enter a credit on a vendor that has no other activity, and later they send you a refund check, that is when you enter a new positive invoice against the vendor but you book it to the checking account (not job expense) so that the entry acts like a deposit. Then set the two invoices to pay, and book them using the new "manual check" option in 4-3-2

Char DeLange · Answer

If you haven't paid it yet, then just adjust the invoice. Or create the credit now, and pay it on the same check. This will identify it as a deduction or backcharge

Char DeLange · Answer

Sorry I was not clear. By short paying I meant you enter it at the lesser amount. OR you enter it at the full amount and then enter a credit for what you did not get.

Char DeLange · Answer

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

Char DeLange · Answer

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.

Sage Construction & Real Estate

Non Job Receivable / Vendor Receivable

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING