Document status:
| Status | ||||
|---|---|---|---|---|
|
Date: Version Requirements are located in the menu on the left.
Requirements:
Component | Version |
|---|---|
POS Reporting DW | 2.4.0.58 |
POS Reporting Staging | 2.4.0.58 |
POS Master | 3.0.0.20 |
POS JournalService | 3.74.158.0 |
POSLog XML | 74 |
Import of stamps
(TFS: 168533)
To keep track of stamp card campaigns we now import stamp cards from Chain Web.
...
CampaignReference - Campaign reference from DimCampaign.
MemberNumber - Member number
StampCardKey - Id for stamp card in Chain Web.
TransactionDate - Timestamp for stamp card transacton
StampCardTransactionTypeName - Type of stamp card transaction.
Value - Number of stamps used in transaction.
InstanceNumber - Which instance. E.g. Every 5. item for free. First 5 items had instance 1, next 5 items has instance 2.
ReceiptID - Receipt id from cash register, if available.
Comment - Comment on transaction, if available.
Coupon information from Chain Web
(TFS: 168541)
When fetching coupon information from Chain Web we now also include TransactionID from used coupons when available.
...
| Info |
|---|
Note: Upgrade script will delete all existing coupons, they will be imported again next time N-job runs. |
Campaign detail
(TFS: 169114)
To show more detail from campaigns, we now fetch price rules and offer details from Chain Web.
...
CampaignReference - Campaign reference
OfferNumber - Offer number
Name - Offer name
OfferStart - Start date on offer
OfferStop - Stop date on offer
New view for member sales data
(TFS: 171445)
3rd party is able to use this view to fetch data on members who have recently made a purchase in a store and can use this data to conduct a customer survey.
...
| Info |
|---|
To create comma separated list of items which should be excluded from Sum and quantity of items. Alter view and edit this line: AND da.EAN NOT IN ('EAN1','EAN2','EAN3') -- List of EANs for plastic bags to be excluded from amount/qty |
Extended RIGAL export to Cash Settlement for Collector payments
(Work ID: 167681)
Export of RIGAL files to Cash Settlement has been extended to include amount per currency for Collector Bank payments. This makes it possible to see amount paid in different currencies in Cash Settlement.
...
| Info |
|---|
Reporting v. 58 is required. |
POS Services worker configuration |
|---|
StoreSettlementCreditPaymentIssuerIds Must be set to the same value as POS Configuration parameter "CollectorCardIssuerId". |
Items sold with open price
(TFS: 167573)
The cube is extended with a counter for items sold with open price.
In addition, there are new columns in FactRetailTransactionArticle for displaying if an item is sold with open price (isOpenPrice) or overridden price (isOverriddenPrice).
Improvements
Modules | Description |
|---|---|
Loyalty | Lookup member from POSLog (TFS: 158811) We have made improvements when doing lookup on members from POSLog. If LoyaltyNumber is available we always use this for lookup before checking identificators. |
Loyalty | Import of coupons (TFS: 164210) The performance of importing coupons from Chain Web has been significantly improved. |
System | POSLog without salesperson (TFS: 169137) It is now possible to update POSLog without salesperson on item line. In such cases we use operatorID from POSLog. Earlier these POSLogs would be rejected. |
Invoice | Invoices created from internal transfer (TFS: 170320) When transfering invoices from Chain Web we now include invoices created from internal transfer. These invoices will have its own documenttype "Transfer". |
Reports | Ordinary price on item (TFS: 170220) Reporting will now read normal price from POSLog and save this in FactRetailTransactionArticle table, column OrdinaryPrice. NB! Customer running temporary solution created in Product Backlog Item 167521: Fetch ordinary price from POS Master (temp solution), must disable this after Reporting is upgraded and cash registers are using poslog version 74. |