Using VI to update Projected Demand

SUGGESTED

Hello all. I am attempting to use Visual Integrator to update my company's projected demands on the fly. I am attempting to import into the MP.SCHED table. The problem I'm running into is that the import fails on the CUST_NUMBER field if this is left blank. We don't use projected demand based on customers. Am I using the wrong table? Is there any way to skip having to have the CUST_NUMBER field populated with anything but still complete an import of data into projected demand?

Thank you for any help you can provide with this.

Parents Reply Children
  • 0 in reply to David Speck

    We tried that and also tried just editing the export as a text file so that the only fields to change were the projected demand numbers. All that did was create multiple copies of each item in the report. What I finally discovered late yesterday through trial and error is that if you omit division completely, everything imports as expected. Thank for your help. I'll keep in mind the padding of the customer number.