Sage 100

2015 Advanced. I need to use VI to update PO_PurchaseOrderDetail: QuantityReceived, ReceivedAmt, and InvoicedAmt. None of these fields are visible in VI. What is the process to make these fields available? I believe you modify ProvideX.dde and/or ProvideX.ddf. I have done this in the past but it has been a while.

Wouldn't that mess up the GL and Inventory postings made when a PO is received and updated?

@LeeGraham The inventory and GL is correct. PO detail is incorrect. I have several hundred line items that need to be corrected going back three or four years so we can complete the PO. Some sort of data corruption or receipt update interruption must have occurred. About 100 POs are affected and 400 line items.

If you don't use the PO's for copying-to-new PO's, you might try setting field #26 Order Status to ""X"" for Complete.

Can you turn off integration between PO/IM/GL and import to PO Receipt and update?

I think I have it figured out. I found a post from may 2014 from @BernieLehman . Thank you everyone for the suggestions. FYI: Description: Allowing Import to read only file in MAS Details: How to modify VI Data Dictionaries for 4.x framework DFDM MAS90\providex.ddf Lookup by name to find the VI entity to modify - get the key ID. Use the first 6 characters. DFDM MAS90\providex.dde Search by Key. Find the field record you want to modify Edit field 20 (15,1) a zero is importable. a 1 is read only.