![]() I’ve put a condition to show me only invoice 1010931 to keep this report simple to see if it’s functioning the way it is intended. My objective is to run this query to bring record of only one unique inoice with its corresponding last payment date (T0."DocDate") recorded, which closed the invoice.īelow is my simplified version of the SQL syntax: Since customers make multiple payments towards an invoice to close it out, there are duplicate records of the invoice number but with its own unique field data (payment date, etc.). I am building a Customers by days between invoice and payment query report. ![]() ![]() In the Query Wizard, expand the node for the table you would like to import into your spreadsheet. Select the option to use Query Wizard to create/edit queries. In Excel, open the Data tab and choose From Other Sources -> From Microsoft Query. ![]() I am reposting this because I don't think I was clear in communicating my issues. You can then work with live SAP Business One data in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |