Unfreeze the Physical Inventory flag.
You are trying to turn off the freeze physical inventory flag and there are still physical inventory records remaining that have not been posted
Error: “update was not successful. At least one physical inventory record exists where posted status is equal to U unposted. (or similar messages).
Solution ID = KB-338
Goal : Unfreeze the Physical Inventory flag.
Version = Syteline7.XX.XX
Module : SLMFG
Fact : INV
Symptom 1 : Physical inventory will not unfreeze.
Symptom 2 : Removing zero count records.
Database : SQL
Fix
First run the "Physical Inventory Record Purge"
form. You can preview to see records that will be purged first but
make sure process with commit button flagged to remove posted physical
inventory records.
If you still cannot unfreeze the physical inventory go to
input/update tags (or sheets) form to see what is left in physical
inventory. Enter counts for records remaining, or void those
tags/sheets. Then post the new entries and run the Physical Inventory
Record Purge again.
If for some reason you have records
that you cannot post or purge. you can empty the physical inventory files.
Note: This process will remove all information that is
still sitting in Physical Inventory records. Make sure all physical
inventory reports and processing is complete and correct before proceeding.
Using SQL query analyzer or
Enterprise Manager connect to the database where you are having problems.
In SQL query analyzer run the
following to clear all physical inventory records. This will remove
all records in the Phyinv table immediately and allow you to unfreeze the
physical inventory flag.
delete phyinv
In SQL Enterprise manager connect to database_app and then
go to Tables folder. Find Phyinv table and right click - open table
then query. Then remove the statement:
select * from
[dbo].phyinv
and replace it with:
delete phyinv
then execute the command.
You can now go to the Freeze\Unfreeze Inventory form and remove the flag to freeze the inventory.
