I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00.
Here is an example of how I'm creating the Import object:
Import importer; importer = (Import)ptApp.CreateImporter(PeachwIEObj.peachwIEObjAdjustmentsJournal); importer.ClearImportFieldList(); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_ItemId); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_Reference); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_Date); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_ReasonToAdjust); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_NumberOfDistributions); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_Amount); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_GLAccountId); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_Quantity); importer.AddToImportFieldList((short)PeachwIEObjAdjustmentsJournalField.peachwIEObjAdjustmentsJournalField_UnitCost); importer.SetFileIncludesHeadersFlag(1); importer.SetFilename(sage50DTO.InventoryOutFileLocation + "\\" + sage50DTO.InventoryOutFileName + "_import.xml"); importer.SetFileType(PeachwIEFileType.peachwIEFileTypeXML); importer.Import();
And this is an example of the xml file that I am importing: