Sage 100

Barbara - When I try to import into BM_BillHeader, I do see L.LineKey available for me on the Data tab and I presume a Replace operation can be done on it from the import file, just like you can with other files that have header/line pairs. Will that work for you? I don't get the option to import directly into BM_BillDetail and when I look in the dictionary I see the flag to exclude that table from import is set.

Yes Alnoor, of course you're correct.  Confusion on my part. 

Barbara - When I try to import into BM_BillHeader, I do see L.LineKey available for me on the Data tab and I presume a Replace operation can be done on it from the import file, just like you can with other files that have header/line pairs. Will that work for you? I don't get the option to import directly into BM_BillDetail and when I look in the dictionary I see the flag to exclude that table from import is set.

If you need this for any other read-only field, I've attached instructions I created for myself.

Yes Alnoor, of course you're correct.  Confusion on my part. 

Barbara - When I try to import into BM_BillHeader, I do see L.LineKey available for me on the Data tab and I presume a Replace operation can be done on it from the import file, just like you can with other files that have header/line pairs. Will that work for you? I don't get the option to import directly into BM_BillDetail and when I look in the dictionary I see the flag to exclude that table from import is set.

Added to our KB: Changing_View-readOnly_Fields_to_be_Importable.docx

If you need this for any other read-only field, I've attached instructions I created for myself.

Yes Alnoor, of course you're correct.  Confusion on my part. 

Barbara - When I try to import into BM_BillHeader, I do see L.LineKey available for me on the Data tab and I presume a Replace operation can be done on it from the import file, just like you can with other files that have header/line pairs. Will that work for you? I don't get the option to import directly into BM_BillDetail and when I look in the dictionary I see the flag to exclude that table from import is set.