Sage 100

Has anyone worked out a more streamlined way to use credit card vendors within AP. I have not run into many end users who use this feature but it seems rather cumbersome to have to enter in the invoice to the original vendor first, print/post then go to the credit card vendor and transfer. It's too bad the credit card vendor couldn't' be entered right on the originating invoice and save a step of having to make the transfer. Maybe I'm missing something here or there's a way people smooth out this workflow? I just get the feeling it's a little-used feature and those who used it ""live with the cumbersomeness of it"" .

You can just put the original invoice in while entering your credit card statement (under credit card vendor) .... once you print and update your statement it will update all the vendors .... it won't let you put in the invoice number and date but you can put that info in comments and it will show up in vendor as well.

I'll have to test that. They are using credit cards to prepay for purchase orders so they need to have some traceability.

It is cumbersome but works nicely for purchase orders. I have a couple of clients that use this feature extensively. On the purchase vendor make sure they have CC (or something similar) for the terms and enter CC in the comments field so they know not to select that invoice for payment in Invoice Payment Selection. My clients do the transfer to CC vendor when the statement arrives. They use AP - Explore Vendor Open Invoices view filtered by the CC terms code to know which invoices should be transferred to the CC vendor.

@AliciaCalvillo thanks that works great! If you put the invoice no on the comment line of the distribution it will show up on the vendors comment line. That makes it so much easier.

I have a few clients that use this feature, and love it. Especially when they pay Vendors for PO's with a CC. Do PO Receipt of Invoice. Like @LisaDion said, be sure your Vendor has a Terms Code on the invoice to stop you from paying by check. Often, our customers will put the invoice on hold right in PO ROG to keep it from being paid. When the Credit Card Statement arrives, most people look at each line item and decide if it is an Expense, or a PO Purchase. In AP Receipt of Invoice, I have them Transfer in all the Vendor PO Invoices from the original vendor to the CC Vendor. Then the balance of the Credit Card Statement gets expenses as usual (Fuel, meals, tolls, etc.). This leaves them with one single invoice that matches the amount of the CC Statement. Easy Peasy.

This process is much easier in v2015 and beyond because you can select all the vendor invoices at once. Prior to that, you had to pull each invoice over individually.

one minor drawback on using the cc vendor as the originating vendor is you have to use the transfer button on each GL distribution line instead of just entering the GL number. If you skip that the distribution doesn't go to the purchase vendor history. being able to transfer several invoices at one if they have already been entered and posted is a plus.