Supplier Bill of Exchange Payment—Key Exercises
IMPORTANT |
It is extremely important
that you set up and work within your own company and with your own supplier to maintain your
data integrity. If you work with any other objects, your exercises will not
function as intended and the data of other students might be affected. Predictable exercise results require that your data
must be isolated in your own company. |
Basic Data Setup
Purpose: The purpose of this exercise is to show you how to
set
up the basic data required to perform this functionality. You will learn how to set up parameters that support bill of exchange
processing and set up
BoE remittance rules and number series.
Windows:
Payment Documents
Bill Types
- Open the Payment Documents window.
- Select
the Supplier Bills of Exchange document
type from the list, and enter the
information shown in the table below.
Note: The number of remittance items is the maximum
number of lines to be printed per check slip.
No Remittance Items |
Remittance Code |
Cash Account |
Payment Method |
5 |
Void |
The cash account to which the bills are connected |
A bill of exchange payment method
|
- Connect a bill type if required by entering a
bill type in the Bill Type field. Save the record.
- Select the record saved, right-click
and then click Payment Document Number Series.
- Click the Valid From field, and add a new record.
- Enter the information shown in the table below.
Valid From |
Start Value |
End Value |
Nest Number |
2000-01-01 |
1 |
9,999 |
1 |
- Save your entries.
Required Data
Purpose: The purpose of this exercise is to show you how
to enter supplier invoices to be used in the exercises below. The invoices/installments must
also be authorized for payment.
- Enter several supplier invoices.
General exercise for Arrival
Entry Supplier Invoice
General exercise for
Post Supplier Invoice
General exercise for Authorize
Supplier Invoice for Payment
Purpose: The purpose of this exercise is to show you how
to select authorized supplier invoices/installments into a payment proposal that will be used
in the exercises below.
- Create a payment proposal.
- Acknowledge the proposal.
General exercise for Load
Payment Proposal
General exercise for Acknowledge
Payment Proposal
Main Exercises
Purpose: The purpose of this exercise is to show you how
to use an
acknowledged payment proposal and create a payment order.
Windows:
Supplier Payment Proposals
- Open the Supplier Payment Proposals window, and
populate it.
- Select your payment proposal line, right-click, and then click Create Payment
Order.
- Enter a supplier bill payment method, or select one from the List of Values.
- Clear the Use only Default Payment Method check box, if it is
checked.
- Enter the financial institution, or payment institute, to which the bills are
connected, or select one from the List of Values.
- Click OK. The
Cash Accounts
window appears. This window shows the possible cash accounts for the payment.
- Click OK. The
Create Order Results window appears.
This window confirms the created order results.
- Click OK to close the window.
Purpose: The purpose of this lesson is to show you how
to create a bill
of exchange payment from the payment order.
Windows:
Supplier Payment Orders
- Open the Supplier Payment Orders window, and
populate it.
- Select the line with your payment order, right-click, and then click Create Bill of Exchange
Payment. The Print And Create Bill Of Exchange Payment window
opens. This window shows the default bill type if bill
types are used, which bill number will be used, etc.
- Click OK.
Purpose: The purpose of this lesson is to show you how
to manually enter bill of exchange information and match it with invoices/installments.
Windows:
Supplier Bills of Exchange
- Open the Supplier Bills of Exchange window, and
create a new record.
- Enter a supplier identity and amount.
- Select the bill line, right-click, and then click Match/View Invoices.
- In the Select Batch of Invoices window, select one or more invoices/installments to be paid by
the bill that matches the bill amount...
- Click OK to close the window. The selected invoices/installments appear in the
Matching window.
- Click
OK to close this window.
- Save the bill. A message appears with payment information.
- Click OK.
- Repeat the same steps and create more bills.
Purpose: The purpose of this lesson is to show you how
to print a bill
of exchange
that was manually entered and created.
Windows:
Supplier Bills of Exchange
- Open the Supplier Bills of Exchange window, and
populate it.
- Select the line that contains the bill that you want to print. The status of
the bill should be Created. Right-click and then click Print BoE. A window
appears with voucher information.
- Click OK to confirm.
Purpose: The purpose of this exercise is to show you how
to cash a bill of exchange
that was created and printed, i.e., change the status from Printed to Settled. In this process,
the payment amount is posted from the Open Supplier BoE account to the Cash account.
Windows:
Mixed Payment
- Open the
Mixed
Payment window, and create a new record.
- Click the
General tab, and enter the cash account that was used when the bill was
cashed. Enter the correct payment date, and set a balance method, if not defaulted from the Cash
account.
- Click the
Transactions tab. In the table portion of the window, right-click
and then click Open Supplier Bills. A window appears showing all open supplier bills that are ready for cashing.
- Select the bill(s) you want to cash, and click OK. The bill or
bills now appear on the
Transactions tab.
- Save the information.
- In the upper portion of the window, right-click and then click Approve.
A window appears with voucher information.
- Click OK to confirm. A message appears with payment information.
- Click OK.
Purpose: The purpose of this exercise is to show you how
to cash a bill of exchange
that was created or printed, i.e., change the status from Created or Printed to Settled. In this process,
the payment amount is posted from the Open Supplier BoE account to the Cash account.
Windows:
Supplier Bills of Exchange
- In the
Supplier Bills of Exchange window,
select a bill that is in the Created or Printed status.
- Right-click and then click Settle BoE. The
Settle
a bill of
exchange dialog box opens.
- Click OK to confirm. A message appears with
the payment information.
- Click OK.
Purpose: The purpose of this exercise is to show you how
to rollback a bill of exchange
that has been settled, i.e., change the status from Settled to Created or
Printed. In this process,
the payment amount is posted from the Cash account to the Open Supplier BoE account.
Windows:
Supplier Bills of Exchange
- In the
Supplier
Bills of Exchange window, select a bill that is in
Settled status.
- Right-click and then click Rollback BoE; the
Rollback
Bill of Exchange dialog box opens.
- Click OK to confirm. A message appears
informing the status from which the rollback has occurred.
- Click OK to confirm. A message appears with
the payment information.
- Click OK.
Purpose: The purpose of this lesson is to show you how
to cancel the
cashing of a bill of exchange.
Windows:
Mixed Payment
- Open the
Mixed
Payment window. Either query or populate to find the mixed payment in
which the bill was cashed.
- In the upper portion of the window, right-click and then click Cancel.
A window appears with voucher information.
- Click OK to confirm. A message appears with payment information.
- Click OK.
Purpose: The purpose of this lesson is to cancel a bill
of exchange.
Windows:
Supplier Bills of Exchange
- Open the Supplier Bills of Exchange window. Either query or populate to find the bill
that you want
to cancel.
- Select the line, right-click, and then click Cancel BoE. A message
appears with payment information.
- Click OK.
Purpose: The purpose of this lesson is to show you how
to follow up on bills of exchange.
Windows:
Supplier Bills of Exchange/ View Details/Supplier Payment Documents Detail Analysis
Supplier Payment Documents Detail Analysis
- From the Supplier Bills of Exchange window,
select one or more bills of exchange that you want to view. Right-click and
then click View Details.
- The Supplier Payment Documents Detail
Analysis
window will be opened with general details, history, and matched items details.
- Click on the
History tab and view the changes of status the bill of exchange
has gone through up to now. Click one or more lines, right-click and click
Voucher Details
to view voucher details in GL Voucher Details Analysis window.
- Click the matched items to view invoices or payment on
accounts matched with the bill.
Required Data
Purpose: The purpose of this exercise is to show you how
to allow stamp duty to be used in the Create Bill of Exchange
with Stamp Duty exercise.
Windows:
Payment Documents
Bill Types
- Open the Payment Documents window.
- Select the Supplier Bill of Exchange document
type from the list.
- In the Document Series ID field, enter a
document series ID and a series ID for an unmatched payment on account. Enter the same information as
in the above exercise, except that the cash account should be different.
- Connect a bill type, if required, by entering a
bill type in the Bill Type field.
- Select the Allow Stamp Duty check box.
- Save the record.
- Select the record that was saved, right-click
and then click Payment Document Number Series.
- In Valid From field, add a new record.
- Enter the same information as in the above exercise.
- Save your entries.
Purpose: The purpose of this exercise is to show you how
to enter basic data for stamp duty, to be used in the exercise below.
Windows:
Stamp Duty
- Open the Stamp Duty window.
- Enter the maximum division amount as
500,000,000. This is the highest value of
the index that is created during a division of a BoE using predefined values in
stamp duty basic data.
- Enter the minimum division amount as 3,000,000. This
is the lowest value
of the index that is created during a division of BoE using predefined values
in stamp duty basic data. The bill of exchange should be above this value for
division calculation.
- Enter the minimum BoE amount as 1,000,000. Bills of exchange
above this amount but lower than the minimum division amount will have a stamp
duty calculated without a division
- Select the Posting of Stamp Duty together with BoE check
box. If selected, stamp duty will be posted at the same time the supplier bill of exchange postings occur. If not selected,
the stamp duty
calculation will take place, but it will not be posted along with the supplier bill
of exchange.
- Save the record.
- Click the Upper Limit field, and add a new record.
- Enter the upper limits and stamp duty as stipulated
by the respective authority. Enter the information shown in the table below.
Upper Limit |
Stamp Duty |
99,999 |
0 |
1,000,000 |
200 |
2,000,000 |
400 |
3,000,000 |
600 |
5,000,000 |
1,000 |
10,000,000 |
2,000 |
20,000,000 |
4,000 |
30,000,000 |
6,000 |
50,000,000 |
10,000 |
100,000,000 |
20,000 |
200,000,000 |
40,000 |
300,000,000 |
60,000 |
500,000,000 |
100,000 |
1,000,000,000 |
150,000 |
999,999,999,999 |
200,000 |
- Save your entries.
Purpose: The purpose of this exercise is to show you how
to enter supplier invoices to be used in the exercises below. The invoices/installments must
also be authorized for payment.
- Enter three supplier invoices for the same supplier. For
each invoice, enter the amounts as 15,300,000, 45,000,000 and 55,000,000
respectively.
General exercise for Arrival
Entry Supplier Invoice
General exercise for
Post Supplier Invoice
General exercise for Authorize
Supplier Invoice for Payment
Main Exercises
Purpose: The purpose of this lesson is to show you how
to manually enter bill of exchange information, match it with
invoices/installments, calculate, and post stamp duty.
Windows:
Supplier Bills of Exchange
- Open the Supplier Bills of Exchange window, and
create a new record.
- Enter a supplier ID, and the amount as 115,300,000.
- Select the bill line, right-click and then click Match/View Invoices.
- In the Select Batch of Invoices window, select
the three invoices/installments, entered above, to be paid by
the bill that matches the bill amount...
- Click OK to close the window. The selected invoices/installments appear in the
Matching window.
- Click
OK to close this window.
- Save the bill. The Stamp Duty Division dialog
box opens
with division information as shown in the table below.
Supplier |
Supplier Name |
Division Amount |
Stamp Duty Amount |
Identity |
Name |
100000000 |
20000 |
Identity |
Name |
10000000 |
2000 |
Identity |
Name |
3000000 |
600 |
Identity |
Name |
2300000 |
600 |
Note: When you change the division amounts, the stamp
duty amount will be retrieved for the new division amount. You can add new lines
or remove lines, but make sure that the total division amount is always equal to
the bill of exchange amount.
- Click
OK to close the dialog box.
A message appears with payment and voucher information. Since
four bills are created after the division, there will be four payment transactions
and voucher transactions created.
- Click on the payment ID to view the rest of the
payment and voucher transactions.
- Click OK. You will see that four bills have
been created in
the bill of exchange window with numbers assigned sequentially. Also for each of the four bills, a stamp duty amount is displayed separately.
Note: Stamp duty division calculation is available
for Automatic Supplier Bill of Exchange Payment as well. A payment order can include
invoices of many suppliers. Therefore, division calculation can be done for more
than one supplier, unlike in Enter and Match Bill of Exchange.
Purpose: The purpose of this lesson is to show you how
to follow up on bills of exchange.
Windows:
Supplier Bills of Exchange
Supplier Payment Documents Detail
Analysis
- In the Supplier Bills of Exchange window,
select the four bills that were created, right-click and then click View Details.
- The Supplier Payment Documents Detail
Analysis
window will be opened. View the stamp duty amount relevant for the bill on the
General tab.
- Click on the
History tab to view payment and voucher
information related to the Created status. Select the record, right-click and
then click Voucher Details to view the voucher information.
Two additional voucher postings, except for
the postings created when stamp duty does not apply, will be created for the
stamp duty and stamp.
- Repeat for the other three bills.
- Click the
Matched Items tab and
observe how
three invoices originally
matched with one bill of exchange, have now being allocated amongst four bills
after stamp duty division calculation.