Does anyone know what the "PriceSource" is in the TransactionEntry table and what the numbers correspond to?
Thanks,
Jay
Does anyone know what the "PriceSource" is in the TransactionEntry table and what the numbers correspond to?
Thanks,
Jay
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 C> Does anyone know what the "PriceSource" is in the TransactionEntry table
Have something to add? Share your thoughts — no account required.
Ask the community — no account required