pixi

Returns Field Reference


List of Returns

Field

Description

Return Amount

Total amount of the return

Status

Status of the return (New, Received, Credited, Rejected)

Return Case Number

Unique return document ID which is automatically generated by pixi

Customer

First and last name of the customer (taken from invoice address)

Invoice Number

Number of the related invoice

Invoice Date

Creation date of the related invoice

Order Type

Order type (B2C or B2B) of the related invoice

Created

Date when the return document was created

Created By

User that created the return document

Modified

Date when the latest changes were made to this return

Modified By

User that made the latest changes to the return

Ship Cost

Ship Costs of the order

Replacement Oder Nr

Number of the related replacement

Voucher Sum

Applied voucher sum

Invoice Total

Total invoice amount


Back to top

Return

Return Header

Field

Description

Return

Unique return document ID which is automatically generated by pixi

Status

Status of the return (New, Received, Credited, Rejected)

Created

Date when return document was created

Created By

User that created the return document

Modified

Date when the latest changes were made to this return

Modified By

User that made the latest changes to the return

Customer Name

First and last name of the customer (taken from invoice address)

Invoice Number

Number of the related invoice

Invoice Date

Create date of the related invoice

Order Type

Order date of the related invoice

Credit Number

Number of the related credit for returns in status GUT

Credit Date

Creation date of the related credit for returns in status GUT

Return Amount

Shows the net values on the left and gross values on the right side

Lines Total

Summary of net/gross price fields for all return lines in the return

VAT Amount

Calculated from: Lines Total GROSS - Lines Total NET

Discount Voucher

Shows the credit's voucher
Note: This value is only filled in case the credit has been created in the pixi Web application.

Shipping Costs

Shows the credit's shipping costs
Note: This value is only filled in case the credit has been created in the pixi Web application.

Return Costs

Shows the credit's return costs
Note: This value is only filled in case the credit has been created in the pixi Web application.

Total Amount

Summary of Gross Price x Returned Qty for all returned items


Back to top

Returned Items

Field

Description

Return Reason

Return reason that was selected for the item in pixi Mobile > Returns program

Bin

Bin the item was put to stock in pixi Mobile > Returns program

Internal Item Nr.

Internal item number assigned to the item

Item Name

Original item name; if it has been renamed in the order, this name is not shown

Shop Item Nr.

Shop item number as it is also shown in pixi Inventory

Barcode

Barcode of the item as it is also shown in pixi Inventory

Invoice Qty

Quantity ordered by the customer on the invoice

Returned Qty

Quantity returned by the customer and entered by the employee when processing the item in pixi Mobile > Returns program

Note: For the email type Return Received, use the variable Returned Qty (RL_ReturnItemQty) for the item quantity that was returned. Using the Invoice Qty (RL_InvoiceItemQty) will lead to incorrect information in return emails, as each returned item will also include the total item quantity sold.


Example: In this case, 2 return lines were created, each with a quantity of 1. They are connected to one invoice line that has a quantity of 5.


Invoice Qty + Returned Qty

Returned Qty

Return received
email

Sold 5, returned 1
Sold 5, returned 1

Returned 1
Returned 1

Conclusion

It may be misinterpreted that a total of 10 items were sold if the variable Invoice Qty is additionally used.

Only the items that have been returned are shown when the Returned Qty variable is used.

Gross Price

Gross price for the single item taken from the related invoice

Net Price

Net price for the single item taken from the related invoice

Serial Nr.

Serial number that was assigned to the item on Scan-In

Batch Nr.

Batch number that was assigned to the item on Scan-In

BBD

Best before date that was assigned to the item on Scan-In

Customer Comment

Customer comment that was entered when processing the return in pixi Mobile

User Comment

User comment that was entered when processing the return in pixi Mobile

Item Classification

Item classification that was selected when processing the return in pixi Mobile


Customer Details

Field

Description

INVOICE ADDRESS (taken from the billing address of the related invoice)

Customer Name

First and last name

Street

Street and house number

City

City

Zip Code

Zip code

Country

Country

Company

Company

Phone

Telephone number

E-Mail

Email address

Note

Note that was entered

PAYMENT DETAILS (taken from the billing address of the related invoice)

Payment Type

Name of the payment type

Account Number

Bank account number

Account Holder

Name of the account holder

Bank Code

Bank code

IBAN

IBAN

BIC

BIC

Bank Name

Name of the bank


Back to top