My Oracle Support Banner

Sales Upload Of Concession And Consignment Items (Doc ID 2959109.1)

Last updated on AUGUST 22, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


Clarification is required for non-inventoried Concession and Consignment Items:

1. Consignment item:

a) Being a non-inventory item, why are sales tran-codes 1 and 2. Shouldn't they be 3 and 5 ?

b) Documentation refers that for concession and consignment items tran-codes preceded by 1 are created. So I was expecting MOM to have created tran-code 101 and tran_code 120. Why has this not happened?

c) If the Consignment Item sale is passed without VAT, the Consigment Invoice in IMCS after upload is created (without VAT) but with a TAX discrepancy - In a automatically generated self-bill invoice it seems to be incorrect that a discrepancy is raised ... but here the main error is that the purchase invoice doens't include VAT regardless of what has come in the sale

d) If the Consignment Item sale is passed with VAT, then the consigment invoice is created with VAT. Althought all is correct from a data perspective, a TAX discrepancy was also raised. Here the invoice has VAT and the TAX discrepacy created is strange, because for on a 100 line cost with 23% VAT rate on the invoice side is 23. What is incorrect is what the system assumes as the system VAT which states it should be 2.3

2. Concession Items:

a) After uploading sales the no transaction record could be found in TRAN_DATA table ? At least the sales record should have been posted in tran_code 1,2 or 3,5, correct ? And being a Concession sale it should be tracked in tran_code 101, correct ?
If not how can the retailer know the retail amount of a concession amount ?

b) The only visible transaction is in table CONCESSION_DATA. And this table only captures the Concession amount. Is this the expected behaviour ?

c) The documentation refers to the following:
- "These transactions are written to staging table (CONCESSION_DATA), which can be interfaced to Accounts Receivable or Payable for account settlement with concessionaires."

3. Integration with financial systems:

How the transactions posted in concession_data table are posted to AR/AP ? How can this record be interfaced to the financial system, if no transaction records exist ? Or what account receivables interface exist from MOM ? Also on the concession_data table it is impossible to relate a record of a concession amount with a sale transaction (POS_TRAN_ID or SALES_PROCESS_ID as in tran_data)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.