Hi!
As an example, we use FedEx for shipping. They invoice us once a package has been delivered, not when the package is shipped. I enter the shipping cost for each package as it is shipped to keep track of what is owed. When the invoice comes in, it lists the packages being invoiced but they are not necessarily in date order. I use the Reports-Supplier Statements to accomplish the payments for invoices. that way I can pick and choose which packages are being paid. BUT - I use a charge card to make the payments and the date of payment is generally set 2 weeks or so later than the actual date I’m putting everything in the system. That works out for matching up with the charge bill but when going into the Report-supplier Statements area, there’s no way to see that some invoices are already marked for payment. This makes it much harder to pick out packages on a current invoice to be paid since dates can be mixed and amounts are often the same. (Hope that all made sense.)
Can something be added to simply show items in that report that are scheduled to be paid?
Thanks.
I don’t believe I’ve seen a custom report that allows me to them take an action from it. Let me try to explain again.
In the normal use of the system, if I simply make a payment to a vendor, it starts with the oldest invoice and applies that amount I pay forward - even if that means I end up with a partially paid invoice. That doesn’t work if you’re trying to pay certain invoices and they aren’t in date order. (Perhaps there’s a questions about an oiler one but not a newer one.)
the way around that is to use the Reports-Supplier Statements. this allows you to look at each individual invoice owed. It also has an option at the top to “Copy To - New Payment”. This pulls up a list of all outstanding invoices and allows you to pick which ones you want to pay, allowing you to give it a date and payment method.
I use a charge card to pay these invoices and set the card to pay them when they are due, usually 2 weeks or so in the future.
I generally pay the vendor weekly. When I go in to choose the invoices the next week, I still see all the invoices I set to pay the previous week on the list. they have no markings that say they have been set to be paid. This makes it difficult to pull out invoices and sometimes, again in a situation where things need to be paid out of date order.
I’ve not seen a custom report have the ability to do a ‘copy to - new payment’ feature so I assume this particular report is not ‘just’ a report. In the Payments tab you see advance payments (ones coming up but past the current date) shown in red so you know they haven’t happened yet but are set to happen. I was hoping perhaps there would be a way to show the invoices in this report in the same way. If they’ve already been set to be paid either have a different color or have a column with the payment date in it - something that identifies them as being set to pay (since this is an unpaid items report). Or, could they be moved to the Transactions report once a payment has been set for them - even if it’s in the future.
Yes, the Advanced Reports works great for creating a report but that doesn’t help me when picking invoices off a list to pay - and I do use the same option in customer’s payments going towards their open invoices as well. That option in those 2 reports is extremely useful.
Can something like that be added into the Advanced reports?
Set the date of the Supplier Statements (Unpaid Invoices) report to 1 day later than the date of your last payment and this will exclude invoices set for payment.