If you have an error when trying to enter or invoice a service call, examples below:
AND/OR
Sql Executed:='INSERT INTO SCReportMaterials(ReportID,DetailID,ItemID,SerialNumber,Description,Quantity,UMID,UM,ConvFactor,Price,Discount,Amount,Bill,Stocked,DeptID,GLID,CostGLID,CostDeptID,CostAppliedGLID,CostAppliedDeptID,TaxFlag,Cost,StockTypeID,PriceSourceID,SystemComputedPrice,OutCostRate,CalculatedOutCost,OutCost,OutCostExtended,UseBaseOutCost,OverrideOutCost,WarrantyStarted,IsWarrantied,TransactionWarrantyID,ContractItemLimitID,UpdatorID,LastUpdate,CreatorID,MoveOrderDetail,MoveOrderLinkedDetailID,MoveOrderLocation) VALUES ( 8865, 1, 4141,'','HP M2727NF Flatbed Scanner Assembly', 1, 1,'Each', 1, 0, 0, 0,1,1,NULL,NULL,NULL,NULL, 7,NULL, 1, 0, 1, 1, 0, 0, 0, 0, 0,0,0,0,0,NULL,NULL,'lynncox',GETDATE(),0,NULL,NULL)' Cannot insert the value NULL into column 'GLID', table; column does not allow nulls. INSERT fails.
You have item(s) that are on the service call, but the service code has been removed from the item before it was entered/invoiced. E-automate cannot identify the GL to expense the items to, because it is expecting that the service code on the item pull that information. Check the items on the service call and make sure they all have a service code assigned to them.
1 Comments