Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Referring to the above case, what are the benefits obtained by the owner with the application of the database system? Case A wholesale company

image text in transcribedimage text in transcribed

1) Referring to the above case, what are the benefits obtained by the owner with the application of the database system?

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions

Question

How many states in India?

Answered: 1 week ago

Question

HOW IS MARKETING CHANGING WITH ARTIFITIAL INTELIGENCE

Answered: 1 week ago

Question

Different types of Grading?

Answered: 1 week ago

Question

Explain the functions of financial management.

Answered: 1 week ago