Is it possible to export an excel spreadsheet containing a list of the all the sales invoice items, such as that priovided in backup, plus the payment date (i.e. when it was paid)? I can obtains 3 separate excel files using backup (Sales_Receipt, Sales_Invoice_Items and Sales_Invoice) but can’t fin a way to display them on the same sheet. I don;t want to have to use Vlookup for example in excel to try and do this.
Hello @Jon_Russ
This isn’t possible I’m afraid as an invoice could have 1 payment, or it could have 100s of payments against it, so it’s a bit tricky to record that in 1 file of invoices.
Is there something you’re looking to achieve in Excel in particular? Perhaps we can suggest another way of doing it in QuickFile directly?
[Edit]
Just to add to this, although it won’t give you the details of the invoices itself, but Sales_Receipt.csv from the back up, does list what invoices a payment is allocated against in the 3rd column.
Many thanks for your reply. I’d much rather do this in QuickFile if there is a way to do it!
The closest report in QuickFile that would produce something like this is the payments view, which can be found (for sales invoices) by going to Sales >> View Payments. However, this mirrors the data in Sales_Receipt.csv.
ah, that’s no good, i really need the payment date alongside the other information
The issue is an invoice can have multiple payment dates. Like my example above, an invoice could have 1 or 100s of payments associated with them.
Is there a reason you’re looking for an overview of this? I’m asking because if you’re trying to work something out (e.g. how long a client takes to pay), then there are other reports in QuickFile that could help.
Yes, i’m trying to start using Quickfiles for my VAT returns but before i do this i need to correlate my old Excel system with the Quickfiles sales. It’s really a one-off thing that i’ll hopefully never have to do again!.
The Sales_Receipt.csv file from backup provides me with payment dates bu there is no invoice reference for me to match up with the other sheets (Sales_Invoice.csv, Sales_Invoice_Items.csv).
There is an invoice number in the details column, although I appreciate this can’t be ordered in any way to match it up quickly.
Apart from going into each invoice and viewing the payments for them directly, then there isn’t a way to view a complete list I’m afraid.
This topic was automatically closed after 7 days. New replies are no longer allowed.