Doc_Inventory.createFacts does not respect !line.isActive() but MInventory.completeIt does. Posting fails.

Our use case is this: We have an automated process that creates an Internal Use Inventory document that our technicians must review, modify and complete. The technician selects from a collection of checkboxes (added in AD) on each line to specify details about the line. Some checkbox selections should cause the line to be ignored in processing. In our case, we do not want the lines deleted because we will lose the record of the technician decision. I tried setting the qty=0 via callout initially but M_Inventory.beforeSave() does not like that. Changing the isActive flag is a good solution for us.

document table have status column for delete case (reverse status)
and almost *line don't show isActive column.

so i think for this case just hidden isActive column

, is *mpiere model - all tables must have IsActive flag and an inactive record must be considered as deleted.

So, I think we have a lot of bugs like what is reporting here - most queries on functional stuff not filtering IsActive can be considered an issue.

Regards,

Carlos Ruiz

hi , do you know any reason to have isActive on Inventory line?

my opinion is get rib of "is active" on inventory line make it consistent with other *line.

in case you have to use it, change code on MInventory.getLines to

.setOrderBy(MInventoryLine.COLUMNNAME_Line).setOnlyActiveRecords(true).