Hello all:
I am trying to create an export that will send the "part number" and
"available to promise quantity" to a file using the export utility. I have
located a table "PartWhse" which has "OnHandQty" and "AllocQty" fields, so
I set up a calculation to subtract the "AllocQty" from the "OnHandQty".
This exports the quantities for all of the warehouses, but I need one field
"Available to Promise" that summarizes quantities from all warehouses. How
can I add an aggregate field to the export?
We would also like to run this export daily. I there a way to easily do
this?
Thanks for your help:
Mike Moloney
CONFIDENTIALITY : This e-mail and any attachments are confidential and may
be privileged. If you are not a named recipient, please notify the sender
immediately and do not disclose the contents to another person, use it for
any purpose or store or copy the information in any medium.
I am trying to create an export that will send the "part number" and
"available to promise quantity" to a file using the export utility. I have
located a table "PartWhse" which has "OnHandQty" and "AllocQty" fields, so
I set up a calculation to subtract the "AllocQty" from the "OnHandQty".
This exports the quantities for all of the warehouses, but I need one field
"Available to Promise" that summarizes quantities from all warehouses. How
can I add an aggregate field to the export?
We would also like to run this export daily. I there a way to easily do
this?
Thanks for your help:
Mike Moloney
CONFIDENTIALITY : This e-mail and any attachments are confidential and may
be privileged. If you are not a named recipient, please notify the sender
immediately and do not disclose the contents to another person, use it for
any purpose or store or copy the information in any medium.