Consignment sales report

Consignment sales report is used for collecting the whole sale of the resources received from one customer/vendor in one consignment warehouse of Own type in a given period.

Detailed description of handling consignment can be found in article Consignment – general information

The consignment sales report is a document which reflects the sale of items from delivery from a specific customer/vendor to a consignment warehouse of Own type on the basis of SOR documents. A report also includes the “sales” for the customer, whereby the item is moved from the consignment warehouse by means of WM documents to a local warehouse of the customer

List of CSR documents and the functionality relating to these documents are available in module Sales → CSR.

List of CSR documents

The list of documents has been described in article List of documents.

In order to issue a new report, it is necessary to click on button [Add] which results in appearing of a new form.

Tab General is slightly different than in other trade documents. The header contains:

  • document number
  • vendor for whom the report is being created
  • warehouse in which the resource delivered by a given vendor has been received (it can only and exclusively be an own consignment warehouse)
  • center in which the document is being issued
  • field with a space for providing an additional description to the report
  • current document status
  • document date of issue
  • total and subtotal value of the report
  • range of dates within which the dates of issue of documents including in the created CSR fall

The list of CSR items displays items and their quantity which has been released within the selected period of time by means of SOR and WM- documents from own consignment warehouse that is the basis of the report.

These items can only be added after selecting a vendor as well as a warehouse. Then, by means of buttons [Add SOR], [Add WM-], a user can select specific SOR or/and WM- documents from the list filtered by dates, vendor or warehouse. The other option involves the automatic addition of all SOR and WM- documents fulfilling the criteria set – button [Add Automatically].

Characteristics of CSR documents:

  • in the document header, in field Warehouse, by default is set the warehouse for which, in configuration, the CSR document has been set as default. However, it is possible to change it into a different consignment warehouse of Own type.
  • It is not possible to issue a CSR for a consignment warehouse of customer’s type or a local warehouse
  • When adding an item to a CSR its quantity is converted to the basic unit.
Note
In databases with FIFO/LIFO methods selected, the system does not include the documents which have already been added to another CSR, SOR documents which have been completely corrected, and WM- documents associated with a SORQC.

Retrieving prices into a CSR

Prices of the individual items are retrieved from the current price list for received items assigned to the vendor selected in the CSR, in the system currency of a company being the document owner. They are not editable and are only used for information purposes.

The prices can differ from the prices in the POR and PI, which ultimately document the purchase.

Generating a CSR document

A CSR document can be generated from the list of SOR and WM- documents.

Generating is possible for one or many documents marked on a list.

In the case of WM-, these can be documents, whose source warehouse is a consignment warehouse of Own type and the source warehouse is set as a local warehouse.

After confirming a CSR document, it is sent to the vendor, who, as a response, provides a sales invoice including exactly the same items.

Czy ten artykuł był pomocny?