webERP Forum

Prices_Customer.php

Lines 281 and 282 refer to fields that are not part of the SQL query string.

[attachment=645]

Should this SQL be joined to custitem table data? If so should "units" be "customersuom"?

Could this have something to do with this: http://www.weberp.org/forum/showthread.p...stomersuom

Strange....

It looks like Phil introduced these fields in this revision https://sourceforge.net/p/web-erp/code/4552/#diff-2

Perhaps he remembers why?

Tim

(12-27-2017, 06:59 PM)falkoner Wrote: [ -> ]Strange....

It looks like Phil introduced these fields in this revision https://sourceforge.net/p/web-erp/code/4552/#diff-2

Perhaps he remembers why?

Tim

I noticed these fields they are used in the customer item data page.
I'm suspecting the idea was to implement the idea of a UOM for sales the same way it is now for PO with suppliers.
I think the idea might have been discarded as it might be too time consuming for the user to set up for each customer UOMs and conversion factors for each product. The same job can be done at the product level by creating a Kit with a 12 count of a single product, that's how we do it now for all our products that are sold in cases to our wholesale customers. Not ideal as all SKUs are that way duplicated for that purpose only.

Also the headings on the data table need updating to include the start and end dates.

Tim