I am getting some very strange messages with VI in one company. It is deleting open orders!
It is not a complicated import, just zero out some UDF fields on the header page. No lines (details)
Table: SO_SalesOrderHeader
Data:
Sales Order - Column 1
AR Division: Column 2
AR Customer: Column 3
UDF Value - Assigning to zero
Header and Line are marked as separate with corresponding records table identifying Header rows.
Note: I have tried with Header and Line together, but Sage says I should use Header and Line separate if not importing any lines information.
The Issue: VI is giving me the following message on both Test and Accept
"An Invoice Receipt is currently refencing purchase order for component. Can not delete"Of Course, VI is actually deleting orders, I am going from 162 orders to 34.
We do have Avatax and Operations Managements installed. No custom office scripts. V2021 Advanced.
I have never seen a VI import job deleting active orders before and I am at loss on what is happening.
To make it more interesting, the same VI job worked in my other Operation Management company.
Any ideas are appreciated
Thank you
Michael
#VI #SalesOrder #Job Ops
------------------------------
Michael Davis
Warren Averett Technology Group
Birmingham, AL
------------------------------