MCPR
MCPR
MCPR
Copyright
Trademarks
Microsoft and Microsoft Dynamics are either registered trademarks or trademarks of Microsoft
Corporation or its affiliates in the United States and/or other countries. FairCom and c-tree Plus
are trademarks of FairCom Corporation and are registered in the United States and other
countries.
The names of actual companies and products mentioned herein may be trademarks or registered
marks - in the United States and/or other countries - of their respective owners.
Unless otherwise noted, the example companies, organizations, products, domain names, e-mail
addresses, logos, people, places, and events depicted herein are fictitious. No association with
any real company, organization, product, domain name, e-mail address, logo, person, place, or
event is intended or should be inferred.
Intellectual property
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual
property rights covering subject matter in this document. Except as expressly provided in any
written license agreement from Microsoft, the furnishing of this document does not give you any
license to these patents, trademarks, copyrights, or other intellectual property.
Warranty disclaimer
Microsoft Corporation disclaims any warranty regarding the sample code contained in this
documentation, including the warranties of merchantability and fitness for a particular purpose.
Limitation of liability
The content of this document is furnished for informational use only, is subject to change without
notice, and should not be construed as a commitment by Microsoft Corporation. Microsoft
Corporation assumes no responsibility or liability for any errors or inaccuracies that may appear
in this manual. Neither Microsoft Corporation nor anyone else who has been involved in the
creation, production or delivery of this documentation shall be liable for any indirect, incidental,
special, exemplary or consequential damages, including but not limited to any loss of anticipated
profit or benefits, resulting from the use of this documentation or sample code.
License agreement
Use of this product is covered by a license agreement provided with the software product. If you
have any questions, please call the Microsoft Dynamics GP Customer Assistance Department at
800-456-0025 (in the U.S. or Canada) or +1-701-281-6500.
Publication date
March 2008
Contents
Introduction ................................................................................................................................................. 2
Whats in this manual...................................................................................................................................2
Symbols and conventions ............................................................................................................................3
Resources available from the Help menu..................................................................................................3
Send us your documentation comments ...................................................................................................5
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
C O N T E N T S
ii
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C O N T E N T S
.............................................................................................................................................. 130
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
iii
iv
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
INTRODUCTION
Introduction
Collection and Payment Methods - Withholds integrates with Receivables and
Payables Management and allows you to enter a single collection or payment using
more than one means of payment. Withholds allows you to calculate withholding
taxes on your purchases and determine the amount payable to vendors. You can
make inquiries for the various transactions that you enter, and generate reports to
be submitted to the tax authorities.
You can also integrate Collection and Payment Methods - Withholds with
Analytical Accounting. You can create analysis information for cash receipts and
payments entered in the Collection/Payment Methods Withholds module. When
you enter a cash receipt or a payment, a single assignment equal to the distribution
amount is created for each distribution linked to an accounting class. You can
modify this analysis information.
You must have installed the Tax Listing module before you can use Collection and
Payment Methods - Withholds.
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
IN T RO D U C T IO N
Part 3, Utilities and Routines, describes the various activities that you must
perform in order to maintain your records in Collection/Payment Methods Withholds.
Part 4, Inquiry and Reporting, shows you how to view the information you
have entered into the system, and generate different kinds of legal and other
reports.
Description
The light bulb symbol indicates helpful tips, shortcuts and
suggestions.
The warning symbol indicates situations you should be
especially aware of when completing tasks.
This manual uses the following conventions to refer to sections, navigation and
other information.
Convention
Description
Creating a batch
TAB
or ENTER
Contents
Opens the Help file for the active Microsoft Dynamics GP component, and displays
the main contents topic. To browse a more detailed table of contents, click the
Contents tab above the Help navigation pane. Items in the contents topic and tab
are arranged by module. If the contents for the active component includes an
Additional Help files topic, click the links to view separate Help files that
describe additional components.
To find information in Help by using the index or full-text search, click the
appropriate tab above the navigation pane, and type the keyword to find.
To save the link to a topic in the Help, select a topic and then select the Favorites
tab. Click Add.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
I N T R O D U C T I O N
Index
Opens the Help file for the active Microsoft Dynamics GP component, with the
Index tab active. To find information about a window thats not currently displayed,
type the name of the window, and click Display.
Lookup
Opens a lookup window, if a window that you are viewing has a lookup window.
For example, if the Checkbook Maintenance window is open, you can choose this
item to open the Checkbooks lookup window.
Printable Manuals
Displays a list of manuals in Adobe Acrobat .pdf format, which you can print or
view.
Orientation Training
Accesses online tutorials that show you how to complete basic procedures within
Microsoft Dynamics GP. Additional tutorials are available through the
CustomerSource Web site.
Whats New
Provides information about enhancements that were added to Microsoft Dynamics
GP since the last major release.
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
IN T RO D U C T IO N
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C O LL E C T IO N
A N D
Chapter 3, Magnetic file setup, contains information about the setups you
must complete in order to generate the magnetic files for reports to be sent to
the tax authorities.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 1:
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
PA RT
S E T U P
A N D
C A R D S
2.
Mark the Print receipt when recording option to print receipts for all receivables
transactions. Select the default report ID to be used to print receipt reports.
3.
Mark the Payment Order Printing option to print payment orders for all
payables transactions. Select the default report ID to print payment order
reports.
4.
Enter a Supplier Class ID in the Fixed Fund field. This ID is used to enter
payments other than vendor payments. When you enter transactions in
Payables Transactions Entry window for vendors belonging to the class ID
specified here, the Description field changes to Corporate Name, and the
Purchase Order No. field changes to C.U.I.T No.
5.
Enter an account number in the Mass Balance Settlement field. This will be the
default account to write off customer balances in bulk.
6.
In the Credit Control field, mark whether Portfolio checks are to be included in
the cash inflow, and in the provision for cash outflow.
Includes Stock Portfolio Mark this option to include the value of portfolio
checks in the cash inflow statement. In the Status column, mark the statuses for
which portfolio checks will be considered as incoming cash flow.
Includes Cash Flow Provision Mark this option to include the value of
portfolio checks as a provision in the cash outflow statement. In the Status
10
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C O L LE C T IO N / P AY M EN T
M ET H O D
S E TU P
column, mark the statuses for which portfolio checks will be considered as
outgoing cash flow.
7.
Choose the Status Changes button to open the Status Change Configuration
window. Refer to Setting up status changes for portfolio checks on page 12 for more
information.
8.
In the Check Features and Restrictions field, select the default options for
cheques.
Default Billing Source Select whether the default origin for the collection
checks is customers own check or third-party checks. You can modify this
selection during transaction entry.
Default Personal Recipient Select the default use for customer's portfolio
checks, whether for deposits only, for deposits and payments, or for payments
only. You can modify this value in the Check Edit window, if you have used the
check in a way other than the default. Refer to Editing portfolio checks on page 91
for more information.
Default Third-party Recipient Select the default use for third party
portfolio checks, whether for deposits only, for deposits and payments, or for
payments only. You can modify this value in the Check Edit window, if you
have used the check in a way other than the default. Refer to Editing portfolio
checks on page 91 for more information.
9.
In the Withhold group, enter the names for the user-defined withhold
certificates that you require. You can specify a format to print these withhold
certificates in the Withhold Type Maintenance window. Refer to Maintaining
withhold types on page 27 for more information.
10. In the RG1547 - Payments field, enter the conditions to print the RG1547
reports. Refer to Generating the RG-1547 report on page 90 for more information.
Minimum Amount Enter a minimum payment amount as specified by the
tax authorities. The R.G 1547 reports are printed only if the total invoice amount
for a particular payment exceeds the minimum amount specified.
Payment Procedure Select the default payment procedure. The options are
Always Assume Cash, Always Assume Installments, or According to applied
amount.
A payment is considered as cash if the applied amount is equal to the invoice amount. A
payment is considered as credit if the applied amount is lower than the invoice amount.
11. Choose Save to save your settings, or choose Clear to clear all the values youve
entered.
12. Choose Redisplay to refresh the window with any information entered since
you last saved.
13. Choose Cancel to close the window without saving changes.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
11
PA RT
S E T U P
A N D
C A R D S
12
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C O L LE C T IO N / P AY M EN T
M ET H O D
S E TU P
2.
Select the original status for a portfolio check. Portfolio checks can have any of
the following statuses: Portfolio, Delivered, Deposited, Rejected, Deferred,
Exchanged, Voided, Proper, Reallocated Deferred, Collected.
3.
In the scrolling window, mark the statuses that a check of the selected status can
be changed to.
4.
In the Show field, select the statuses to be displayed in the scrolling window.
All Select this option to display all the available statuses in the scrolling
window.
Selected Select this option to display only the statuses that are marked in the
scrolling window.
5.
Choose Save to save the setup for the selected portfolio status.
6.
7.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
13
PA RT
S E T U P
A N D
C A R D S
2.
3.
4.
Choose Save to save the Group ID, or Clear to clear the values displayed in this
window.
5.
14
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C O L LE C T IO N / P AY M EN T
M ET H O D
S E TU P
2.
3.
4.
Mark the Active checkbox to use the collection or payment ID while entering
transactions.
5.
6.
7.
Enter or select a group ID for the collection or payment method in the Group ID
field.
8.
Select the default currency for the collection or payment method in the
Currency ID field.
9.
Mark the Allows Payment checkbox to use the selected payment ID to enter
payments.
10. Mark the Allows Collection checkbox to use the selected collection ID to enter
collections.
11. Mark the Affects Cash Balance checkbox to allow transactions entered using the
selected collection or payment ID to affect the cash balance. The cash balance is
affected only if you have also marked either the Allows payment or Allows
Collection options.
12. Mark the Uses Doc. Details checkbox to enter additional information when you
enter collections or payments.
13. Mark the Uses Status checkbox to track the status of the selected collection or
payment method if it is a Portfolio check. The Checkbook ID field is blank and
unavailable if this checkbox is marked along with the Allows payment and
Allows Collection checkboxes.
14. Mark the Affects Credit Limit checkbox to add the collection amount to the
customers credit limit balance and the payment amount to vendors credit
limit balance.
15. Mark the Uses Checkbook to make payments using a check number assigned to
a bank account ID.
16. Mark the Affects Bank Reconciliation checkbox to update the current checkbook
balance with the transaction amount for reconciliation.
17. Mark the Includes Cash Flow Provision checkbox to include the amount of the
portfolio check in the cash flow statement. This option is available only if the
Allows payment, Allows collection and Uses Status checkboxes are marked.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
15
PA RT
S E T U P
A N D
C A R D S
18. Mark the Includes Clearing checkbox to include the portfolio check in the cash
flow statement only after the specified number of clearing days.This checkbox
is available only if the Allows payment, Allows collection and Uses Status
checkboxes are marked.
The portfolio check is directly included in the cash flow statement if the Include
Clearing checkbox is not marked.
19. Select the type of collection/payment method in the Type field. The options are:
Individual CI, Third-Party CIs, Accepted Payment Means, Withhold, Rejection,
VAT Bond, Cash, Checks and Other.
20. Select an option in the RG1547 field to print a report using the collection/
payment method ID youve set up.
21. Choose Save to save the collection or payment method that you have set up.
22. Choose Clear to clear the values that are displayed in the window.
23. Choose Delete to delete the collection or payment method that you have set up.
16
C O LL E C T IO N
A N D
1.
2.
3.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C O L LE C T IO N / P AY M EN T
M ET H O D
S E TU P
4.
5.
6.
7.
Mark the CIR option to treat the income or expense type as a Credit Invoice.
Refer to Setting up credit invoice parameters on page 48 for more information on
credit invoices.
8.
Choose Save to save the income/expense type, Clear to clear the values entered,
or Delete to delete the displayed income/expense type.
2.
Enter a numbering ID, and a description for the ID you are creating.
3.
Enter a sequential number for the numbering ID in the Next Number field. This
number increases by one each time you enter a collection or payment for the
numbering ID.
4.
Choose Save to save the numbering ID, or Clear to clear the values displayed in
this window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
17
PA RT
S E T U P
A N D
C A R D S
5.
2.
Enter a bank account ID, and a description for the ID you are creating.
3.
Select the Active option for the bank account ID to be available during
transactions. Select Inactive to mark the bank account ID as inactive. You cannot
use an inactive bank account ID in transactions.
4.
Enter or select a default distribution account to associate with the bank account
ID. Choose the expansion button to open the Account Entry window and enter
an alias for the selected account.
5.
Choose the C.U.I.T field to open the Fiscal Key Entry window. Select the
document type and choose OK to return to the Bank Accounts Maintenance
window. Refer to Validating tax codes on page 38 for more information.
6.
7.
8.
Enter the number of days to clear own checks. This number will override the
number of clearing days youve set up in the Bank Branch Maintenance
window.
9.
10. Enter or select the operating currency of the bank account in the Currency ID
field.
18
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C O L LE C T IO N / P AY M EN T
M ET H O D
S E TU P
Setting up checkbooks
Use this information to set up checkbooks and to associate them with a bank
account ID.
To set up checkbooks:
1.
2.
3.
4.
5.
6.
Enter a starting check number and the ending check number for the checkbook
ID, in the Check: From Number and Check: To Number fields respectively.
7.
Enter the number of the next check in the Next Check Number field. Each time
you enter a payment in the Input of Payments window, this number increments
by one.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
19
PA RT
S E T U P
A N D
C A R D S
8.
9.
Enter a comment that provides a brief description about the Checkbook ID, if
required.
20
C O LL E C T IO N
A N D
1.
2.
3.
4.
Enter the name of the contact person for the bank branch ID that's displayed
5.
Enter the bank branchs address information, including phone and fax
numbers.
6.
Enter the number of days to clear the check for the selected bank branch ID.
7.
8.
9.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C O L LE C T IO N / P AY M EN T
M ET H O D
S E TU P
Stock Portfolio
Receipt Header
Receipt Lines
Payment Header
Payment Lines
Collection/Payment Means
Accrued Withholds
Withhold Details
2.
3.
Choose Add to create the folders and the links in the Smartlist.
4.
Choose Remove to remove the folders and links from the Smartlist.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
21
22
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 2:
Withholdings setup
A withholding tax is calculated based on the type of company, the tax plan and the
scale specified by the government. In Argentina, withhold is calculated on three
basic types of taxes: VAT, Income Tax and Gross Revenue Tax.
You can understand how to set up withhold details, and attach them to a withhold
plan. You can also define the slabs to calculate withhold, the withhold due dates,
and the base amount to calculate withhold on. This information is divided into the
following sections:
2.
3.
4.
5.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
23
PA RT
S E T U P
A N D
C A R D S
6.
Enter or select an account for the withhold detail ID in the Posting Account
field. Choose the expansion button to open the Account Entry window and
enter an alias for the selected account.
7.
8.
Enter the range for the base amount on which to calculate withholds in the
Subject Amount field.
Min Enter the minimum base amount. The withhold is calculated only if the
base amount is equal to or higher than the minimum subject amount.
Max Enter the maximum base amount.
9.
Enter the range for the withhold amount in the Withhold Amount field.
Min Enter the minimum amount to be retained. If the calculated withhold
amount is lower than the minimum amount, no withhold is calculated.
Max Enter the maximum amount that will be retained, even if the calculated
withhold amount is higher than the maximum amount. The withhold amount
will be equal to the amount entered.
10. To determine how the withhold amount will be calculated during transaction
entry, mark the necessary checkboxes.
Minus minimum amount The base amount to calculate withhold is arrived
at by subtracting the minimum base amount for the withhold detail ID from the
taxable amount of the invoice.
Takes accrued payments The base amount to calculate withhold is the
sum of all the payments made to a vendor in a month. Only those payments are
considered on which no withhold was calculated while making the payment.
Minus accrued withholding The calculated withhold amount is arrived at
by subtracting the accrued withholds for the vendor in the month from the
withhold amount for the invoice.
Calculate total based on first payment The entire withhold amount for
an invoice with multiple installments is deducted from the first payment made
to the vendor.
The payment amount cannot be less than the withhold amount.
Calculate based on total payment Mark this option to calculate
withholds in a single line in the Edicion de Retenciones window for similar
withhold detail IDs when you apply a payment to more than one invoice. This
field is unavailable if the Requests withhold base checkbox is marked.
11. Mark the Paid Voucher Details checkbox to print details of all the invoices or
receipts on which the withhold was calculated.
24
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
W I T HH O L D I N GS
S E T U P
12. Mark the Requests withhold base checkbox to override the taxable base ID and
enter a different base amount for calculating withhold while making a
payment. This field is unavailable when the Calculate based on total payment
checkbox is marked.
13. Enter the tax registration number of the company issued by the tax authority in
the Registration Number field.
14. Choose the Regime field to open the Withholdings - Tax/Regime window.
15. Enter the Tax ID and the Regulation ID. Choose Save to save the information
you have entered. These values will default in the Regime field in the Withhold
Details Maintenance window.
16. Choose Save to save your changes and return to the Withhold Details
Maintenance window.
17. Enter the number of copies of the tax report that will be printed.
18. Enter or select a Numbering ID to specify the numbering sequence for each
withhold detail.
19. Enter or select a withhold Scale ID. Refer to Entering withhold scales on page 27
for more information.
Any value entered in the Scale ID field will override the value entered in the Percentage
field.
20. Enter or select a Base ID to calculate withhold on.
21. Choose Save to save the withhold detail ID you have set up.
22. Choose Clear to clear the values displayed in the window.
23. Choose Delete to delete the withhold detail ID youve set up.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
25
PA RT
S E T U P
A N D
C A R D S
26
C O LL E C T IO N
A N D
1.
2.
Enter a withhold plan ID in the Withhold Plan ID field and a description for the
ID you are setting up.
3.
To add withhold details to the plan, complete the following steps for each detail
you want to add:
In the Available Details ID list, select the plan detail you want to add.
4.
Choose Remove to remove the selected tax plan from the Selected Details ID
list.
5.
Choose Copy to open the Copy Withhold Plan window. You can copy the
withhold detail IDs from an existing withhold plan to the one that you are
setting up.
6.
Select the plan ID to copy the withhold detail IDs from, and choose OK to close
the Copy Withhold Plan window. The withhold detail IDs will be displayed in
the Selected Details ID list, along with any previous entries.
7.
8.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
W I T HH O L D I N GS
S E T U P
2.
Enter a withhold scale ID, and a description for the ID you are creating.
3.
Enter an amount to be the lower limit for the slab in the From column of the
scrolling window.
4.
Enter an amount to be the upper limit for the slab in the To column of the
scrolling window.
Be sure that you have entered as many 9s as possible in the To column for the last slab
that you enter in the scrolling window. If you dont, then no withhold will be calculated
for an amount higher than what you have specified.
5.
Enter a fixed amount to be retained for each slab in the Fixed Amount column.
6.
Enter the withhold percentage for each slab in the Perc. field.
7.
Choose Save to save the withhold scale ID you have set up.
8.
9.
Choose Delete to delete the withhold scale ID you have set up.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
27
PA RT
S E T U P
A N D
C A R D S
2.
Enter a withhold type ID and the description for the withhold type ID.
3.
You can select one of the specified print certificates or you can select to print a
user-defined certificate. You must have entered the name for the user-defined
certificates in the Billing/Payment Methods Configuration window. Refer to
Setting up defaults for collection and payments on page 10 for more information.
INC Withhold cert Select this option to print an income tax certificate.
GI Withhold cert Select this option to print a gross revenue tax certificate.
GI II Withhold cert Select this option to print a gross revenue tax certificate.
VAT Withhold cert Select this option to print a value added tax certificate.
SUSS Withhold cert Select this option to print the SUSS tax reports.
4.
Select a format to print the certificate in the Form field. You can select from 15
different formats to print the withhold certificates for INC, GI, GI II and VAT.
The SUSS and the user-defined withhold certificates can be printed only in the
default format available for each of them.
5.
Enter the first day of the range that make up a withhold period in the From Day
column of the scrolling window.
6.
Enter the last day of the range that make up a withhold period in the To Day
column of the scrolling window.
7.
Enter the day on which withhold is payable for the range in the Payday column
of the scrolling window.
8.
Mark the Next Month checkbox if the payment date is to be carried forward to
the next month of the scrolling window.
You can enter multiple ranges of dates in the scrolling window.
28
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
9.
W I T HH O L D I N GS
S E T U P
Choose Save to save the withhold type ID you have set up.
2.
Enter a Base ID, and a description for the ID you are creating.
3.
The withhold base amount is calculated based on the selections you have made
for the displayed Base ID.
Purchases Mark this checkbox to exclude the purchase amount while
calculating withhold.
Discount Mark this checkbox to exclude the discount amount while
calculating withhold.
Freights Mark this checkbox to exclude the freight charges while calculating
withhold.
Taxes Mark this checkbox to exclude the tax amount while calculating
withhold.
Various Charges Mark this checkbox to exclude the miscellaneous charges
while calculating withhold.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
29
PA RT
S E T U P
A N D
C A R D S
4.
In the Calculate Based On: group, select an option to calculate the withhold.
This group is unavailable if you have marked the Taxes checkbox.
Tax Mark this option to calculate the withhold based on taxes.
Basis Mark this option to calculate the withhold based on the base amount.
Tax+Base Mark this option to calculate the withhold based on the tax
amount and the base amount.
5.
Select a tax detail ID from the Available Details list, and choose Insert to add it
into the Selected Details ID list.
6.
7.
Choose Copy to open the Copy Tax Base window, where you can copy the tax
detail IDs from an existing withhold base to the one that you are setting up.
8.
Select the base ID to copy the withhold detail IDs from, and choose OK to
return to the Tax Bases Maintenance window. The withhold detail IDs are
displayed in the Selected Details ID list, along with any previous entries.
9.
Choose Save to save the withhold base ID you have set up.
10. Choose Delete to delete the withhold base ID displayed in the window.
30
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 3:
2.
3.
4.
Enter the province code in the Code for File field. This code will be used for the
selected province ID in the file that is exported to SICORE.
5.
6.
7.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
31
PA RT
S ETU P
AND
CARD S
2.
3.
Enter the condition code in the Code for File field. This code will be used for the
selected condition ID in the file that is exported to SICORE.
4.
5.
Choose Clear to clear the values that are displayed in the window.
6.
32
C O LL E C T IO N
A N D
1.
2.
3.
4.
Enter the tax code in the Code for File field. This code will be used for the
selected tax ID in the file that is exported to SICORE.
5.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
M A G N E T I C
F IL E
6.
Choose Clear to clear the values that are displayed in the window.
7.
S E T U P
2.
3.
4.
5.
Enter the file code to be exported to SICORE for the selected regimen ID in the
Code for File field.
6.
7.
Choose Clear to clear the values that are displayed in the window.
8.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
33
PA RT
S ETU P
AND
CARD S
2.
3.
4.
The Tax Entity field displays the government agency which collects taxes.
5.
Enter the file code to be exported to SICORE for the selected operation ID in the
Code for File field.
6.
7.
8.
34
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
M A G N E T I C
F IL E
S E T U P
2.
Enter the code to be associated with each sales document in the Sales column.
3.
4.
2.
The Tax Entity field displays the government agency to which the file will be
exported.
3.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
35
PA RT
S ETU P
AND
CARD S
PM Transactions
transaction details.
Subjects Select this option to set up the file format for vendor/customer
details. The transactions for the vendor/customer details will be included in the
transaction report.
You must have set up the transaction type of files and the subject type of files in this
window before you can generate the subject files in the Sicore Export window. Refer to
Exporting Sicore data on page 89, for more information.
4.
Enter the file name to be generated in the File Name to create field. This file will
contain the details that are displayed in the scrolling window.
5.
Point
Comma
6.
In the Field column, select the transaction related field or the subject related
field to export to SICORE.
7.
Select the type of the transaction field or subject field in the Type column.
Select this option if the field already has a value entered in it.
Entire
Decimal
Date
Text
8.
Enter the field position for each field you have selected.
9.
Enter the field length for each field you have selected.
10. Choose Save to save the file you have set up.
11. Choose Clear to clear the values that are displayed in the window.
12. Choose Delete to delete the file you have set up.
36
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
M A G N E T I C
F IL E
S E T U P
2.
3.
Select the country for which you want to set up the tax code in the Mask field,
whether Argentina, Uruguay or Paraguay.
4.
5.
Mark the checkboxes for which you want the validation to take place in the
Customer/Vendor Maintenance windows. Choose OK to save the changes and
return to the Fiscal Code Configuration window.
6.
In the Enable for field, mark the modules where the tax codes will be used.
Accounts Receivable Mark this option to validate the tax registration code
for customers.
Accounts Payable Mark this option to validate the tax registration code for
vendors.
Company Mark this option to validate the tax registration code for the
company youre logged into.
7.
8.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
37
PA RT
S ETU P
AND
CARD S
2.
The Customer ID, Supplier ID, Company ID, or Bank ID fields display the ID
for the selected customer, vendor, company, or bank respectively.
3.
The Name field displays the name corresponding to the selected customer,
vendor or company ID.
4.
Enter or select the document type to base your validation on in the Document
Type field. This field is unavailable while validating tax codes for banks.
5.
The document type that you select is displayed below the Document Type field.
Enter the tax code in this field for validation. If the tax code you have entered is
valid, then it will default in the Tax Registration field of the selected Customer,
Vendor or Company Maintenance window.
The C.U.I.T number assigned to a bank will appear in the RG-1547 reports. You
can view these numbers in the reports only if you have selected the Check
endorsement or Checks or cancellation checks option in the R.G.1547 field, in
the Collection/Payment Means Maintenance window. Refer to Maintaining
collection and payment methods on page 14 for more information.
You can assign a single tax registration code to multiple customers, vendors or
companies and banks.
38
C O LL E C T IO N
A N D
6.
7.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
M A G N E T I C
F IL E
S E T U P
2.
The Tax ID and the Description fields display the tax detail ID selected in the
Tax Detail Maintenance window and the description respectively.
3.
Select the tax class to which the selected tax detail ID belongs, in the Class field.
4.
Choose OK to save your settings, or choose Cancel to close the window without
saving your changes.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
39
40
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 4:
Cards
Use this information to create and maintain master record information that can be
used while entering transactions. You can create master records for the various
collection and payment methods that you will use. Use this information to assign
withhold plans to vendors. You can set up the tax condition codes for customers
and vendors. You can also define the C.U.I.T format.
This information is divided into the following sections:
2.
3.
The Name field displays the name for the selected vendor ID from the Vendor
Maintenance window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
41
PA RT
S E T U P
A N D
C A R D S
4.
Enter or select a withhold plan ID in the With. Plan ID field. The Description
field displays the description for the selected withhold plan ID. The scrolling
window displays all the withhold type IDs assigned to the withhold plan ID,
along with their description.
5.
6.
Enter the cut-off date up to which to calculate the exemption on withhold in the
To column.
7.
Enter the percentage of reduction for the selected withhold ID up to the cut-off
date Percentage column.
8.
Enter the date of the bulletin published by the tax authority for the reduction of
withhold percentage in the F.Public column.
9.
Enter a second cut-off date and reduction percentage if required for the selected
withhold ID. You can enter as many cut-off dates and percentages as required.
10. The amount of reduction/exemption for each withhold ID will be calculated for
all transactions that fall within the specified date.
11. Choose Save to save the withhold plan that you have set up.
12. Choose Clear to clear the values that are displayed in the window.
13. Choose Delete to delete the withhold plan that you have set up.
42
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C AR D S
2.
Enter or select a vendor ID in the Supplier ID field. The vendor class that the
selected supplier belongs to is displayed in the Class ID field.
3.
Select the Operations Source for the supplier, whether Local, Free Zone,
External, or Internal.
4.
5.
Mark the Controls CAI option to verify the CAI number during transactions.
6.
7.
Enter the country TIN if you have selected External in the Operations Source
field.
8.
Enter the Customs Code and the Destination Code if you have selected Free
Zone, or External in the Operations Source field.
9.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
43
PA RT
S E T U P
A N D
C A R D S
13. Select the Gross Income Status for the supplier, whether Local, Multilateral
Agreement, Non Registered or Simplified Regime.
14. Enter the IB Registration number. This field is available only if youve selected
Local, Multilateral Agreement or Simplified Regime as the gross income status.
15. Choose Save to save the values entered, or Clear to clear the displayed values.
16. Choose Delete to delete the additional information you have entered for the
selected vendor.
44
C O LL E C T IO N
A N D
1.
2.
3.
4.
Enter the default type of transactions, whether Local, Free Zone, External or
Internal in the Predet. Source field. You can assign this as a default transaction
type for all the address IDs of the customer, or you can assign a different one for
each address ID in the scrolling window.
5.
The Country TIN field displays the CUIT number for the selected customer ID.
This field is available only when the customers taxpayer type ID is External.
6.
7.
Select the Gross Income Status for the customer, whether Local, Multilateral
Agreement, Non Registered or Simplified Regime.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
C AR D S
8.
Enter the IB Registration number. This field is available only if youve selected
Local, Multilateral Agreement or Simplified Regime as the gross income status.
9.
In the scrolling window, select a Tax ID. The Description column displays the
description for the selected tax ID.
10. Select the condition for the tax ID in the Condition column.
You can select multiple tax IDs and set the conditions to calculate taxes.
11. The second scrolling window displays all the address IDs for the customer. You
can assign a different transaction type to each address ID if required.
12. Choose Save to save the values entered, or Clear to clear the displayed values.
13. Choose Delete to delete the additional information you have entered for the
selected customer.
2.
3.
4.
5.
6.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
45
PA RT
S E T U P
A N D
C A R D S
The Client ID and the Address ID fields display the customer ID and the
Address ID respectively from the Customer Maintenance window.
2.
Enter or select the province ID. You must have set up these province IDs in the
Province Configuration window. Refer to Setting up the province codes on page 31
for more information.
3.
Choose Save to save the information that you have set up.
4.
The Supplier ID and the Address ID fields display the values from the Vendor
Maintenance window.
46
C O LL E C T IO N
A N D
2.
Enter or select the province ID. You must have set up these province IDs in the
Province Configuration window. Refer to Setting up the province codes on page 31
for more information.
3.
Choose Save to save the information that you have set up.
4.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 5:
Credit Invoices
Use this information to set up the parameters for credit invoices, enter credit invoice
receipts, and view all the credit invoices that you have issued against vendor tax
invoices. You can print or cancel credit invoices if required. You also can print the
credit invoice reports for sales and purchasing.
This information is divided into the following sections:
2.
3.
Enter the tax condition code to be used for the company in the Tax Code field.
4.
Choose OK to save the code entered, or choose Cancel to close the window
without saving the code.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
47
PA RT
S E T U P
A N D
C A R D S
2.
Enter a two-digit alphanumeric code to identify the condition you are setting
up. Enter a description for the code.
3.
Select the tax condition option for the code in the Tax Condition field.
4.
5.
Choose Save to save the tax condition code you have set up. Choose Clear to
clear the values displayed, or choose Delete to delete the displayed tax
condition code.
48
C O LL E C T IO N
A N D
1.
2.
3.
Enter the minimum amount for considering a credit invoice. All invoices whose
values are less than the minimum amount specified here will be exempted from
being considered a credit invoice.
4.
Enter or select the numbering ID from which to obtain the credit invoice
numbers.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
CRE DI T
INV O ICE S
5.
6.
Select the procedure to be followed when an unpaid and over due cash receipt
exists.
Same original term The credit invoice is generated with the same expiry
period as the fiscal invoice, from the date of issue of the credit invoice.
Other cash period The credit invoice is generated and the due date is equal
to the number of days to be considered as cash, beginning from the issue date of
the credit invoice.
Do not generate No credit invoice is generated, and the due date of the
fiscal invoice is not modified.
7.
Enter the text to be printed to identify the receipts for which no credit invoice
needs to be issued. This text must be entered as the first line of the notes
associated with the receipt number.
8.
Choose Save to save the credit invoice parameters you have set up, or choose
Delete to delete the parameters displayed in this window.
2.
3.
Enter the receipt number in the CIR Number field. This receipt number is given
for the tax invoices that will be cancelled.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
49
PA RT
S E T U P
A N D
C A R D S
4.
5.
6.
The CIR Amount field displays the total amount of the selected invoices that are
to be cancelled.
7.
The Voucher Number column in the scrolling window displays all the credit
invoice receipts for the selected vendor ID that are associated with the tax
invoices.
8.
9.
50
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
CRE DI T
INV O ICE S
2.
3.
The scrolling window displays the details of all the credit invoices that are
associated with the cancelled tax invoices.
4.
You can specify the net withholding amount in the Accepted Amount column.
5.
6.
Choose Redisplay to refresh the window displayed with any new information
since you opened the window.
7.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
51
PA RT
S E T U P
A N D
C A R D S
2.
Enter the date range to select the invoices from in the From Date and Up To
Date fields. All the invoices within the specified date range are displayed in the
scrolling window.
3.
Mark the Generate checkbox to select the invoices to generate the credit invoice
for.
4.
Select Mark All to select all the displayed invoices, or Unmark All to clear the
selection.
5.
In the View field, select All to view all invoices within the range, or select
Selected option to display only the invoices that are marked.
6.
Choose Select to select all the marked invoices for generating the credit invoice.
7.
Choose Process to generate the credit invoices for all the selected documents.
8.
52
C O LL E C T IO N
A N D
1.
2.
Enter the date range to select the invoices from in the From and To fields. All the
credit invoices within the specified range are displayed in the scrolling window.
3.
4.
5.
Enter a date of rejection/voiding for each selected invoice, and enter a reason of
rejection/voiding in the Refusal Reason column.
6.
7.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
8.
CRE DI T
INV O ICE S
2.
3.
Enter the date range depending on the report you have selected.
CI Book Enter the date range in the From Date and To Date fields.
Reprint CI Enter the date range in the From Date and To Date fields. Also
enter the range of credit invoice numbers to be reprinted in the From CI and To
CI fields. Also enter the range of credit invoice numbers to be printed in the
From FF and To FF fields.
Reprint CIR Enter the date range in the From Date and To Date fields. Also
enter the range in the From CI and To CI fields.
4.
Choose Print to print the selected report for the selected ranges.
5.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
53
PA RT
S E T U P
A N D
C A R D S
54
C O LL E C T IO N
A N D
1.
2.
Enter the date range for the report in the From Date and To Date fields.
3.
Enter the range of credit invoice numbers for which to print the report.
4.
Choose Print to print the report for the selected range, or Choose Cancel to close
the window without printing the report.
P AY M EN T
M ET H O DS
W IT HH O LD S
PART 2: TRANSACTIONS
Part 2: Transactions
You can enter a single receipt or payment using a combination of the collection/
payment methods.
The following information is discussed:
56
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 6:
Receivables Transactions
Use this information to enter collections from customers. A single cash receipt can
include a combination of collection methods in different currencies.
This information is divided into the following sections:
2.
3.
The Doc. Number field displays the document number for the receipt ID. This
number is a combination of the numbering ID and the next number for the
numbering ID.
4.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
57
PA RT
T R A N S AC T I O N S
5.
Enter the receipt date in the Date field. Choose the Date expansion button to
open the Receipt Date Entry window, where you can enter a posting date for
the collection type.
6.
7.
Enter or select a customer ID if the entity type is Client in the Client ID field.
8.
The Currency ID field displays the default currency for the customer. It displays
the functional currency if you have selected Miscellaneous as the entity type.
9.
10. Choose the Collection Means button to open the Collection Means Entry
window, where you can enter the collection methods. Refer to Entering collection
methods on page 59 for more information.
11. Choose the Distribution button to view the posting accounts that the receipt
will be posted to, or select other accounts for posting. Refer to the Receivables
Management documentation for more information on Distribution.
12. Choose Apply to apply the collection to individual posted documents. Refer to
the Receivables Management documentation for more information on
Applying Sales Documents.
If the collection method is set up as a Portfolio Collection, Portfolio Exchange or
Portfolio Transfer in the Income/Expense Types Maintenance window, the Apply button
in the Cash Receipts Entry window will be replaced by Portfolio button.
13. Choose the Portfolio button to enter the checks for the various collection
methods. Refer to Entering portfolio checks on page 64 for more information.
14. Choose Save to save the receipt ID you have setup.
15. Choose Post to post the transaction.
16. Choose Delete to delete the receipt ID.
17. Choose Auto Apply to apply the receipt to as many documents as the document
being applied allows.
58
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
R E C E I V A B L E S
T R A N S A C T I O N S
2.
The Client ID, Type, Name and Document No. fields display the client ID, the
receipt type, the name of the client and the document number respectively for
the collection type you have set up in the Cash Receipts Entry window.
3.
4.
Enter or select a bank account ID. This field is available only if you have marked
the Affects Bank Reconciliation checkbox for the selected Collection/Payment
method in the Collection/Payment Means Maintenance window.
5.
Enter additional details for the collection means ID you have selected.
Bank ID Enter or select a bank ID in this field.
Check Source Displays the default billing source from the Billing\Payment
Methods Configuration window. Select a different check source, if required.
This option is unavailable if you have unmarked the Uses Status checkbox in
the Collection/Payment Means Maintenance window.
Document Number Enter the document number of the collection ID in this
field.
Location Enter the location in this field.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
59
PA RT
T R A N S AC T I O N S
Main Rec. No. Enter the record number for the collection ID in this field.
Date of Issue Enter the posting date of the receipt in this field. The posting
date by default will be the cash receipt date.
Due Date Enter the due date in this field. This field is available if you have
marked the Affects Bank Reconciliation checkbox and unmarked the Uses Doc.
Details checkbox in the Collection/Payment Means Maintenance window.
These fields are available only if you mark the Uses Doc. Details checkbox and unmark
the Affects Bank Reconciliation checkbox in the Collection/Payment Means
Maintenance window.
6.
7.
Enter the number of days to clear the check if you have marked the Uses Doc
Details checkbox in the Collection/Payment Means Maintenance window.
8.
The Currency ID field displays the currency that you have set up for the
selected customer ID in the Cash Receipts Entry window.
9.
Enter or select the customers tax ID in the Signers Tax ID field. This field is
unavailable if you unmark the Uses Doc. Details and the Uses Payment
Checkbox in the Collection/Payment Means Maintenance window.
10. Enter a brief comment for the collection if required in the Comment field.
11. Choose Insert to insert the collection method you have set up into the scrolling
window.
12. Repeat this procedure to enter cash received through another collection
method.
13. To modify a collection method, select the collection method in the scrolling
window and choose Modify to make changes.
14. To remove a collection method from the scrolling window, select the collection
method and choose Remove.
15. Choose OK to save the collection method you have setup.
16. Choose Clear to clear the values displayed in the window.
60
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
R E C E I V A B L E S
T R A N S A C T I O N S
Voiding receipts
Use the Cancellation of Several Receipts window to void the cash receipts from
third parties. Receipts that are moved to history cannot be voided.
To void receipts:
1.
2.
3.
4.
The Document Number column in the scrolling window displays the document
number of the cash receipt from the Cash Receipts Entry window.
5.
6.
The Date of Void column displays the date on which a collection was voided.
7.
The Due Date column displays the posting date of the collection.
8.
The Doc. Date column displays the document date of the receipt.
9.
Mark the Cancel checkbox for the collections you want to void.
10. Choose Mark All to select all the collections that are displayed in the scrolling
window for voiding.
11. Choose Unmark All to remove the selections for all the displayed collections.
12. Choose Void to void the selected collections. A financial batch is generated for
the voided document.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
61
PA RT
T R A N S AC T I O N S
2.
3.
The Description field defaults the description of the selected tax schedule ID.
4.
Select the sales document type in the Type column, to which to assign the
selected tax schedule ID.
5.
6.
7.
62
C O LL E C T IO N
A N D
1.
2.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
R E C E I V A B L E S
T R A N S A C T I O N S
3.
4.
5.
6.
7.
The Document Number field displays the document IDs that you have assigned
to the tax schedule ID linked to the selected customer ID.
You can only view the document IDs here if you have already assigned them to the
customers tax schedule ID in the Tax Plan Further Details window. Refer to Assigning
tax schedules to sales documents on page 62 for more information.
8.
Select a document ID and choose select to default or change the document type
in the Sales Transaction Entry window.
9.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
63
PA RT
T R A N S AC T I O N S
2.
The Entity ID, Document No. and the Name fields display the client ID,
document number and the description from the Cash Receipts Entry window.
3.
4.
5.
6.
7.
Select the check and choose OK to insert it in the Portfolio Selection window.
8.
The details of the selected check will be displayed in the scrolling window.
9.
To remove the check from the scrolling window, select the check and choose
Remove.
10. The Distributed Control Total field displays the total payable amount in
functional and originating currencies.
11. Choose OK to save the selected portfolio check.
64
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
R E C E I V A B L E S
T R A N S A C T I O N S
2.
The Means ID and the Client ID fields display the payment method ID and the
customer ID respectively.
3.
4.
All the portfolio checks entered for the selected Means ID, based on the search
criteria, will appear in the scrolling window.
5.
6.
Choose Mark All to select all the portfolio checks that are displayed in the
scrolling window.
7.
Choose Unmark All to clear the selection for all the portfolio checks that are
displayed in the scrolling window.
8.
9.
Choose Cancel to cancel the selection of portfolio checks and close the window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
65
PA RT
T R A N S AC T I O N S
66
C O LL E C T IO N
A N D
1.
2.
In the Search By field, select the criterion to filter the documents. The options
are Check No., Payment Date / Due Date, Enter Date, Issue Date, Bank ID,
Functional Amount, Originating Amount, Clearing, or Check Source.
3.
Enter the range for the selected criterion in the From and To fields respectively.
4.
Choose Insert to insert the range and then enter any additional ranges if
necessary.
5.
Highlight a range and choose Remove to remove a range from the search.
6.
Choose OK to run the search and close the window. The documents fulfilling
the search criteria are displayed in the Checks in Portfolio scrolling window.
7.
Choose Cancel to cancel the search and return to the Checks in Portfolio
window.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 7:
Payables Transactions
Use this information to enter payments using a combination of payment methods.
You can change the base amount for withholds, or edit the withhold amount. You
can also generate a batch of payments, or void a payment.
This information is divided into the following sections:
Entering payments
Searching for payables documents to apply
Entering payment methods
Selecting checks in wallet
Defining the search criteria for checks in wallet
Changing the base amount for withholds
Editing withholds
Generating payment batches
Voiding payments
Differentiating withholds
Entering payments
Use the Input of Payments window to enter the payments made to the vendors or to
other third party entities. You can also use this information to deposit a cash receipt.
You can make a single payment using a combination of payment methods. You
must apply the payment to the appropriate document, either by auto-applying the
payment or by applying it manually to specific documents. Payments can be
entered individually or in a batch.
To enter payments:
1.
2.
3.
The Document No field displays the next document number for the payment
ID.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
67
PA RT
T R A N S AC T I O N S
4.
5.
The Date field displays the document date for the payment. Choose the Date
expansion button to open the Accounting by CP Dates window, where you can
enter a posting date for the payment.
6.
7.
Enter or select a vendor ID in the Supplier ID field if the entity type is Suppliers.
This field is unavailable for Miscellaneous and Deposit entity types.
8.
The Beneficiary field displays the description entered in the Check Name field
of the Vendor Maintenance window for the selected vendor ID.
9.
Enter or select the check ID in the Checkbook ID field if the entity type is
Miscellaneous.
68
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
14. Choose Search in the Apply Payables Documents window to open the Search
Payables Documents to Apply window. Refer to Searching for payables documents
to apply on page 70 for more information. You can select the documents to which
to apply the payments. Refer to the Payables Management documentation for
more information on applying payables documents.
15. Choose the expansion button next to the Unapplied Amount field in the Apply
Documents window to open the Advance Withholds window. You can change
the withholds base amount here to calculate withholds. Refer to Changing the
base amount for withholds on page 75 for more information.
16. Choose OK to return to the Input of Payments window.
17. In the Input of Payments window, the Amount field displays the total amount
being paid.
18. You can view the applied, unapplied, withhold and payment amount in the
Amount box.
Applied Displays the amount of the payment applied to the selected vendor's
vouchers.
Not Applied Displays the amount of payment not applied to any vouchers.
Withholds Displays the withholding amount taken for this payment. Choose
the expansion button next to the Withholds field to open the Withhold Edit
window. Refer to Editing withholds on page 76 for more information.
To be Paid Displays the total amount to be paid. For a vendor payment, the
total amount is the sum of applied and unapplied amounts minus withholds, if
any.
For a miscellaneous or deposit payment, the total amount is the sum of all the
values entered in the Payment Means Entry window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
69
PA RT
T R A N S AC T I O N S
19. Choose the Payment Means button to open the Payment Means Entry window.
You can enter the various means by which you are making the payment. Refer
to Entering payment methods on page 71 for more information.
20. Choose the Distribution button to view the posting accounts that the payment
will be posted to, or select other accounts for posting.
21. The Accepted Discounts field displays the discount amount youve taken as per
the payment terms for the vouchers this payment is applied to.
22. The Available Discounts field displays the discount amount available as per the
payment terms for the vouchers that this payment is applied to.
23. Choose Save to save or Post to post the payment youve entered. You can print
the withhold certificate and the payment order that youve posted.
24. Choose Delete to delete the payment ID youve set up.
25. Choose Auto apply to apply the transaction to as many documents as the
amount being applied permits. Refer to Auto applying transactions in Payables
Management documentation for more information.
70
C O LL E C T IO N
A N D
1.
2.
The Supplier ID and the Name field default from the Apply Payables
Documents window.
3.
Select the document type, whether Invoice, Finance Charge, Misc Charge or All.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
4.
P AY AB L E S
T R A N S A C T IO N S
5.
Select whether to search the documents by Document date, Posting date or Due
date in the Select Date field. Select All, or enter a date range in the From and To
fields.
6.
7.
Select the type of range to include in the Range field. The options are All, Is
equal to, Is between, Is greater than and Is less than. Enter the amount for the
selected range.
8.
9.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
71
PA RT
T R A N S AC T I O N S
2.
The Entity ID, Document No., Name fields display the vendor ID, document
number and the description respectively for the payment ID you have set up in
the Input of Payments window.
3.
The Functional Amount field displays the payment amount in the functional
currency for the vendor.
4.
The Payment Total field displays the total amount to be paid to the vendor in
the originating currency.
5.
The Currency ID field displays the currency from the currency ID youve set up
in the Input of Payments window.
6.
7.
Choose Examine Values to open the Checks in Wallet window which displays
all the portfolio type of checks for the selected payment method ID. Refer to
Selecting checks in wallet on page 73 for more information.
The Checks in Wallet window opens only if youve marked the Uses Status checkbox for
the selected payment method ID in the Collection/Payment Means Maintenance
window.
72
C O LL E C T IO N
A N D
8.
Enter or select a bank account ID. This field is available only if youve marked
the Affects Bank Reconciliation checkbox and unmarked the Uses Status
checkbox for the selected payment method ID in the Collection/Payment
Means Maintenance window. Refer to Maintaining collection and payment methods
on page 14 for more information.
9.
The Bank ID field displays the bank name for the selected bank account ID.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
10. Enter or select the checkbook ID for the selected bank account in the Checkbook
ID field.
11. The Bank Branch ID field displays the bank branch ID for the selected bank ID.
12. Enter a payment date in the Due Date field. This field is not available if youve
marked the Uses Status checkbox for the selected payment method ID in the
Collection/Payment Means Maintenance window. Refer to Maintaining
collection and payment methods on page 14 for more information.
13. Enter an issue date in the Issue Date field.
14. Enter the total payment amount.
15. The Document Number field displays the sequential number for the selected
checkbook ID.
16. Enter the number of days for clearing the check in the Clearing field.
17. The Signers Tax ID field displays the vendors tax ID that youve set up in the
Signers Maintenance window.
18. Enter a brief comment for the payment method, if required.
19. Choose Insert to insert the payment method you have set up into the scrolling
window. Once you have inserted a payment into the scrolling window, you can
repeat the above procedure to enter as many payment methods as you require.
20. To modify a payment method, select the payment method in the scrolling
window and choose Modify to make changes.
21. To remove a payment method from the scrolling window, select the payment
method and choose Remove.
22. To void a payment method from the scrolling window, select the payment
method and choose Void.
23. Choose OK to save the payment method you've entered.
24. Choose Clear to clear the payment methods entered in the window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
73
PA RT
T R A N S AC T I O N S
2.
The Method ID field displays the payment method ID from the Payment Means
Entry window.
3.
4.
Mark the Filter by Clearing checkbox to enter the number of days to clear the
check in the clearing field.
5.
Choose Redisplay to refresh the scrolling window with any information entered
since you last saved.
6.
Choose Search to open the Search window. Refer to Defining the search criteria for
checks in wallet on page 75 for more information.
7.
All the portfolio checks entered for the selected method ID, based on the search
criteria, will appear in the scrolling window.
8.
9.
Choose Mark All to select all the portfolio checks that are displayed in the
scrolling window.
10. Choose Unmark All to clear the selection for all the portfolio checks that are
displayed in the scrolling window.
11. Choose OK to insert the selected portfolio checks in the Payment Means Entry
window.
12. Choose Cancel to cancel the selection of portfolio checks and close the window.
74
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
2.
3.
Enter the range for the selected criterion in the From and To fields respectively.
4.
Choose Insert to insert the range and then enter any additional ranges if
necessary.
5.
Highlight a range and choose Remove to remove a range from the search.
6.
Choose OK to run the search and close the window. The documents fulfilling
the search criteria are displayed in the Checks in Wallet scrolling window.
7.
Choose Cancel to cancel the search and return to the Checks in Wallet window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
75
PA RT
T R A N S AC T I O N S
2.
The Payment Number field displays the document number for the selected
payment type ID.
3.
4.
5.
The Name field displays the description for the selected vendor.
6.
7.
The Advance Payment Amt. field displays the unapplied amount for the
document.
8.
Select the withhold detail ID in the With. Detail ID column. You can select only
those withhold detail IDs for which you have marked the Calculate based on
total payment checkbox in the Withhold Details Maintenance window. Refer to
Adding withholding details on page 23 for more information.
9.
Enter an amount in the Taxable Amount column. This will be the default base
amount in the Withhold Edit window. Refer to Editing withholds on page 76 for
more information.
The amount in the Taxable Amount column should be less than or equal to the
unapplied amount.
Editing withholds
Use this information to modify the withhold amount for the vendor you have
selected in the Input of Payments window. Withhold amounts for similar withhold
76
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
detail IDs can be calculated in single line when you apply a payment to more than
one invoice.
To edit withholds:
1.
2.
The Type ID, Document No., Supplier ID, Name fields display the default
values from the Input of Payments window. The Source Amount field and the
Functional Amount fields display the document amount in the originating and
the functional currencies respectively.
3.
The Withhold ID column displays the withhold IDs of a withhold plan set up
for a particular vendor.
4.
The Document No. column displays the default document number for the
selected payment.
5.
The Document Type displays the document type for the selected vendor ID.
6.
The Base Amount column displays the taxable amount for the particular detail
ID youve entered in the Advance Withholds window. Refer to Changing the base
amount for withholds on page 75 for more information. For the invoices applied,
the amount is based on the withhold plan that you have selected in the
Withhold Plan Maintenance window. Refer to Setting up withhold plans on
page 25 for more information.
7.
The Withhold Amount column displays the total amount to be retained. The
withhold is calculated on the base amount based on the percentage specified in
the Withhold Details Maintenance window. Refer to Adding withholding details
on page 23 for more information.
8.
Choose Delete to delete all the withholds that are calculated. The total withhold
amount for the payment will then be zero.
9.
Choose default to display the withhold you had last set up for the withhold
detail ID. The withhold will be recalculated if there is any change in the base
amount.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
77
PA RT
T R A N S AC T I O N S
2.
Enter a batch ID to build a batch in the Batch ID field or select a batch ID to add
a payment record.
3.
The Batch Total field displays the amount paid to the vendors currently selected
in the batch.
4.
5.
6.
78
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
7.
8.
The Account ID field displays the bank account ID you have selected.
9.
10. The Description field displays the description for the checks.
11. Choose OK to include the checks in the batch in the Payment Batch Generation
window.
12. Choose Cancel to close the window without saving and return to the Payment
Batch Generation window.
13. The Currency ID field displays the currency ID set up for the selected payment
method ID.
The currency ID for the selected payment method ID and the bank account ID should be
the same.
14. Choose the Currency ID expansion button to open the Exchange Entry Zoom
window where you can view exchange rate information for the batch.
15. Enter the payment date for the batch ID in the Due Date field.
16. Select from the list of vendors to pay in the Select supplier by field by Supplier
ID, Suppliers Name, Class ID, or Payment priority.
All Includes all vendors in the range.
From Enter the starting and the ending ID for name, class or priority to
include in the vendor range in the From and To fields respectively.
17. Select a range of documents to pay by voucher number or document number in
the Select document by field.
All Includes all the unpaid invoices, finance charges, miscellaneous charges,
returns, unapplied payments, and credit memos for the vendors selected in the
vendor range.
From Enter the starting and the ending voucher number or document number
to include in the document range in the From and To fields respectively.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
79
PA RT
T R A N S AC T I O N S
18. The Date maturity closed field limits the vouchers to be included for payment
in the batch.
None Mark this option to include all the vouchers within the vendor and
document ranges you have specified.
Due Date Mark this option and enter a cutoff date for vouchers to include the
vouchers with due dates on or before the specified date.
19. The Date discount closed field limits the vouchers included for payment in the
batch, based on the discount date.
None Mark None if you do not want to use vouchers' discount dates as a
selection criterion.
All Mark All to include all vouchers with discounts available in the batch.
Discount Date Mark Discount Date and enter a cutoff date for vouchers
with discounts available to include the vouchers with discounts that will expire
before the date you specify in the selected ranges.
20. Select an option from the Select documents field to restrict the range of
documents to pay. The documents must meet all the other criteria specified and
the option you select here. The options change depending on whether the
currency ID assigned to this batch is the functional currency.
21. Mark the Payment, Credit notes, Returns checkboxes in the Automatically
apply these unapplied documents field to apply unapplied payments, credit
memos, and returns respectively for the selected vendors to vouchers in the
batch. The check amounts are reduced by the amounts of these documents. You
might want to mark this option to ensure that vouchers aren't paid twice.
Only working currency Mark the option to apply only those credit
documents that use the functional currency.
All currencies Mark this option to apply the credit documents of any
currency.
22. Mark the Take unclassified discounts checkbox to take all discounts for the
vouchers regardless of the discount date. If this option is unmarked, only the
discounts available on the check date are taken.
23. Mark the Pay Only Minimum checkbox to print a check for the minimum
payment amount for each vendor in the batch during the process of printing
checks. If this option is unmarked, the checks are printed for the total amount of
the vouchers selected in the batch. You can specify the minimum payment
amount for each vendor using the Vendor Maintenance Options window.
24. Enter or accept the date in the Apply date field thats used to determine if
discounts are available when processing checks.
25. Choose Generate batch to build the batch. Once the batch is created, the button
name changes to Add to batch to add a batch.
26. Choose Clear to clear the values displayed in this window.
80
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
Voiding payments
Use the Cancellation of Several Payments window to void payments made to third
parties, or deposit kind of payments. You can void both historical and open
transactions in Payables Management. To void payments in history, you must be
maintaining the transaction history for the vendor associated with the payment,
and the payment youre voiding must be fully applied to one or more transactions.
You can void an open payables transaction that have been posted and is unapplied.
You can void invoices for active and temporary vendors. If youre maintaining
history and you void a voucher, the voucher is moved to history along with any
distributions and tax information. If youre not maintaining history and you void a
voucher, that voucher is removed from the system.
To void payments:
1.
2.
3.
Select an option in the Entity Type field to display the types of payment in the
scrolling window.
All Select this option to display all types of payments.
Deposits Select this option to display payment deposits.
Miscellaneous Select this option to display payments from 3rd party.
4.
5.
The Document Number column in the scrolling window displays the document
number of the payment from the Input of Payments window.
6.
The Document Amount column displays the original amount of the payment.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
81
PA RT
T R A N S AC T I O N S
7.
The Date of Void column displays the date on which a payment was voided.
8.
The Due Date column displays the posting date of the payment.
9.
The Doc. Date column displays the document date of the payment.
10. Mark the Cancel checkbox for the payments you want to void.
11. Choose Mark All to select all the payments that are displayed in the scrolling
window for voiding.
12. Choose Unmark All to clear the selection for all the displayed payments.
13. Choose Void to void the selected payments.
Differentiating withholds
Use the PM Differentiated Withholds window to enter new base amounts for the
selected withhold detail ID. You can also add or modify the pre-determined base
amounts corresponding to the withhold plan for a particular transaction. The
withholds for the particular transaction will be calculated based on the withhold
plan set up in this window and will not consider the pre-determined withhold plan
of the vendor.
To differentiate withholds:
82
C O LL E C T IO N
A N D
1.
2.
The Supplier ID, Invoice and Total Amount fields display the default values
from the Payables Transaction Entry window.
3.
The Withhold Plan ID field displays the plan ID assigned to the selected vendor
in the Supplier Maintenance - Other Data window. Refer to Entering additional
information for vendors on page 42 for more information.
4.
In the scrolling window, select the withhold detail IDs in the Detail ID column.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
P AY AB L E S
T R A N S A C T IO N S
5.
The description for the selected withhold details default in the Description
column.
6.
In the Base Amount column, enter a base amount to calculate each withhold
detail ID. You can select multiple withhold details and define the base amounts
for each. The total withhold for a particular transaction is then calculated.
7.
Choose According to plan to display all the withhold detail IDs belonging to the
selected withhold plan ID in the scrolling window.
8.
Choose OK to accept the base amounts for the withhold detail IDs you have set
up.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
83
84
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
86
C O LL E C T IO N
A N D
Chapter 9, Routines, describes how to generate and export a Sicore file, edit
portfolio checks, and process own deferred checks.
Chapter 10, Exchange rate differences, describes how to generate the credit
documents and debit documents for a realized gain or loss respectively due to
difference in the exchange rates.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 8:
Utilities
Use this information to write off customer balances for a range of customers, and to
define the text to be used as the header for VAT sales and purchasing reports.
This information is divided into the following sections:
2.
Select the default batch ID in the Batch ID field. The system defaults the batch
ID to cancel the balances.
3.
Mark the Only report checkbox to view a report before processing the
cancellation of customer balances.
4.
Enter a starting ID for the range of customers whose balances to write off in the
Client from field.
5.
Enter an ending ID for the range of customers whose balances to write off in the
Client to field.
6.
Enter the amount to be written off in the Amount field. All the balances that are
equal to or less than the specified amount in each debit document will be
written off for the selected customer range.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
87
PA RT
U T I L I T I E S
A N D
7.
R O U T I N E S
Choose Run to process the writing off of balances of the selected customers and
close the window. You can also print a report which shows the cancellation of
balances for the selected customers.
Be sure that the Only report checkbox is unmarked in order to process the cancellation.
8.
Choose Cancel to cancel the values displayed and close the window.
88
C O LL E C T IO N
A N D
1.
2.
Select the Sales option to set up the text for the sales reports. Select the
Purchases option to set up the text for the purchasing reports.
3.
Enter a text in the Text for NO inclusion field to appear as the title for all the
report.
4.
The Tax Class column displays all the taxes for the company.
5.
Enter the text that you want to appear in the report for each tax in the Heading
Text column.
6.
7.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 9:
Routines
Use this information to generate the Sicore tax report file. You can also edit portfolio
checks, or process own deferred checks.
This information is divided into the following sections:
2.
Enter the starting date and the ending date of the range to generate files for in
the From Date and To Date fields respectively.
3.
The Tax Entity field displays the name of the government agency that receives
the file.
4.
Mark the Include Subjects checkbox to include the subject files you have set up
in the File Configuration window.
You must have set up both the transactions and the subject file types in the File
Configuration window to export the subject files. Refer to Setting up files for magnetic
support on page 35 for more information.
5.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
89
PA RT
U T I L I T I E S
A N D
R O U T I N E S
Both Choose this option to generate both the customers tax details and
vendors withhold details.
6.
Choose Process to name a destination for the report file. You can also generate a
customer tax details report, a control report and an error report, if any.
7.
90
C O LL E C T IO N
A N D
1.
2.
Enter the date range for which to generate the report in the From Date and Until
date fields respectively.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
3.
R O U T I N E S
In the Document Type group, select the document types for which to generate
the report.
Payment - Suppliers Mark this option to include the payments made to the
vendors in the report.
Payment - Miscellaneous Mark this option to include miscellaneous type
of expenses in the report.
Return Mark this option to include returns in the report. This option is
available only if you have marked the Payment - Suppliers checkbox.
Credit Memo Mark this option to include credit memos in the report. This
option is available only if you have marked the Payment - Suppliers checkbox.
4.
Select to include all the vendors or enter a range of vendors in the From and To
fields in the Vendor ID group to generate the report. This option is available
only if you have marked the Payment - Suppliers checkbox in the Document
Type group.
5.
6.
7.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
91
PA RT
U T I L I T I E S
A N D
2.
R O U T I N E S
3.
The Description field displays the description for the selected collection or
payment ID.
4.
Choose the document number lookup button to open the Select Outstanding
Checks window.
5.
6.
Choose OK to close the Outstanding Checks Search window and return to the
Select Outstanding Checks window.
7.
8.
The Type ID and Income Number field displays the collection ID from the Cash
Receipts Entry window.
9.
The Type ID and Expense Number field displays the payment ID from the
Input of Payments window.
The payment ID is displayed only when a payment has been posted using the portfolio
check.
10. The Previous Due Date field displays the original due date from the Cash
Receipts Entry window.
11. Enter a new due date in the Due Date field, if required.
12. The Previous Status field displays the status of the portfolio check at the time of
receipt.
13. Select a new status for the check in the Status field, if required. The statuses that
appear in the drop down list depend on your settings in the Status Change
Configuration window. Refer to Setting up status changes for portfolio checks on
page 12 for more information.
14. The Previous Bank ID field displays the original bank ID from the Payments
Means Entry window.
15. Enter or select a new bank ID, if required.
16. The Previous Bank Branch ID displays the original bank branch ID from the
Payment Means Entry window.
17. Enter or select a new bank branch ID, if required.
92
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
R O U T I N E S
18. The Clearing Previous field displays the number of clearing days entered in the
Cash Receipts Entry window.
19. Enter a new number of days to clear the checks in the Clearing field.
20. Select the receipt for which you want to change the Exchange number in the
Exchanged in No field. This field is available only for Exchange status type.
21. The Previous Signers Tax ID field displays the tax ID from the Payment Means
Entry window.
22. Enter a new tax ID in the Signers Tax ID field.
23. The Previous Check Recipient field displays the default destination for the
customers or third party check from the Billing/Payment Methods
Configuration window. Refer to Setting up defaults for collection and payments on
page 10 for more information.
24. Select a new destination for the check, if required.
25. Choose Save to save the changes youve made.
26. Choose Clear to clear the values displayed in this window.
27. Choose Cancel to cancel the process close the window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
93
PA RT
U T I L I T I E S
A N D
R O U T I N E S
2.
The Bank ID column displays the bank ID from the Payment Means Entry
window. The deferred check upon realization will affect the bank account
associated with this bank.
3.
The Checkbook ID column displays the checkbook ID you have selected in the
Bank Account Maintenance window. The deferred check upon realization
affects the checkbook balance of this checkbook ID.
4.
The Document Number, Due Date and Supplier ID columns in the scrolling
window default from the Payment Means Entry window.
5.
Enter a date to post the deferred check in the Posting Date field. If this field is
blank, the user date will be the posting date for the deferred check.
6.
7.
Choose Mark All to select all the checks that are displayed in the scrolling
window for realization.
8.
Choose Unmark All to remove the selections for all the displayed checks.
9.
The No. of Checks Marked field displays the number of checks that are selected
for realization.
10. The Total Originating Amount field displays the total amount of the checks
selected for realization.
11. Choose Post to process the selected deferred checks and update the bank
account ID or the checkbook ID.
94
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
R O U T I N E S
12. Choose Search to open the Search-Deferred Own Checks window. Refer to
Defining the search criteria to process own deferred checks on page 95 for more
information.
13. Choose Cancel to close the window without processing the deferred checks.
2.
In the Search By field, select the criteria to filter the documents. The options are
Due Date, Issue Date, Supplier ID, Bank Account ID, Bank ID, Checkbook ID,
Functional Amount, Originating Amount, Clearing or Document Number.
3.
Enter the range for the selected criterion in the From and To fields respectively.
4.
Choose Insert to insert the range and then enter any additional ranges if
necessary.
5.
Highlight a range and choose Remove to remove a range from the search.
6.
Choose OK to run the search and close the window. The documents fulfilling
the search criteria are displayed in the Deferred Own Checks Record scrolling
window.
7.
Choose Cancel to cancel the search and return to the Deferred Own Checks
Record window.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
95
96
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 10:
Selecting customers
Selecting invoices and returns
Generating the credit documents and debit documents
Viewing the credit documents and debit documents
Deleting the debit documents and credit documents
Selecting customers
You can select the customers to generate the credit memos, debit memos, invoices,
and returns based on the customer ID, name or class.
To select customers:
1.
2.
Select the criterion by which to filter customers, whether customer ID, name or
class.
3.
Choose All, or enter a valid range for the selected criterion. All the customers
that fulfill the given range are displayed in the scrolling window.
4.
Choose Mark All to select all the customers in the scrolling window to generate
the credit documents and debit documents.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
97
PA RT
U T I L I T I E S
A N D
R O U T I N E S
5.
Choose Unmark All to clear the selections for all the customers displayed in the
scrolling window.
6.
Choose Redisplay to refresh the scrolling window with any information entered
since you last saved.
98
C O LL E C T IO N
A N D
1.
2.
The SOP batch field displays the next default batch number to be used for the
Sales Order Processing batch. The SOP batch is created only for invoices and
returns and does not include trade discounts, freight charges, and
miscellaneous charges.
3.
The RM batch field displays the next default batch number for the Receivables
Management batch. The RM batch is created for a realized gain or loss in the
functional currency and does not include trade discounts, freight charges,
miscellaneous charges, and tax.
4.
Enter a default return ID in the NC Checkbook field. You can select a different
return ID if required.
5.
Enter a default invoice ID in the ND Checkbook field. You can select a different
invoice ID if required.
6.
The NC document number and the ND document number fields display the
next document numbers for the default return ID and the invoice ID
respectively.
7.
Choose OK to save the default information that you have set up.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 0
E XC H A N G E
R AT E
D IF FE R E N C E S
2.
Enter an option to identify the credit memo or the debit memo to generate.
3.
Mark the Generate NC/ND option in the Results group to generate the credit
documents and debit documents.
4.
Mark the Print Report option in the Results group to print a preview of the
credit documents and debit documents.
5.
Enter the date on which to generate the credit documents and debit documents
in the NC/ND Date field.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
99
PA RT
U T I L I T I E S
A N D
R O U T I N E S
6.
Select an item with miscellaneous charge type in the NC Item field. You must
select a miscellaneous charge type of item since it does not affect the inventory
balance. The returns that are generated do not represent an actual sale for such
items.
7.
Select an item with miscellaneous charge type in the ND Item field. You must
select a miscellaneous charge type of item since it does not affect the inventory
balance. The invoices that are generated do not represent an actual sale for such
items.
8.
The NC Checkbook and ND Checkbook fields display the default return ID and
invoice ID respectively from the Sales Order Processing Setup window. You can
select a different return ID and an invoice ID if required. These IDs are used to
identify the credit memos and debit memos.
9.
Enter a minimum amount to generate the credit memos and debit memos. The
memos are generated only if the exchange rate difference amount is more than
the minimum amount.
10. Select the tax plan to calculate the tax in the Client Tax Plan and Item Tax Plan
groups. The taxes will be calculated based on the common tax details in these
groups. For tax details that originate from the Perceptions module, a reduction
in the tax percentage as specified for that tax detail is also calculated. Refer to
the Perceptions documentation for more information.
Original Customer Mark this option to consider the tax detail IDs from the
customers default tax schedule ID.
Ship to Address Mark this option to consider the tax detail IDs from the tax
schedule ID attached to the Ship to Address ID for each line item.
Original Item Mark this option to consider the tax detail IDs assigned to the
original invoice for each line item in the document.
Change Difference Item Mark this option to consider the tax detail IDs
from the miscellaneous type of item's tax schedule.
11. Select the tax exempt plan that you have created to exempt taxes on the
rounding off differences amount. The rounding off differences amount is the
difference in the tax amount while generating the credit documents and debit
documents. You can view this tax plan in the Item Tax Schedule ID field in the
Sales Item Detail Entry window (Transactions >> Sales >> Sales Transaction
Entry >> Item Number expansion button).
You cannot use tax plans that originate from the Perceptions module.
12. You can generate a valid legal number for the debit and credit documents based
on the Invoicing Site, and the Point of Sale that you enter in the Legal
Documents group. You can also generate a valid legal number based on the
legal numbering parameters for the original invoice that you have set up in the
Numerator Configuration window. Refer to the Legal Documents
documentation for more information.
The options in the Legal Documents group are available only if you have installed Legal
Documents on your system.
100
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 0
E XC H A N G E
R AT E
D IF FE R E N C E S
13. Mark the Original Invoice Setup checkbox to generate a valid legal number for
the invoices based on the legal numbering for the original invoice. Unmark this
option to generate a valid legal number for invoices and return type of
documents at the invoicing site and the point of sale that you select here.
14. Mark the Original Invoice Setup checkbox and select the Invoicing Site and
Point of Sale to generate legal numbers for the return type of documents.
15. Select the type of range to generate the credit memos and debit memos.
Date Select this option to include the range of documents that are applied
within the specified date range.
Checkbook Select this option to include the range of documents that are set
up in the Sales Order Processing Setup window.
Client Select this option to include the range of customers selected in the
Select Customers window. Refer to Selecting customers on page 97 for more
information.
16. Enter the range for the selected criterion in the From and To fields respectively.
17. Choose Insert to insert the range in the Filters group.
18. Highlight a range and choose Remove to remove the range from the Filters
group.
19. Choose Run to generate the credit memos and debit memos for the documents
in the selected criteria.
20. Choose Save to save, Clear to clear the fields, and Delete to delete the
information you have setup.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
101
PA RT
U T I L I T I E S
A N D
R O U T I N E S
2.
3.
Select All to view all the documents for the selected criterion or enter the range
in the From and To fields respectively.
4.
The scrolling window displays the documents based on the selected criterion.
5.
Choose Redisplay to refresh the scrolling window with any information entered
since you last saved.
6.
102
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 0
E XC H A N G E
R AT E
D IF FE R E N C E S
2.
3.
Select All to delete all the documents for the selected criterion or enter the range
in the From and To fields respectively.
4.
5.
Choose Mark All to select all the documents in the scrolling window for
deleting.
6.
Choose Unmark All to clear the selections for all the documents displayed in
the scrolling window.
7.
8.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
103
104
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
106
C O LL E C T IO N
A N D
Chapter 11, Inquiries, describes how you can view the information for the
collection and payment methods, and withholds that you have entered.
Chapter 12, Reports, describes how to create report options and print the
required reports.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 11:
Inquiries
You can use inquiries to view the information youve entered into the system. You
can analyze transaction information, and display the information either on the
computer screen or on a report.
This information is divided into the following sections:
2.
Select the collection or payment ID in the Means ID field. You can select only
those IDs for which you have marked the Allows Payment or Allows Collection
checkbox and the Uses Status checkbox in the Collection/Payment Means
Maintenance window. Refer to Maintaining collection and payment methods for
more information.
3.
4.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
107
PA RT
I N Q U I R Y
A N D
R E P O R T I N G
5.
6.
The Functional Amount Total field displays the total amount in the functional
currency for the selected transactions.
7.
The Originating Amount Total field displays the total amount in the originating
currency for the selected transactions.
8.
108
C O LL E C T IO N
A N D
1.
2.
3.
Enter the range for the selected criterion in the From and To fields respectively.
4.
Choose Insert to insert the range and then enter any additional ranges if
necessary.
5.
Highlight a range and choose Remove to remove a range from the selected
search.
6.
Choose OK to run the search and close the window. The documents fulfilling
the search criteria are displayed in the Consultation of Collection/Payment
Means scrolling window.
7.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 1
I N Q U I R I E S
2.
3.
To view specific information, you can open several other windows from the
Cash Receipts Inquiry window.
The following table lists the windows that you can go to:
4.
Field or button
Distribution button
Apply button
Applied to Debits
Portfolio
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
109
PA RT
I N Q U I R Y
A N D
R E P O R T I N G
110
C O LL E C T IO N
A N D
1.
2.
The scrolling window displays the details for the collection method for the
selected customer ID as it was originally entered.
3.
Select the Payment Method ID in the scrolling window to view the details of
each collection method.
4.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 1
I N Q U I R I E S
2.
The scrolling window displays the details of the portfolio type of collection
method.
3.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
111
PA RT
I N Q U I R Y
A N D
R E P O R T I N G
2.
3.
112
C O LL E C T IO N
A N D
Field or button
Apply button
Distribution button
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 1
I N Q U I R I E S
2.
You can view the different payment methods used in the selected document to
pay the selected vendor.
3.
Select a payment method ID in the scrolling window to view the details of each
payment method.
4.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
113
PA RT
I N Q U I R Y
A N D
R E P O R T I N G
2.
3.
The scrolling window displays the details of Receivables transactions within the
selected range.
4.
114
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 1
I N Q U I R I E S
2.
The Type ID, Document No. Supplier ID, and Name fields display the values
from the Input of Payments Inquiry window. The Source Amount and the
Functional Amount fields display the document amount in the originating and
the functional currencies respectively.
3.
The scrolling window displays the withhold details for the payment as it was
originally entered in the Withhold Details Maintenance window. Refer to
Adding withholding details on page 23 for more information.
4.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
115
PA RT
I N Q U I R Y
A N D
R E P O R T I N G
116
C O LL E C T IO N
A N D
1.
2.
The Supplier ID, Invoice and Total Amount fields display the default values
entered during transaction entry.
3.
The Withhold Plan ID field displays the plan ID assigned to the selected vendor
in the Supplier Maintenance - Other Data window. Refer to Entering additional
information for vendors on page 42 for more information.
4.
The Detail ID and the Description columns displays the withhold detail ID and
their description for the selected transaction.
5.
The Base Amount column displays the base amount for each withhold detail
ID.
6.
P AY M EN T
M ET H O DS
W IT HH O LD S
Chapter 12:
Reports
Report options include specifications for sorting options and range restrictions for a
particular report. You can create multiple report options to easily print all the
information you need.
Collection and Payment Methods - Withholds reports are available in the report list.
You can select a report in the report list and add it to My Reports for easy access.
Refer to the Microsoft Dynamics GP documentation for more information.
This information is divided into the following sections:
2.
3.
Mark the Print Record option to print the details for each collection ID in the
report.
4.
In the Include field, select the types of transactions for which to print the report.
The options are Accounted, Not Accounted or Both.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
117
P A R T
I N Q U I R Y
A N D
R E PO R TI N G
5.
Enter the text to identify the transactions that are not accounted in the Text for
Not Accounted field, if youve marked the Not Accounted or Both options in
the Include field.
6.
Mark the Enable Reprint checkbox to allow the report to be reprinted. Enter the
text to identify a reprinted report in the Text for Reprint field.
7.
8.
Enter or select the beginning value for the range in the From field.
9.
Enter or select the ending value for the range in the To field.
10. Choose Insert to insert the range in the Restrictions list. To remove an existing
range from the list, select the range and choose Remove.
11. Choose Destination to select a printing destination. Reports can be printed to
the screen, to the printer, to a file, or to any combination of these options. If you
select Ask Each Time, you can select printing options each time you print this
report option.
12. To print the report option from the report options window, choose Print before
saving it. If you dont want to print the option now, choose Save and close the
window. The report window will be cleared.
13. Choose Delete to delete the report ID youve set up, or Clear to clear the values
displayed in this window.
118
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 2
R E P O R T S
2.
3.
In the Print field, select whether to print the report for Payment Order,
Withhold Certificate, or for both.
4.
In the Include field, select the type of transactions for which to print the report.
The options are Accounted, Not Accounted or Both.
5.
Mark the Print Record option to print the details for each payment in the report.
6.
Enter the text to identify the transactions that are not accounted in the Text for
Not Accounted field, if youve marked the Not Accounted or Both options in
the Include field.
7.
Mark the Enable Reprint checkbox to allow the report to be reprinted. Enter the
text to identify a reprinted report in the Text for Reprint field.
8.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
119
P A R T
I N Q U I R Y
A N D
R E PO R TI N G
Expense Type ID Select this option to print the report for a range of expense
type IDs.
Payment Number Select this option to print the report for a range of
payment orders.
9.
Enter or select the beginning value for the range in the From field.
10. Enter or select the ending value for the range in the To field.
11. Choose Insert to insert the range in the Restrictions list. To remove an existing
range from the list, select the range and choose Remove.
12. Choose Destination to select a printing destination. Reports can be printed to
the screen, to the printer, to a file, or to any combination of these options. If you
select Ask Each Time, you can select printing options each time you print this
report option.
13. To print the report option from the report options window, choose Print before
saving it. If you dont want to print the option now, choose Save and close the
window. The report window will be cleared.
14. Choose Delete to delete the report ID youve set up, or Clear to clear the values
displayed in this window.
2.
120
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 2
R E P O R T S
3.
In the Spreadsheet Report window, enter the date range for which to print the
report in the Beginning Date and Open OC fields.
4.
Enter a currency ID to print only transactions for that currency ID. Leave this
field blank to include transactions in all currencies in the report.
5.
Choose OK to print the report for all incomes, for all expenses, a summary
report and return to the Reports window.
6.
Choose Cancel to close the window without printing a report, and return to the
Reports window.
7.
8.
2.
Enter the date range for which to generate the report in the From and To fields.
3.
Select whether to generate the VAT report for sales or purchases in the VAT
field.
4.
Choose Print to print the selected report for the specified date range.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
121
P A R T
I N Q U I R Y
A N D
R E PO R TI N G
2.
Select a bank account ID and a checkbook ID that is associated with the selected
bank account ID.
If you do not select a checkbook ID, all the checkbook IDs for the selected bank
account ID will be considered while printing the report.
3.
Enter the range of check numbers for the selected checkbook ID in the Check
Number: From and To fields respectively
4.
Choose Print to print the Own Checks report, or choose Cancel to cancel the
process and close the window.
122
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 2
R E P O R T S
2.
Select the range for the report in the Range field. The options are Customer ID
and Posting Date.
3.
Enter the beginning value and the ending value for the selected range in the
From and To fields respectively.
4.
Mark the In Detail checkbox to print the Customer Debt Control Report in
detail, if required. If this field is not marked, the report will print as a Summary
report.
5.
Choose Insert to insert the range and then enter additional ranges if necessary.
6.
7.
Choose Print to print the Customer Debt Control report, or Clear to clear the
values in the window.
8.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
123
P A R T
I N Q U I R Y
A N D
R E PO R TI N G
2.
Select the range for the report in the Range field. The options are Vendor ID and
Posting Date.
3.
Enter the beginning value and the ending value for the selected range in the
From and To fields respectively.
4.
Mark the In Detail checkbox to print the Vendor Debt Control Report in detail, if
required. If this field is not marked, the report will print as a Summary report.
5.
Choose Insert to insert the range and then enter additional ranges if necessary.
6.
7.
Choose Print to print the Vendor Debt Control report, or Clear to clear the
values in the window.
8.
2.
Select whether to print the batch control report for payments or receipts in the
Origin field.
3.
124
C O LL E C T IO N
A N D
4.
Enter or select the beginning value and the ending value for the selected range
in the From and To fields respectively.
5.
Choose Insert to insert the range and then enter additional ranges if necessary.
P AY M EN T
M ET H O DS
W IT HH O LD S
C H A P T E R
1 2
R E P O R T S
6.
7.
Choose Print to print the Batch Control Report, or Clear to clear the values in
the window.
8.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
125
126
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
Glossary
Collection/Payment Means
Method through which you make a
collection or payment. Examples of
collection/payment means in Argentina are
cash, check, portfolio check etc.
Credit invoice
An unpaid invoice.
CUIT
Tax registration code to validate taxes.
Deferred check
A check that is due at a date later than the
date it was issued.
Reallocated deferred
The status that a deferred check changes to
when it is posted.
Reverse withholding
The tax that is calculated on sales based on a
reduction in the tax percentage. These taxes
are paid by the customer directly to the
authorities.
Withhold certificate
A certificate issued to a vendor that displays
the amount that has been withheld for a
payment.
Withholding plan
A tax schedule that contains all the
withholding tax details that must be used
together. The withholding tax details for a
transaction are calculated based on the
withholding plan assigned to the
transaction.
Withhold scale
The reduction amount or the reduction
percentage for a tax base amount.
Withholding tax
The tax that is deducted from the payment
made to vendors and submitted directly to
the tax authorities.
C O L LE C T IO N
AN D
PA Y M E N T
M ET H O DS -
WI TH H O LD S
127
128
C O LL E C T IO N
A N D
P AY M EN T
M ET H O DS
W IT HH O LD S
APPENDIX
Appendix
Refer the following tables for a list of fields that are available in the Collection
Means Entry and Payment Means Entry windows based on the options selected in
the Collection/Payment Means Maintenance window.
13 0 C O LLE C T I O N
A N D
PA Y M E N T
M E T HO D S
WI TH HO L DS
A P P E N D I X
C O LL EC TI O N A N D P A Y M E N T M E T HO D S - WI TH H O LD S
131
A P P E N D I X
13 2 C O LLE C T I O N
A N D
PA Y M E N T
M E T HO D S - WI T HH O LD S
A P P E N D I X
C O LL EC TI O N A N D P A Y M E N T M E T HO D S - WI TH H O LD S
133
A P P E N D I X
13 4 C O LLE C T I O N
A N D
PA Y M E N T
M E T HO D S - WI T HH O LD S
A P P E N D I X
C O LL EC TI O N A N D P A Y M E N T M E T HO D S - WI TH H O LD S
135
A P P E N D I X
13 6 C O LLE C T I O N
A N D
PA Y M E N T
M E T HO D S - WI T HH O LD S
A P P E N D I X
C O LL EC TI O N A N D P A Y M E N T M E T HO D S - WI TH H O LD S
137
13 8 C O LLE C T I O N
A N D
PA Y M E N T
M E T HO D S
WI TH HO L DS
Index
C O L LE C T IO N
AN D
PA Y M E N T
E
exchange rate differences overview 97
F
File Configuration window, displaying 35
Fiscal Code Configuration window,
displaying 37
Fiscal Key Entry window, displaying 38
G
Generate Debit/Credit Documents
window, displaying 99
H
help, displaying 3
Help menu, described 3
I
icons, used in manual 3
income and expense types, setting up 16
Income/Expense Types Maintenance
window, displaying 16
Input of Payments Inquiry window,
displaying 112
Input of Payments window, displaying 67
invoices and returns, selecting 98
L
lessons, accessing 4
lookup window, displaying 4
M
magnetic support files
setting up 35, for receipts 34
magnetic support files setup
conditions 32
provinces 31
tax IDs 32
tax regimen 33
Mass Balance Settlement window,
displaying 87
N
new features, information about 4
Numbering Maintenance window,
displaying 17
numbering sequence
explained 17
M ET H O DS -
WI TH H O LD S
139
IN DEX
O
operating code, setting up 33
Operation Codes Configuration window,
displaying 34
Orientation training, accessing 4
Own Checks Control Report window,
displaying 122
own checks report, printing 122
Own Credit Invoices, displaying 51
P
payables documents to apply, searching
70
Payment Batch Generation window,
displaying 78
payment batches, generating 78
Payment Means Entry window,
displaying 72
Payment Means Inquiry window,
displaying 113
payment method information, viewing
113
payment methods, entering 71
Payment Order Printing by Ranges
window, displaying 119
payments
entering 67
voiding 81
payments to vendors, viewing 112
PM - Differentiated Withholds window,
displaying 82, 116
PM - Input of Credit Invoice Receipts,
displaying 49
portfolio checks
editing 91
entering 64
searching 66
selecting 65
setting up status changes 12
portfolio checks information, viewing 111
portfolio collection, explained 16
portfolio exchange, explained 16
Portfolio Selection Inquiry window,
displaying 111
Portfolio Selection window, displaying 64
Province Configuration window,
displaying 31
Provinces - Clients window, displaying 46
Provinces - Suppliers window, displaying
46
Purchases - CI Reports window,
displaying 54
R
R.G.1547 Report Generation window,
displaying 90
Receipt Date Entry window, displaying 58
Receipt Printing by Ranges window,
displaying 117
140
C O LL E C T IO N
A N D
U
upgrade information, accessing on the
Web 4
S
sales document type, modifying 62
Sales/Purchases VAT Configuration
window, displaying 88
Sales/Purchases VAT Generation window,
displaying 121
Scale Maintenance window, displaying 27
Search - Checks in Portfolio window,
displaying 66
Search - Deferred Own Checks window,
displaying 95
Search Checks in Wallet window,
displaying 75
Search Payables Documents to Apply
window, displaying 70
Search-Consultation of Collection/
Payment Means window, displaying
108
Select Customers window, displaying 97
selecting customers, explained 97
sicore data, exporting 89
Sicore Export window, displaying 89
Signer Maintenance window, displaying
45
Smartlist Integration window, displaying
21
Spreadsheet Report window, displaying
121
Status Change Configuration window,
displaying 13
status changes, for portfolio checks 12
Supplier Maintenance-Other Data
window, displaying 43
symbols, used in manual 3
T
Tax Bases Maintenance window,
displaying 29
tax classes, assigning to tax detail IDs 39
Tax Classes window, displaying 39
tax codes
setting up 36
validating 38
Tax Codes Configuration window,
displaying 32
Tax Conditions - CI Configuration
window, displaying 48
tax ID, setting up 45
P AY M EN T
M ET H O DS
W
whats new, accessing 4
withhold base details, maintaining 29
withhold details
adding 23
viewing 114
Withhold Details Maintenance window,
displaying 23
Withhold Edit window, displaying 77
Withhold Inquiry window, displaying 115
Withhold Plan Maintenance window,
displaying 26
withhold plans
assigning to vendors 41
setting up 25
withhold scales, entering 27
Withhold Type Maintenance window,
displaying 28
withhold types, maintaining 27
Withholding Plan Assignment window,
displaying 41
Withholdings - Tax/Regime window,
displaying 25
withholds
base amount, changing 75
differentiating 82
editing 76
W IT HH O LD S