Welcome, Guest
Username: Password: Remember me

TOPIC: OEORDHDR/OEORDLIN sales amount discrepancy

OEORDHDR/OEORDLIN sales amount discrepancy #309

  • kbieber
  • kbieber's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Version 7.5.103f MS SQL - comparing the OEORDHDR tot_sls_amt and tot_dollars fields against the corresponding OEORDLIN qty_ordered * unit_price revealed discrepancies where either/both the tot_sls_amt or tot_dollars field = 0 on about 5% of our open sales orders. There is nothing unique about these orders that I can discern. Can anyone explain the use of the tot_sls_amt and tot_dollars fields and what can cause this discrepancy?
Klaus Bieber
Business Analyst, US Endoscopy
kbieber@usendoscopy.com
The administrator has disabled public write access.

OEORDHDR/OEORDLIN sales amount discrepancy #310

  • Kruegeme
  • Kruegeme's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 91
  • Karma: 0
Are the items that have 0 in the tot_sls_amt field backordered? Its been my experience that this field is not 100% until the order is selected
The administrator has disabled public write access.

OEORDHDR/OEORDLIN sales amount discrepancy #311

  • kbieber
  • kbieber's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Thanks for the reply - you were close. The formula for tot_sls_amt is actually qty_to_ship*unit_price and not qty_ordered*unit_price. Problem solved.
Klaus Bieber
Business Analyst, US Endoscopy
kbieber@usendoscopy.com
The administrator has disabled public write access.

OEORDHDR/OEORDLIN sales amount discrepancy #312

  • Kruegeme
  • Kruegeme's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 91
  • Karma: 0
Almost all of our parts are entered with Qty Ordered = x and Qty to Ship = 0 so that's why it doesn't fill in the dollars until selected. At that time, they designate the qty that was shipped. Glad you found the problem.
The administrator has disabled public write access.
Time to create page: 0.034 seconds
Powered by Kunena Forum  Protected by R Antispam