Wiki Detay | wiki workcube

The sale made by a seller with another seller, distributor or broker in order to receive the value of his goods after they are sold is called "consignment".

The company sending the goods and the company receiving the goods to sell them create an agreement regarding the sales conditions of the goods. The goods sent in this way are called consignment goods, and the sales process is called consignment sale. In consignment sales, the ownership of the goods still belongs to the seller, that is, the sender of the consignment goods.

To carry out consignment transactions in Workcube; You need to define consignment invoice, consignment entry delivery note, consignment exit delivery note, consignment exit return delivery note, consignment entry return delivery note.

Consignment Exit Delivery Note

Path: ERP > Sales-Distribution > Shipping-Logistics > Sales Delivery Note

Fill in the necessary sections, add the products we will sell on consignment to the delivery note and save by selecting the transaction type "Consignment Outgoing Delivery Note".

Type: In order to ensure proper consignment transfer and reporting, no changes should be made between transaction types in different process_id after the transaction type is recorded. To do this, "Should Transaction Type Checks Be Performed?" "Yes" should be selected in the "Consignment Invoice" is selected and after selecting the customer on the delivery note, the delivery note popup is clicked.

When you select the quantity to be invoiced, click on the box next to it and then press the add button, the product and its quantity are transferred to the invoice line.

From the amount of 100 on the delivery note, we add 50 of the "remaining" part to the invoice line and convert 50 of them into invoices.

Type: If the entire delivery note is desired to be converted into an invoice. Add by checking the box next to “Delivery Note No”. If it will be converted into a partial invoice, the delivery note number is clicked and the amount is added in the remaining field.

Consignment Output Return Delivery Note

Path: ERP > Sales-Distribution > Shipment-Logistics > Receiving. Delivery note

This is the delivery note you create for your returned consignment products. Transaction type "Consignment Output Return Delivery Note" is selected, and since it is a return type transaction, delivery note is also selected. After selecting the relevant client, the delivery note popup is clicked.

Selecting the returned quantities from the listed delivery notes and pressing the add button, the products are added to the line of the consignment return delivery note with their quantities.

Type: Before consignment operations, the following xml. Do not forget to make the settings.

1 - Transaction type control should be performed when selecting the delivery note in consignment delivery notes.

If Yes is selected, only consignment type delivery notes will be allowed to be selected when selecting the delivery note in consignment transactions. For example; Even if you are authorized for the goods purchase delivery note transaction type, this transaction type will not appear in the update.

2 - Perform project control in consignment transactions

If Yes is selected, the following checks are made regarding the project in consignment return transactions; If the project is selected on the consignment delivery note, it is checked that the same project is selected in the return process. If a project is not selected on the consignment delivery note, it is not allowed to select a project in the return process. When more than one consignment issue delivery note is requested to be returned, it is checked that the same project is selected in all of them.

11 - Should the associated issue delivery note be mandatory in the consignment return process?

If selected as yes, a related issue delivery note must be selected in order to perform the consignment return issue transaction.

This includes the transactions you have made, that is, the movements of your consignment products; You can get it via “KConsignment Report” based on transaction type, current, brand, project, warehouse, stock, document and within the date range you specify.

Consignment Report

Path: Report > Standard Reports > Consignment Report

Consignment delivery notes and related transactions (return-invoice) in the periods covered by the given date range are listed with their costs. The date range can be entered to cover more than one accounting period (1/1/2019-31/12/2021).
"Delivery Note Period" ensures that only consignment delivery notes registered in the relevant period are listed within the given date range. Return and invoice information regarding these delivery notes are checked within the given date range. Ex. When the date range 1/1/2020-31/12/2021 and 2019 is selected as the delivery note period, consignment delivery notes in the 2019 period and the return and invoice transactions of these delivery notes recorded in the 1/1/2019-31/12/2020 date range can be reported.
If "Unclosed Documents" is selected All consignments with remaining amounts between start and end dates; When "Transfers from the Previous Period" is selected, all consignment documents in the active period and only consignments with a balance from the previous period are listed.
When "Month Based Invoice Information" is selected, the invoices for the delivery notes are listed monthly in separate columns with cost information.
“Transfer Transactions. If "Fetch " is checked, only the transfers will be reported. If unchecked, the report returns data by looking at all periods.
The "Export to Table" option can be selected together with document-based reporting and "Month-Based Invoice Information" filters. The report results are transferred to a table named "consigment_report_table" in the company database. (Export to table selection depends on xml.)

Consignment Transfer Transaction

Path: Control Panel > System > Period Transactions > Consignment Transfer

Consignment Transfer enables the transfer of consignment issue delivery note transactions from the previous period to the next period. It is used together with the “Get from Transfer Transactions” option in the consignment report.

In order to get accurate results, the consignment transfer process must be carried out regularly every year.

For example;

In 2020, 1000 consignments were issued and in the same year, 100 were invoiced and 100 were returned.

When the transfer was made in 2020, the remaining consignment amount is 1000 - 100 - 100 = 800.

200 units were invoiced and 50 units were returned in 2021.

When 2021 is transferred, the remaining amount is calculated as 800 - 200 - 50 = 550.

If only 2021 is transferred without transfer at the end of 2020, the amount transferred to 2021 will be taken into account as 1000. and is calculated as 1000 - 200 - 50 = 750.

Note: You can use the consignment report without making a transfer. You should not select "Get from Rollovers".

Tips

Record was not found

Feedback

Did you find this content helpful?

Please Write Your Feedback!

Name*

Last Name*

Email *

About Workcube Objects

Consignment Report

It is used to report consignment transactions. In the report, consignment delivery notes and related transactions (return-invoice) for the periods covered by the given date range are listed with their costs. The date range can be taken to cover more than one accounting period.

Type: Report Version: Catalsyt v20 Licence: Standard Author: Workcube Core