Sage 100

Another PITA issue that I ran into. Customer on 2016 PU3 - they set up a few BOM kits (luckily I imported the bulk of them which went just fine) but the customer entered some kits and neglected to check the ""Print Components"". Naturally a whole bunch made it onto SO which when invoiced copies them to INV. Until you print invoices you cannot tell anything is wrong. When you print invoices you notice components are missing which they wanted to have printed -- some of which have serial number tracking. There's really no way after-the-fact to fix this screw up short of DFDM that I've found. It does not appear you can import into the line detail without overwriting records. So one-by-one you have to go through and edit the field that controls whether to suppress printing of components. Now I have about 1/2 dozen Crystal Reports which I have to run to verify the data entry. Would be nice if when I changed the BOM and flagged print components to either Y or N that Sage would prompt me to change the value in the order entry or unposted invoice file as well.

If you export the key fields from SO_InvoiceHeader and SO_InvoiceDetail you should be able to VI import the records that need the ""print components check box. if you use the line key on the import, then the detail records shouldn't duplicate. Just import the key fields and the print components check box (Y or N). VI can't overwrite any fields that aren't specified in the import.

I tried that but there was something that kept failing which made me think importing in the lines wasn't practical