Accounts Payable Report
Accounts Payable Report
Functional requirements
Accounts payable represent the amount owed on a specific date for the
purchase of products or services. Accounts payable are recorded at the time when
an invoice is approved for payment and is recorded in the General Ledger (or in the book
assistant of accounts payable) as a liability, pending payment or open due to
that has not been settled.
Company name
NIT.
Email.
Phone number.
Address
Credit Amount of each Supplier.
Supplier name.
Document number.
Initial credit date.
Date of the last payment.
Initial credit value.
Value of the last payment,
Payment method and outstanding balance.
Reports: It will generate reports by filtering the information and will show a detailed list.
for each selected option, Supplier, State, amounts purchased, type of product,
date range
Within the Reports, it is handled in detail according to the user roles to be able to manage the
hierarchy of positions and responsibilities to maintain strict control of the accounts for
to pay.
Reports to Assign:
We will be establishing the account statement to have control over it and not
lose track of the payments to be made.
The account statement control will go over the accounting module which will be generated in it.
module called STATEMENTS which will consist of the following sub -
module.
1. Date
2. Description
3. Invoice
4. No. Check
5. Movement
6. NC. Document
7. Credit
Debit
9. Balance
By having this information we will have control of our account statements and thus be able to
make the payments for each of our expenses, purchases, etc.
Invoice Entry: The details of the products we will be acquiring will be entered.
Part of the suppliers where a correlational number will be assigned to identify them.
invoice, date, and amount. All this so that it can be shared with the department
of inventories, this option is necessary to keep track of all the
movements that involve the purchase of products from suppliers and therefore our
the system is responsible for paying these invoices for any canceled product.
After the main menu, we will have a design that will feature as First Courses.
points to visualize:
Search
Enter
Save
Print
Back
● Exit
Second points to visualize after selecting the first 2 options:
Date: Format corresponding to the day, month, and year of the invoice to be entered.
Note: At this point, the provider's tax identifier should already be created from
the first modules of our system, however it is essential to have
Option to create as a new provider when entering a NIT that we do not have registered.
database.
Branch: This identifier corresponds to the place from where they come. products
acquired.
Seller information: It is necessary to register the seller's name and contact details.
who led the negotiations with the company.
Total of the Invoice: This will be the total of the entered invoice without leaving any amount
excluded since this will help us fill out the general account statement of accounts to
to pay.
Invoice No.: In this space, the invoice number will be entered that carries the
document that the provider extends to us.
Product entry: The following box will allow us to enter products from a
submenu that will be generated when entering this option, since it does not need to request several
points of a product (Type, model, series, color, quantity, and unit value) the system to
Having the entered data will automatically generate a unique code for the product.
Services to offer:
An internal use API will be created for the company with the necessary data for backup.
the payments made to suppliers and the details of the products acquired in each
invoice.
Requirements for the creation of our API: Basic knowledge will be employed.
JavaScript to implement a browser API, one of which will be of the type
Obtaining data from the server, this means it will update our stock of
products from a list that will be available for the inventory group only
consume our API.
Services we need:
An API will be created that requests confirmation of payments made with a number of
order depending on the type of transaction to update the general account statement.
To carry out this process, we will use a Restful API that will help us to reconcile a
iteration with web services. When we send a request through an API of
Restful, this will make a request for a resource to the other end and it is expected to perform
a response through a JSON (JavaScript Object) or through HTML, Python or PHP.