Wiki Detay | wiki workcube

Direct Sales System (DBS) was developed to guarantee the prices of the products sold to the dealers of local and national companies with many dealers. With this method, the credit limits defined by the bank for the dealer come into play. In other words, the seller collects the invoice amount directly from the bank after selling the product. The bank makes this payment from the credit limits it has defined in the account of the dealer it will receive.

Path:Control Panel > System > Import > DBS Transfer

With DBS, customers' limits are processed into the system, minimizing the risk of financial work. In the Direct Debit System; The bank to which we send the debt file evaluates the overdue payments in line with the customer limits, collects them and then sends a collection file. The work is prepared in notepad and the file is saved with the txt extension. The most important point to consider when entering fields is the file pattern. In some patterns, line-based distinctions are made. For example; such as which line in the file should start and end. Since this information will be requested from the bank, when the limit file is requested from the bank, it must be ensured that it sends it in accordance with Workcube standards.

Bank selection is made before DBS Transfer is made.

The transfer starts from the 1st line, so there should be no headers in the first line. The fields available for transfer are as follows;

Customer Number: The Number in the Corporate Account field of the company whose limit information will be entered is the "Customer Number" information. It can consist of numeric and verbal characters between 0-20. For example; C5245
The placement part in the lines must start from line 0 and end at the beginning of line 21. (0-21)
Title: This is the title of the corporate account. It can consist of 0-40 numeric or verbal characters.
The placement part in the lines must start from the 21st line and end at the beginning of the 61st line. (21-61)
Branch Code: This is the bank branch code of the bank we selected before starting the import process. Its definition in the system must be 5 digits. It can be checked in the branch code section under ERP > Finance Accounting > Bank > Bank Branches. For example; If the branch code is 2068 in the system, the branch code should be entered as 02068 in the file.
The placement part in the lines must start from the 66th line and end at the beginning of the 71st line.
Limit: The total amount of the customer's loan amount and limit amount is entered in this field. It consists of a total of 15 numeric characters. For example; if the limit is 150,000 TL, it should be entered in the file with a leading zero (000000000150000).
The placement part in the lines must start from the 71st line and end at the beginning of the 86th line.
Available Limit: It is the usable amount of the customer limit. It consists of a total of 15 numeric characters. For example; If the available limit is 50,000 TL, it should be entered in the file with a leading zero (000000000050000).
The placement part in the lines must start from the 86th line and end at the beginning of the 101st line.
Amount Used from the Credit: This is the amount used from the customer's credit. It consists of a total of 15 numeric characters. For example; If it is 30,000 TL used from the customer loan, it should be entered in the file with a leading zero (000000000030000).
The placement part in the lines must start from the 101st line and end at the beginning of the 116th line.
Currency: These are the currencies in the system. Entry must be made in TL, USD, EUR. It consists of 3 verbal characters.
The placement part in the lines should definitely start from the 116th line and end at the beginning of the 119th line.

Hint: Even if the Turkish Lira is defined as "TL" in the system, it is written as "TRY" in the import file. should be written.

Sample File;

NYN Niyan Chocolates Imp. expulsion Singing. Tic. 02068000000000150000000000000050000000000000030000TRY

When the import process is completed, control is provided from the "DBS Limits" field.

ERP > Sales-Distribution > Customer-Supplier > Corporate Accounts > Corporate Account Detail > Risk and Working Information > DBS Limits

ERP > Finance Accounting > Risk and Guarantee > DBS Limits

Tips

Record was not found

Feedback

Did you find this content helpful?

Please Write Your Feedback!

Name*

Last Name*

Email *

About Workcube Objects

DDS Transfer

With DBS transfer, customer limits are collectively recorded in the system. By recording customers' limits into the system, financial risk is minimized.

Type: Import Version: Catalsyt v8 Licence: Standard Author: Workcube Core