Price Source


J

Jay

Does anyone know what the "PriceSource" is in the TransactionEntry table
and what the numbers correspond to?

Thanks,

Jay
 
Ad

Advertisements

G

Glenn Adams [MVP - Retail Mgmt]

It tells you where the sold price for that line item came from:
Regular price
sale price
Price Level A, B or C
Customer Discount
Discount at POS
etc...

Check the knowledge base for "Database Definitions" and you should find
an article that gives you the values. If not, look at the definition of
the Detailed Sales report - the Column Definition for PriceSource should
have a Case statement that maps each value to it's meaning.

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top