Jump to content


Photo

underlying query


  • Please log in to reply
2 replies to this topic

#1 Shank

Shank

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 02 October 2008 - 04:59 AM

MOM 4.0
REPORTS > Profit and Response > Profit by Product

Can anyone tell me what the underlying query(s) is for the above report?

The above report gives me different results than when I query the DBF tables outside of the MOM interface. They are close, but not the same.

thanks

#2 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 06 October 2008 - 06:09 AM

MOM 4.0
REPORTS > Profit and Response > Profit by Product

Can anyone tell me what the underlying query(s) is for the above report?

The above report gives me different results than when I query the DBF tables outside of the MOM interface. They are close, but not the same.

thanks


First thing that comes to mind is how MOM treats returns. If you returned product back to stock, it shows it as a return on the report and subtracts the PROFIT on the item from all profit. If you returned product NOT back to stock, I think it shows it as a return on the report and subtracts the ENTIRE COST of the item from all profit.

Could also be your date selection. Choose Shipped or Invoiced Order Date Range... not ALL. ALL will include Quotes too.

Hope that helps...
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#3 wenzi110

wenzi110

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 27 April 2009 - 01:14 AM

The men of the twenty-ninth century live in a perpetual fairyland, though they do not seem to realise it. Bored with wonders, they are cold towards everything that progress brings them every day. It all seems only natural.
wow gold
If they compared it with the past, they would better appreciate what our civilisation is, and realise what a road it has traversed. What would then seem finer than our modern cities, with streets a hundred yards wide, with buildings a thousand feet high, always at an equable temperature, and the sky furrowed by thousands of aero-cars and aero-buses! Compared with these towns, whose population may include up to ten million inhabitants, what were those villages, those hamlets of a thousand years ago, that Paris, that London, that New York - muddy and badly ventilated townships, traversed by jolting contraptions, hauled along by horses - yes! by horses! it's unbelievable!
wow power leveling
If they recalled the erratic working of the steamers and the railways, their many collisions, and their slowness, how greatly would travellers value the aero-trains, and especially these pneumatic tubes laid beneath the oceans, which convey them with a speed of a thousand miles an hour? And would they not enjoy the telephone and the telephote even better if they recollected that our fathers were reduced to that antediluvial apparatus which they called the 'telegraph'?
It's very strange. These surprising transformations are based on principles which were quite well known to our ancestors,
World of warcraft gold although these, so to speak, made no use of them. Heat, steam, electricity are as old as mankind. Towards the end of the nineteenth century, did not the savants declare that the only difference between the physical and chemical forces consists of the special rates of vibration of the etheric particles?

As so enormous a stride had been made, that of recognising the mutual relationship of all these forces, it is incredible that it took so long to work out the rates of vibration that differentiate between them. It is especially surprising that the method of passing directly from one to another, and of producing one without the other, has only been discovered so recently.
World of warcraft Power Leveling
So it was, however, that things happened, and it was only in 2790, about a hundred years ago, that the famous Oswald Nyer succeeded in doing so.
A real benefactor of humanity, that great man! His achievement, a work of genius, was the parent of all the others! A constellation of inventors was born out of it, culminating in our extraordinary James Jackson. It is to him that we owe the new accumulators, some of which condense the force of the solar rays, others the electricity stored in the heart of our globe, and yet again others, energy coming from any source whatever, whether it be the waterfalls, winds, or rivers. It is to him that we owe no less the transformer which, at a touch on a simple switch, draws on the force that lives in the accumulators and releases it as heat, light, electricity, or mechanical power after it has performed any task we need.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users