| Problem 5: |
| Write SQL to get receivables payment report per-period as above report ! |
Case A wholesale company sells a variety of staples and glassware for household needs, such as sugar, oil, wheat, and others. Meanwhile, glassware such as plates, brooms, spoons, forks, and others. Because there are many types of goods owned, the company wants it the data is stored in the database. The seller can be a credit with a certain repayment period. The seller is assisted by Sales who are concurrently invoicing. The accounting department will print out daily reports on which customers are due for invoicing. To facilitate billing, an application was created in which this application has been integrated with the existing sales system, so that if you want to make a receivable report through the application it will display customer data that is due. After the sales billing is carried out, which is also the invoice, it will give the results of the bill to the accounting department. In the accounting section will enter customers who have paid in the settlement of accounts receivable. Example of Receivables Bill Report Accounts Receivable Maturity Report Period: 29-12-2020 to 29-12-2020 Customer : Agung (AG1) Payment Note Cash Check Number Date Total Sales Due Check Cash Discount Bank Date Number K234 29/12/2020 959,000 Amir K235 29/12/2020 32,000 Amir Sub Total 991,000 Total Value The empty field above is useful for content by the collector, which will be used for input to the system Example of Receivables Payment Report Accounts Receivable Payers Period: 29-12-2020 to 29-12-2020 Payment Number: 202099 Customer : Agung (AG1) Date Invoice Number Value 29-12-2020 K234 959,000 29-12-2020 K235 32,000 Sub Total 991,000 Case A wholesale company sells a variety of staples and glassware for household needs, such as sugar, oil, wheat, and others. Meanwhile, glassware such as plates, brooms, spoons, forks, and others. Because there are many types of goods owned, the company wants it the data is stored in the database. The seller can be a credit with a certain repayment period. The seller is assisted by Sales who are concurrently invoicing. The accounting department will print out daily reports on which customers are due for invoicing. To facilitate billing, an application was created in which this application has been integrated with the existing sales system, so that if you want to make a receivable report through the application it will display customer data that is due. After the sales billing is carried out, which is also the invoice, it will give the results of the bill to the accounting department. In the accounting section will enter customers who have paid in the settlement of accounts receivable. Example of Receivables Bill Report Accounts Receivable Maturity Report Period: 29-12-2020 to 29-12-2020 Customer : Agung (AG1) Payment Note Cash Check Number Date Total Sales Due Check Cash Discount Bank Date Number K234 29/12/2020 959,000 Amir K235 29/12/2020 32,000 Amir Sub Total 991,000 Total Value The empty field above is useful for content by the collector, which will be used for input to the system Example of Receivables Payment Report Accounts Receivable Payers Period: 29-12-2020 to 29-12-2020 Payment Number: 202099 Customer : Agung (AG1) Date Invoice Number Value 29-12-2020 K234 959,000 29-12-2020 K235 32,000 Sub Total 991,000
